dianzhouyu4467-CSDN博客

转载 mybatis什么时候必须指定jdbcType

#{property,javaType=int,jdbcType=NUMERIC}如果一个列允许 null 值，并且会传递值 null 的参数，就必须要指定 JDBC Type转载于:https://www.cnblogs.com/jagng951014/p/9462602.html...

2018-08-12 12:02:00 351

转载 SpringMVC文件下载

@RequestMapping("/downLoadXlsFile") public ResponseEntity<byte[]> downLoadXlsFile(@RequestParam("filePath")String path,HttpServletRequest request) throws IOException{ St...

2018-08-12 12:01:00 87

转载 MyBatis直接执行sql语句mapper

<select id="queryBySql" resultType="HashMap"> <![CDATA[ ${sql} ]]></select><![CDATA[]]>这个标记所包含的内容将表示为纯文本转载于:https://www.cnblogs.com/...

2018-08-12 11:59:00 282

转载 Mybatis动态语句部分收集

where:<select id="findActiveBlogLike" resultType="Blog"> SELECT * FROM BLOG <where> <if test="state != null"> state = #{state} </if> ...

2018-08-12 11:58:00 75

转载 MyBatis动态语句if与choose的区别

if(通过“title”和“author”两个参数进行可选搜索)：<select id="findActiveBlogLike" resultType="Blog"> SELECT * FROM BLOG WHERE state = ‘ACTIVE’ <if test="title != null"> AND title...

2018-08-12 11:55:00 547

转载 Mybatis批量事务处理

/** * 批量提交数据 * @param sqlSessionFactory * @param mybatisSQLId SQL语句在Mapper XML文件中的ID * @param commitCountEveryTime 每次提交的记录数 * @param list 要提交的数据列表 ...

2018-08-12 11:53:00 549

转载 MyBatis批量插入模板

oracle:<insert id="insertBatch" parameterType="List">　　INSERT INTO TStudent(name,age)　　<foreach collection="list" item="item" index="index" open="("close=")"separator="union all"...

2018-08-12 11:51:00 248

转载 MyBatis两种传参方式的区别

$与#的区别 select * from T_PRINT_LAYOUT where D_RECID = ${recId}最后生成的SQL为：select * from T_PRINT_LAYOUT where D_RECID = 1即：直接将参数值替换到了原来${recId}的位置，相当于硬拼SQL select * from T_PRINT_...

2018-08-12 11:48:00 174

转载 MyBatis批量更新动态sql

<update id="updateDataKetState"> update ${tablespace}.IDEA_DATAKEY_STATE <trim prefix="set" suffixOverrides=","> <trim prefix="STATENAME = case" s...

2018-08-12 11:44:00 188

dianzhouyu4467的博客