Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
177
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. String sql = "SELECT id_usuario,nome,senha FROM usuario where login = ? and senha = ?";
  2. try {
  3. PreparedStatement stmt = con.prepareStatement(sql);
  4. stmt.setString(1, u.getLogin());
  5. stmt.setString(2, u.getSenha());
  6. ResultSet rs = stmt.executeQuery();
  7.  
  8. if (rs.next()){
  9. String update = "UPDATE usuario SET senha=? WHERE id_usuario = " +Sessao.getInstancia().getUsuario().getId()+ "";
  10. PreparedStatement stmt2 = con.prepareStatement(sql);
  11. stmt2.setString(1, u.getNovaSenha());
  12. ResultSet rs2 = stmt2.executeQuery();
  13.  
  14. return true;
  15. }
  16.  
  17. GRAVE: null
  18. java.sql.SQLException: No value specified for parameter 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement