mybatis 时间判断 if else
来源:互联网 发布:nodejs 写入json文件 编辑:程序博客网 时间:2024/05/17 21:06
写了一个模糊查询 感觉是我学Java的巅峰了
<select id="findBorSearch" resultType="java.util.HashMap"
parameterType="java.util.HashMap">select
bli.borloaninfo_id,
bli.bor_id,ee.emp_name,
bli.emp_id ,
bli.loan_number
,bli.loan_account
,to_char(bli.loan_date,'yyyy-MM-dd')
loanDate
,to_char(bli.loan_repayment_date,'yyyy-MM-dd')
loanRepaymentDate,
bli.loan_rate
,bli.loaninfo_type ,
bor.bor_name
,lt.loantype_name
,ls.loanstate_name
from
employee ee,
borLoanInfo bli,
borrower
bor,loantype
lt,loanmanage lm,loanstate ls,bankinfo bk
<where>
bli.bor_id =
bor.bor_id
and
bli.loan_type = lt.loantype_id
and
lm.loaninfo_id =
bli.borloaninfo_id
and lm.loanstate_id =
ls.loanstate_id and ee.emp_id =
bli.emp_id and bli.bankinfo_id =
bk.bankinfo_id
<if test="borName!=null and borName!=''">
and bor.bor_name like '%' || '${borName}' ||'%'
</if>
<if test="empName!=null and empName!=''">
and ee.employee like '%' || '${empName}' ||'%'
</if>
<if test="contractId!=null and contractId!=''">
and bli.contract_id like '%' || '${contractId}' || '%'
</if>
<if test="!(loanStateId.length()>5)">
and lm.loanstate_id = #{loanStateId,jdbcType=VARCHAR}
</if>
<if test="!(bankId.length()>5)">
and bli.bankinfo_id = #{bankId,jdbcType=VARCHAR}
</if>
<choose>
<when test="dateFrom!=null and dateFrom!=''">
and bli.loan_repayment_date between
to_date('${dateFrom}','yyyy/MM/dd')
</when>
<otherwise>
and bli.loan_repayment_date between
to_date('1900-01-01','yyyy/MM/dd')
</otherwise>
</choose>
<choose>
<when test="dateTo!=null and dateTo!=''">
and to_date('${dateTo}','yyyy/MM/dd')
</when>
<otherwise>
and to_date('2100-12-31','yyyy/MM/dd')
</otherwise>
</choose>
</where>
</select>
好开心
阅读全文
0 0
- mybatis 时间判断 if else
- mybatis 中使用if else 进行判断
- mybatis 的if else
- MyBatis if else
- if /else判断语句
- Smarty if else /if 判断
- Smarty if else /if 判断
- mybatis xml中的if else
- JAVA 闰年判断 if - else
- Makefile if else 判断平台
- JSTL标签 if else 判断
- if elseif else 判断语句
- shell 判断语句 if else
- if else 错误的判断
- js04.if...else条件判断
- python条件判断 if else
- if else if的判断问题
- linux shell 条件判断if else, if elif else....
- Android studio apk直接发送到手机无法使用的问题及扩展/apk签名/SHA1的获取
- kindeditor获取内容,清空,设置kindeditor输入提示信息
- python——自写数据库(带平衡树索引)
- 手机终于可以预定车位了
- 下拉框回显
- mybatis 时间判断 if else
- python中的list、tuple、dict辨析
- Hone Hone Clock 以及小松鼠等代码以及插入方法
- 2017-9-8 15:56:23
- PageRank (佩奇等级)
- C++对象模型目录
- 物联网创造一片蓝海无线通讯协定百家争鸣
- 操作系统
- 指针类型的定义