jdbc 胖连接_Mybatis中javaType和jdbcType对应和CRUD例子

select * from JCM

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}

)

select * from jcm where

FLD_NUMBER=#{FLD_NUMBER,jdbcType=INTEGER}

delete from jcm

where

FLD_NUMBER=#{FLD_NUMBER,jdbcType=INTEGER}

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}