Guest User

Untitled

a guest
Aug 16th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.31 KB | None | 0 0
  1. My entity class--->>
  2. @Entity
  3. @Table(name="mytable")
  4. public class User {
  5.  
  6. @Id
  7. private int id;
  8. private String username;
  9. private String firstname;
  10. private String lastname;
  11. private int age;
  12. private String password;
  13.  
  14. public User() {
  15.  
  16. }
  17.  
  18.  
  19. public User(String username, String firstname, String lastname, int age, String password) {
  20. super();
  21. this.username = username;
  22. this.firstname = firstname;
  23. this.lastname = lastname;
  24. this.age = age;
  25. this.password = password;
  26. }
  27. omit getters and setters
  28.  
  29. Here is my controller
  30.  
  31. @Controller
  32. public class ApplicationController {
  33.  
  34. @Autowired
  35. UserService userService;
  36.  
  37. @RequestMapping("/welcome")
  38. public String Welcome(HttpServletRequest request) {
  39. request.setAttribute("mode", "MODE_HOME");
  40. return "welcomepage";
  41. }
  42.  
  43. @GetMapping("/register")
  44. public String registration(HttpServletRequest request) {
  45. request.setAttribute("mode", "MODE_REGISTER");
  46. return "welcomepage";
  47. }
  48.  
  49. @PostMapping("/save-user")
  50. public String registerUser(@ModelAttribute User user, BindingResult bindingResult, HttpServletRequest request) {
  51. userService.saveMyUser(user);
  52. request.setAttribute("mode", "MODE_HOME");
  53. return "welcomepage";
  54. }
  55.  
  56. @GetMapping("/show-users")
  57. public String showAllUsers(HttpServletRequest request) {
  58. request.setAttribute("users", userService.showAllUsers());
  59. request.setAttribute("mode", "ALL_USERS");
  60. return "welcomepage";
  61. }
  62.  
  63. @RequestMapping("/delete-user")
  64. public String deleteUser(@RequestParam int id, HttpServletRequest request) {
  65. userService.deleteMyUser(id);
  66. request.setAttribute("users", userService.showAllUsers());
  67. request.setAttribute("mode", "ALL_USERS");
  68. return "welcomepage";
  69. }
  70.  
  71. @RequestMapping("/edit-user")
  72. public String editUser(@RequestParam int id,HttpServletRequest request) {
  73. request.setAttribute("user", userService.editUser(id));
  74. request.setAttribute("mode", "MODE_UPDATE");
  75. return "welcomepage";
  76. }
  77.  
  78. @RequestMapping("/login")
  79. public String login(HttpServletRequest request) {
  80. request.setAttribute("mode", "MODE_LOGIN");
  81. return "welcomepage";
  82. }
  83.  
  84. @RequestMapping ("/login-user")
  85. public String loginUser(@ModelAttribute User user, HttpServletRequest request) {
  86. if(userService.findByUsernameAndPassword(user.getUsername(), user.getPassword())!=null) {
  87. return "homepage";
  88. }
  89. else {
  90. request.setAttribute("error", "Invalid Username or Password");
  91. request.setAttribute("mode", "MODE_LOGIN");
  92. return "welcomepage";
  93.  
  94. }
  95. }
  96.  
  97. }
  98. [here is my registration form when i run the application][1]
  99.  
  100.  
  101. [1]: https://i.stack.imgur.com/33QvJ.png
  102.  
  103. spring.mvc.view.prefix=/WEB-INF/view/
  104. spring.mvc.view.suffix=.jsp
  105.  
  106. #Persistence Related Code
  107. spring.datasource.url=jdbc:mysql://localhost/db_example?useSSL=false
  108. spring.datasource.username=springuser
  109. spring.datasource.password=ThePassword
  110.  
  111. spring.jpa.show-sql=true
  112. spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
  113. logging.level.org.hibernate.SQL=debug
  114.  
  115.  
  116.  
  117. but, after clicking register button i am getting the above error
  118. can someone help me out.thanks in advance
Add Comment
Please, Sign In to add comment