springMvc（Maven构建，整合mybatis）附git地址

最新推荐文章于 2024-01-06 11:21:21 发布

云水天堂

最新推荐文章于 2024-01-06 11:21:21 发布

阅读量4.3k

点赞数

文章标签： spring mvc mybatis maven mysql

本文链接：https://blog.csdn.net/u013561386/article/details/51791658

版权

2个数据源

mysql数据库test: 表 user
DROP TABLE IF EXISTS user;
CREATE TABLE user (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
name varchar(255) DEFAULT NULL,
pwd varchar(255) DEFAULT NULL,
PRIMARY KEY (id),
KEY index_name (name)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gbk;
INSERT INTO user VALUES (‘1’, ‘11’, ‘1’);
INSERT INTO user VALUES (‘2’, ‘wwe12’, ‘123和’);
mysql数据库springmvctest1: 表 pub_menu
CREATE TABLE pub_menu (
menu_id varchar(64) NOT NULL,
p_menu_id varchar(64) NOT NULL,
menu_name varchar(64) NOT NULL,
menu_title varchar(256) DEFAULT NULL,
menu_url varchar(1024) DEFAULT NULL,
menu_target varchar(64) DEFAULT NULL,
order_no int(8) NOT NULL,
create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
is_valid varchar(8) DEFAULT NULL,
domain_code varchar(64) DEFAULT NULL,
PRIMARY KEY (menu_id),
KEY idx_p_menu_id (p_menu_id) USING BTREE,
KEY idx_order_no (order_no) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

主要配置

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>wdd</groupId>
  <artifactId>springMvc</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>springMvc</name>
  <url>http://maven.apache.org</url>
  <properties>
        <!-- spring版本号 -->
        <spring.version>4.0.2.RELEASE</spring.version>
        <!-- mybatis版本号 -->
        <mybatis.version>3.2.6</mybatis.version>
        <!-- log4j日志文件管理包版本 -->
        <slf4j.version>1.7.7</slf4j.version>
        <log4j.version>1.2.17</log4j.version>
    </properties>
  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <!-- spring核心包 -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-oxm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency> 
       <groupId>javax.servlet</groupId> 
       <artifactId>servlet-api</artifactId> 
       <version>2.5</version> 
       <scope>provided</scope> 
    </dependency> 
<!-- mybatis核心包 -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>${mybatis.version}</version>
    </dependency>
    <!-- mybatis/spring包 -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.2.2</version>
    </dependency>
    <!-- 导入java ee jar 包 -->
    <!-- <dependency>
        <groupId>javax</groupId>
        <artifactId>javaee-api</artifactId>
        <version>7.0</version>
    </dependency> -->
    <!-- 导入Mysql数据库链接jar包 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.18</version>
    </dependency>
    <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
    <dependency>
        <groupId>commons-dbcp</groupId>
        <artifactId>commons-dbcp</artifactId>
        <version>1.4</version>
    </dependency>
    <!-- JSTL标签类 -->
    <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
    </dependency>
    <!-- 日志文件管理包 -->
    <!-- log start -->
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>
    <!-- 格式化对象，方便输出日志 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.1.41</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <!-- 映入JSON -->
    <dependency>
        <groupId>org.codehaus.jackson</groupId>
        <artifactId>jackson-mapper-asl</artifactId>
        <version>1.9.13</version>
    </dependency>
    <!-- 上传组件包 -->
    <dependency>
        <groupId>commons-fileupload</groupId>
        <artifactId>commons-fileupload</artifactId>
        <version>1.3.1</version>
    </dependency>
    <dependency>
        <groupId>commons-io</groupId>
        <artifactId>commons-io</artifactId>
        <version>2.4</version>
    </dependency>
    <!-- <dependency>
        <groupId>commons-codec</groupId>
        <artifactId>commons-codec</artifactId>
        <version>1.9</version>
    </dependency> -->
    <!-- spring aop -->
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.8.3</version>
    </dependency>
  </dependencies>
  <build>
    <finalName>springMvc</finalName>
    <!-- JDK 1.7 -->
     <plugins>  
      <plugin>  
        <groupId>org.apache.maven.plugins</groupId>  
        <artifactId>maven-compiler-plugin</artifactId>  
        <configuration>  
          <source>1.7</source>  
          <target>1.7</target>  
        </configuration>  
      </plugin>  
    </plugins> 
  </build>
</project>

2.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"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    version="3.0">
  <display-name>Archetype Created Web Application</display-name>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <!-- spring配置 -->
    <param-value>classpath: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>
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <listener>
    <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
  </listener>
  <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:spring-mvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
    <async-supported>true</async-supported>
  </servlet>
  <servlet-mapping>
    <servlet-name>SpringMVC</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
  <welcome-file-list>
    <welcome-file>/index.jsp</welcome-file>
  </welcome-file-list>
  <session-config>
    <session-timeout>15</session-timeout>
  </session-config>
</web-app>

3.spring-mvc.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"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/beans  
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd  
                        http://www.springframework.org/schema/context  
                        http://www.springframework.org/schema/context/spring-context-3.1.xsd  
                        http://www.springframework.org/schema/mvc  
                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
                        http://www.springframework.org/schema/aop 
                        http://www.springframework.org/schema/aop/spring-aop-2.5.xsd ">
    <!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 -->
    <!-- 下面注解也可以使用 -->
    <context:component-scan base-package="com" />
<!--    <context:component-scan base-package="com.jdbcbase.controller" /> -->
<!--    <context:component-scan base-package="com.jdbcyw1.controller" /> -->
    <!-- 定义跳转的文件的前后缀 ，视图模式配置-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!-- 自动给后面controller的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 -->
        <property name="prefix" value="/WEB-INF/jsp/" />
        <property name="suffix" value=".jsp" />
    </bean>
    <!-- 配置文件上传，如果没有使用文件上传可以不用配置，当然如果不配，那么配置文件中也不必引入上传组件包 -->
    <bean id="multipartResolver"  
        class="org.springframework.web.multipart.commons.CommonsMultipartResolver">  
        <!-- 默认编码 -->
        <property name="defaultEncoding" value="utf-8" />  
        <!-- 文件大小最大值 -->
        <property name="maxUploadSize" value="10485760000" />  
        <!-- 内存中的最大值 -->
        <property name="maxInMemorySize" value="40960" />  
    </bean> 
    <!-- 注解aop 只能写在此处aop才生效 -->
    <aop:aspectj-autoproxy/>   
</beans>

4.spring-mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:tx="http://www.springframework.org/schema/tx"
    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"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/beans  
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd  
                        http://www.springframework.org/schema/tx 
                        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
                        http://www.springframework.org/schema/context  
                        http://www.springframework.org/schema/context/spring-context-3.1.xsd  
                        http://www.springframework.org/schema/mvc  
                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
                        http://www.springframework.org/schema/aop 
                        http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
    <!-- 自动扫描 -->
    <context:component-scan base-package="com" />
    <!-- 引入配置文件 -->
    <bean id="propertyConfigurer"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:jdbc.properties" />
    </bean>
    <!-- test -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="${driver}" />
        <property name="url" value="${url}" />
        <property name="username" value="${username}" />
        <property name="password" value="${password}" />
        <!-- 初始化连接大小 -->
        <property name="initialSize" value="${initialSize}"></property>
        <!-- 连接池最大数量 -->
        <property name="maxActive" value="${maxActive}"></property>
        <!-- 连接池最大空闲 -->
        <property name="maxIdle" value="${maxIdle}"></property>
        <!-- 连接池最小空闲 -->
        <property name="minIdle" value="${minIdle}"></property>
        <!-- 获取连接最大等待时间 -->
        <property name="maxWait" value="${maxWait}"></property>
    </bean>
    <!-- soringmvc -->
    <bean id="dataSource2" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="${driver}" />
        <property name="url" value="${url2}" />
        <property name="username" value="${username2}" />
        <property name="password" value="${password2}" />
        <!-- 初始化连接大小 -->
        <property name="initialSize" value="${initialSize}"></property>
        <!-- 连接池最大数量 -->
        <property name="maxActive" value="${maxActive}"></property>
        <!-- 连接池最大空闲 -->
        <property name="maxIdle" value="${maxIdle}"></property>
        <!-- 连接池最小空闲 -->
        <property name="minIdle" value="${minIdle}"></property>
        <!-- 获取连接最大等待时间 -->
        <property name="maxWait" value="${maxWait}"></property>
    </bean>
    <!--============== test 数据源1(ok)============== -->
    <!-- spring和MyBatis完美整合，此处需要指定mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation" value="classpath:jdbcyw1-mybatis-config.xml"></property>
        <!-- 自动扫描mapping.xml文件 -->
        <!-- <property name="mapperLocations" value="classpath:com/jdbcyw1/*/*.xml"></property> -->
    </bean>

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

    <!--==============  srpingmvc 数据源2(ok)============== -->
    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource2" />
        <!-- 自动扫描mapping.xml文件 -->
        <property name="mapperLocations" value="classpath:com/jdbcbase/*/*.xml"></property>
    </bean>
    <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.jdbcbase.dao" />
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory2"></property>
    </bean>
    <!-- ============================事务(ok)=========================== -->
    <!-- 申明式食物配置 -->
    <!-- test库(事务管理) -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>
    <!-- srpingmvc 库 -->
    <bean id="transactionManager2" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource2" />
    </bean>
    <!-- 注解方式配置事物 -->
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" />
    <!-- 注解方式配置事物 -->
    <tx:annotation-driven transaction-manager="transactionManager2" proxy-target-class="true" />
    <!-- ====AOP方式==== -->
    <bean id="sleepHelpe" class="com.AopTest"></bean>
    <!-- 定义了bean被初始化之前和之后要执行的方法 -->
    <bean class="com.InitBean" />
    <!--避免IE执行AJAX时，返回JSON出现下载文件 -->
    <bean id="mappingJacksonHttpMessageConverter"
        class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
        <property name="supportedMediaTypes">
            <list>
                <value>text/html;charset=UTF-8</value>
            </list>
        </property>
    </bean>
    <!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 -->
    <bean
        class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
        <property name="messageConverters">
            <list>
                <ref bean="mappingJacksonHttpMessageConverter" />   <!-- JSON转换器 -->
            </list>
        </property>
    </bean>

     <!--配置拦截器, 多个拦截器,顺序执行 -->  
    <mvc:interceptors>    
        <mvc:interceptor>    
            <!-- 匹配的是url路径， 如果不配置或/**,将拦截所有的Controller -->  
            <mvc:mapping path="/" />  
            <mvc:mapping path="/user/**" />  
            <mvc:mapping path="/menu/getMenuList*" />
            <bean class="com.cn.interceptor.CommonInterceptor"></bean>    
        </mvc:interceptor>  
        <!-- 当设置多个拦截器时，先按顺序调用preHandle方法，然后逆序调用每个拦截器的postHandle和afterCompletion方法 -->  
    </mvc:interceptors>  
        <!-- 添加异常默认跳转页 -->
    <bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">
        <property name="exceptionMappings">
            <props>
                <prop key="com.exception.SpringException">
                ExceptionPage
                </prop>
            </props>
        </property>
        <property name="defaultErrorView" value="error"/>
    </bean>

</beans>

5.jdbcyw1-mybatis-config.xml
（上面sqlSessionFactory Bean的指定的配置文件，可以设置成自动扫描xml，参考sqlSessionFactory2）

<?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>
    <typeAliases>
        <typeAlias alias="User" type="com.jdbcyw1.module.User" />
    </typeAliases>
    <mappers>
        <mapper resource="com/jdbcyw1/mapping/UserMapper.xml" />
    </mappers>
</configuration>

6.jdbc.properties

driver=com.mysql.jdbc.Driver
#url=jdbc:mysql://192.168.100.2:3306/projectdata
#username=user_jtsp
url=jdbc:mysql://localhost:3306/test
username=root
password=1234
#定义初始连接数
initialSize=0
#定义最大连接数
maxActive=20
#定义最大空闲
maxIdle=20
#定义最小空闲
minIdle=1
#定义最长等待时间
maxWait=60000



url2=jdbc:mysql://localhost:3306/springmvctest1
username2=root
password2=1234

7.log4j.properties

#打印数据库连接 sql日志
log4j.logger.com=debug
log4j.logger.org.mybatis=debug
log4j.logger.org.apache.ibatis=debug

#定义LOG输出级别
log4j.rootLogger=INFO,Console,File
#定义日志输出目的地为控制台
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.Target=System.out
#可以灵活地指定日志输出格式，下面一行是指定具体的格式
log4j.appender.Console.layout = org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n

#文件大小到达指定尺寸的时候产生一个新的文件
log4j.appender.File = org.apache.log4j.RollingFileAppender
#指定输出目录
log4j.appender.File.File = logs/ssm.log
#定义文件最大大小
log4j.appender.File.MaxFileSize = 10MB
# 输出所以日志，如果换成DEBUG表示输出DEBUG以上级别日志
log4j.appender.File.Threshold = ALL
log4j.appender.File.layout = org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

项目结构

这里写图片描述

关键java代码

1).UserDao.java

package com.jdbcyw1.dao;

import java.util.List;

import com.jdbcyw1.module.User;

public interface UserDao {
    public List<User> queryUser(User user);
    public User queryUserForOne(String str);
    public int addUser(User user);
}

2).UserService.java

package com.jdbcyw1.service;

import java.util.List;

import com.jdbcyw1.module.User;

public interface UserService {
    public List<User> queryUser(User user);
    public User queryUserForOne(String str);
    public int addUser(User user);
}

3).UserServiceImpl.java
（@Transactional需要指定是哪一个事务管理器，例如@Transactional(“transactionManager”),即显示的要求spring用id=”transactionManager”的事务管理器来管理事务，如果未指定id则spring中先声明的事务管理会起作用）

package com.jdbcyw1.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.jdbcbase.dao.MenuDao;
import com.jdbcyw1.dao.UserDao;
import com.jdbcyw1.module.User;
import com.jdbcyw1.service.UserService;
@Service("userService")
public class UserServiceImpl implements UserService {
    @Resource
    private UserDao userDao;
    @Override
    public List<User> queryUser(User user) {
        return this.userDao.queryUser(user);
    }
    @Override
    public User queryUserForOne(String str) {
        return this.userDao.queryUserForOne(str);
    }
    @Override
    @Transactional("transactionManager")
    //异常回滚需要指定是哪一个数据源事务管理
    public int addUser(User user) {
        int flag = this.userDao.addUser(user);
        System.out.println(1/0);
        return flag;
    }

}

4).User.java

package com.jdbcyw1.module;

public class User {

    private String id;
    private String name;
    private String pwd;
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPwd() {
        return pwd;
    }
    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

}

5).UserMapper.xml

<?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.jdbcyw1.dao.UserDao" >
  <resultMap id="BaseResultMap" type="User" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="pwd" property="pwd" jdbcType="VARCHAR" />
  </resultMap>
  <select id="queryUser" resultMap="BaseResultMap" parameterType="com.jdbcyw1.module.User" >
    select 
    id,name,pwd
    from user
    <where> 
        and 1 = 1
        <if test = "id != null and id != '' ">
          and   id = #{id}
        </if>
        <if test = "name != null and name != '' " >
         and    role_name = #{roleName}
        </if>
        <if test = "pwd != null and pwd != '' " >
        and order_no = #{orderNo}
        </if>
    </where>

  </select>
  <select id="queryUserForOne" resultMap="BaseResultMap" parameterType="java.lang.String" >
   select 
    id,name,pwd
    from user where id = '1'
  </select>
  <insert id="addUser" parameterType="User" useGeneratedKeys="true" keyProperty="id">
        insert into user(name,pwd) values(#{name},#{pwd})
    </insert>
</mapper>

6).UserController.java

package com.jdbcyw1.controller;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.jdbcbase.service.MenuService;
import com.jdbcyw1.module.User;
import com.jdbcyw1.service.UserService;

@Controller
@RequestMapping("/user")
public class UserController {
    @Resource
    private UserService userService;
    @RequestMapping("/getUserList")
    @ResponseBody
    //http://localhost:8080/springMvc/user/getUserList
    public List<User> queryUser() {
        User u = new User();
        return userService.queryUser(u);
    }
    @RequestMapping("/getUser")
    @ResponseBody
    public User queryUserForOne() {
        String str = "";
        return userService.queryUserForOne(str);
    }
    @RequestMapping("/addUser")
    @ResponseBody
    public int addUser() {
        User user = new User();
        user.setName("test");
        user.setPwd("pwd的");
        return userService.addUser(user);
    }

}

7).CommonInterceptor .java

package com.cn.interceptor;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;

import com.jdbcyw1.module.User;
import com.jdbcyw1.service.UserService;

/**
 * 拦截器
 * @author wdd-think
 *
 */
public class CommonInterceptor extends HandlerInterceptorAdapter {

    private final Logger log = LoggerFactory.getLogger(CommonInterceptor.class);  
    public static final String LAST_PAGE = "com.alibaba.lastPage";  
    private static ApplicationContext ack;
    /**  
     * 在业务处理器处理请求之前被调用  
     * 如果返回false  
     *     从当前的拦截器往回执行所有拦截器的afterCompletion(),再退出拦截器链 
     * 如果返回true  
     *    执行下一个拦截器,直到所有的拦截器都执行完毕  
     *    再执行被拦截的Controller  
     *    然后进入拦截器链,  
     *    从最后一个拦截器往回执行所有的postHandle()  
     *    接着再从最后一个拦截器往回执行所有的afterCompletion()  
     */    
    @Override    
    public boolean preHandle(HttpServletRequest request,    
            HttpServletResponse response, Object handler) throws Exception {    
        if ("GET".equalsIgnoreCase(request.getMethod())) {  
            //RequestUtil.saveRequest();  
        }  
        log.info("==============执行顺序: 1、preHandle================");    
        String requestUri = request.getRequestURI();  
        String contextPath = request.getContextPath();  
        String url = requestUri.substring(contextPath.length());  

        log.info("requestUri:"+requestUri);    
        log.info("contextPath:"+contextPath);    
        log.info("url:"+url);    

        String username =  (String)request.getSession().getAttribute("user");   
        if(username == null){  
//            log.info("Interceptor：跳转到login页面！");  
//            request.getRequestDispatcher("/WEB-INF/jsp/login.jsp").forward(request, response);  
//            return false;  
            return true; //没有判断session
        }else  
            return true;     
    }    

    /** 
     * 在业务处理器处理请求执行完成后,生成视图之前执行的动作    
     * 可在modelAndView中加入数据，比如当前时间 
     */  
    @Override    
    public void postHandle(HttpServletRequest request,    
            HttpServletResponse response, Object handler,    
            ModelAndView modelAndView) throws Exception {     
        log.info("==============执行顺序: 2、postHandle================");    
        if(modelAndView != null){  //加入当前时间    
            modelAndView.addObject("var", "测试postHandle");    
        }    
    }    

    /**  
     * 在DispatcherServlet完全处理完请求后被调用,可用于清理资源等   
     *   
     * 当有拦截器抛出异常时,会从当前拦截器往回执行所有的拦截器的afterCompletion()  
     */    
    @Override    
    public void afterCompletion(HttpServletRequest request,    
            HttpServletResponse response, Object handler, Exception ex)    
            throws Exception {    
        //setAck(new ClassPathXmlApplicationContext("spring-mybatis.xml"));
        //ApplicationContext ack2 = new ClassPathXmlApplicationContext("spring-mybatis.xml");
        //UserService userService= (UserService) ack2.getBean("userService");
        //User user = userService.queryUserForOne("");
        //System.out.println("-----"+user+"=======================");
        log.info("==============执行顺序: 3、afterCompletion================");    
    }

    public static ApplicationContext getAck() {
        return ack;
    }

    public static void setAck(ApplicationContext ack) {
        CommonInterceptor.ack = ack;
    }    

}

8).SpringException .java
（异常）

package com.exception;

public class SpringException extends  RuntimeException{
    private String exceptionMsg;
    public SpringException(String exceptionMsg) {
        System.out.println("SpringException"+this.exceptionMsg);
        this.exceptionMsg = exceptionMsg;
    }
    public String getExceptionMsg(){
        System.out.println("getExceptionMsg"+this.exceptionMsg);
        return this.exceptionMsg;
    }
    public void setExceptionMsg(String exceptionMsg) {
        System.out.println("setExceptionMsg"+this.exceptionMsg);
        this.exceptionMsg = exceptionMsg;
    }
}

9).AopTest .java
（springAop测试）

package com;
import org.aspectj.lang.annotation.AfterReturning;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Before;
import org.aspectj.lang.annotation.Pointcut;

@Aspect
public class AopTest {

    public AopTest(){

    }

   // @Pointcut("execution(* test.spring.aop.bean.Human.*(..))")
    @Pointcut("execution(* com.jdbcbase.service.impl.MenuServiceImpl.*(..))")
    public void allMethod(){}

    @Before("allMethod()")
    public void beforeSleep(){
        System.out.println("AopTest before!");
    }

    @AfterReturning("allMethod()")
    public void afterSleep(){
        System.out.println("AopTest after！");
    }
}

10).error.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"   pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>异常</title>
</head>
<body>
异常
</body>
</html>

启动访问

web访问结果
这里写图片描述
控制台拦截器，aop测试

源码下载（git 地址：https://code.csdn.net/u013561386/springmvc.git，用eclipse导入maven项目），test包是平时测试，不影响运行

问题解决

场景：在A 数据库的a表添加一条数据，同时在B库的b表中添加一条数据，如果b表添加失败，希望a表，b表数据都可以回滚，甚至更多的数据库，上面的事务无法满足在多数据源操作时同时回滚多表。
解决办法：用分布式事务可以解决，下一篇是具体解决方法（不过现在大多数应用都是一个个微服务叠加起来的，即一个服务对应一个数据源，这样设计的一个重要原因是可以在其中某一个微服务应用挂掉不会影响别的服务应用，so上面的场景很少用到，但不排除特殊情况，下面一篇则是是解决方案）

云水天堂

关注

0
点赞
踩
4

收藏

觉得还不错? 一键收藏
2
评论
springMvc（Maven构建，整合mybatis）附git地址

2个数据源mysql数据库test: 表 user DROP TABLE IF EXISTS user; CREATE TABLE user ( id int(11) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, pwd varchar(255) DEFAULT NULL, PRIMAR
复制链接

扫一扫