Advertisement
Guest User

Untitled

a guest
Jul 15th, 2017
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.47 KB | None | 0 0
  1. $("#logger-button").click(function () {
  2.  
  3. var loginData = {
  4.  
  5. nickName:$("#user-name").val(),
  6. email:$("#email").val(),
  7. password:$("#password").val(),
  8. formId:$("#loginForm").val()
  9. }
  10.  
  11. var JSONString = JSON.stringify(loginData);
  12.  
  13. console.log(JSONString);
  14.  
  15. var url = "http://localhost:8080/CouponProject/login";
  16.  
  17. $.ajax({
  18.  
  19. url:url,
  20. method:"post",
  21. data:JSONString,
  22. contentType:"application/json",
  23. error:function (message) {
  24. console.log(message);
  25. },
  26. success:function (data) {
  27.  
  28. console.log(data); // line 29
  29.  
  30. var JSONObject = JSON.parse(data); // line 31
  31. console.log(JSONObject);
  32.  
  33. },
  34. headers:
  35. {
  36. "Accept":"application/json",
  37. "Accept-Language":"en",
  38. "Cache-Control":"max-age=3600"
  39. }
  40. });
  41.  
  42. protected static boolean postDatabase(String[] loginData, HttpServletResponse response) throws IOException {
  43. try {
  44. output = response.getWriter();
  45. Class.forName("com.mysql.jdbc.Driver");
  46. connection = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
  47. String checkingUser = "SELECT nick_name,email,password FROM users WHERE nick_name=?";
  48. PreparedStatement preparedStatement = connection.prepareStatement(checkingUser);
  49. preparedStatement.setObject(1, loginData[0]);
  50. ResultSet resultSet = preparedStatement.executeQuery();
  51. while (resultSet.next()) {
  52. int passwordColumn = resultSet.findColumn("password");
  53. int emailColumn = resultSet.findColumn("email");
  54.  
  55. System.out.println(passwordColumn);
  56. System.out.println(emailColumn);
  57.  
  58. System.out.println(resultSet.getString(passwordColumn)); // correct
  59. System.out.println(resultSet.getString(emailColumn));// correct
  60.  
  61. if (resultSet.getString(passwordColumn).equals(loginData[1])) {
  62. System.out.println(resultSet.getString(passwordColumn));
  63. if (resultSet.getString(emailColumn).equals(loginData[2])) {
  64. ResponseDataHandler.ToJSONresponse("success", response);
  65. }
  66. }
  67. }
  68. } catch (IOException ioError) {
  69. ResponseDataHandler.ToJSONresponse(ioError.toString(), response);
  70. } catch (ClassNotFoundException notFound) {
  71. ResponseDataHandler.ToJSONresponse(notFound.toString(), response);
  72. } catch (SQLException sql) {
  73. ResponseDataHandler.ToJSONresponse(sql.toString(), response);
  74. } finally {
  75. try {
  76. connection.close();
  77. } catch (SQLException sql) {
  78. ResponseDataHandler.ToJSONresponse(sql.toString(), response);
  79. }
  80. }
  81. return false;
  82. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement