springboot + jpa 練習(xí)

spingboot集成jpa(一）：最基本的環(huán)境搭建 spingboot集成jpa(二）：使用單元測(cè)試

?

?

1. pom.xml中添加依賴

<!-- jdbc --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId></dependency><!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency>

2. application.propertis添加配置

spring.datasource.url=jdbc:mysql://localhost:3306/test spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.jpa.properties.hibernate.hbm2ddl.auto=update spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect spring.jpa.show-sql=true

3. 實(shí)體類User.java創(chuàng)建

package com.king.entity;import java.util.Date; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table;@Entity @Table(name="m_user") public class User{@Id@Column(name="ID")private String id;@Column(name="user_code")private String code;@Column(name="user_name")private String username;@Column(name="user_pwd")private String password;@Column(name="update_tmsp")private Date updateTime;public String getId() {return id;}public void setId(String id) {this.id = id;}public String getCode() {return code;}public void setCode(String code) {this.code = code;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public Date getUpdateTime() {return updateTime;}public void setUpdateTime(Date updateTime) {this.updateTime = updateTime;}@Overridepublic String toString() {return "User [id=" + id + ", code=" + code + ", username=" + username+ ", password=" + password + ", updateTime=" + updateTime + "]";} }

4. dao層創(chuàng)建UserDao.java繼承JpaRepository

package com.king.dao;import org.springframework.data.jpa.repository.JpaRepository;import com.king.entity.User;public interface UserDao extends JpaRepository<User, String>{}

5. service層創(chuàng)建查詢方法，并裝備dao中的方法

UserService接口

package com.king.service;import java.util.List; import com.king.entity.User;public interface UserService {public User findOne(String id);public List<User> findAll(); }

UserService實(shí)現(xiàn)類

package com.king.service.impl;import java.util.List;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.king.dao.UserDao; import com.king.entity.User; import com.king.service.UserService;@Service("userService") public class UserServiceImpl implements UserService{@Autowiredprivate UserDao userDao;@Overridepublic User findOne(String id) {return userDao.findOne(id);}@Overridepublic List<User> findAll() {return userDao.findAll();} }

6. controller層查詢

package com.king.controller;import java.util.List;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController;import com.king.entity.User; import com.king.service.UserService;@RestController public class UserController {@Autowiredprivate UserService userService;@RequestMapping("/queryUser")public User getUser(String id){return userService.findOne(id);}@RequestMapping("/queryAll")public List<User> getAll(){return userService.findAll();}}

7. App中配置掃描

package com.king.app;import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.EnableAutoConfiguration; import org.springframework.boot.autoconfigure.domain.EntityScan; import org.springframework.context.annotation.ComponentScan; import org.springframework.data.jpa.repository.config.EnableJpaRepositories;@ComponentScan(basePackages={"com.king.controller","com.king.service"}) @EnableJpaRepositories(basePackages="com.king.dao") @EntityScan(basePackages="com.king.entity") @EnableAutoConfiguration public class App {public static void main(String[] args) {SpringApplication.run(App.class, args);} }

到此，所有的配置完成。

測(cè)試1：根據(jù)id查詢單個(gè)對(duì)象,返回json對(duì)象

測(cè)試2： 測(cè)試查詢所有對(duì)象，返回json數(shù)組

?

轉(zhuǎn)載于:https://www.cnblogs.com/30go/p/8440343.html

總結(jié)

以上是生活随笔為你收集整理的spingboot集成jpa(一）的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。