博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
基于spring boot的spring data jpa配置
阅读量:6869 次
发布时间:2019-06-26

本文共 4180 字,大约阅读时间需要 13 分钟。

hot3.png

一、下载jar包pom.xml配置
4.0.0
com.hxkj
spring-data-jpa
0.0.1-SNAPSHOT
org.springframework.boot
spring-boot-starter-parent
1.4.0.RELEASE
org.springframework.boot
spring-boot-starter-web
mysql
mysql-connector-java
org.springframework.boot
spring-boot-starter-data-jpa
org.springframework.boot
spring-boot-configuration-processor
true
org.springframework.boot
spring-boot-maven-plugin
上面的jar包,包含了spring boot的基本包,还有连接mysql的驱动包,和data jpa包。我用的spring boot最新版本进行搭建的。二、application.properties配置#jdbc datasource#数据源的基本配置spring.datasource.url=jdbc:mysql://127.0.0.1:3306/datajpa?useUnicode=true&characterEncoding=utf8spring.datasource.username=rootspring.datasource.password=rootspring.datasource.driver-class-name=com.mysql.jdbc.Driver#tomcat的连接配置,随个人的机器的配置来设定值spring.datasource.tomcat.max-wait=10000spring.datasource.tomcat.max-active=50000spring.datasource.tomcat.test-on-borrow=true# JPA (JpaBaseConfiguration, HibernateJpaAutoConfiguration)spring.jpa.database=MYSQL#该配置自动检查实体和数据库表是否一致,如果不一致则会进行更新数据库表,spring.jpa.hibernate.ddl-auto=update#显示sql语句spring.jpa.show-sql=true # EMBEDDED SERVER CONFIGURATION (ServerProperties)#服务器访问端口设置server.port=8080三、Application.java配置,作为spring boot的启动配置@EnableTransactionManagement//开启默认事务管理@SpringBootApplication//spring boot的配置启动容器@ServletComponentScan//servlet的扫描public class Application extends SpringBootServletInitializer { private static Logger logger = Logger.getLogger(Application.class); @Override protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) { return builder.sources(Application.class); } public static void main(String[] args) { SpringApplication.run(Application.class, args); logger.info("============= SpringBoot Start Success ============="); }}上面的类继承了SpringBootServletInitializer可以把项目打包war文件放入tomcat中进行运行。四、实体层基本配置@Entity@Table(name="sysuser")public class SysUser implements Serializable { private static final long serialVersionUID = -463669689326264297L; @Id @Column(name="SYSUSER_CUID") private String sysUserCuid; @Column(name="SYSUSER_NAME") private String sysUserName; @Column(name="SYSUSER_PASSWORD") private String sysUserPassword; @Column(name="SYSUSER_AGE") private Integer sysUserAge; public String getSysUserCuid() { return sysUserCuid; } public void setSysUserCuid(String sysUserCuid) { this.sysUserCuid = sysUserCuid; } public String getSysUserName() { return sysUserName; } public void setSysUserName(String sysUserName) { this.sysUserName = sysUserName; } public String getSysUserPassword() { return sysUserPassword; } public void setSysUserPassword(String sysUserPassword) { this.sysUserPassword = sysUserPassword; } public Integer getSysUserAge() { return sysUserAge; } public void setSysUserAge(Integer sysUserAge) { this.sysUserAge = sysUserAge; } }该配置会在数据库生成对应的表结构。五、dao层配置@Transactionalpublic interface ISysUserDao extends CrudRepository
{ }该dao继承了CrudRepository,其中实现了基本的操作数据库方法,查询、增加、删除、修改、直接接口调用即可。六、controller层调用实现@Controller@RequestMapping(value="sysUser")public class SysUserController { @Autowired private ISysUserDao iSysUserDao; @RequestMapping(value="findAll") @ResponseBody public Object findAll(){ return iSysUserDao.findAll(); } @RequestMapping(value="doInsert") @ResponseBody public Object doInsert(){ SysUser sysUser = new SysUser(); sysUser.setSysUserCuid(UUID.randomUUID().toString()); sysUser.setSysUserName("啊啊啊"); sysUser.setSysUserPassword("123456"); sysUser.setSysUserAge(21); return iSysUserDao.save(sysUser); }}访问就可得到结果,如下图。

七、结果显示

162618_Htcp_2661831.png

sql打印:

162703_iwOk_2661831.png

转载于:https://my.oschina.net/fellowtraveler/blog/727304

你可能感兴趣的文章
Flume-ng 高级功能配置
查看>>
我的友情链接
查看>>
CRM技术发展历程
查看>>
编译安装LAMP(php-fpm)步骤详解
查看>>
2-Ceph运维
查看>>
深入浅出Linux设备驱动编程--定时器
查看>>
常见移动设备的 CSS3 Media Query 整理(iPhone/iPad/Galaxy/HTC
查看>>
java递归-迷宫求解
查看>>
ImageButton实现触屏监听
查看>>
Unit13 What's the date today?
查看>>
IP地址解析
查看>>
iPhone开发之object c基础一定义接口
查看>>
Linux下清除磁盘分区及残留raid信息
查看>>
如何确认第二个sskgslcas就是获得Buffer Pin锁
查看>>
在Eclipse中配置tomcat
查看>>
Python基础
查看>>
springboot加载顺序
查看>>
python chapter 学习之序列
查看>>
我的友情链接
查看>>
Linux下如何知道自己外网的IP
查看>>