依赖导入
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.27</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.0</version>
</dependency>
dao层
在dao层建立UserMapper接口,并写方法
然后在resources建立mapper包,然后起名UserMapper.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.nowcoder.community.dao.UserMapper">
</mapper>
namespace要和接口路径对应
sql语句
如果 在以后的事务中会增加属性,但是xml配置文件就要逐项对语句的select 后的属性增加,工作量很大,所以可以用复用语句。
<sql id="insertFields">
username, password, salt, email, type, status, activation_code, header_url, create_time
</sql>
<sql id="selectFields">
id, username, password, salt, email, type, status, activation_code, header_url, create_time
</sql>
然后可以在以后的<select>语句中, 用<include> 其中refid为上面sql的id,这样就可以实现复用语句
<select id="selectById" resultType="User">
select <include refid="selectFields"></include>
from user
where id = #{id}
</select>