jpa mysql5.7_SpringBoot入门系列：第五篇 JPA mysql（转）

一，准备工作，建立spring-boot-sample-mysql工程

1、http://start.spring.io/

A、Artifact中输入spring-boot-sample-mysql

B、勾选Web下的web

C、勾选SQL下的JPA MYSQL

2、Eclips中导入工程spring-boot-sample-mysql

A、解压快捷工程spring-boot-sample-mysql到某文件夹

B、eclips中file->import->Import Existing Maven Projects-->Select Maven projects-->finish导入工程

3、工程导入之后，文件结构如下图

4、在包com.example下建立web文件夹

5、便于测试，引入spring-boot-sample-helloworld的HelloController及配置文件logback.xml

HelloController代码为

packagecom.example.web;importorg.slf4j.Logger;importorg.slf4j.LoggerFactory;importorg.springframework.web.bind.annotation.PathVariable;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.RestController;

@RestControllerpublic classHelloController {protected static Logger logger=LoggerFactory.getLogger(HelloController.class);

@RequestMapping("/")publicString helloworld(){

logger.debug("访问hello");return "Hello world!";

}

@RequestMapping("/hello/{name}")publicString helloName(@PathVariable String name){

logger.debug("访问helloName,Name={}",name);return "Hello "+name;

}

}

logback.xml配置为：

%d %p (%file:%line\)- %m%n

GBK

class="ch.qos.logback.core.rolling.RollingFileAppender">

log/base.log

log/base.log.%d.i%

64 MB

%d %p (%file:%line\)- %m%n

UTF-8

注：logback.xml文件位于src/main/resources下

6、启动工程，通过浏览器查看正确性

http://localhost:8080/

http://localhost:8080/hello/上帝

二，使用JPA,构建业务对象及访问库

1、在包com.example下建立domain文件夹

2、在domain中建立类Person

packagecom.example.domain;importjavax.persistence.Entity;importjavax.persistence.GeneratedValue;importjavax.persistence.Id;

@Entitypublic classPerson {

@Id

@GeneratedValueprivateLong id;privateString name;privateInteger age;privateString address;publicPerson() {super();

}publicPerson(Long id, String name, Integer age, String address) {super();this.id =id;this.name =name;this.age =age;this.address =address;

}publicLong getId() {returnid;

}public voidsetId(Long id) {this.id =id;

}publicString getName() {returnname;

}public voidsetName(String name) {this.name =name;

}publicInteger getAge() {returnage;

}public voidsetAge(Integer age) {this.age =age;

}publicString getAddress() {returnaddress;

}public voidsetAddress(String address) {this.address =address;

}

}

注意：构造函数

3、在包com.example下建立repository文件夹

4、在repository中建立接口PersonRepository

packagecom.example.repository;importjava.util.List;importorg.springframework.data.jpa.repository.JpaRepository;importorg.springframework.data.jpa.repository.Query;importorg.springframework.data.repository.query.Param;importorg.springframework.stereotype.Repository;importcom.example.domain.Person;

@Repositorypublic interface PersonRepository extends JpaRepository{

ListfindByName(String name);

ListfindByAddress(String address);

ListfindByNameAndAddress(String name,String address);

@Query("select p from Person p where p.name=:name and p.address=:address")

List withNameAndAddressQuery(@Param("name")String Name,@Param("address")String address);

}

5、在web中建立DataController

packagecom.example.web;importjava.util.List;importorg.slf4j.Logger;importorg.slf4j.LoggerFactory;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.data.domain.Page;importorg.springframework.data.domain.PageRequest;importorg.springframework.data.domain.Sort;importorg.springframework.data.domain.Sort.Direction;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.RestController;importcom.example.domain.Person;importcom.example.repository.PersonRepository;

@RestControllerpublic classDataController {protected static Logger logger=LoggerFactory.getLogger(DataController.class);

@Autowired

PersonRepository personRepository;

@RequestMapping("/save")publicPerson save(String name,String address,Integer age){

logger.debug("save 开始");

Person p=personRepository.save(new Person(null,name,age,address));

logger.debug("save 结束");returnp;

}

@RequestMapping("/q1")public Listq1(String address){

logger.debug("q1 开始");

logger.debug("q1 接收参数address={}",address);

List people=personRepository.findByAddress(address);returnpeople;

}

@RequestMapping("/q2")public Listq2(String name,String address){

logger.debug("q2 开始");

logger.debug("q2接收参数name={},address={}",name,address);returnpersonRepository.findByNameAndAddress(name, address);

}

@RequestMapping("/q3")public Listq3(String name,String address){

logger.debug("q3 开始");

logger.debug("q3接收参数name={},address={}",name,address);returnpersonRepository.withNameAndAddressQuery(name, address);

}

@RequestMapping("/sort")public Listsort(){

logger.debug("sort 开始");

List people=personRepository.findAll(new Sort(Direction.ASC,"age"));returnpeople;

}

@RequestMapping("/page")public Pagepage(){

logger.debug("page 开始");

Page people=personRepository.findAll(new PageRequest(1,2));returnpeople;

}

}

6、配置数据库连接，在application.properties(src/main/resources下)

spring.datasource.url=jdbc:mysql://192.168.56.201:3306/bootsample?useUnicode=true&characterEncoding=UTF-8

spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.jpa.hibernate.ddl-auto=update

spring.jpa.show-sql=true

spring.jackson.serialization.indent_output=true

7、运行测试

A、先保存数据

http://localhost:8080/save?name=aa&&address=北京&&age=1

http://localhost:8080/save?name=ab&&address=北京&&age=2

http://localhost:8080/save?name=cq1&&address=重庆&&age=50

http://localhost:8080/save?name=cq2&&address=重庆&&age=51

B、查询q1

http://localhost:8080/q1?address=北京

C、查询q2

http://localhost:8080/q2?address=北京&&name=aa

D、查询q3

http://localhost:8080/q3?address=北京&&name=aa

E、排序

http://localhost:8080/sort

F、分页

http://localhost:8080/page

运用hibernate访问mysql，基本也是老技术，只是用JPA简化了dao层代码，对于业务对象基本没有变化。

————————————————

版权声明：本文为CSDN博主「lxhjh」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。

原文链接：https://blog.csdn.net/lxhjh/article/details/51755035