<?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">
<!--namespace=绑定要给对应的Dao/mapper接口-->
<mapper namespace="com.gao.dao.UserMapper">
<!-- <select id="getUserById" parameterType="int" resultType="com.gao.pojo.User">-->
<!-- select * from mybatis.user where id = #{id};-->
<!-- </select>-->
<!--解决实体类属性和数据库字段名冲突问题-->
<!-- 1.resultMap去解决-->
<!--结果集映射-->
<resultMap id="UserMap" type="User">
<!--只映射属性名和字段名不一样的-->
<result column="pwd" property="password"></result>
</resultMap>
<select id="getUserById" resultMap="UserMap">
select * from mybatis.user where id = #{id};
</select>
</mapper>
Mybatis和数据库字段不匹配解决
最新推荐文章于 2023-11-11 16:26:17 发布