<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><img src="Imagens/Logo.jpg" width="800px" height="224px" align="bottom" style=" width : 691px; height : 223px;">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>SGL 1.0 - Brasil Iphone</title>
<style type="text/css">
@import url("TelaInicial.css");
</style>
<link href="css/smoothness/jquery-ui-1.10.0.custom.min.css" type="text/css" rel="stylesheet"/>
<script type="text/javascript" src="media/js/jquery.js"></script>
<script src="js/jquery-ui-1.10.0.custom.min" type="text/javascript"></script>
<script type="text/javascript" src="media/js/jquery.dataTables.min.js"></script>
<link href="media/css/demo_table.css" type="text/css" rel="stylesheet" media="screen"/>
<style type="text/css">
div#corpo{margin: 0 auto; padding: 0; width: 960px; background:silver; height: 400px;}
</style>
<script type="text/javascript" >
$(document).ready(function(){
$('#tabela1').DataTable({
"bPaginate": true,
"bJQueryUI": true
} );
});
</script>
</head>
<body>
<div id="menu2">
<ul>
<li><a href="TelaInicial.jsp"><b style="FONT-SIZE: Large; FONT-FAMILY: 'Trebuchet MS';">Cliente</b></a></li>
<li><a href="Telainicial_funcionario.jsp"><b style="FONT-SIZE: Large; FONT-FAMILY: 'Trebuchet MS';">Funcionário</b></a></li>
<li><a href="Telainicial_produto.jsp"><b style="FONT-SIZE: Large; FONT-FAMILY: 'Trebuchet MS';">Produto</b></a></li>
<li><a href="Telainicial_servico.jsp"><b style="FONT-SIZE: Large; FONT-FAMILY: 'Trebuchet MS';">Serviço</b></a></li>
</ul>
</div>
<a href="novoCliente.jsp" title="Novo Cliente" target="_blank" ><img src="Imagens/cadastrar.jpg" style="width : 144px; height : 181px;"></a>
<div id="corpo">
<table cellspacing="0" cellpadding="0" class="display" id="tabela1">
<thead>
<tr>
<th>Nome</th>
<th>Endereço</th>
<th>Cep</th>
<th>Complemento</th>
<th>Cidade</th>
<th>UF</th>
<th>Data de nascimento</th>
<th>Rg</th>
<th>Cpf</th>
<th>Telefone</th>
<th>Celular</th>
<th>E-mail</th>
</tr>
</thead>
<tbody>
<tr>
<td>Robson</td>
<td>Rua x</td>
<td>00000</td>
<td>casa</td>
<td>São Paulo</td>
<td>SP</td>
<td>13/02/1996</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>[email removido]</td>
</tr>
<tr>
<td>Robson</td>
<td>Rua x</td>
<td>00000</td>
<td>casa</td>
<td>São Paulo</td>
<td>SP</td>
<td>13/02/1996</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>[email removido]</td>
</tr>
<tr>
<td>Robson</td>
<td>Rua x</td>
<td>00000</td>
<td>casa</td>
<td>São Paulo</td>
<td>SP</td>
<td>13/02/1996</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>[email removido]</td>
</tr>
<tr>
<td>Robson</td>
<td>Rua x</td>
<td>00000</td>
<td>casa</td>
<td>São Paulo</td>
<td>SP</td>
<td>13/02/1996</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>[email removido]</td>
</tr>
<tr>
<td>Robson</td>
<td>Rua x</td>
<td>00000</td>
<td>casa</td>
<td>São Paulo</td>
<td>SP</td>
<td>13/02/1996</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>[email removido]</td>
</tr>
<tr>
<td>Robson</td>
<td>Rua x</td>
<td>00000</td>
<td>casa</td>
<td>São Paulo</td>
<td>SP</td>
<td>13/02/1996</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>[email removido]</td>
</tr>
<tr>
<td>Robson</td>
<td>Rua x</td>
<td>00000</td>
<td>casa</td>
<td>São Paulo</td>
<td>SP</td>
<td>13/02/1996</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>000000</td>
<td>[email removido]</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import javax.swing.JOptionPane;
import com.mysql.jdbc.Statement;
import modelo.consultaCliente;
public class JDBCConsulta implements consultaClienteDAO {
String relacao;
ResultSet rs;
public String getRelacao() {
return relacao;
}
public void setRelacao(String relacao) {
this.relacao = relacao;
}
public ResultSet getRs() {
return rs;
}
public void setRs(ResultSet rs) {
this.rs = rs;
}
public FabricaConexao getConexao1() {
return conexao1;
}
public void setConexao1(FabricaConexao conexao1) {
this.conexao1 = conexao1;
}
FabricaConexao conexao1 = new FabricaConexao();
public void consulta() throws ClassNotFoundException{
try{
conexao1.fazConexao();
java.sql.Statement stmt= conexao1.getConexao().createStatement();
String sql="select* from Cliente";
rs= stmt.executeQuery(sql);
while (rs.next()){
relacao += "\n"+ "Código: "+rs.getString(1).toString()+" Nome: "+rs.getString(2).toString();
}
rs.close();
System.out.println(relacao+"\n");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
try{
conexao1.fecharConexao();
}catch (Exception e){
e.printStackTrace();
}
}
}
@Override
public List<consultaCliente> listarTodos() {
// TODO Auto-generated method stub
return null;
}
@Override
public void consultar(consultaCliente consulta) {
// TODO Auto-generated method stub
}
}
<%JDBCConsulta consulta = new JDBCConsulta();%>
3 Respostas
R
O que é esse import no seu dao?
Você está querendo usar Swing em uma app web??
J
O que é esse import no seu dao?Você está querendo usar Swing em uma app web??
Não cara, eu importei o swing pois fiz um teste para saber se meu método de consulta estava funcionando, exibindo o resultado em um JOptionPane 
J
Resolvido usando um For para popular a tabela !
Criado 12 de fevereiro de 2013
Ultima resposta 3 de mar. de 2013
Respostas 3
Participantes 2