电脑知识|欧美黑人一区二区三区|软件|欧美黑人一级爽快片淫片高清|系统|欧美黑人狂野猛交老妇|数据库|服务器|编程开发|网络运营|知识问答|技术教程文章 - 好吧啦网

您的位置:首頁技術(shù)文章
文章詳情頁

SpringBoot整合spring-data-jpa的方法

瀏覽:3日期:2023-05-09 08:41:34

jpa是JavaEE定義的一種規(guī)范,常用的實(shí)現(xiàn)一般是Hibernate,而spring-data-jpa則是對(duì)jpa的又一層封裝,提供了更多便捷的方法。

這里不會(huì)深入講解spring-data-jpa的使用,只是講解怎么快速的整合使用,目的是幫助那些想學(xué),但是在整合上老是翻車的同學(xué)

導(dǎo)入依賴

<dependency><groupId>com.zaxxer</groupId><artifactId>HikariCP</artifactId></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId></dependency>

配置

spring: data: jpa: repositories: # 開啟jpa enabled: true bootstrap-mode: default jpa: # 數(shù)據(jù)庫方言 database-platform: org.hibernate.dialect.MySQL57Dialect open-in-view: false # 打印SQL show-sql: false properties: # 格式化輸出的SQL語句 hibernate.format_sql: false hibernate: # 自動(dòng)建表策略 ddl-auto: update

這里忽略了數(shù)據(jù)源的配置

關(guān)于自動(dòng)建表策略

# 枚舉值spring.jpa.hibernate.ddl-autocreate不管表是否存在, 每次啟動(dòng)都會(huì)重新建表(會(huì)導(dǎo)致數(shù)據(jù)丟失)create-drop啟動(dòng)的時(shí)候創(chuàng)建表, 程序退出(SessionFactory關(guān)閉)的時(shí)候刪除表none不進(jìn)行任何操作update如果數(shù)據(jù)表不存在則創(chuàng)建, 在實(shí)體對(duì)象被修改后,下次啟動(dòng)重新修改表結(jié)構(gòu)(不會(huì)刪除已經(jīng)存在的數(shù)據(jù))validate啟動(dòng)的時(shí)候驗(yàn)證數(shù)據(jù)表的結(jié)構(gòu),

相關(guān)的配置類

這里僅僅列出了部分常用的配置,如果需要了解所有的配置信息,可以參考配置類

JpaPropertiesSpringDataWebPropertiesHibernateProperties

相關(guān)配置的文檔docs.spring.io/spring-boot…

定義實(shí)體類User

import java.io.Serializable;import java.time.LocalDateTime;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.Enumerated;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.Index;import javax.persistence.Table;// 指定表名稱@Table(name = 'user', indexes = {// 定義索引@Index(columnList = 'account', unique = true) })// 標(biāo)識(shí)實(shí)體類@Entity// 設(shè)置表注釋@org.hibernate.annotations.Table(appliesTo = 'user', comment = '用戶')public class User implements Serializable {/** * */private static final long serialVersionUID = 4953012795378725917L;@Id // id 字段@Column(columnDefinition = 'INT(11) UNSIGNED COMMENT ’id’')@GeneratedValue(strategy = GenerationType.IDENTITY) // 自增private Integer id;// 賬戶@Column(columnDefinition = 'VARCHAR(50) COMMENT ’登錄賬戶’', nullable = false)private String account;// 密碼@Column(columnDefinition = 'VARCHAR(255) COMMENT ’登錄密碼’', nullable = false)private String password;// 性別@Column(columnDefinition = 'TINYINT(1) COMMENT ’性別。0:男,1:女’', nullable = false)@Enumeratedprivate Gender gender;// 創(chuàng)建時(shí)間@Column(name = 'created_date', columnDefinition = 'timestamp DEFAULT CURRENT_TIMESTAMP COMMENT ’創(chuàng)建時(shí)間’', nullable = false)private LocalDateTime createdDate;// 最后修改時(shí)間@Column(name = 'last_modified_date', columnDefinition = 'timestamp NULL DEFAULT NULL COMMENT ’最后一次修改時(shí)間’')private LocalDateTime lastModifiedDate;// 記錄狀態(tài)@Column(columnDefinition = 'TINYINT(1) unsigned COMMENT ’是否啟用’', nullable = false)private Boolean enabled;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getAccount() {return account;}public void setAccount(String account) {this.account = account;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public Gender getGender() {return gender;}public void setGender(Gender gender) {this.gender = gender;}public LocalDateTime getCreatedDate() {return createdDate;}public void setCreatedDate(LocalDateTime createdDate) {this.createdDate = createdDate;}public LocalDateTime getLastModifiedDate() {return lastModifiedDate;}public void setLastModifiedDate(LocalDateTime lastModifiedDate) {this.lastModifiedDate = lastModifiedDate;}public Boolean getEnabled() {return enabled;}public void setEnabled(Boolean enabled) {this.enabled = enabled;}@Overridepublic String toString() {return 'User [id=' + id + ', account=' + account + ', password=' + password + ', gender=' + gender+ ', createdDate=' + createdDate + ', lastModifiedDate=' + lastModifiedDate + ', enabled=' + enabled+ ']';}public static enum Gender {BOY, GIRL}}

Repository

抽象出BaseRepository

import org.springframework.data.jpa.repository.JpaRepository;import org.springframework.data.jpa.repository.JpaSpecificationExecutor;import org.springframework.data.repository.NoRepositoryBean;@NoRepositoryBean // 該接口不是一個(gè)Repository,不需要生成代理實(shí)現(xiàn)public interface BaseRepository <T, ID> extends JpaRepository<T, ID>, JpaSpecificationExecutor <T>// , QuerydslPredicateExecutor<T> 如果使用了QueryDSL還可以實(shí)現(xiàn)這個(gè)接口{}

定義 UserRepository

import io.springboot.jpa.entity.User;public interface UserRepository extends BaseRepository<User, Integer> {}

Service

抽象出 BaseService

import org.springframework.data.jpa.repository.JpaRepository;import org.springframework.data.jpa.repository.JpaSpecificationExecutor;public interface BaseService<T, ID> extends JpaRepository<T, ID>, JpaSpecificationExecutor <T>// , QuerydslPredicateExecutor<T> {}

抽象出 AbstractService

import java.util.List;import java.util.Optional;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.data.domain.Example;import org.springframework.data.domain.Page;import org.springframework.data.domain.Pageable;import org.springframework.data.domain.Sort;import org.springframework.data.jpa.domain.Specification;import org.springframework.transaction.annotation.Transactional;import io.springboot.jpa.repository.BaseRepository;public abstract class AbstractService<T, ID> implements BaseService <T, ID> {/** * 泛型注入 */@Autowiredprotected BaseRepository<T, ID> baseRepository;@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public List<T> findAll() {return this.baseRepository.findAll();}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public List<T> findAll(Sort sort) {return this.baseRepository.findAll(sort);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public List<T> findAllById(Iterable<ID> ids) {return this.baseRepository.findAllById(ids);}@Override@Transactional(rollbackFor = Throwable.class)public <S extends T> List<S> saveAll(Iterable<S> entities) {return this.baseRepository.saveAll(entities);}@Override@Transactional(rollbackFor = Throwable.class)public void flush() {this.baseRepository.flush();}@Transactional(rollbackFor = Throwable.class)public <S extends T> S saveAndFlush(S entity) {return this.baseRepository.saveAndFlush(entity);}@Override@Transactional(rollbackFor = Throwable.class)public void deleteInBatch(Iterable<T> entities) {this.baseRepository.deleteInBatch(entities);}@Override@Transactional(rollbackFor = Throwable.class)public void deleteAllInBatch() {this.baseRepository.deleteAllInBatch();}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public T getOne(ID id) {return this.baseRepository.getOne(id);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public <S extends T> List<S> findAll(Example<S> example) {return this.baseRepository.findAll(example);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public <S extends T> List<S> findAll(Example<S> example, Sort sort) {return this.baseRepository.findAll(example, sort);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public Page<T> findAll(Pageable pageable) {return this.baseRepository.findAll(pageable);}@Override@Transactional(rollbackFor = Throwable.class)public <S extends T> S save(S entity) {return this.baseRepository.save(entity);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public Optional<T> findById(ID id) {return this.baseRepository.findById(id);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public boolean existsById(ID id) {return this.baseRepository.existsById(id);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public long count() {return this.baseRepository.count();}@Override@Transactional(rollbackFor = Throwable.class)public void deleteById(ID id) {this.baseRepository.deleteById(id);}@Override@Transactional(rollbackFor = Throwable.class)public void delete(T entity) {this.baseRepository.delete(entity);}@Override@Transactional(rollbackFor = Throwable.class)public void deleteAll(Iterable<? extends T> entities) {this.baseRepository.deleteAll(entities);}@Override@Transactional(rollbackFor = Throwable.class)public void deleteAll() {this.baseRepository.deleteAll();}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public <S extends T> Optional<S> findOne(Example<S> example) {return this.baseRepository.findOne(example);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public <S extends T> Page<S> findAll(Example<S> example, Pageable pageable) {return this.baseRepository.findAll(example, pageable);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public <S extends T> long count(Example<S> example) {return this.baseRepository.count(example);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public <S extends T> boolean exists(Example<S> example) {return this.baseRepository.exists(example);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public Optional<T> findOne(Specification<T> spec) {return this.baseRepository.findOne(spec);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public List<T> findAll(Specification<T> spec) {return this.baseRepository.findAll(spec);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public Page<T> findAll(Specification<T> spec, Pageable pageable) {return this.baseRepository.findAll(spec, pageable);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public List<T> findAll(Specification<T> spec, Sort sort) {return this.baseRepository.findAll(spec, sort);}@Override@Transactional(readOnly = true, rollbackFor = Throwable.class)public long count(Specification<T> spec) {return this.baseRepository.count(spec);}}

定義 UserService

import org.springframework.stereotype.Service;import io.springboot.jpa.entity.User;@Servicepublic class UserService extends AbstractService<User, Integer> {}

添加注解驅(qū)動(dòng)

import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.boot.autoconfigure.domain.EntityScan;import org.springframework.data.jpa.repository.config.EnableJpaRepositories;@SpringBootApplication@EnableJpaRepositories(basePackages = { 'io.springboot.jpa.repository' })@EntityScan(basePackages = { 'io.springboot.jpa.entity' })public class JpaApplication {public static void main(String[] args) {SpringApplication.run(JpaApplication.class, args);}}

@EnableJpaRepositories指定repository所在的包@EntityScan指定entity所在的包

測試

import io.springboot.jpa.JpaApplication;import io.springboot.jpa.entity.User;import io.springboot.jpa.service.UserService;import java.time.LocalDateTime;import org.junit.Test;import org.junit.runner.RunWith;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.test.context.SpringBootTest;import org.springframework.test.context.junit4.SpringRunner;@RunWith(SpringRunner.class)@SpringBootTest(classes = JpaApplication.class, webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)public class JpaApplicationTest {static final Logger LOGGER = LoggerFactory.getLogger(JpaApplicationTest.class);@AutowiredUserService userService;@Testpublic void test () {// 存儲(chǔ)User user = new User();user.setAccount('kevinblandy.cn@gmail.com');user.setPassword('123456');user.setGender(User.Gender.GIRL);user.setEnabled(Boolean.TRUE);user.setCreatedDate(LocalDateTime.now());this.userService.save(user);LOGGER.info('save success.....');// 檢索User results = this.userService.findById(user.getId()).orElseGet(null);LOGGER.info('query result={}', results);}}

自動(dòng)創(chuàng)建的表

CREATE TABLE `user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT ’id’, `account` varchar(50) NOT NULL COMMENT ’登錄賬戶’, `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ’創(chuàng)建時(shí)間’, `enabled` tinyint(1) unsigned NOT NULL COMMENT ’是否啟用’, `gender` tinyint(1) NOT NULL COMMENT ’性別。0:男,1:女’, `last_modified_date` timestamp NULL DEFAULT NULL COMMENT ’最后一次修改時(shí)間’, `password` varchar(255) NOT NULL COMMENT ’登錄密碼’, PRIMARY KEY (`id`), UNIQUE KEY `UKdnq7r8jcmlft7l8l4j79l1h74` (`account`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=’用戶’;

執(zhí)行的日志

Hibernate: insert into user (account, created_date, enabled, gender, last_modified_date, password) values (?, ?, ?, ?, ?, ?)2020-06-23 17:57:36.264 INFO 7612 --- [ main] i.s.jpa.test.JpaApplicationTest : save success.....Hibernate: select user0_.id as id1_0_0_, user0_.account as account2_0_0_, user0_.created_date as created_3_0_0_, user0_.enabled as enabled4_0_0_, user0_.gender as gender5_0_0_, user0_.last_modified_date as last_mod6_0_0_, user0_.password as password7_0_0_ from user user0_ where user0_.id=?2020-06-23 17:57:36.303 INFO 7612 --- [ main] i.s.jpa.test.JpaApplicationTest : query result=User [id=1, account=kevinblandy.cn@gmail.com, password=123456, gender=GIRL, createdDate=2020-06-23T17:57:36, lastModifiedDate=null, enabled=true]

總結(jié)

到此這篇關(guān)于SpringBoot整合spring-data-jpa的方法的文章就介紹到這了,更多相關(guān)SpringBoot整合spring-data-jpa內(nèi)容請搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!

標(biāo)簽: Spring
相關(guān)文章:
主站蜘蛛池模板: 断桥铝破碎机_铝合金破碎机_废铁金属破碎机-河南鑫世昌机械制造有限公司 | 对辊式破碎机-对辊制砂机-双辊-双齿辊破碎机-巩义市裕顺机械制造有限公司 | 昆山PCB加工_SMT贴片_PCB抄板_线路板焊接加工-昆山腾宸电子科技有限公司 | 杭州中策电线|中策电缆|中策电线|杭州中策电缆|杭州中策电缆永通集团有限公司 | 垃圾处理设备_餐厨垃圾处理设备_厨余垃圾处理设备_果蔬垃圾处理设备-深圳市三盛环保科技有限公司 | 档案密集架_电动密集架_移动密集架_辽宁档案密集架-盛隆柜业厂家现货批发销售价格公道 | 【365公司转让网】公司求购|转让|资质买卖_股权转让交易平台 | 热风机_工业热风机生产厂家上海冠顶公司提供专业热风机图片价格实惠 | 深圳宣传片制作-企业宣传视频制作-产品视频拍摄-产品动画制作-短视频拍摄制作公司 | 基本型顶空进样器-全自动热脱附解吸仪价格-AutoHS全模式-成都科林分析技术有限公司 | 披萨石_披萨盘_电器家电隔热绵加工定制_佛山市南海区西樵南方综合保温材料厂 | 合肥钣金加工-安徽激光切割加工-机箱机柜加工厂家-合肥通快 | 桨叶搅拌机_螺旋挤压/方盒旋切造粒机厂家-无锡市鸿诚输送机械有限公司 | 水性绝缘漆_凡立水_绝缘漆树脂_环保绝缘漆-深圳维特利环保材料有限公司 | 上海单片机培训|重庆曙海培训分支机构—CortexM3+uC/OS培训班,北京linux培训,Windows驱动开发培训|上海IC版图设计,西安linux培训,北京汽车电子EMC培训,ARM培训,MTK培训,Android培训 | 金刚网,金刚网窗纱,不锈钢网,金刚网厂家- 河北萨邦丝网制品有限公司 | 小型气象站_便携式自动气象站_校园气象站-竞道气象设备网 | 消防设施操作员考试报名时间,报名入口,报考条件 | 连续油炸机,全自动油炸机,花生米油炸机-烟台茂源食品机械制造有限公司 | 钢绞线万能材料试验机-全自动恒应力两用机-混凝土恒应力压力试验机-北京科达京威科技发展有限公司 | 双齿辊破碎机-大型狼牙破碎机视频-对辊破碎机价格/型号图片-金联机械设备生产厂家 | 罗茨真空机组,立式无油往复真空泵,2BV水环真空泵-力侨真空科技 | 称重传感器,测力传感器,拉压力传感器,压力变送器,扭矩传感器,南京凯基特电气有限公司 | 卧涛科技有限公司科技项目申报公司|高新技术企业申报|专利申请 | 排烟防火阀-消防排烟风机-正压送风口-厂家-价格-哪家好-德州鑫港旺通风设备有限公司 | 校车_校车价格_19座幼儿园校车_幼儿园校车_大鼻子校车 | 首页-恒温恒湿试验箱_恒温恒湿箱_高低温试验箱_高低温交变湿热试验箱_苏州正合 | 喷码机,激光喷码打码机,鸡蛋打码机,手持打码机,自动喷码机,一物一码防伪溯源-恒欣瑞达有限公司 | 圆形振动筛_圆筛_旋振筛_三次元振动筛-河南新乡德诚生产厂家 | 粉碎机_塑料粉碎机_塑料破碎机厂家-星标机械 | 无锡市珂妮日用化妆品有限公司|珂妮日化官网|洗手液厂家 | 面粉仓_储酒罐_不锈钢储酒罐厂家-泰安鑫佳机械制造有限公司 | 盐水蒸发器,水洗盐设备,冷凝结晶切片机,转鼓切片机,絮凝剂加药系统-无锡瑞司恩机械有限公司 | 开云(中国)Kaiyun·官方网站 - 登录入口 | 武汉高温老化房,恒温恒湿试验箱,冷热冲击试验箱-武汉安德信检测设备有限公司 | Win10系统下载_32位/64位系统/专业版/纯净版下载 | 胃口福饺子加盟官网_新鲜现包饺子云吞加盟 - 【胃口福唯一官网】 | 炉门刀边腹板,焦化设备配件,焦化焦炉设备_沧州瑞创机械制造有限公司 | 不锈钢列管式冷凝器,换热器厂家-无锡飞尔诺环境工程有限公司 | 电机修理_二手电机专家-河北豫通机电设备有限公司(原石家庄冀华高压电机维修中心) | 船用锚链|专业锚链生产厂家|安徽亚太锚链制造有限公司 |