<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE configuration

  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

  "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

  <mappers>

      <!-- 实体类映射文件 -->

      <mapper resource="com/bsss/entity/userloginMapper.xml"/>

  </mappers>

</configuration>

<?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.bsss.entity.userloginMapper">

<resultMap type="com.bsss.entity.Userlogin" id="UserLoginResult">

    <id column="id" jdbcType="INTEGER" property="id"/>

    <result column="username" jdbcType="VARCHAR" property="username"/>

    <result column="userpassword" jdbcType="VARCHAR" property="userpassword"/>

    <result column="usertype" jdbcType="VARCHAR" property="usertype"/>

</resultMap>

  <select id="getUserlogin" parameterType="com.bsss.entity.Userlogin" resultMap="UserLoginResult">

    select id,username,userpassword,usertype from userlogin where 1 = 1

    <if test="username != null and !&quot;&quot;.equals(username)">and username=#{username}</if>

    <if test="userpassword != null and !&quot;&quot;.equals(userpassword)">and userpassword=#{userpassword}</if>

  </select>

</mapper>

<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xmlns="http://www.springframework.org/schema/beans" xmlns:aop="http://www.springframework.org/schema/aop"

  xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"

  xmlns:cache="http://www.springframework.org/schema/cache" xmlns:p="http://www.springframework.org/schema/p"

  xsi:schemaLocation="http://www.springframework.org/schema/beans

     http://www.springframework.org/schema/beans/spring-beans.xsd

     http://www.springframework.org/schema/aop

     http://www.springframework.org/schema/aop/spring-aop.xsd

     http://www.springframework.org/schema/context

     http://www.springframework.org/schema/context/spring-context.xsd

     http://www.springframework.org/schema/tx

     http://www.springframework.org/schema/tx/spring-tx.xsd

     http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache.xsd">

    <!-- 配置数据源 -->

     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

         <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>

         <property name="url" value="jdbc:mysql://localhost:3306/bsss"></property>

         <property name="username" value="root"></property>

         <property name="password" value="root"></property>

     </bean>

     <!-- 配置sqlSessionFactory -->

     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

         <property name="dataSource" ref="dataSource"></property>

         <property name="configLocation" value="classpath:com/bsss/conf/mybatis.xml"></property>

     </bean>

    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">

        <constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>

    </bean>

    <bean id="userLoginDAO" class="com.bsss.dao.impl.UserloginDAOImpl">

        <!-- property name必须与class中SqlSessionTemplate的变量名字保持一致 -->

        <property name="sqlSession" ref="sqlSessionTemplate"></property>

    </bean>

</beans>

public class Userlogin {

    private int id;

    private String username;

    private String userpassword;

    private int usertype;

    public Userlogin() {

        super();

    }

    public Userlogin(int id, String username, String userpassword, int usertype) {

        super();

        this.id = id;

        this.username = username;

        this.userpassword = userpassword;

        this.usertype = usertype;

    }

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public String getUsername() {

        return username;

    }

    public void setUsername(String username) {

        this.username = username;

    }

    public String getUserpassword() {

        return userpassword;

    }

    public void setUserpassword(String userpassword) {

        this.userpassword = userpassword;

    }

    public int getUsertype() {

        return usertype;

    }

    public void setUsertype(int usertype) {

        this.usertype = usertype;

    }

    @Override

    public String toString() {

        return "Userlogin [id=" + id + ", username=" + username + ", userpassword=" + userpassword + ", usertype="

                + usertype + "]";

    }

}

//接口

public interface UserloginDAO {

    public Userlogin getUserloginInfo(String username,String userpassword);

}

//实现类

public class UserloginDAOImpl implements UserloginDAO{

    private SqlSessionTemplate sqlSession;//变量名字必须与spring bean中的property name保持一致

    public void setSqlSession(SqlSessionTemplate sqlSession) {

        this.sqlSession = sqlSession;

    }

    @Override

    public Userlogin getUserloginInfo(String username,String userpassword){

        Userlogin ul = new Userlogin();

        ul.setUsername(username);

        ul.setUserpassword(userpassword);

        ul = sqlSession.selectOne("com.bsss.entity.userloginMapper.getUserlogin", ul);

        return ul;

    }

}

public class Test {

    public static void main(String[] args) {

        // TODO Auto-generated method stub

        ApplicationContext ac = new ClassPathXmlApplicationContext("com/bsss/conf/beans.xml");//spring-bean配置文件路径

        UserloginDAO uld = (UserloginDAO)ac.getBean("userLoginDAO");

        Userlogin ul = uld.getUserloginInfo("admin", "admin");

        System.out.println(ul);

    }

}

Userlogin [id=1, username=admin, userpassword=admin, usertype=0]