mybatis的user的xml簡單配置

2024-04-27 15:10:38

字體：大中小

來源：轉載

供稿：網友

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" ><mapper namespace="data.bi.dao.BIUserDao"> <cache eviction="LRU" flushInterval="100000" readOnly="true" size="1024" />  <select id="getModules" resultType="data.bi.entity.ModuleData" flushCache="false" useCache="true"> SELECT * from module </select>  <select id="getUserInfo" resultType="data.bi.entity.User" flushCache="true" useCache="false"> SELECT * from user </select>  <insert id="insert_User_table" flushCache="true"> INSERT into `user`(user_name,user_passWord,user_email,user_phone,user_role) VALUES( <if test="user_name!=null"> #{user_name}, </if> <if test="user_name==null"> " ", </if> <if test="user_password!=null"> #{user_password}, </if> <if test="user_password==null"> " ", </if> <if test="user_email!=null"> #{user_email}, </if> <if test="user_email==null"> " ", </if> <if test="user_phone!=null"> #{user_phone}, </if> <if test="user_phone==null"> " ", </if> <if test="user_role!=null"> #{user_role} </if> <if test="user_role==null"> "0" </if> ) </insert>  <insert id="grantPermission" flushCache="true"> insert into permission(user_id,module_id) values( <if test="user_id!=null"> #{user_id}, </if> <if test="user_id==null"> "", </if> <if test="module_id!=null"> #{module_id} </if> <if test="module_id==null"> "" </if> ) </insert>  <delete id="deletePerByUserId" flushCache="true"> delete from permission where user_id=#{user_id} and module_id=#{module_id} </delete>  <select id="queryUserByUserName" resultType="data.bi.entity.User" flushCache="false" useCache="true"> select * from `user` u where u.user_name=#{user_name} </select>  <select id="getUserPerByUserId" resultType="data.bi.entity.help.UserPermission" flushCache="false" useCache="false"> SELECT * from module m where m.module_name not in (select m.module_name from permission p,module m where m.module_id=p.module_id and p.user_id=#{user_id}) </select>  <select id="getUserPersByUserId" resultType="data.bi.entity.help.UserPermission" flushCache="false" useCache="false"> SELECT * from module m where m.module_name in (select m.module_name from permission p,module m where m.module_id=p.module_id and p.user_id=#{user_id}) </select>  <select id="getCountByUserName" resultType="java.lang.Integer" flushCache="false" useCache="false"> select COUNT(u.user_name) from `user` u where u.user_name=#{user_name} </select>  <update id="updateUserPassword" flushCache="true"> update `user` t SET t.user_password=#{user_password} where t.user_name=#{user_name} </update>  <delete id="delete_User" flushCache="true"> delete from `user` where user_id=#{user_id} </delete>  <delete id="delete_permission" flushCache="true"> delete from `permission` where user_id=#{user_id} </delete></mapper>

上一篇：常見用戶接口

下一篇：JS 實現反射功能