1 2 3 4 5 6 7 8 9 10 11 12
| public void insertUser(UserDO user) throws SQLException {
String sql = "INSERT INTO USER (IDUSER,FIRSTNAME,LASTNAME,SEX,FONCTION,USERNAME,PASSWORD) VALUES (?,?,?,?,?,?,?)";
PreparedStatement ps = m_connection.prepareStatement(sql);
ps.setLong(1, 0);
ps.setString(2, user.getFirstName());
ps.setString(3, user.getLastName());
ps.setString(4, user.getSex());
ps.setString(5, user.getFonction());
ps.setString(6, user.getLogin());
ps.setString(7, user.getPassword());
ps.executeUpdate();
} |
Partager