mybatis中mapper.xml对pojo类对应表的映射引用

    映射关系表:
    <resultMap id="basePerson" type="com.model.person" >
            <id column="id_" property="id" jdbcType="BIGINT" />
            <result column="create_by" property="createBy" jdbcType="BIGINT" />
            <result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
            <result column="update_by" property="updateBy" jdbcType="BIGINT" />
            <result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />
            <result column="enable_" property="enable" jdbcType="BIT" />
             <result column="state_" property="state" jdbcType="INTEGER" />
            <result column="remark_" property="remark" jdbcType="VARCHAR" />
    注意没有INT,而是INTEGER
    <sql id="personBCL">
    			p.id_,
    			p.create_by,
    			p.create_time,
    			p.update_by,
    			p.update_time,
    			p.enable_,
    			p.state_,
    			p.remark_,
    </sql>
    sql编写:
    这样返回的就是驼峰式,比如use_code转为useCode:
    <select id="select" resultMap="basePerson">
            select
            <include refid="personBCL"/>
            from
            `person` p
            <include refid="condition"/> 
        </select>
   sql引用:
   也可以直接写语句里面,这样为复用
   <sql id="condition">
      <where>
         <if test="key != null and key != ''">
	       and p.state=#{key}
		 </if>
      </where>
   </sql>