import com.google.common.collect.Lists;import com.gukeer.common.persistence.DataEntity;import com.gukeer.modules.personal.entity.Dept;import com.gukeer.modules.personal.entity.Staff;import com.gukeer.modules.school.entity.School;import java.util.Date;/*** 用戶Entity** auther:cc* date:2016/9/2*/public class User extends DataEntity<User> {private static final long serialVersionUID = 1L;private String id;private Office company; // 歸屬公司private Office office; // 歸屬部門private String loginName;// 登錄名private String password;// 密碼private String no; // 工號private String name; // 姓名private String email; // 郵箱private String phone; // 電話private String mobile; // 手機private String userType;// 用戶類型private String loginIp; // 最后登陸IPprivate Date loginDate; // 最后登陸日期private String loginFlag; // 是否允許登陸private String photo; // 頭像private String qrCode; // 二維碼private String oldLoginName;// 原登錄名private String newPassword; // 新密碼private String oldLoginIp; // 上次登陸IPprivate Date oldLoginDate; // 上次登陸日期private Dept dept;　　//部門private Staff staff;　　//職位private Role role; // 根據角色查詢用戶條件private List<Role> roleList = Lists.newArrayList(); // 擁有角色列表private School school; //歸屬學校private String remarks; // 備注private User createBy; // 創建者private Date createDate; // 創建日期private User updateBy; // 更新者private Date updateDate; // 更新日期private String delFlag; // 刪除標記（0：正常；1：刪除；2：審核）}

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.gk.modules.sys.dao.UserDao">　　<!-- 重點就是這一段，將數據庫保存的id字段直接賦值給一個對象的成員變量中，比如a.company_id AS "company.id"，此時后臺查詢回的List或User對象中的屬性可以直接通過user.getCompany().getId()來獲取到-->　　<!-- 當然Company中的引用類型變量也可以使用這種方法來賦值，通過LEFT JOIN可以聯查多表，這是數據庫查詢方面的操作，這里不作討論 --><sql id="userColumns">a.id,a.company_id AS "company.id",a.office_id AS "office.id",a.login_name,a.password,a.no,a.name,a.email,a.phone,a.mobile,a.user_type,a.login_ip,a.login_date,a.remarks,a.login_flag,a.photo,a.qrcode,a.create_by AS "createBy.id",a.create_date,a.update_by AS "updateBy.id",a.update_date,a.del_flag,c.name AS "company.name",c.parent_id AS "company.parent.id",c.parent_ids AS "company.parentIds",ca.id AS "company.area.id",ca.name AS "company.area.name",ca.parent_id AS "company.area.parent.id",ca.parent_ids AS "company.area.parentIds",o.name AS "office.name",o.parent_id AS "office.parent.id",o.parent_ids AS "office.parentIds",oa.id AS "office.area.id",oa.name AS "office.area.name",oa.parent_id AS "office.area.parent.id",oa.parent_ids AS "office.area.parentIds",cu.id AS "company.primaryPerson.id",cu.name AS "company.primaryPerson.name",cu2.id AS "company.deputyPerson.id",cu2.name AS "company.deputyPerson.name",ou.id AS "office.primaryPerson.id",ou.name AS "office.primaryPerson.name",ou2.id AS "office.deputyPerson.id",ou2.name AS "office.deputyPerson.name",sc.xxlx AS "school.xxlx",sc.xxmc AS "school.xxmc"</sql><sql id="userJoins">LEFT JOIN sys_office c ON c.id = a.company_idLEFT JOIN sys_area ca ON ca.id = c.area_idLEFT JOIN sys_office o ON o.id = a.office_idLEFT JOIN sys_area oa ON oa.id = o.area_idLEFT JOIN sys_user cu ON cu.id = c.primary_personLEFT JOIN sys_user cu2 ON cu2.id = c.deputy_personLEFT JOIN sys_user ou ON ou.id = o.primary_personLEFT JOIN sys_user ou2 ON ou2.id = o.deputy_personLEFT JOIN xj_school sc ON sc.id = a.school</sql><!-- 查詢語句，根據Id查詢結果，返回類型可以直接寫User，而不同配置resultMap省略編寫xml的時間 --><select id="getUserById" resultType="User">SELECT<include refid="userColumns"/>FROM sys_user a<include refid="userJoins"/>WHERE a.id = #{id}</select><!-- 查詢語句，根據User對象來查詢，這里的參數即為User變量 --><select id="getByLoginName" resultType="User" parameterType="User">SELECT<include refid="userColumns"/>FROM sys_user a<include refid="userJoins"/>WHERE 　　　　 a.login_name = #{loginName} 　　　　 AND a.del_flag = #{DEL_FLAG_NORMAL}</select><!-- 插入語句，參數肯定是User對象 --><insert id="insert">INSERT INTO sys_user(id, company_id, office_id, login_name, password, no, name, email, phone, mobile, user_type, create_by, create_date, update_by, update_date, remarks, login_flag, photo, qrcode,del_flag,dept_id,staff_id,school) VALUES (#{id}, #{company.id}, #{office.id}, #{loginName}, #{password}, #{no}, #{name}, #{email}, #{phone}, #{mobile}, #{userType}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{loginFlag}, #{photo}, #{qrCode},#{delFlag},#{dept.id},#{staff.id},#{school.id})</insert><!-- 更新語句，參數也是User對象 --><update id="update">UPDATE sys_user SET company_id = #{company.id}, office_id = #{office.id}, login_name = #{loginName}, password = #{password}, no = #{no}, name = #{name}, email = #{email}, phone = #{phone}, mobile = #{mobile}, user_type = #{userType}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks},login_flag = #{loginFlag},photo = #{photo},qrcode = #{qrCode},school = #{school.id}WHERE id = #{id}</update><!-- 物理刪除用戶 --><update id="delete">DELETE FROM sys_user WHERE id = #{id}</update><!-- 邏輯刪除用戶 --><update id="deleteByLogic">UPDATE sys_user SET del_flag = #{DEL_FLAG_DELETE}WHERE id = #{id}</update></mapper>