分享一下在springboot中使用mybatis
目录
导入依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
配置springboot
spring:
datasource:
type: org.apache.tomcat.jdbc.pool.DataSource
driverClassName: com.mysql.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/my_user?useUnicode=true&characterEncoding=UTF-8&useSSL=false
username: root
password: root
mybatis:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
mapper-locations: classpath*:sql/*.xml
dao层添加注解
@Mapper
public interface UserDao {
public List<User> query(User user);
}
SQL映射文件
<?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="dao的路径">
<parameterMap id="parameterMap" type="实体类的路径"></parameterMap>
<resultMap id="resultMap" type="实体类的路径">
<result property="id" column="id"/>
<result property="username" column="username"/>
<result property="age" column="age"/>
<result property="address" column="address"/>
</resultMap>
<select id="query" resultMap="resultMap" parameterMap="parameterMap">
select id,username,age,address from user
</select>
</mapper>
然后就可以开始使用了~