public static int generateId() throws SQLException {
// Calcula proximo IdObra
try {
con = (Connection) BdConecta.getConnection();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
int last_id_obra = 0;
java.sql.PreparedStatement stmt121;
stmt121 = InvestimentoDAO.con.prepareStatement("select max(idinvestimento) from investimento;");
ResultSet rs = stmt121.executeQuery();
while (rs.next()) {
String string = rs.getString("max(idinvestimento)");
if (string == null) {
return 1;
}
last_id_obra = Integer.parseInt(rs.getString("max(idinvestimento)"));
// stmt121.close();
// con.close();
}
System.out.println("Last id Obra: " + last_id_obra);
if (last_id_obra == 0) {
return 1;
} else {
return (last_id_obra + 1);
}
}
public static void inserir(Investimento investimento, Obra obra) throws SQLException {
System.out.println("chegou no ins invest");
System.out.println(investimento.toString() + "" + obra.toString());
// Criar investimento
try {
con = (Connection) BdConecta.getConnection();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
java.sql.PreparedStatement stmt =
InvestimentoDAO.con.prepareStatement(
"insert into investimento (idinvestimento,"
+ " valor_invest, data_invest, descricao_invest,obra_id)"
+ " values(?,?,?,?,?)");
stmt.setInt(1, investimento.getIdInvestimento());
stmt.setDouble(2, investimento.getValor());
java.sql.Date date = new java.sql.Date(Calendar.getInstance().getTime().getTime());
stmt.setDate(3, (java.sql.Date) date);
stmt.setString(4, investimento.getDescricao());
stmt.setInt(5, obra.getId_obra());
try {
stmt.execute();
System.out.println("invest criado");
stmt.close();
con.close();
JOptionPane.showMessageDialog(null, "gravado com successo");
} catch (Exception e) {
e.getMessage();
}
}
public InvestimentoDAO() throws SQLException {
this.con = (Connection) BdConecta.getConnection();
}