mybatis 查询 动态sql语句怎么写

mybatis 查询 动态sql语句怎么写

mybatis的sql和你在数据库客户端执行的sql是一样的，但是在mybatis中调用的sql一般都是动态的，所以用到了参数传递。这个mybatis有对应的标签以及相应的变量来实现。你可以搜索下mybatis标签。同时给你一个参考的你看看，这个是一个查询用户的

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50


select
ID,
LOGIN_NAME AS loginName,
PASSWORD,
REAL_NAME AS realName,
POSITION,
(SELECT D.POSITION_NAME FROM UNIT_POSITION D WHERe D.POSITION_CODE=T.POSITION) POSITIONNAME,
USER_TYPE AS userType,
SEX,
PID,
TO_CHAr(T.BIRTHDAY,'YYYY-MM-DD') BIRTHDAY,
EMAIL,
CONTACT_TEL AS contactTel,
CONTACT_MOBILE AS contactMobile,
CONTACT_FAX AS contactFax,
CONTACT_ZIP AS contactZip,
CONTACT_ADDR AS contactAddr,
STATUS,
EDUCATION,
(SELECt D.EDUCATION_NAME FROM UNIT_EDUCATION D WHERe D.EDUCATION_CODE=T.EDUCATION AND D.STATUS=0) EDUCATIONNAME,
NATION,
POLITICAL,
REMARK,
TO_CHAr(T.CREATE_DATE,'YYYY-MM-DD HH24:MI:SS') createDate,
(SELECt D.REAL_NAME FROM UNIT_USER D WHERe D.ID= T.CREATE_USER_ID) createUserId,
TO_CHAr(T.UPDATe_DATE,'YYYY-MM-DD HH24:MI:SS') updateDate,
(SELECT D.REAL_NAME FROM UNIT_USER D WHERe D.ID= T.UPDATe_USER_ID) updateUserId
from UNIT_USER T
]]>

T.STATUS='1'

and T.REAL_NAME like '%${realName}%'


AND T.ID IN (SELECt DISTINCT D.USER_ID FROM UNIT_USER_DEPT D WHERe D.DEPT_CODE IN (${nexusDpartment}))


AND T.ID IN (SELECt DISTINCT D.USER_ID FROM UNIT_USER_DEPT D WHERe D.DEPT_CODE = #{deptCode})



order by ${sort}

${direction}

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息