首先创建一个springboot的项目
- 创建实体类
@Data
public class User {
private Integer id;
private String name;
private String sexTime;
}
-
创建dao
创建接口dao
@Mapper
public interface UserMapper {
List<User> findById(Long id);
}
创建mybatis的影射文件
<?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.exceptiondeal.demo.mapper.UserMapper">
<select id="findById" parameterType="Long" resultType="User">
select * from user where id = #{id}
</select>
</mapper>
3.添加yml文件
spring:
application:
name: mybatisTest
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/demos?useUnicode=true&CharacterEncoding=utf-8&useSSL=false
username: root
password: root
server:
port: 8001
mybatis:
mapper-locations: classpath:mapper/*.xml
//配置别名
type-aliases-package: com.exceptiondeal.demo.entities
//配置驼峰影射
configuration:
map-underscore-to-camel-case: true
- 添加依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.2</version>
</dependency>
<dependency>
<groupId>javax.persistence</groupId>
<artifactId>persistence-api</artifactId>
<version>1.0</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>