src/main/resources/mappers/UserMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.finance.dao.UserDao">
	<resultMap type="User" id="UserResult">
		<result property="id" column="id"/>
		<result property="username" column="username"/>
		<result property="password" column="password"/>
		<result property="truename" column="truename"/>
		<result property="email" column="email"/>
		<result property="phone" column="phone"/>
		<result property="address" column="address"/>
		<result property="sex" column="sex"/>
		<result property="age" column="age"/>
		<result property="appellation" column="appellation"/>
		<result property="salary" column="salary"/>
		<result property="card" column="card"/>
		<result property="isvalid" column="isvalid"/>
		<result property="createtime" column="createtime"/>
		<result property="updatetime" column="updatetime"/>
		<result property="rolename" column="rolename"/>
		<collection property="roleIDsList"  column="id"  ofType="java.util.Map" javaType="java.util.ArrayList" select="selectRoleids" /> 
	</resultMap>
	
	<select id="selectRoleids" parameterType="int" resultType="java.util.Map">
	   select a.roleid,b.rolename from t_user_role a,t_role b where a.roleid=b.id and a.userid=#{id}
	</select>
	
	<select id="loginUsername" parameterType="User" resultMap="UserResult">
	    select * from t_user where isvalid=1 and username=#{username}
	</select>
	
	<select id="loginPassword" parameterType="User" resultMap="UserResult">
	    select * from t_user where isvalid=1 and username=#{username} and password=#{password}
	</select>
	
	<select id="loginRolename" parameterType="User" resultMap="UserResult">
		select * from t_user a,t_user_role b where a.isvalid=1 and a.id=b.userid and a.username=#{username} and a.password=#{password} and b.roleid=#{roleid}
	</select>
	
	<select id="getUserById" parameterType="Integer" resultMap="UserResult">
	    select * from t_user a,t_user_role b where a.id=#{id} and a.isvalid=1 and b.userid=a.id
	</select>
	
	<select id="getAllUser" parameterType="Map" resultMap="UserResult">
	    select id,username from t_user
	    <where>
	        isvalid=1
	        <if test="userid!=null and roleid!=1">
				and id=#{userid}
			</if>
	    </where>
	</select>
	
	<select id="findUser" parameterType="Map" resultMap="UserResult">
		select * from t_user a,t_user_role b,t_role c
		<where>
		    a.isvalid=1 and a.id=b.userid and c.id=b.roleid
		    <if test="username!=null and username!='' ">