SpringBoot web开发 (3) 使用 mysql-jpa 登录验证

刺骨的言语ヽ痛彻心扉 2021-10-13 03:51 241阅读 0赞

## 3、使用 mysql-jpa ##

1.  构造 数据库实体类型

*  添加maven依赖

<dependency>
    	<groupId>org.springframework.boot</groupId>
    	<artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <dependency>
    	<groupId>mysql</groupId>
    	<artifactId>mysql-connector-java</artifactId>
    </dependency>

(1) 创建 用户表,新建 entity/User.java （注意，属性小写开头）

package com.learn.first.entitys;
    
    import javax.persistence.Column;
    import javax.persistence.Entity;
    import javax.persistence.Table;
    import javax.persistence.Transient;
    
    import com.learn.first.commons.StringTools;
    
    @Entity
    public class User{
    	@Id
        @GeneratedValue
        private Long id;
        @Column(nullable = false, unique = true, length = 32)
        private String userName;
        @Column(nullable = false,length = 32)
        private String passWord;
        @Column(nullable = false, unique = true,length = 32)
        private String phoneNum;
    
    	//...get--set
    }

(3) 添加 数据库配置 src/main/resources/application.properties ,(mysql要自己先到数据库新建数据库 test)

spring.jpa.hibernate.ddl-auto=update
    spring.jpa.show-sql=true
    
    spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
    spring.datasource.username=root
    spring.datasource.password=asdf@#123
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

1.  新建 Login2Controller.java

// 添加一天数据测试
    @RequestMapping("")
    public String index(){
    	//TODO TEST
    	if(userService.getUserByName("admin") == null){
    		User user = new User();
    		user.setUserName("admin");
    		user.setPassWord("admin");
    		user.setPhoneNum("110900");
    		userService.Add(user);
    	}
    	return "login/index";
    }
    
    //登录验证
    @RequestMapping("/in")
    public String in(@RequestParam String lname,@RequestParam String pwd){
    	User user = userService.getUserByName(lname);
    	if(user != null && user.checkPassWorl(pwd)){
    		session.setAttribute("name", "admin");
    		return "redirect:/";
    	}
    	return "redirect:/login/";
    }

1.  启动 main 函数，浏览器输入 http://127.0.0.1:8080/login2,输入用户名 admin，密码 admin 登录，观察数据库test中变化
2.  [demo 地址][demo]

[demo]: https://github.com/jiegemena/springbootlearn/tree/master/springbootlearn