Question

mybatis自定义sql是什么意思

Answer 1

mybatis的sql和你在数据库客户端执行的sql是一样的，但是在mybatis中调用的sql一般都是动态的，所以用到了参数传递。这个mybatis有对应的标签以及相应的变量来实现。你可以搜索下mybatis标签。同时给你一个参考的你看看，这个是一个查询用户的 <select id="queryUsers" parameterType="map" resultType="xx.xx.xx.bean.UserBean"> <![CDATA[ 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_EDUCATI