海阔天空

手机扫码查看

2020java框架教程之mybatis实体类属性

列名和属性名不一致的情况

1.使用别名

<select id="selectUser2" resultType="Users" parameterType="int">
    select username as uname,password from users where id = #{id}
</select>

2.使用ResultMap

<?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="mybatis.dao.UsersDao">
    <!-- 设置 ResultMap -->
    <resultMap id="usersResultMap" type="Users">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <!-- 将 password 设置 pwd 为别名 -->
        <result column="pwd" property="password" jdbcType="VARCHAR"/>
    </resultMap>
    <!-- 通过 resultMap 查询用户 -->
    <select id="selectUser2" resultMap="usersResultMap" parameterType="int">
        select * from users where id = #{id}
    </select>
</mapper>

 

jdbcType类型