一,准备工作,建立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