Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- My entity class--->>
- @Entity
- @Table(name="mytable")
- public class User {
- @Id
- private int id;
- private String username;
- private String firstname;
- private String lastname;
- private int age;
- private String password;
- public User() {
- }
- public User(String username, String firstname, String lastname, int age, String password) {
- super();
- this.username = username;
- this.firstname = firstname;
- this.lastname = lastname;
- this.age = age;
- this.password = password;
- }
- omit getters and setters
- Here is my controller
- @Controller
- public class ApplicationController {
- @Autowired
- UserService userService;
- @RequestMapping("/welcome")
- public String Welcome(HttpServletRequest request) {
- request.setAttribute("mode", "MODE_HOME");
- return "welcomepage";
- }
- @GetMapping("/register")
- public String registration(HttpServletRequest request) {
- request.setAttribute("mode", "MODE_REGISTER");
- return "welcomepage";
- }
- @PostMapping("/save-user")
- public String registerUser(@ModelAttribute User user, BindingResult bindingResult, HttpServletRequest request) {
- userService.saveMyUser(user);
- request.setAttribute("mode", "MODE_HOME");
- return "welcomepage";
- }
- @GetMapping("/show-users")
- public String showAllUsers(HttpServletRequest request) {
- request.setAttribute("users", userService.showAllUsers());
- request.setAttribute("mode", "ALL_USERS");
- return "welcomepage";
- }
- @RequestMapping("/delete-user")
- public String deleteUser(@RequestParam int id, HttpServletRequest request) {
- userService.deleteMyUser(id);
- request.setAttribute("users", userService.showAllUsers());
- request.setAttribute("mode", "ALL_USERS");
- return "welcomepage";
- }
- @RequestMapping("/edit-user")
- public String editUser(@RequestParam int id,HttpServletRequest request) {
- request.setAttribute("user", userService.editUser(id));
- request.setAttribute("mode", "MODE_UPDATE");
- return "welcomepage";
- }
- @RequestMapping("/login")
- public String login(HttpServletRequest request) {
- request.setAttribute("mode", "MODE_LOGIN");
- return "welcomepage";
- }
- @RequestMapping ("/login-user")
- public String loginUser(@ModelAttribute User user, HttpServletRequest request) {
- if(userService.findByUsernameAndPassword(user.getUsername(), user.getPassword())!=null) {
- return "homepage";
- }
- else {
- request.setAttribute("error", "Invalid Username or Password");
- request.setAttribute("mode", "MODE_LOGIN");
- return "welcomepage";
- }
- }
- }
- [here is my registration form when i run the application][1]
- [1]: https://i.stack.imgur.com/33QvJ.png
- spring.mvc.view.prefix=/WEB-INF/view/
- spring.mvc.view.suffix=.jsp
- #Persistence Related Code
- spring.datasource.url=jdbc:mysql://localhost/db_example?useSSL=false
- spring.datasource.username=springuser
- spring.datasource.password=ThePassword
- spring.jpa.show-sql=true
- spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
- logging.level.org.hibernate.SQL=debug
- but, after clicking register button i am getting the above error
- can someone help me out.thanks in advance
Add Comment
Please, Sign In to add comment