mabatis查询时间格式_mybatis 获取数据库的日期格式

主要是贴下配置1文件：

?>

/p>

"-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

namespace="com.mybatis.config.InfoDao">

type="java.util.Map" id="resultjcm">

property="FLD_NUMBER" column="FLD_NUMBER" javaType="double" jdbcType="NUMERIC"/>

property="FLD_VARCHAR" column="FLD_VARCHAR" javaType="string"

jdbcType="VARCHAR"/>

column="FLD_DATE" javaType="java.sql.Date"

jdbcType="DATE"/>

property="FLD_INTEGER"

column="FLD_INTEGER" javaType="int"

jdbcType="INTEGER"/>

property="FLD_DOUBLE" column="FLD_DOUBLE" javaType="double" jdbcType="DOUBLE"/>

property="FLD_LONG" column="FLD_LONG" javaType="long" jdbcType="INTEGER"/>

property="FLD_CHAR" column="FLD_CHAR" javaType="string" jdbcType="CHAR"/>

property="FLD_BLOB" column="FLD_BLOB" javaType="[B" jdbcType="BLOB" />

property="FLD_CLOB" column="FLD_CLOB" javaType="string" jdbcType="CLOB"/>

property="FLD_FLOAT" column="FLD_FLOAT" javaType="float" jdbcType="FLOAT"/>

column="FLD_TIMESTAMP"javaType="java.sql.Timestamp"

jdbcType="TIMESTAMP"/>

parameterType="map" resultMap="resultjcm">

select * from

JCM

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}

)

resultMap="resultjcm">

select * from jcm

where

FLD_NUMBER=#{FLD_NUMBER,jdbcType=INTEGER}

parameterType="map">

delete from

jcm

where

FLD_NUMBER=#{FLD_NUMBER,jdbcType=INTEGER}

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}

主配置文件：

?>

/p>

"-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

default="development">

id="development">

type="JDBC" />

type="POOLED">

name="driver" value="oracle.jdbc.driver.OracleDriver"

/>

name="url" value="jdbc:oracle:thin:@10.24.1.18:1521:orcl"

/>

name="username" value="cbmain" />

name="password" value="sunline" />

resource="com/mybatis/config/UserDaoMapper.xml"

/>

需要注意的问题：

?>

/p>

"-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

13123

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