mapper 使用示例

/**
 * sys_user
 */
@ApiModel("用户表")
public class SysUser implements Serializable {
    private static final long serialVersionUID = 1L;
    @ApiModelProperty("用户ID")
    private Integer sysUserId;
    /**
     * 名称
     */
    @ApiModelProperty("用户名称")
    private String sysUserName;
    /**
     * 帐户
     */
    @ApiModelProperty("用户帐号")
    private String sysUserAccount;
    /**
     * 电话
     */
    @ApiModelProperty("用户电话")
    private String sysUserPhone;
    /**
     * 邮箱
     */
    @ApiModelProperty("用户邮箱")
    private String sysUserMail;
    /**
     * 密码
     */
    @ApiModelProperty("用户密码")
    private String sysUserPassword;
    /**
     * 生日
     */
    @ApiModelProperty("用户生日")
    private String sysUserBirthday;
    /**
     * 年龄
     */
    @ApiModelProperty("用户年龄")
    private String sysUserAge;
    /**
     * 星座
     */
    @ApiModelProperty("星座")
    private String sysUserConstellation;
    /**
     * 头像
     */
    @ApiModelProperty("头像")
    private String sysUserHeaderIcon;
    /**
     * 角色ID
     */
    @ApiModelProperty("角色id")
    private Integer sysRoleId;
    private SysRole sysRole;
    @ApiModelProperty("用户状态1启用0禁用")
    private Integer sysUserStatus;

/**
 * UserOptions 
 */
public class UserOptions {
    @ApiModelProperty("用户名称")
    private String sysUserName;
    @ApiModelProperty("角色ID")
    private Integer sysRoleId;
    @ApiModelProperty("用户电话")
    private String sysUserPhone;

    public String getSysUserName()
    {
        return sysUserName;
    }

    public void setSysUserName(String sysUserName)
    {
        this.sysUserName = sysUserName;
    }

    public Integer getSysRoleId()
    {
        return sysRoleId;
    }

    public void setSysRoleId(Integer sysRoleId)
    {
        this.sysRoleId = sysRoleId;
    }

    public String getSysUserPhone()
    {
        return sysUserPhone;
    }

    public void setSysUserPhone(String sysUserPhone)
    {
        this.sysUserPhone = sysUserPhone;
    }
}

/**
 * SysUserDao
 */
public interface SysUserDao {
    /**
     * deleteByPrimaryKey
     *
     * @param sysUserId
     * @return
     */
    int deleteByPrimaryKey(Integer sysUserId);

    /**
     * insert
     *
     * @param record
     * @return
     */
    int insert(SysUser record);

    /**
     * insertSelective
     *
     * @param record
     * @return
     */
    int insertSelective(SysUser record);

    /**
     * selectByPrimaryKey
     *
     * @param sysUserId
     * @return
     */
    SysUser selectByPrimaryKey(Integer sysUserId);

    /**
     * updateByPrimaryKeySelective
     *
     * @param record
     * @return
     */
    int updateByPrimaryKeySelective(SysUser record);

    /**
     * updateByPrimaryKey
     *
     * @param record
     * @return
     */
    int updateByPrimaryKey(SysUser record);

    /**
     * sysLogin
     *
     * @param sysUser
     * @return
     */
    SysUser sysLogin(SysUser sysUser);

    /**
     * countByOptions
     *
     * @param paginationHelper
     * @return
     */
    Integer countByOptions(PaginationHelper paginationHelper);

    /**
     * selectByOptions
     *
     * @param paginationHelper
     * @return
     */
    List<SysUser> selectByOptions(PaginationHelper paginationHelper);

    /**
     * 检查次数过多
     *
     * @param name
     * @return
     */
    SysUser selectByName(String name);

    /**
     * 查询单个用户信息
     */
    SysUser selectSysUserByUserId(Integer userId);

}

/**
 * SysUserDao.xml(Mapper)
 */
mySql
Mapper使用范例：SysUserDao.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="biz.xcj.mapper.sys.permit.SysUserDao">
    <resultMap id="BaseResultMap" type="biz.xcj.entity.sys.permit.SysUser">
        <id column="sys_user_id" jdbcType="INTEGER" property="sysUserId"/>
        <result column="sys_user_name" jdbcType="VARCHAR" property="sysUserName"/>
        <result c