一、下载jar包pom.xml配置上面的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 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 { }该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); }}访问就可得到结果,如下图。
七、结果显示
sql打印: