授权
shiroUserMapper.xml
<?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.yq.ssm.mapper.ShiroUserMapper" >
<resultMap id="BaseResultMap" type="com.yq.ssm.model.ShiroUser" >
<constructor >
<idArg column="userid" jdbcType="INTEGER" javaType="java.lang.Integer" />
<arg column="username" jdbcType="VARCHAR" javaType="java.lang.String" />
<arg column="PASSWORD" jdbcType="VARCHAR" javaType="java.lang.String" />
<arg column="salt" jdbcType="VARCHAR" javaType="java.lang.String" />
<arg column="createdate" jdbcType="TIMESTAMP" javaType="java.util.Date" />
</constructor>
</resultMap>
<sql id="Base_Column_List" >
userid, username, PASSWORD, salt, createdate
</sql>
<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
select
<include refid="Base_Column_List" />
from t_shiro_user
where userid = #{userid,jdbcType=INTEGER}
</select>
<delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
delete from t_shiro_user
where userid = #{userid,jdbcType=INTEGER}
</delete>
<insert id="insert" parameterType="com.yq.ssm.model.ShiroUser" >
insert into t_shiro_user (userid, username, PASSWORD,
salt, createdate)
values (#{userid,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
#{salt,jdbcType=VARCHAR}, #{createdate,jdbcType=TIMESTAMP})
</insert>
<insert id="insertSelective" parameterType="com.yq.ssm.model.ShiroUser" >
insert into t_shiro_user
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="userid != null" >
userid,
</if>
<if test="username != null" >
username,
</if>
<if test="password != null" >
PASSWORD,
</if>
<if test="salt != null" >
salt,
</if>
<if test="createdate != null" >
createdate,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="userid !=