springmvc+mybatis的两种配置和应用方式

<project  ns="http://maven.apache.org/POM/4.0.0"  ns:xsi="http://www.w3.org/2001/ Schema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>com.troy</groupId>  <artifactId>spring-mvc</artifactId>  <version>0.0.1-SNAPSHOT</version>  <packaging>war</packaging>  <dependencies>      <dependency>      <groupId>org.spring work</groupId>      <artifactId>spring-webmvc</artifactId>      <version>3.2.8.RELEASE</version>    </dependency>    <dependency>      <groupId>org.spring work</groupId>      <artifactId>spring-jdbc</artifactId>      <version>3.2.8.RELEASE</version>    </dependency>    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis-spring</artifactId>      <version>1.2.3</version>    </dependency>    <dependency>      <groupId>commons-dbcp</groupId>      <artifactId>commons-dbcp</artifactId>      <version>1.4</version>    </dependency>    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis</artifactId>      <version>3.3.0</version>    </dependency>    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>5.1.37</version>    </dependency>    <dependency>      <groupId>com.faster .jackson.core</groupId>      <artifactId>jackson-core</artifactId>      <version>2.2.3</version>    </dependency>    <dependency>      <groupId>com.faster .jackson.core</groupId>      <artifactId>jackson-annotations</artifactId>      <version>2.2.3</version>    </dependency>    <dependency>      <groupId>com.faster .jackson.core</groupId>      <artifactId>jackson-databind</artifactId>      <version>2.2.3</version>    </dependency>  </dependencies></project>

<?  version="1.0" encoding="UTF-8"?><web-app  ns:xsi="http://www.w3.org/2001/ Schema-instance"  ns="http://java.sun.com/ /ns/javaee" xsi:schemaLocation="http://java.sun.com/ /ns/javaee http://java.sun.com/ /ns/javaee/web-app_2_5.xsd" version="2.5">  <display-name>spring-mvc</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.spring work.web.servlet.DispatcherServlet</servlet-class>      <init-param>          <param-name>contextConfigLocation</param-name>          <param-value>classpath:spring/spring-mvc. </param-value>      </init-param>      <load-on-startup>1</load-on-startup>  </servlet>  <servlet-mapping>      <servlet-name>springmvc</servlet-name>      <url-pattern>/</url-pattern>  </servlet-mapping>  <filter>      <filter-name>encodingFilter</filter-name>      <filter-class>org.spring work.web.filter.CharacterEncodingFilter</filter-class>      <init-param>          <param-name>encoding</param-name>          <param-value>UTF-8</param-value>      </init-param>      <init-param>          <param-name>forceEncoding</param-name>          <param-value>true</param-value>      </init-param>  </filter>  <filter-mapping>      <filter-name>encodingFilter</filter-name>      <url-pattern>/</url-pattern>  </filter-mapping></web-app>

<?  version="1.0" encoding="UTF-8"?><beans  ns="http://www.spring work.org/schema/beans"      ns:xsi="http://www.w3.org/2001/ Schema-instance"     ns:context="http://www.spring work.org/schema/context"      ns:jdbc="http://www.spring work.org/schema/jdbc"       ns:jee="http://www.spring work.org/schema/jee"      ns:tx="http://www.spring work.org/schema/tx"     ns:aop="http://www.spring work.org/schema/aop"      ns:mvc="http://www.spring work.org/schema/mvc"     ns:util="http://www.spring work.org/schema/util"     ns:jpa="http://www.spring work.org/schema/data/jpa"    xsi:schemaLocation="        http://www.spring work.org/schema/beans http://www.spring work.org/schema/beans/spring-beans-3.2.xsd        http://www.spring work.org/schema/context http://www.spring work.org/schema/context/spring-context-3.2.xsd        http://www.spring work.org/schema/jdbc http://www.spring work.org/schema/jdbc/spring-jdbc-3.2.xsd        http://www.spring work.org/schema/jee http://www.spring work.org/schema/jee/spring-jee-3.2.xsd        http://www.spring work.org/schema/tx http://www.spring work.org/schema/tx/spring-tx-3.2.xsd        http://www.spring work.org/schema/data/jpa http://www.spring work.org/schema/data/jpa/spring-jpa-1.3.xsd        http://www.spring work.org/schema/aop http://www.spring work.org/schema/aop/spring-aop-3.2.xsd        http://www.spring work.org/schema/mvc http://www.spring work.org/schema/mvc/spring-mvc-3.2.xsd        http://www.spring work.org/schema/util http://www.spring work.org/schema/util/spring-util-3.2.xsd">    <mvc:annotation-driven/>    <context:component-scan  -package="com.troy"/>    <bean class="org.spring work.web.servlet.view.InternalResourceViewResolver">        <property name="prefix" value="/WEB-INF/page/"/>        <property name="suffix" value=".jsp"/>    </bean>    <import resource="spring-mybatis. "/></beans>

<?  version="1.0" encoding="UTF-8"?><beans  ns="http://www.spring work.org/schema/beans"      ns:xsi="http://www.w3.org/2001/ Schema-instance"     ns:context="http://www.spring work.org/schema/context"      ns:jdbc="http://www.spring work.org/schema/jdbc"       ns:jee="http://www.spring work.org/schema/jee"      ns:tx="http://www.spring work.org/schema/tx"     ns:aop="http://www.spring work.org/schema/aop"      ns:mvc="http://www.spring work.org/schema/mvc"     ns:util="http://www.spring work.org/schema/util"     ns:jpa="http://www.spring work.org/schema/data/jpa"    xsi:schemaLocation="        http://www.spring work.org/schema/beans http://www.spring work.org/schema/beans/spring-beans-3.2.xsd        http://www.spring work.org/schema/context http://www.spring work.org/schema/context/spring-context-3.2.xsd        http://www.spring work.org/schema/jdbc http://www.spring work.org/schema/jdbc/spring-jdbc-3.2.xsd        http://www.spring work.org/schema/jee http://www.spring work.org/schema/jee/spring-jee-3.2.xsd        http://www.spring work.org/schema/tx http://www.spring work.org/schema/tx/spring-tx-3.2.xsd        http://www.spring work.org/schema/data/jpa http://www.spring work.org/schema/data/jpa/spring-jpa-1.3.xsd        http://www.spring work.org/schema/aop http://www.spring work.org/schema/aop/spring-aop-3.2.xsd        http://www.spring work.org/schema/mvc http://www.spring work.org/schema/mvc/spring-mvc-3.2.xsd        http://www.spring work.org/schema/util http://www.spring work.org/schema/util/spring-util-3.2.xsd">    <util:properties id="config" location="classpath:conf/spring-config.properties"/>    <bean id="dataSource" class="org.spring work.jdbc.datasource.DriverManagerDataSource"> //这里可以替换成线程池的方式连接，参数根据自己需要设置        <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>        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <property name="mapperLocations" value="classpath:mapper/*. "/>    </bean>        <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">        <constructor-arg index="0">            <ref bean="sqlSessionFactory"/>        </constructor-arg>    </bean>        <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name=" Package" value="com.troy.dao"/>        <property name="sqlSessionTemplate" ref="sqlSessionTemplate"/>    </bean>        <bean id="transactionManager" class="org.spring work.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource"/>    </bean>    <tx:annotation-driven transaction-manager="transactionManager"/></beans>

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/m_model?useUnicode=true&characterEncoding=utf8username=rootpassword=root

<?  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"><mapper namespace="com.troy.dao.ModelDao">    <select id="findAll" resultType="java.util.Map">        select * from  model    </select>    </mapper>

@Repository(value="modelDao")public interface ModelDao {    public List<Map<String,  >> findAll();}

public interface ModelService {    public List<Map<String,  >> findAll();}

@Service(value="modelService")public class ModelServiceImpl implements ModelService{    @Resource(name="modelDao")    private ModelDao modelDao;        public List<Map<String,  >> findAll() {                return modelDao.findAll();    }}

@RequestMapping(value="/model")@Controllerpublic class ModelController {        @Resource(name="modelService")    private ModelService modelService;        @RequestMapping(value="/init")    public String init(){                return "model";    }        @RequestMapping(value="/find")    @ResponseBody    public List<Map<String,  >> find(){        return modelService.findAll();    }}

<?  version="1.0" encoding="UTF-8"?><beans  ns="http://www.spring work.org/schema/beans"      ns:xsi="http://www.w3.org/2001/ Schema-instance"     ns:context="http://www.spring work.org/schema/context"      ns:jdbc="http://www.spring work.org/schema/jdbc"       ns:jee="http://www.spring work.org/schema/jee"      ns:tx="http://www.spring work.org/schema/tx"     ns:aop="http://www.spring work.org/schema/aop"      ns:mvc="http://www.spring work.org/schema/mvc"     ns:util="http://www.spring work.org/schema/util"     ns:jpa="http://www.spring work.org/schema/data/jpa"    xsi:schemaLocation="        http://www.spring work.org/schema/beans http://www.spring work.org/schema/beans/spring-beans-3.2.xsd        http://www.spring work.org/schema/context http://www.spring work.org/schema/context/spring-context-3.2.xsd        http://www.spring work.org/schema/jdbc http://www.spring work.org/schema/jdbc/spring-jdbc-3.2.xsd        http://www.spring work.org/schema/jee http://www.spring work.org/schema/jee/spring-jee-3.2.xsd        http://www.spring work.org/schema/tx http://www.spring work.org/schema/tx/spring-tx-3.2.xsd        http://www.spring work.org/schema/data/jpa http://www.spring work.org/schema/data/jpa/spring-jpa-1.3.xsd        http://www.spring work.org/schema/aop http://www.spring work.org/schema/aop/spring-aop-3.2.xsd        http://www.spring work.org/schema/mvc http://www.spring work.org/schema/mvc/spring-mvc-3.2.xsd        http://www.spring work.org/schema/util http://www.spring work.org/schema/util/spring-util-3.2.xsd">        <util:properties id="config" location="classpath:conf/spring-config.properties"/>    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">        <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>        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <property name="mapperLocations" value="classpath:mapper/*. "/>    </bean>    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">        <constructor-arg index="0">            <ref bean="sqlSessionFactory"/>        </constructor-arg>    </bean>        <bean id="transactionManager" class="org.spring work.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource"/>    </bean>    <tx:annotation-driven transaction-manager="transactionManager"/></beans>

<?  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"><mapper namespace="user">    <select id="findAll" parameterType="java.util.Map" resultType="java.util.Map">        select * from  model where modelId=#{modelId}    </select>    </mapper>

public interface UserDao {    public Map<String,  > findAll();}

@Repository(value="userDao")public class UserDaoImpl implements UserDao{    @Resource(name="sqlSessionTemplate")    private SqlSession sqlSession;        public Map<String,  > findAll() {        Map<String,  > map = new HashMap<String,  >();        map.put("modelId", "09cd318807294ba4bd098e2f95f82ac5");        Map<String,  > result = sqlSession.selectOne("user.findAll", map);        return result;    }    }

public interface UserService {    public Map<String,  > find();}

@Service(value="userService")public class UserServiceImpl implements UserService{        @Resource(name="userDao")    private UserDao userDao;        public Map<String,  > find() {                return userDao.findAll();    }    }

@RequestMapping(value="/user")@Controllerpublic class UserController {        @Resource(name="userService")    private UserService userService;        @RequestMapping(value="/init")    public String init(){                return "user";    }        @RequestMapping(value="/find")    @ResponseBody    public Map<String,  > find(){        Map<String,  > list = userService.find();        System.out.println(list);        System.out.println(list.size());        return list;    }}