SM框架集合

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
  <display-name>test1</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <servlet>
      <servlet-name>springmvc</servlet-name>
      <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      <!-- 
          DispatcherServlet在初始化方法里面,
          会读取该初始化参数的值来获取spring
          配置文件的位置, 然后启动spring容器.
       -->
      <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:springmvc.xml</param-value>
      </init-param>
      <load-on-startup>1</load-on-startup>
 </servlet>
  <servlet-mapping>
    <servlet-name>springmvc</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>
</web-app>

    <!-- 配置视图解析器 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

<util:properties id="config" location="classpath:config.properties"/>
    <!-- 配置连接池 -->
    <bean id="ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="#{config.driver}"/>
        <property name="url" value="#{config.url}"/>
        <property name="username" value="#{config.username}"/>
        <property name="password" value="#{config.password}"/>
    </bean>

<!-- 配置SqlSessionFactoryBean -->
    <!-- 
        spring集成mybatis,不再需要mybatis
        的配置文件(使用SqlSessionFactoryBean
        来代替mybatis的配置文件).
     -->
    <bean id="ssfb" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 注入连接池 不再使用mybatis自带的连接池,而
                是使用spring管理的连接池 -->
        <property name="dataSource" ref="ds"/>
        <!-- mapperLocations是字符串 所以用value注入映射文件的位置 -->
        <property name="mapperLocations" value="classpath:entity/*.xml"/>
    </bean>

 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
         <!-- Mapper映射器所在的包 -->
         <property name="basePackage" value="dao"/>
         <!-- 只扫描特定的接口 -->
     <!--      <property name="annotationClass" value="annotations.MyBatisRepository"/>-->
     </bean>

<?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"
    xmlns:jdbc="http://www.springframework.org/schema/jdbc"
    xmlns:jee="http://www.springframework.org/schema/jee"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:jpa="http://www.springframework.org/schema/data/jpa"
    xmlns:util="http://www.springframework.org/schema/util"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xsi:schemaLocation="
        http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
        http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa.xsd     
        http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
    <!-- 配置mvc注解扫描 -->
    <mvc:annotation-driven/>
    <!-- 配置视图解析器 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    <util:properties id="config" location="classpath:config.properties"/>
    <!-- 配置连接池 -->
    <bean id="ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="#{config.driver}"/>
        <property name="url" value="#{config.url}"/>
        <property name="username" value="#{config.username}"/>
        <property name="password" value="#{config.password}"/>
    </bean>
    <!-- 配置SqlSessionFactoryBean -->
    <!-- 
        spring集成mybatis,不再需要mybatis
        的配置文件(使用SqlSessionFactoryBean
        来代替mybatis的配置文件).
     -->
    <bean id="ssfb" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 注入连接池 不再使用mybatis自带的连接池,而
                是使用spring管理的连接池 -->
        <property name="dataSource" ref="ds"/>
        <!-- mapperLocations是字符串 所以用value注入映射文件的位置 -->
        <property name="mapperLocations" value="classpath:entity/*.xml"/>
    </bean>
    <!-- 配置MapperScannerConfigurer -->
    <!-- 
        MapperScannerConfigurer负责扫描
        指定包下面的所有的Mapper映射器,
        然后生成符合这些映射器(接口)要求的对象.
        (其实,就是调用SqlSession的getMapper方法).
        另外,还会将这些对象添加到spring容器
        里面(默认的id是首字母小写以后的接口名,
        也可以使用@Repository来重新设置id).
     -->
     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
         <!-- Mapper映射器所在的包 -->
         <property name="basePackage" value="dao"/>
         <!-- 只扫描特定的接口 -->
     <!--      <property name="annotationClass" value="annotations.MyBatisRepository"/>-->
     </bean>
</beans>

<?xml version="1.0" encoding="UTF-8" ?>
<!-- Dept.xml 在com.tarena.entity 包中  -->  
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"      
 "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<!-- namespace 的值是 DeptMapper 接口
  每个Mapper 接口对应一个配置文件  -->
<mapper namespace="dao.AdminDAO">
    <select id="findByusername" parameterType="java.lang.String" resultType="entity.Admin">
        select * from admin1 where username=#{username}
    </select>
</mapper>







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

<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"      
 "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<!-- namespace 的值是 DeptMapper 接口
  每个Mapper 接口对应一个配置文件  -->
<mapper namespace="dao.AdminDAO">
    <select id="findByusername" parameterType="java.lang.String" resultType="entity.Admin">
        select * from admin1 where username=#{username}
    </select>
</mapper>

package entity;

import org.springframework.stereotype.Component;

@Component("admin")
public class Admin {

    private String username;
    private String pwd;

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    @Override
    public String toString() {
        return "Admin [username=" + username + ", pwd=" + pwd + "]";
    }

}