![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mybatis
非僵即躺
这个作者很懒,什么都没留下…
展开
-
mybatis xml文件中的大于等于 小于等于
<if test="start_time != null and start_time != ''" > and to_date(substr(t.create_time,0,10),'YYYY-MM-DD') >= to_date(#{start_time,jdbcType=VARCHAR},'YYYY-MM-DD')</if><if test="end_time != null and end_time != ''" > and to_dat原创 2020-07-03 20:48:37 · 475 阅读 · 0 评论 -
mybatis 插入记录后获取主键
<insert id="saveJudgePersonInfoForManage" parameterType="java.util.HashMap" > <selectKey keyProperty="person_id" resultType="String" order="BEFORE"> select sys_guid() from dual </selectKey>insert into ij_judgement_person (p原创 2020-07-03 15:45:07 · 331 阅读 · 0 评论 -
mybatis 字段like查询
mybatis 字段like查询<if test="conditionName != null and conditionName != ''"> <bind name="_conditionName" value="'%' + conditionName + '%'"/> and t.condition_name LIKE #{_conditionName}</if>或者<if test="queryConditi原创 2020-07-03 10:23:54 · 252 阅读 · 0 评论