mybatis入门使用（一）

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;