<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation=
               "http://www.springframework.org/schema/beans
                http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
                http://www.springframework.org/schema/context
                http://www.springframework.org/schema/context/spring-context-4.1.xsd">
    <!-- apache.dbcp连接池的配置 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver">
        </property>
        <property name="url" value="jdbc:mysql://localhost:3306/db2"></property>
        <property name="username" value="root"></property>
        <property name="password" value="messi3838"></property>
        <property name="maxActive" value="100"></property>
        <property name="maxIdle" value="30"></property>
        <property name="maxWait" value="500"></property>
        <property name="defaultAutoCommit" value="true"></property>
    </bean>
    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 自动扫描mapping.xml文件 -->
        <property name="mapperLocations" value="classpath*:mapping/*.xml"></property>
         <property name="configLocation" value="classpath:/configs/spring-mybaits.xml" />
    </bean>

    <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.dao" />
     <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>
</beans>

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

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

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jee="http://www.springframework.org/schema/jee"

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

    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:util="http://www.springframework.org/schema/util"

    xsi:schemaLocation="http://www.springframework.org/schema/beans 
  
           http://www.springframework.org/schema/beans/spring-beans-4.1.xsd 
  
             http://www.springframework.org/schema/context 
  
             http://www.springframework.org/schema/context/spring-context-4.0.xsd 
  
             http://www.springframework.org/schema/jee 
  
              http://www.springframework.org/schema/jee/spring-jee-4.1.xsd 
  
              http://www.springframework.org/schema/mvc 
  
             http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd 
  
             http://www.springframework.org/schema/util 
  
             http://www.springframework.org/schema/util/spring-util-4.1.xsd">



    <context:component-scan base-package="controller" />
    <context:component-scan base-package="service" />
    <context:component-scan base-package="com.dao" />



    <mvc:resources mapping="/styles/**" location="/styles/" />

    <mvc:resources mapping="/scripts/**" location="/scripts/" />

    <mvc:resources mapping="/images/**" location="/images/" />
    <mvc:annotation-driven />
    <context:annotation-config />
    <mvc:default-servlet-handler />

    <!-- json 获得 -->

    <!-- <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> 
        <property name="messageConverters"> <list> <ref bean="mappingJackson2HttpMessageConverter" 
        /> </list> </property> </bean> <bean id="mappingJackson2HttpMessageConverter" 
        class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter" 
        /> -->



    <bean

        class="org.springframework.web.servlet.view.InternalResourceViewResolver">

        <property name="prefix" value="/views/" />

        <property name="suffix" value=".html" />

    </bean>



</beans> 

package com.dao;

public interface LoginDao {
    public Integer isLogin(String username,String password);
}

package service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.dao.LoginDao;

import exception.UsersException;
@Service
public class LoginServiceImp implements LoginService{
    @Autowired
    public LoginDao userService;
    
    public void isLogin(String username,String password){
        int count=userService.isLogin(username, password);
        System.out.println(count);
        if(count==0){
            
                throw new UsersException(001);
            
        }
        
        
    }
    
}

<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.LoginDao">
    <select id="isLogin" resultType="bean.UserBean">
        select count(*) from admin where username = #{username} and password =#{password}
    </select>
</mapper>