比较
表列出了JPA与其他持久化技术的比较
添加依赖
<!-- 引入jpa 依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
<version>${spring.boot}</version>
</dependency>
<!-- 引入MySQL连接依赖包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.41</version>
<scope>runtime</scope>
</dependency>
配置文件
##mysql
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/cc3?useUnicode=true&characterEncoding=utf8
username: root
password: 123456
#jpa
jpa:
hibernate:
ddl-auto: update
show-sql: true
jackson:
serialization:
indent_output: true
controller
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/login")
public Map<String, Object> login() {
userService.getUser("1");
return null;
}
}
service接口及serviceImpl
public interface UserService {
public Sys_users getUser(String id);
}
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
public Sys_users getUser(String id) {
// 有两种方式:
// 1.调用crudRepository的接口
System.out.println(userDao.findById(id).toString());
// 2.调用我们自己写的接口
System.out.println(userDao.getUser(id).toString());
return userDao.getUser(id);
}
}
dao
/**
* 注意:
* 1.这里这里是interface,不是class
*
* 2.CrudRepository里面的泛型,第一个是实体类,第二个是主键的类型
*
* 3.由于crudRepository 里面已经有一些接口了,如deleteAll,findOne等, 我们直接调用即可
*
* 4.当然,我们也可以根据自己的情况来实现自己的接口,如下面的getUser()方法,jpql语句和hql语句差不多
*
* */
public interface UserDao extends CrudRepository<Sys_users,String>{
/**
* 我们这里只需要写接口,不需要写实现,spring boot会帮忙自动实现
*
* */
@Query("from Sys_users where id =:id ")
public Sys_users getUser(@Param("id") String id);
}
entity
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import lombok.Data;
/**
* sys_users 实体类
* 2019-10-11 16:29:19 wcc
*/
@Entity
@Table(name="Sys_users")
@Data
public class Sys_users{
/**
*账号
*/
@Id @GeneratedValue(strategy=GenerationType.AUTO)
private String id;
/**
*名称
*/
private String name;
}
参考文档
springboot集成jpa
jpa优势