0,启动文件中增加扫描mapper文件@MapperScan("com.example.demo.mapper")的注解
1,pom中添加依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
2,application.properties中添加mybatis配置
# mybatis config
mybatis.config-location=classpath:mybatis/mybatis-config.xml
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
在resource中添加文件夹mybatis,其中新建mapper文件夹和mybatis-config.xml文件,mybatis-config.xml内容如下
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!-- 获取数据库自增主键值 -->
<setting name="useGeneratedKeys" value="true"/>
<!-- 使用列别名替换列名,默认为 true -->
<setting name="useColumnLabel" value="true"/>
<!-- 开启驼峰命名转换:Table(create_time) => Entity(createTime) -->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
</configuration>
3,在com.example.demo.mapper包中新建CityMapper接口
public interface CityMapper {
//获取所有的城市
List<CityModel> getAll();
}
4,在resource中mapper下创建相应的CityMapper.xml文件,*注意namespace值为对应mapper文件名;<select>中的id为mapper文件中对应的方法名,resultMap中的type对应方法返回的类型model
<?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.example.demo.mapper.CityMapper" >
<resultMap id="BaseResultMap" type="com.example.demo.vo.CityModel" >
<id column="id" property="cityId" jdbcType="BIGINT" />
<result column="cityarea" property="cityArea" jdbcType="VARCHAR" />
</resultMap>
<sql id="Base_Column_List" >
id, cityarea
</sql>
<select id="getAll" resultMap="BaseResultMap" >
SELECT
<include refid="Base_Column_List" />
FROM cityarea
</select>
</mapper>
5,调用在service中直接使用,如使用普通的dao层一样
@Autowired
private CityMapper cityMapper;