数据库字段与java实体中的属性映射不上
总结:
- 当数据中的字段与java实体中的属性映射不上时,我们可以这样做:
方式一:取别名
select ID id,NAME name,TB_JSON tbJson
from temp
方式二:使用<resultMap>
<resultMap id="PeopleBase" type="com.thin.hello.People">
<id column="ID" property="id" jdbcType="VARCHAR"></id>
<result column="NAME" property="name" jdbcType="VARCHAR"></result>
<result column="AGE" property="age" jdbcType="VARCHAR"></result>
<result column="SEX" property="sex" jdbcType="VARCHAR"></result>
<result column="BIRTH" property="birth" jdbcType="VARCHAR"></result>
<result column="UPDATEUSER" property="updateUser" jdbcType="VARCHAR"></result>
<result column="UPDATETIME" property="updateTime" jdbcType="TIMESTAMP"></result>
</resultMap>
<sql id="Column_People">
ID ,NAME ,AGE ,SEX ,BIRTH ,UPDATEUSER ,UPDATETIME
</sql>
方式三:在mybatis-config.xml中添加配置信息(mapUnderscoreToCamelCase)
<?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="mapUnderscoreToCamelCase" value="true" />
</settings>
</configuration>