持久层:负责数据持久化,就是将数据存储到数据库或硬盘等,断电也不会丢失数据
ctrl+d可以快速复制一行
1加入依赖
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.37</version> </dependency>
引入mysql就要写执行sql的xml文件TestMapper.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.course.system.mapper.TestMapper">接口的位置 一个接口对应一个sql的xml文件 <select id="list" resultType="com.course.system.domain.Test">对应实体类的位置 select id,name from test </select> </mapper>
配置数据库连接application.properties
spring.application.name=system #地址要拼接/system server.servlet.context-path=/system server.port=9001 eureka.client.service-url.defaultZone= http://localhost:8761/eureka/ #增加数据库连接 spring.datasource.url=jdbc:mysql://localhost:3306/course?useSSL=true& useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8 spring.datasource.username=root spring.datasource.password=x5 一定要写清楚,最好是粘贴,检查数据库名对不对 spring.datasource.driver-class-name=com.mysql.jdbc.Driver启动数据库连接 扫描mapper下的所有xml文件 mybatis.mapper-locations=classpath:/mapper/*.xml 曾删改查 ccontroller层
@RestController public class TestController { @Resource private TestService testService; @RequestMapping("/test") public List<Test> test(){ return testService.list(); } }
domain实体类,记得加get,set方法
private String id; private String name;
mapper接口,写了查询,可以写其他的
public interface TestMapper { public List<Test> list(); }
service层
@Service public class TestService { @Resource private TestMapper testMapper; public List<Test> list(){ return testMapper.list(); } }