Advertisement
Guest User

Untitled

a guest
Oct 5th, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. Class.forName("com.mysql.jdbc.Driver");
  2.  
  3. connection = DriverManager.getConnection(URL,USER_NAME,PASSWORD);
  4.  
  5. String checkingUser = "SELECT nick_name FROM users WHERE nick_name=? AND password=? AND users.email=?";
  6.  
  7. PreparedStatement preparedStatement = connection.prepareStatement(checkingUser);
  8. System.out.println("Before 1");
  9. preparedStatement.setString(1,loginData[0]);
  10. System.out.println("Before 2");
  11. preparedStatement.setString(2,loginData[1]);
  12. System.out.println("Before 3");
  13. preparedStatement.setString(3,loginData[2]);
  14. preparedStatement.execute();
  15.  
  16. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
  17. You have an error in your SQL syntax; check the manual that
  18. corresponds to your MySQL server version for the right syntax to user near '?, password=?, users.email=?' at line 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement