<dependency>
    <groupId>com.opdar.plugins</groupId>
    <artifactId>gulosity-mybatis-plugin</artifactId>
    <version>v1.1.7</version>
</dependency>

<bean id="sqlSessionFactory" class="com.opdar.plugins.mybatis.core.GuSqlSessionFactoryBean">
    <-- 数据源 -->
    <property name="dataSource" ref="dataSource" />
    <-- Namespace对应的实体扫描路径 -->
    <property name="basePackage" value="com.opdar.web.entities" />
    <-- 库名，默认为空，即表名不加前缀 -->
    <property name="databaseName" value="test"/>
    <-- 表前缀，默认为空，即表名不加前缀 -->
    <property name="tablePrefix" value="t_"/>
    <-- Mapper扫描路径 -->
    <property name="mapperLocations" value="classpath:com/opdar/mapper/*.xml" />
</bean>

/**
* Mapper Interface
**/
class UserMapper extends IBaseMapper<UserEntity>{
//...
}

   /**
/**
* 实体对象
**/
@Namespace(UserMapper.class)
class UserEntity{
    private String id;
    private String userName;
    private String userPwd;
//...
}

<?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.opdar.web.mapper.UserMapper">

    <select id="selectOne" parameterType="...UserEntity" resultMap="userResult">
        SELECT TOP 1 * FROM `database`.`t_user` WHERE
        ID = #{id}
    </select>
    
    <select id="selectOne2" parameterType="...UserEntity" resultMap="userResult">
        SELECT TOP 1 * FROM `database`.`t_user` WHERE `vaild` = 0
        AND ID = #{id}
    </select>
</mapper>