摘要: <select id="selectListPage" resultType="User"> SELECT id,name,password FROM( SELECT id,name,password,ROWNUM rn FROM t_user <where> <if test="id!=null 阅读全文
posted @ 2019-11-07 08:48 JAVA之家TY 阅读(1432) 评论(0) 推荐(0) 编辑
摘要: <insert id="insert"> <selectKey order="BEFORE" keyProperty="id" resultType="int"> SELECT SEQ_ROLE_PERMISSION.NEXTVAL FROM dual </selectKey> INSERT INT 阅读全文
posted @ 2019-11-07 08:46 JAVA之家TY 阅读(333) 评论(0) 推荐(0) 编辑
摘要: <resultMap id="myDept" type="com.stayreal.mybatis.Department"> <id column="did" property="id"/> <result column="dept_name" property="name"/> <!-- coll 阅读全文
posted @ 2019-11-07 08:44 JAVA之家TY 阅读(7975) 评论(0) 推荐(0) 编辑