Question

如何保证mybatis查询的mysql和oracle结果集的key的大小写一致

Answer 1

mybatis 单个和批量插入mysql与oracle配置说明 一. mysql [html] view plain copy insert into black_list(uuid,type,value,delete_flag,gmt_create,gmt_modified) values (#{uuid:VARCHAR},#{type:VARCHAR},#{value:VARCHAR}, #{deleteFlag:INTEGER},#{gmtCreate:DATE},#{gmtModified:DATE}) insert into black_list (uuid,type,value,delete_flag,gmt_create,gmt_modified) values (#{item.uuid},#{item.type},#{item.value} #{item.deleteFlag},#{item.gmtCreate},#{item.gmtModified}) 二. oracle [html] view plain copy select seq_black_list.nextval from dual insert into black_list(id,uuid,type,value,delete_flag,gmt_create,gmt_modified) values (#{id:DECIMAL},#{uuid:VARCHAR},#{type:VARCHAR},#{value:VARCHAR}, #{deleteFlag:INTEGER},#{gmtCreate:DATE},#{gmtModified:DATE}) select seq_black_list.nextval as id from dual insert into black_list (id,uuid,type,value,delete_flag,gmt_create,gmt_modified) select seq_black_list.nextval, A.* FROM ( select #{item.uuid,jdbcType=VARCHAR}, #{item.type,jdbcType=VARCHAR}, #{item.value,jdbcType=VARCHAR}, #{item.deleteFlag,jdbcType=INTEGER}, #{item.gmtCreate,jdbcType=DATE}, #{item.gmtModified,jdbcType=DATE} from dual ) A 模糊匹配查询 [html] view plain copy select * from table_name AND description like CONCAT(CONCAT('%', #{description}), '%') </select