@Override
public boolean create(ImpiegatoTO impiegato) {
Connection conn = MySqlConnectionFactory.getConnection();
PreparedStatement statement = null;
int result = 0;
boolean response = false;
try {
statement = conn.prepareStatement(queryFactory.getQuery("create_impiegato"));
int i = 1;
statement.setString(i++, impiegato.getCf());
statement.setString(i++, impiegato.getNome());
statement.setString(i++, impiegato.getCognome());
statement.setDate(i++, java.sql.Date.valueOf(impiegato.getDataNascita()));
statement.setString(i++, impiegato.getTelefono());
statement.setString(i++, impiegato.getAgenzia());
statement.setString(i++, impiegato.getUsername());
statement.setString(i++, "attivo");
result = statement.executeUpdate();
if (result > 0) response = true;
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
DbEntityCloser.close(statement);
DbEntityCloser.close(conn);
}
return response;
}
