本篇文章主要介绍了spring boot 添加mysql数据库及jpa，小编觉得挺不错的，现在分享给大家，也给大家做个参考。一起跟随小编过来看看吧
最近在学习spring boot，继续前面的学习，这一次我们加入mysql数据库和jpa。
配置:
pom.xml文件
<!-- 添加mysql和jpa-->
<dependency>
<groupid>org.springframework.boot</groupid>
<artifactid>spring-boot-starter-data-jpa</artifactid>
</dependency>
<dependency>
<groupid>mysql</groupid>
<artifactid>mysql-connector-java</artifactid>
</dependency>
在application.properties(在resource文件夹下新建，进行配置)文件中添加数据进行配置：
spring.datasource.url = jdbc:mysql://localhost:3306/spring_boot
spring.datasource.username = root
spring.datasource.password = root
spring.datasource.driverclassname = com.mysql.jdbc.driver
# specify the dbms
spring.jpa.database = mysql
# show or not log for each sql query
spring.jpa.show-sql = true
# hibernate ddl auto (create, create-drop, update)
spring.jpa.hibernate.ddl-auto = update
# naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.improvednamingstrategy
# stripped before adding them to the entity manager)
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.mysql5dialect
user类
package com.seawater.bean;
import javax.persistence.*;
import javax.validation.constraints.notnull;
/**
* created by zhouhs on 2016/12/30.
*/
@entity
@table(name = "user")
public class user {
@id
@generatedvalue(strategy = generationtype.auto)
private long id;
private string name;
private int age;
public long getid() {
return id;
}
public void setid(long id) {
this.id = id;
}
public string getname() {
return name;
}
public void setname(string name) {
this.name = name;
}
public int getage() {
return age;
}
public void setage(int age) {
this.age = age;
}
}
usercontroller
package com.seawater.controller;
import com.seawater.dao.userdao;
import com.seawater.bean.user;
import io.swagger.annotations.api;
import io.swagger.annotations.apiimplicitparam;
import io.swagger.annotations.apiimplicitparams;
import io.swagger.annotations.apioperation;
import org.springframework.web.bind.annotation.requestmapping;
import org.springframework.web.bind.annotation.requestmethod;
import org.springframework.web.bind.annotation.requestparam;
import org.springframework.web.bind.annotation.restcontroller;
import javax.annotation.resource;
/**
* created by zhouhs on 2016/12/30.
*/
@restcontroller
@requestmapping(value = "/user")
@api(description = "用户")
public class usercontroller {
@resource
userdao userdao;
@apioperation(value = "添加用户")
@apiimplicitparams({
@apiimplicitparam(name = "name" , value = "name" , paramtype = "query" , required = true ),
@apiimplicitparam(name = "age" , value = "age" , paramtype = "query" , required = true )
})
@requestmapping(value = "/adduser" , method = requestmethod.post)
public string adduser(@requestparam(value = "name") string name,@requestparam(value = "age") int age){
user user = new user();
user.setname(name);
user.setage(age);
userdao.save(user);
return "add user success !";
}
@apioperation(value = "查找用户")
@apiimplicitparam(name = "id" , value = "id" , paramtype = "query" , required = true , datatype = "int")
@requestmapping(value = "/findbyid" , method = requestmethod.post)
public string findbyid(@requestparam(value = "id") long id){
user user = userdao.findbyid(id);
if(user == null){
return "error";
}else{
return "name:" + user.getname() + " , age:" + user.getage();
}
}
@apioperation(value = "查询所有用户")
@requestmapping(value = "/findall" , method = requestmethod.post)
public iterable findall(){
iterable<user> userlist = userdao.findall();
return userlist;
}
@apioperation(value = "删除用户")
@apiimplicitparam(name = "id" , value = "id" , paramtype = "query" , required = true , datatype = "int")
@requestmapping(value = "/deletebyid" , method = requestmethod.post)
public string deletebyid(@requestparam(value = "id") long id){
userdao.delete(id);
return "delete success !";
}
}
数据表(id定义为integer)：
userdao:
package com.seawater.dao;
import com.seawater.bean.user;
import org.springframework.data.repository.crudrepository;
/**
* created by zhouhs on 2016/12/30.
*/
public interface userdao extends crudrepository<user, long> {
public user findbyid(long id);
}
然后启动项目：访问localhost:8081/swagger-ui.html
结果：
方法我就不一一操作了。
以上就是spring boot添加mysql数据库及jpa实例的示例代码分享的详细内容。