o meu script da tabela e esse
DROP TABLE IF EXISTS `ltp`.`materialtiagoalves`;
CREATE TABLE `ltp`.`materialtiagoalves` (
`cdmat` int(10) NOT NULL,
`nome` varchar(100) DEFAULT NULL,
`valor` int(10) DEFAULT NULL,
`tamanho` int(10) DEFAULT NULL,
`cor` varchar(100) DEFAULT NULL,
`vlmercado` int(100) DEFAULT NULL,
`vllimite` int(100) DEFAULT NULL,
`vlbase` int(100) DEFAULT NULL,
PRIMARY KEY (`cdmat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
o codigo tesponsavel por faser a consulta e esse
DAO
public MatModelo consultar_materialtiagoalves(int cdMat){
Connection conexao = null;
ResultSet rs = null;
Statement stmt = null;
MatModelo modelo= new MatModelo();
try {
conexao = obterConexao();
stmt = conexao.createStatement();
rs = stmt.executeQuery("select * from ltp.materialtiagoalves where cdMat = "+cdMat);
while (rs.next()){
modelo.setCdMat(rs.getInt(cdMat));
modelo.setCor(rs.getString("cor"));
modelo.setNome(rs.getString("nome"));
modelo.setTamanho(rs.getInt("tamanho"));
modelo.setValor(rs.getInt("valor"));
modelo.setVlbase(rs.getInt("vlbase"));
modelo.setVllimite(rs.getInt("vllimite"));
modelo.setVlMercado(rs.getInt("vlmercado"));
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
rs.close();
stmt.close();
conexao.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return modelo;
}
assinatura do metodo FACADE
public MatModelo consultar_materialtiagoalves(int cdMat){
return mbo.consultar_materialtiagoalves(cdMat);//retorna um objeto
}
aki e executado a consulta para imprimir no console
CONTROLE
mmodelo = new MatModelo();
mmodelo=mfacade.consultar_materialtiagoalves(10);
System.out.println(mmodelo.getCdMat());
System.out.println(mmodelo.getCor());
System.out.println(mmodelo.getNome());
System.out.println(mmodelo.getTamanho());
System.out.println(mmodelo.getValor());
System.out.println(mmodelo.getVlbase());
System.out.println(mmodelo.getVllimite());
System.out.println(mmodelo.getVlMercado());
}
}
so pra completar a assinatura do metodo de consulta do BO
public MatModelo consultar_materialtiagoalves(int cdMat){
return mdao.consultar_materialtiagoalves(cdMat);//retorna um objeto
}
