public ArrayList<Fabricante> getFabricantes(String material)
throws ClassNotFoundException, SQLException {
Connection con = null;
try {
con = ConexaoDAO.getConnection();
ResultSet rs =
con.createStatement()
.executeQuery("SELECT nome FROM fabricante WHERE material='" + material + "'");
ArrayList<Fabricante> tipos = new ArrayList<>();
while (rs.next()) {
Fabricante f = new Fabricante();
f.setNome(rs.getString(1));
tipos.add(f);
}
return tipos;
} catch (Exception e) {
con.close();
return null;
}
}
public boolean cadastrar(Fabricante fab) throws SQLException {
Connection con = null;
PreparedStatement st = null;
try {
con = ConexaoDAO.getConnection();
st = con.prepareStatement("INSERT INTO fabricante (nome,material) VALUES(?,?)");
st.setString(1, fab.getNome());
st.setString(2, fab.getMaterial());
;
return st.execute();
} catch (Exception e) {
// e.printStackTrace();
st.close();
con.close();
return false;
}
}