ideaJPA实现mysql_idea下整合springboot+spring data jpa

1.建立springboot工程，File->new->project

1.png

2.png

3.png

4.png

5.png

2.配置application.properties文件

spring.datasource.url=jdbc:mysql://localhost:3306/students?characterEncoding=utf-8&useSSL=true&serverTimezone=GMT

spring.datasource.username=root

spring.datasource.password=123456

spring.jpa.database=mysql

spring.jpa.show-sql=true

spring.jpa.hibernate.ddl-auto=update

spring.mvc.view.prefix=/

spring.mvc.view.suffix=.html

spring.thymeleaf.mode=HTML5

spring.thymeleaf.encoding=UTF-8

spring.thymeleaf.cache=false

3.建立数据库

建立students数据库

create database students CHARACTER SET utf8 COLLATE utf8_general_ci;

4.建立Stu实体类(实体类建立好以后,运行项目，jpa便会自动在students数据库中生成相应的stu表)

@Entity

//@JsonIgnoreProperties(value = {"hibernateLazyInitializer", "handler"})

@Proxy(lazy = false) //关闭延迟加载，不然测试单元总是报错

public class Stu {

@Id

@GeneratedValue

private Integer id;

private String name;

private String school;

public Stu(){

}

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getSchool() {

return school;

}

public void setSchool(String school) {

this.school = school;

}

@Override

public String toString() {

return "Stu{" +

"id=" + id +

", name='" + name + '\'' +

", school='" + school + '\'' +

'}';

}

}

@Entity实体类里的基本注解包括有@Entity、@Table、@Id、@IdClass、@GeneratedValue、@Basic、@Transient、@Column、@Temporal、@Enumerated、@Lob

5.建立StuRepository接口

public interface StuRepository extends JpaRepository {

}

JPA关键字列表如下所示:

关键字

示例

JPQL表达

And

findByLastnameAndFirstname

... where x.lastname=?1 and x.firstname=?2

Or

findByLastnameOrFirstname

...where x.lastname=?1 or x.firstname=?2

Is、Equals

findByFirstname、findByFirstnameIs、findByFirstnameEquals

...where x.firstname = ?1

Between

findByStartDateBetween

..where x.startDate between ?1 and ?2

LessThan

findByAgeLessThan

...where x.age1

LessThanEqual

findByAgeLessThanEqual

...where x.age<=?1

GreaterThan

findByAgeGreaterThan

... where x.age>?1

GreaterThanEqual

findByAgeGreaterThanEqual

... where x.age>=?1

After

findByStartDateAfter

...where x.startDate>?1

Before

findByStartDateBefore

... where x.startDate1

isNull

findByAgeIsNull

...where x.age is null

IsNotNull,NotNull

findByAge(Is)NotNull

..where x.age not null

Like

findByFirstnameLike

...where x.firstname like ?1

NotLike

findByFirstnameNotLike

...where x.firstname not like ?1

StartingWith

findByFirstnameStartingWith

...where x.firstname like ?1(参数增加前缀%)

EndingWith

findByFirstnameEndingWith

...where x.firstname like ?1(参数增加后缀%)

Containing

findByFirstnameContaining

...where x.firstname like ?1(参数被%包裹)

OrderBy

findByAgeOrderByLastnameDesc

...where x.age=?1 order by x.lastname desc

Not

findByLastnameNot

... where x.lastname <> ?1

In

findByAgeIn(Collectionages)

...where x.age in ?1

NotIn

findByAgeNotIn(Collectionages)

...where x.age not in ?1

True

findByActiveTrue()

...where x.active = true

False

findByActiveFalse()

...where x.active = false

IgnoreCase

findByFirstnameIgnoreCase

...where UPPER(x.firstname)UPPER(?1)

6.建立StuDao接口以及实现类

public interface StuDao {

Stu findOne(Integer id);

}

@Repository

public class StuDaoImpl implements StuDao {

@Autowired

private StuRepository stuRepository;

@Override

public Stu findOne(Integer id) {

return stuRepository.getOne(id);

}

}

7.建立service接口以及实现类

public interface StuService {

Stu findStuById(Integer id);

}

@Service

public class StuServiceImpl implements StuService {

@Autowired

private StuDao stuDao;

@Override

public Stu findStuById(Integer id) {

return stuDao.findOne(id);

}

}

8.建立controller层

@RestController

public class StuController {

@Autowired

private StuService stuService;

@GetMapping(value = "/findStu/{id}")

public Stu findStu(@PathVariable("id") Integer id) {

return stuService.findStuById(id);

}

}

6.png

9.浏览器测试

向students数据库中插入一条数据

insert stu(id, name, school)values(1,'zhangsan', 'zju');

通过TestApplication里的主函数来启动项目程序，然后在浏览器中输入

7.png

测试成功，整合完毕！

10.单元测试

若要测试stuService接口，先打开stuService界面，然后右键->Go To->Test->Create New Test,然后选中要测试的方法，idea便会在test文件下自动帮你生成一个测试的service的测试类,然后自己补充测试代码

@RunWith(SpringRunner.class)

@SpringBootTest

//如果报错就将@SpringBootTest改成下列这句话

//@SpringBootTest(classes = StuServiceTest.class)

public class StuServiceTest {

@Autowired

private StuService stuService;

@Test

public void findStuById() {

Stu stu = stuService.findStuById(1);

System.out.println(stu);

}

}

右键->Run findStuById()

8.png

测试成功，信息打印在控制台里了。