<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.Date"%>
<%@page import="javax.servlet.*,java.text.*" %>
acessórios para informática
<%
request.setCharacterEncoding("UTF-8");
int matric=0;
String nome="", cargo="";
Date dtnasc = new Date();
double salario=0;
String sql="select ra,nome,cargo,dtaniv,salario from func order by nome";
SimpleDateFormat formatoDesejado = new SimpleDateFormat("dd/MM/yyyy");
String dataFormatada = null;
String salarioFormatado=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","123");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sql);
while (rs.next()){
ra=rs.getInt("ra");
nome=rs.getString("nome");
cargo=rs.getString("cargo");
dtnasc = rs.getDate("dtaniv");
salario=rs.getDouble("salario");
//salarioFormatado=NumberFormat.getCurrencyInstance().format(salario);
DecimalFormat df = new DecimalFormat("#,###.00");
String dx = df.format(salario);
dataFormatada = formatoDesejado.format(dtnasc);
%>
<%=nome %>
<%=cargo %>
<%=dataFormatada%>
<%=dx %>
<%
}
con.close();
}
catch (SQLException e){
out.println(e.getMessage());
}
catch (Exception e){
out.println(e.getMessage());
}
%>