blog目标
环境搭建
springboot对jpa的支持
生成数据库表
直接上操作教学就完事
先处理pom文件是必须的:和数据库挂钩的pom依赖
<mysql.version>5.1.44</mysql.version>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
</dependency>
//由于之前环境搭建中以及选中了JPA所以这里不需要导入当然没有选中可以手动导入如下代码
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
配置文件application.yml
server:
port: 80
servlet:
context-path: /
spring:
jpa:
hibernate:
ddl-auto: update
show-sql: true
datasource:
#1.JDBC
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
username: root
password: 123
druid:
initial-size: 5
min-idle: 5
max-active: 20
max-wait: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 30000
validation-query: SELECT 1 FROM DUAL
test-while-idle: true
test-on-borrow: true
test-on-return: false
pool-prepared-statements: true
max-pool-prepared-statement-per-connection-size: 20
filter:
stat:
merge-sql: true
slow-sql-millis: 5000
web-stat-filter:
enabled: true
url-pattern: /*
exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"
session-stat-enable: true
session-stat-max-count: 100
stat-view-servlet:
enabled: true
url-pattern: /druid/*
reset-enable: true
login-username: admin
login-password: admin
allow: 127.0.0.1
entity实体包
package com.onlyk.springboot03.entity;
import javax.persistence.*;
/**
* @author only老K
* @create 2020-01-02 16:32
*/
@Data
@Entity
@Table(name="springboot_student")
public class Student {
@Id
@GeneratedValue
private int sid;
@Column
private String name;
@Column
private String sex;
}
讲述上面实体包使用到的注解:
@Id:主键的意思
@GeneratedValue:自增长
@Column:列段
@Entity:实体类
@Table(name="springboot_student")//name里面的值是表名
@Data:提供set,get,tostring方法
测试数据
StudentDao
package com.onlyk.springboot03.dao;
import com.onlyk.springboot03.entity.Student;
import org.springframework.data.jpa.repository.JpaRepository;
/**
* @author only老K
* @create 2020-01-02 16:52
*/
public interface StudentDao extends JpaRepository<Student,Integer> {
}
StudentController
package com.onlyk.springboot03.controller;
import com.onlyk.springboot03.dao.StudentDao;
import com.onlyk.springboot03.entity.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
/**
* @author only老K
* @create 2020-01-02 16:54
*/
@RestController
public class StudentController {
@Autowired
private StudentDao studentDao;
@RequestMapping("/add")
public String add(Student student){
studentDao.save(student);
return "success";
}
@RequestMapping("/edit")
public String edis(Student student){
studentDao.save(student);
return "success";
}
@RequestMapping("/del")
private String del(Student student){
studentDao.delete(student);
return "success";
}
@RequestMapping("/getOne")
public Student getOne(Integer sid){
return studentDao.findById(sid).get();
}
@RequestMapping("/getAll")
public List<Student> getAll(){
return studentDao.findAll();
}
}
查询全部getAll
增加Add
修改add
查询单个getOne
删除自行测试
CRUD案例
删除和新增自行测试即可
上代码:
MyWebAppConfi