Esta fue la forma que encontré de acuerdo a la clase
@Override
public void save(Employee employee) throws SQLException {
String sql;
if (employee.getId() < 1) {
sql = "INSERT INTO employees(first_name, pa_surname, ma_surname, email, salary) VALUES(?, ?, ?, ?, ?)";
} else {
sql = "UPDATE employees set first_name = ?, pa_surname = ?, ma_surname = ?, email = ?, salary = ? WHERE id = ?";
}
try(PreparedStatement myStmt = getConnection().prepareStatement(sql)){
myStmt.setString(1, employee.getFirst_name());
myStmt.setString(2, employee.getPa_surname());
myStmt.setString(3, employee.getMa_surname());
myStmt.setString(4, employee.getEmail());
myStmt.setFloat(5, employee.getSalary());
if (employee.getId() != 0){
myStmt.setInt(6, employee.getId());
}
int rows = myStmt.executeUpdate();
if (rows > 0) {
System.out.println("All that's good");
} else {
System.out.println("Something is going wrong");
}
}
}```
¿Quieres ver más aportes, preguntas y respuestas de la comunidad?