MyBatis 字段属性映射类型

主要是贴下配置文件：

<?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.mybatis.config.InfoDao">
 <resultMap type="java.util.Map" id="resultjcm">
  <result property="FLD_NUMBER" column="FLD_NUMBER"  javaType="double" jdbcType="NUMERIC"/>
  <result property="FLD_VARCHAR" column="FLD_VARCHAR" javaType="string" jdbcType="VARCHAR"/>
  <result property="FLD_DATE" column="FLD_DATE" javaType="java.sql.Date" jdbcType="DATE"/>
  <result property="FLD_INTEGER" column="FLD_INTEGER"  javaType="int" jdbcType="INTEGER"/>
  <result property="FLD_DOUBLE" column="FLD_DOUBLE"  javaType="double" jdbcType="DOUBLE"/>
  <result property="FLD_LONG" column="FLD_LONG"  javaType="long" jdbcType="INTEGER"/>
  <result property="FLD_CHAR" column="FLD_CHAR"  javaType="string" jdbcType="CHAR"/>
  <result property="FLD_BLOB" column="FLD_BLOB"  javaType="[B" jdbcType="BLOB" />
  <result property="FLD_CLOB" column="FLD_CLOB"  javaType="string" jdbcType="CLOB"/>
  <result property="FLD_FLOAT" column="FLD_FLOAT"  javaType="float" jdbcType="FLOAT"/>
  <result property="FLD_TIMESTAMP" column="FLD_TIMESTAMP"  javaType="java.sql.Timestamp" jdbcType="TIMESTAMP"/>
 </resultMap>
 <select id="selectAll" parameterType="map" resultMap="resultjcm">
  select * from JCM
 </select>
 <insert id="insertInfo" parameterType="map">
  insert into jcm
  values
  (
  #{FLD_NUMBER,jdbcType=INTEGER},
  #{FLD_VARCHAR,jdbcType=VARCHAR},
  #{FLD_DATE,jdbcType=DATE},
  #{FLD_INTEGER,jdbcType=INTEGER},
  #{FLD_DOUBLE,jdbcType=DOUBLE},
  #{FLD_LONG,jdbcType=INTEGER},
  #{FLD_CHAR,jdbcType=CHAR},
  #{FLD_BLOB,jdbcType=BLOB},
  #{FLD_CLOB,jdbcType=CLOB},
  #{FLD_FLOAT,jdbcType=FLOAT},
  #{FLD_TIMESTAMP,jdbcType=TIMESTAMP}
  )
 </insert>
 <select id="selectOne" resultMap="resultjcm">
  select * from jcm where
  FLD_NUMBER=#{FLD_NUMBER,jdbcType=INTEGER}
 </select>
 <delete id="delectOne" parameterType="map">
  delete from jcm
  where
  FLD_NUMBER=#{FLD_NUMBER,jdbcType=INTEGER}
 </delete>
 <update id="updateOne" parameterType="map">
  update jcm  set
  FLD_VARCHAR=#{FLD_VARCHAR,jdbcType=VARCHAR},FLD_DATE=#{FLD_DATE,jdbcType=DATE},FLD_INTEGER=#{FLD_INTEGER,jdbcType=INTEGER} where
  FLD_NUMBER=#{FLD_NUMBER,jdbcType=INTEGER}
 </update>
</mapper>

主配置文件：

<?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>
 <environments default="development">
  <environment id="development">
   <transactionManager type="JDBC" />
   <dataSource type="POOLED">
     <property name="driver" value="oracle.jdbc.driver.OracleDriver" />
     <property name="url" value="jdbc:oracle:thin:@10.24.1.18:1521:orcl" />
     <property name="username" value="cbmain" />
     <property name="password" value="sunline" />
   </dataSource>
  </environment>
 </environments>
 <mappers>
  <mapper resource="com/mybatis/config/UserDaoMapper.xml" />
 </mappers>
</configuration>

需要注意的问题：

 

<?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">

 

这个头文件需要换行，必须要和上面一样写，否则会让你崩溃的！