@Override
public MaterialBean obtenerMaterial(String codMaterial) throws Exception {
Connection cn = MySqlDbConn.obtenerConexion();
CallableStatement st = cn.prepareCall("{ call pr_obtenerMaterial(?) }");
st.setString(1, codMaterial);
ResultSet rs = st.executeQuery();
MaterialBean mat = new MaterialBean();
if (rs.next()) {
mat.setStrCodMaterial(rs.getString("cod_mat"));
mat.setStrTipoMaterial(rs.getString("tip_mat"));
mat.setStrDescripMaterial(rs.getString("desc_mat"));
mat.setStrUnidadMedida(rs.getString("und_med_mat"));
mat.setBdPrecioUnitario(rs.getBigDecimal("prec_uni_mat"));
mat.setStrDescTipoMaterial(rs.getString("descTipMat"));
// System.out.println(mat.getBdPrecioUnitario());
}
rs.close();
cn.close();
return mat;
}
