Spring Boot 之 JPA 和 Controller接收参数

最新推荐文章于 2022-06-07 17:42:36 发布

鲁鲁517

最新推荐文章于 2022-06-07 17:42:36 发布

阅读量1.2k

点赞数

文章标签：数据库 spring hibernate java mysql

本文链接：https://blog.csdn.net/lunan/article/details/103637956

版权

在pom.xml中添加依赖包

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

在application.properties中增加数据库配置

注意spring.jpa.properties.hibernate.hbm2ddl.auto的选择，create每次都会重新建表

spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=!QAZ2wsx
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.jpa.properties.hibernate.hbm2ddl.auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.properties.hibernate.format_sql=true
spring.jpa.show-sql= true

增加模型类

@Entity
@Data
public class User implements Serializable {

	private static final long serialVersionUID = 1L;
	
	@Id
	@GeneratedValue
	private Long id;
	
	@Column(nullable = false, unique = true)
	private String userName;
	
	@Column(nullable = false)
	private String passWord;
	
	@Column(nullable = false)
	private String email;
	
	@Column(nullable = true)
	private String nickName;
	
	@Column(nullable = false)
	private String regTime;
}

增加模型接口

public interface UserRepository extends JpaRepository<User, Long> {
}

增加接收参数并操作数据库

@RestController
public class UserController {
	
	@Autowired
    private UserRepository userRepository;
	
    @RequestMapping("/list")
    public List<User> list() {
    	return userRepository.findAll();
    }
    
    @RequestMapping("/add")
    // /add?userName=c&passWord=c&email=c&regTime=c&nickName=c
    public List<User> add(
    		@RequestParam(name = "userName") String userName,
    		@RequestParam(name = "passWord") String passWord,
    		@RequestParam(name = "email") String email,
    		@RequestParam(name = "regTime") String regTime,
    		@RequestParam(name = "nickName") String nickName) {
    
    	User user = new User();
    	user.setUserName(userName);
    	user.setPassWord(passWord);
    	user.setEmail(email);
    	user.setRegTime(regTime);
    	user.setNickName(nickName);
    	userRepository.save(user);
    	return userRepository.findAll();
    }
    
    @RequestMapping("/del/{id}")
    // /del/{1}
    public List<User> del(@PathVariable(name = "id") Long id) {
    
    	userRepository.deleteById(id);
    	return userRepository.findAll();
    }

}