/*ProjectController */
public void update(Project project) {
String sql = "UPDATE projects SET "
+ "name = ?,"
+ "description = ?,"
+ "createdAt = ?,"
+ "updatedAt = ? WHERE id = ? ";
Connection connection = null;
PreparedStatement statement = null;
try {
connection = ConnectionFactory.getConnection();
statement = connection.prepareStatement(sql);
statement.setString(1,project.getName());
statement.setString(2,project.getDescription());
statement.setDate(3,new Date(project.getCreatedAt().getTime()));
statement.setDate(4,new Date(project.getUpdatedAt().getTime()));
statement.setInt(5,project.getId());
statement.executeUpdate();
} catch (Exception ex) {
throw new RuntimeException("Erro na atualização do banco de dados "
+ ex.getMessage(), ex);
} finally {
ConnectionFactory.closeConnection(connection, statement);
}
}
/*Main*/
package TudoApp;
import controler.ProjectController;
import model.Project;
public class Main {
public static void main(String[] args) {
ProjectController projectController = new ProjectController();
Project project = new Project();
project.setId(4);
project.setName("Gabriekkl");
project.setDescription("Degdingd");
projectController.update(project);
}
}
Eu seto as informações e ele não atualiza no bando de dados