5.框架连通测试（Spring+Mybatis）

    前两篇博客已经把Spring和Mybatis基础配置完成，接下来需要测试下 页面<--->服务器<--->数据库之间是否正确连通。

 

• 1. 截止目前为止，各个配置文件的内容

• pom.xml:

• <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  	<modelVersion>4.0.0</modelVersion>
  	<groupId>com.qyuz</groupId>
  	<artifactId>myecom</artifactId>
  	<packaging>war</packaging>
  	<version>0.0.1-SNAPSHOT</version>
  	<name>myecom</name>
  	<url>http://maven.apache.org</url>
  
  	<dependencies>
  	 <!-- spring mvc相关的包-->
          <dependency>
          	<groupId>org.springframework</groupId>
          	<artifactId>spring-webmvc</artifactId>
          	<version>4.3.0.RELEASE</version>
          </dependency>
          
           <!-- spring 事物管理相关的包-->
          <dependency>
          	<groupId>org.springframework</groupId>
          	<artifactId>spring-tx</artifactId>
          	<version>4.3.0.RELEASE</version>
          </dependency>
          
          <!-- spring 数据库链接相关的包-->
          <dependency>
          	<groupId>org.springframework</groupId>
          	<artifactId>spring-jdbc</artifactId>
          	<version>4.3.0.RELEASE</version>
          </dependency>
          <dependency>
  			<groupId>springframework</groupId>
  			<artifactId>spring-orm</artifactId>
  			<version>1.2.5</version>
  		</dependency>
  		
  		<!-- Spring 面向切面AOP相关用到的包，Spring 3.0以前的版本不需要手动引入，之后则需要引入，如下 -->
          <dependency>
          	<groupId>org.aspectj</groupId>
          	<artifactId>aspectjweaver</artifactId>
          	<version>1.8.9</version>
          </dependency>
         
           <!-- HttpServletRequest 等用 -->
          <dependency>
          	<groupId>javax.servlet</groupId>
          	<artifactId>servlet-api</artifactId>
          	<version>2.5</version>
          </dependency>
          
  	   <!-- 单元测试用 -->
  		<dependency>
  			<groupId>junit</groupId>
  			<artifactId>junit</artifactId>
  			<version>3.8.1</version>
  			<scope>test</scope>
  		</dependency>
  		
  		
  		<!-- mysql驱动，链接mysql必须要有的包 -->
  		<dependency>
  			<groupId>mysql</groupId>
  			<artifactId>mysql-connector-java</artifactId>
  			<version>5.1.39</version>
  		</dependency>
  		
  		
  		<!-- 数据库连接池 -->
  		<dependency>
  			<groupId>commons-dbcp</groupId>
  			<artifactId>commons-dbcp</artifactId>
  			<version>1.4</version>
  		</dependency>
  		
  		
          <!-- mybatis -->
          <dependency>
          	<groupId>org.mybatis</groupId>
          	<artifactId>mybatis</artifactId>
          	<version>3.4.1</version>
          </dependency>
          
           
          <!-- 把mybatis和spring结合起来的包 -->
          <dependency>
          	<groupId>org.mybatis</groupId>
          	<artifactId>mybatis-spring</artifactId>
          	<version>1.3.0</version>
          </dependency>
  	</dependencies>	
  	
  	<build>
  		<finalName>myecom</finalName>
  	</build>
  </project>

   
• web.xml

• <?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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
    
    <!-- 整合mybatis -->
    <context-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:config/spring-mybatis.xml</param-value>
    </context-param>
  
    <!-- 编码过滤器 -->
    <filter>
      <filter-name>encodingFilter</filter-name>
      <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
      <async-supported>true</async-supported>
      <init-param>
        <param-name>encoding</param-name>
        <param-value>UTF-8</param-value>
      </init-param>
    </filter>
    
    <filter-mapping>
      <filter-name>encodingFilter</filter-name>
      <url-pattern>/*</url-pattern>
    </filter-mapping>
    
    <!-- spring 启动 -->
    <servlet>
      <servlet-name>springmvc</servlet-name>
      <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      <init-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:config/springmvc-servlet.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>
    
     <!-- 监听 -->
    <listener>
      <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    
  </web-app>

•  
• springmvc-servlet.xml

• <?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:p="http://www.springframework.org/schema/p"
      xmlns:context="http://www.springframework.org/schema/context"
      xmlns:mvc="http://www.springframework.org/schema/mvc"
      xsi:schemaLocation="
      http://www.springframework.org/schema/beans
      http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
      http://www.springframework.org/schema/context
      http://www.springframework.org/schema/context/spring-context-3.0.xsd
      http://www.springframework.org/schema/mvc
      http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd"> 
     
      <!-- 默认的注解映射的支持 -->  
      <mvc:annotation-driven />
       
      <!-- 自动扫描该包，将注解的类变为bean，并注入上下文直接使用-->  
      <context:component-scan base-package="com.qyuz.controller"  />
      
      <!-- 定义跳转的文件的前后缀 ，视图模式配置 -->  
      <bean  
          class="org.springframework.web.servlet.view.InternalResourceViewResolver">  
          <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 -->  
          <property name="prefix" value="/WEB-INF/views/" />
          <property name="suffix" value=".jsp" />
      </bean>
  </beans>

   
• spring-mybatis.xml

• <?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:mvc="http://www.springframework.org/schema/mvc"
      xmlns:context="http://www.springframework.org/schema/context"
      xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
      xsi:schemaLocation="http://www.springframework.org/schema/beans
              http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
              http://www.springframework.org/schema/mvc
              http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
              http://www.springframework.org/schema/context
              http://www.springframework.org/schema/context/spring-context-3.0.xsd
              http://www.springframework.org/schema/aop
              http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
              http://www.springframework.org/schema/tx
              http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">
      
      <!-- 自动扫描该包，将注解的类变为bean，并注入上下文直接使用-->  
      <context:component-scan base-package="com.qyuz.service.*"  />
      
      <!-- 由于包的兼容性问题, 这里不能用 ${jdbc.driver}类似的形式赋值了-->
      <!--  context:property-placeholder location="classpath:config/jdbc.properties" ignore-unresolvable="true"/>-->
      
      <!-- 1.数据库配置信息 -->
      <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
          <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
          <!--这里需要注意的是'$' 要用 '&amp;'代替 -->
          <property name="url" value="jdbc:mysql://localhost:3306/ecom?useUnicode=true&amp;characterEncoding=utf-8"/>
          <property name="username" value="jxh"/>
          <property name="password" value="123456"/>
          <property name="validationQuery" value="SELECT 1"/>
          <property name="testWhileIdle" value="true"/>
          <property name="timeBetweenEvictionRunsMillis" value="3600000"/>
          <property name="minEvictableIdleTimeMillis" value="1800000"/>
          <property name="testOnBorrow" value="true"/>
      </bean>
      
      <!-- 2.sessionFactory 将spring和mybatis整合 -->
      <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
          <property name="dataSource" ref="dataSource" />  
           <!--property name="configLocation" value="classpath:config/mybatis.cfg.xml" -->
          <property name="mapperLocations" value="classpath:mapper/*.xml" />
      </bean>
      
      <!-- 3.自动扫描 将Mapper接口生成代理注入到Spring-->
      <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer" autowire="byName">  
          <property name="basePackage" value="com.qyuz.dao" />  
          <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />  
      </bean>    
      
      <!-- 4.配置事物 (事务管理)transaction manager, use JtaTransactionManager for global tx --> 
      <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
          <property name="dataSource" ref="dataSource" />  
      </bean>
      
      <!-- 5.设置事物的传播行为种类 -->
      <tx:advice id="transactionAdvice" transaction-manager="transactionManager">
          <tx:attributes>
              <tx:method name="add*" propagation="REQUIRED" />
              <tx:method name="append*" propagation="REQUIRED" />
              <tx:method name="insert*" propagation="REQUIRED" />
              <tx:method name="save*" propagation="REQUIRED" />
              <tx:method name="update*" propagation="REQUIRED" />
              <tx:method name="modify*" propagation="REQUIRED" />
              <tx:method name="edit*" propagation="REQUIRED" />
              <tx:method name="delete*" propagation="REQUIRED" />
              <tx:method name="remove*" propagation="REQUIRED" />
              
              <tx:method name="get*" propagation="SUPPORTS" />
              <tx:method name="find*" propagation="SUPPORTS" />
              <tx:method name="load*" propagation="SUPPORTS" />
              <tx:method name="search*" propagation="SUPPORTS" />           
              <tx:method name="*" propagation="SUPPORTS" />
          </tx:attributes>
      </tx:advice>
      
      <!-- 6.定义一个切面,在定义的切面上加入事物 -->
      <aop:config>
          <aop:pointcut id="transactionPointcut" expression="execution(* com.qyuz.service..*Impl.*(..))" />
          <aop:advisor pointcut-ref="transactionPointcut" advice-ref="transactionAdvice" />
      </aop:config>
  </beans>

   
• 2.新建测试部分
• ①数据库新建test表格并初始化数据：

• -- ----------------------------
  -- Table structure for test
  -- ----------------------------
  DROP TABLE IF EXISTS `test`;
  CREATE TABLE `test` (
    `pagename` varchar(255) DEFAULT NULL,
    `id` int(11) NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of test
  -- ----------------------------
  INSERT INTO `test` VALUES ('testpage', '1');

   
• ②新建TestDao.java层接口和TestDaoMapper.xml

• public interface TestDao {
  	public String getPageAtDao();
  }

   

  <?xml version="1.0" encoding="UTF-8"?>
  <!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  <mapper namespace="com.qyuz.dao.TestDao">
      <select id="getPageAtDao" resultType="string">
      	select pagename from test limit 0,1
      </select>
  </mapper>

   
• ③新建ITestService.java层和TestServiceImpl.java

• public interface ITestService {
  	public String getPage();
  }

• import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.stereotype.Service;
  
  import com.qyuz.dao.TestDao;
  import com.qyuz.service.ITestService;
  
  @Service
  public class TestServiceImpl implements ITestService{
  	
  	@Autowired
  	TestDao dao;
  
  	@Override
  	public String getPage() {
  		// TODO Auto-generated method stub
  		return dao.getPageAtDao();
  	}
  
  }

   
• ④新建TestController.java

• import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.stereotype.Controller;
  import org.springframework.web.bind.annotation.RequestMapping;
  
  import com.qyuz.service.ITestService;
  
  @Controller
  public class TestController {
  	
  	@Autowired
  	ITestService service;
  
  	@RequestMapping("/test")
  	public String test(){
  		return service.getPage();
  	}
  
  }

   
• ⑤WEB-INF/views/下新建testpage.jsp页面

• <%@ page language="java" contentType="text/html; charset=UTF-8"
  	pageEncoding="UTF-8"%>
  <html>
  <body>
  <h2>测试网页，成功！</h2>
  </body>
  </html>

   
• ⑥最后，右击项目run as -> run on server,启动之后，在浏览器中输入http://localhost:8080/myecom/test.do 回车，显示如下：
• 
  

     测试成功，基础框架搭建成功！