@Override
public Editora getPorId(String cnpj) {
Connection conexao = connectionFactory.conectar();
String sql = "SELECT * FROM tbEditora " + "WHERE cnpj=?";
Editora editora = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conexao.prepareStatement(sql);
ps.setString(1, cnpj);
rs = ps.executeQuery();
while (rs.next()) {
editora = new Editora();
editora.setCnpj(rs.getString("cnpj"));
editora.setNome(rs.getString("nome"));
editora.setLogoBlob(rs.getBlob("logo"));
}
} catch (SQLException e) {
e.printStackTrace();
}
return editora;
}
@Override
public List<Editora> listar() {
Connection conexao = connectionFactory.conectar();
String sql = "SELECT * FROM tbEditora";
List<Editora> editoras = new ArrayList<Editora>();
Statement stmt = null;
ResultSet rs = null;
try {
stmt = conexao.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
Editora editora = new Editora();
editora.setCnpj(rs.getString("cnpj"));
editora.setLogoBlob(rs.getBlob("logo"));
editora.setNome(rs.getString("nome"));
editora.setLogo(
new DefaultStreamedContent(
new ByteArrayInputStream(
editora.getLogoBlob().getBytes(1, (int) editora.getLogoBlob().length()))));
editoras.add(editora);
}
stmt.close();
rs.close();
conexao.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
stmt.close();
rs.close();
conexao.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return editoras;
}
