ssm整合(基于xml配置方式)

来源:互联网 发布:linux查看有几个cpu 编辑:程序博客网 时间:2024/06/14 19:54

本文是基于xml配置的方式来整合SpringMVC、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.xuebusi</groupId>  <artifactId>xssm</artifactId>  <packaging>war</packaging>  <version>1.0-SNAPSHOT</version>  <name>ssm Maven Webapp</name>  <url>http://maven.apache.org</url>  <!-- 集中定义依赖版本号 -->  <properties>    <generator.version>1.3.2</generator.version>    <junit.version>4.12</junit.version>    <spring.version>4.1.3.RELEASE</spring.version>    <mybatis.version>3.2.8</mybatis.version>    <mybatis.spring.version>1.2.2</mybatis.spring.version>    <mybatis.paginator.version>1.2.15</mybatis.paginator.version>    <mysql.version>5.1.32</mysql.version>    <slf4j.version>1.6.4</slf4j.version>    <jackson.version>2.4.2</jackson.version>    <druid.version>1.0.9</druid.version>    <httpclient.version>4.3.5</httpclient.version>    <jstl.version>1.2</jstl.version>    <servlet-api.version>2.5</servlet-api.version>    <jsp-api.version>2.0</jsp-api.version>    <joda-time.version>2.5</joda-time.version>    <commons-lang3.version>3.3.2</commons-lang3.version>    <commons-io.version>1.3.2</commons-io.version>    <commons-net.version>3.3</commons-net.version>    <pagehelper.version>3.4.2</pagehelper.version>    <jsqlparser.version>0.9.1</jsqlparser.version>    <commons-fileupload.version>1.3.1</commons-fileupload.version>    <jedis.version>2.7.2</jedis.version>    <solrj.version>4.10.3</solrj.version>  </properties>  <!-- 依赖管理 -->  <dependencies>    <!-- 逆向工程 -->    <dependency>      <groupId>org.mybatis.generator</groupId>      <artifactId>mybatis-generator-core</artifactId>      <version>${generator.version}</version>    </dependency>    <!-- 时间操作组件 -->    <dependency>      <groupId>joda-time</groupId>      <artifactId>joda-time</artifactId>      <version>${joda-time.version}</version>    </dependency>    <!-- Apache工具组件 -->    <dependency>      <groupId>org.apache.commons</groupId>      <artifactId>commons-lang3</artifactId>      <version>${commons-lang3.version}</version>    </dependency>    <dependency>      <groupId>org.apache.commons</groupId>      <artifactId>commons-io</artifactId>      <version>${commons-io.version}</version>    </dependency>    <dependency>      <groupId>commons-net</groupId>      <artifactId>commons-net</artifactId>      <version>${commons-net.version}</version>    </dependency>    <!-- Jackson Json处理工具包 -->    <dependency>      <groupId>com.fasterxml.jackson.core</groupId>      <artifactId>jackson-databind</artifactId>      <version>${jackson.version}</version>    </dependency>    <!-- httpclient -->    <dependency>      <groupId>org.apache.httpcomponents</groupId>      <artifactId>httpclient</artifactId>      <version>${httpclient.version}</version>    </dependency>    <!-- 日志处理 -->    <dependency>      <groupId>org.slf4j</groupId>      <artifactId>slf4j-log4j12</artifactId>      <version>${slf4j.version}</version>    </dependency>    <!-- Mybatis -->    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis</artifactId>      <version>${mybatis.version}</version>    </dependency>    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis-spring</artifactId>      <version>${mybatis.spring.version}</version>    </dependency>    <dependency>      <groupId>com.github.miemiedev</groupId>      <artifactId>mybatis-paginator</artifactId>      <version>${mybatis.paginator.version}</version>    </dependency>    <dependency>      <groupId>com.github.pagehelper</groupId>      <artifactId>pagehelper</artifactId>      <version>${pagehelper.version}</version>    </dependency>    <!-- MySql -->    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>${mysql.version}</version>    </dependency>    <!-- 连接池 -->    <dependency>      <groupId>com.alibaba</groupId>      <artifactId>druid</artifactId>      <version>${druid.version}</version>    </dependency>    <!-- Spring -->    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-context</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-beans</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-jdbc</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-aspects</artifactId>      <version>${spring.version}</version>    </dependency>    <!-- JSP相关 -->    <dependency>      <groupId>jstl</groupId>      <artifactId>jstl</artifactId>      <version>${jstl.version}</version>    </dependency>    <dependency>      <groupId>javax.servlet</groupId>      <artifactId>servlet-api</artifactId>      <version>${servlet-api.version}</version>      <scope>provided</scope>    </dependency>    <dependency>      <groupId>javax.servlet</groupId>      <artifactId>jsp-api</artifactId>      <version>${jsp-api.version}</version>      <scope>provided</scope>    </dependency>    <!-- 文件上传组件 -->    <dependency>      <groupId>commons-fileupload</groupId>      <artifactId>commons-fileupload</artifactId>      <version>${commons-fileupload.version}</version>    </dependency>    <!-- Redis客户端 -->    <dependency>      <groupId>redis.clients</groupId>      <artifactId>jedis</artifactId>      <version>${jedis.version}</version>    </dependency>    <!-- solr客户端 -->    <dependency>      <groupId>org.apache.solr</groupId>      <artifactId>solr-solrj</artifactId>      <version>${solrj.version}</version>    </dependency>    <!-- 单元测试 -->    <dependency>      <groupId>junit</groupId>      <artifactId>junit</artifactId>      <version>${junit.version}</version>      <scope>test</scope>    </dependency>  </dependencies>  <build>    <!-- 如果不添加此节点mybatis的mapper.xml文件都会被漏掉。 -->    <resources>      <resource>        <directory>src/main/java</directory>        <includes>          <include>**/*.properties</include>          <include>**/*.xml</include>        </includes>        <filtering>false</filtering>      </resource>    </resources>    <plugins>      <!-- 资源文件拷贝插件 -->      <plugin>        <groupId>org.apache.maven.plugins</groupId>        <artifactId>maven-resources-plugin</artifactId>        <version>2.7</version>        <configuration>          <encoding>UTF-8</encoding>        </configuration>      </plugin>      <!-- java编译插件 -->      <plugin>        <groupId>org.apache.maven.plugins</groupId>        <artifactId>maven-compiler-plugin</artifactId>        <version>3.2</version>        <configuration>          <source>1.7</source>          <target>1.7</target>          <encoding>UTF-8</encoding>        </configuration>      </plugin>    </plugins>    <pluginManagement>      <plugins>        <!-- 配置Tomcat插件 -->        <plugin>          <groupId>org.apache.tomcat.maven</groupId>          <artifactId>tomcat7-maven-plugin</artifactId>          <version>2.2</version>        </plugin>      </plugins>    </pluginManagement>  </build></project>
复制代码

(2)既然是web项目,首先得配置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_2_5.xsd" id="xuebusi" version="2.5">    <display-name>xuebusi</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>    <!-- 加载spring容器 -->    <context-param>        <param-name>contextConfigLocation</param-name>        <param-value>classpath:spring/applicationContext-*.xml</param-value>    </context-param>    <listener>        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>    </listener>    <!-- 解决post乱码 -->    <filter>        <filter-name>CharacterEncodingFilter</filter-name>        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>        <init-param>            <param-name>encoding</param-name>            <param-value>utf-8</param-value>        </init-param>    </filter>    <filter-mapping>        <filter-name>CharacterEncodingFilter</filter-name>        <url-pattern>/*</url-pattern>    </filter-mapping>    <!-- springmvc的前端控制器 -->    <servlet>        <servlet-name>dispatcherServlet</servlet-name>        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>        <!-- contextConfigLocation不是必须的, 如果不配置contextConfigLocation, springmvc的配置文件默认在:WEB-INF/servlet的name+"-servlet.xml" -->        <init-param>            <param-name>contextConfigLocation</param-name>            <param-value>classpath:spring/springmvc.xml</param-value>        </init-param>        <load-on-startup>1</load-on-startup>    </servlet>    <servlet-mapping>        <servlet-name>dispatcherServlet</servlet-name>        <url-pattern>/</url-pattern>    </servlet-mapping></web-app>
复制代码

 

(3)数据库连接配置 db.properties 

jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/xssm?characterEncoding=utf-8jdbc.username=rootjdbc.password=root

 

(4)Mybatis的配置文件 SqlMapConfig.xml

复制代码
<?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>    <!-- 配置分页插件 -->    <plugins>        <plugin interceptor="com.github.pagehelper.PageHelper">            <!-- 设置数据库类型,支持Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL六种数据库-->            <property name="dialect" value="mysql"/>        </plugin>    </plugins></configuration>
复制代码

(5)springmvc的配置文件 springmvc.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: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.xsd        http://www.springframework.org/schema/mvc        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd        http://www.springframework.org/schema/context        http://www.springframework.org/schema/context/spring-context.xsd">    <context:component-scan base-package="com.xuebusi.xssm.controller" />    <mvc:annotation-driven />    <bean        class="org.springframework.web.servlet.view.InternalResourceViewResolver">        <property name="prefix" value="/WEB-INF/jsp/" />        <property name="suffix" value=".jsp" />    </bean>    <!-- 资源映射 -->    <mvc:resources location="/WEB-INF/css/" mapping="/css/**"/>    <mvc:resources location="/WEB-INF/js/" mapping="/js/**"/>        <!-- 定义文件上传解析器 -->    <bean id="multipartResolver"        class="org.springframework.web.multipart.commons.CommonsMultipartResolver">        <!-- 设定默认编码 -->        <property name="defaultEncoding" value="UTF-8"></property>        <!-- 设定文件上传的最大值5MB,5*1024*1024 -->        <property name="maxUploadSize" value="5242880"></property>    </bean></beans>
复制代码

(6)Spring的配置文件applicationContext-service.xml 扫描@Service注解

复制代码
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xsi:schemaLocation="http://www.springframework.org/schema/beans           http://www.springframework.org/schema/beans/spring-beans-4.0.xsd        http://www.springframework.org/schema/context        http://www.springframework.org/schema/context/spring-context-4.0.xsd">    <!-- 扫描包加载Service实现类 -->    <context:component-scan base-package="com.xuebusi.xssm.service"></context:component-scan></beans>
复制代码

(7)Spring的事物配置 applicationContext-trans.xml

复制代码
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:aop="http://www.springframework.org/schema/aop"       xmlns:tx="http://www.springframework.org/schema/tx"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xsi:schemaLocation="http://www.springframework.org/schema/beans        http://www.springframework.org/schema/beans/spring-beans-4.0.xsd        http://www.springframework.org/schema/aop        http://www.springframework.org/schema/aop/spring-aop-4.0.xsd        http://www.springframework.org/schema/tx        http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">    <!-- 事务管理器 -->    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <!-- 数据源 -->        <property name="dataSource" ref="dataSource"/>    </bean>    <!-- 通知 -->    <tx:advice id="txAdvice" transaction-manager="transactionManager">        <tx:attributes>            <!-- 传播行为 -->            <tx:method name="save*" propagation="REQUIRED"/>            <tx:method name="insert*" propagation="REQUIRED"/>            <tx:method name="add*" propagation="REQUIRED"/>            <tx:method name="create*" propagation="REQUIRED"/>            <tx:method name="delete*" propagation="REQUIRED"/>            <tx:method name="update*" propagation="REQUIRED"/>            <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>            <tx:method name="select*" propagation="SUPPORTS" read-only="true"/>            <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>        </tx:attributes>    </tx:advice>    <!-- 切面 -->    <aop:config>        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.xuebusi.xssm.service.*.*(..))"/>    </aop:config></beans>
复制代码

(8)Spring的数据源配置文件 applicationContext-dao.xml

复制代码
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xsi:schemaLocation="http://www.springframework.org/schema/beans           http://www.springframework.org/schema/beans/spring-beans-4.0.xsd        http://www.springframework.org/schema/context        http://www.springframework.org/schema/context/spring-context-4.0.xsd">    <!-- 加载配置文件 -->    <context:property-placeholder location="classpath:resource/*.properties" />    <!-- 数据库连接池 -->    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">        <property name="url" value="${jdbc.url}" />        <property name="username" value="${jdbc.username}" />        <property name="password" value="${jdbc.password}" />        <property name="driverClassName" value="${jdbc.driver}" />        <property name="maxActive" value="10" />        <property name="minIdle" value="5" />    </bean>    <!-- 配置sqlsessionFactory -->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml"></property>        <property name="dataSource" ref="dataSource"></property>    </bean>    <!-- 配置扫描包,加载mapper代理对象 -->    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="com.xuebusi.xssm.mapper"></property>    </bean></beans>
复制代码

(9)redis配置文件 applicationContext-jedis.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"       xsi:schemaLocation="http://www.springframework.org/schema/beans           http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">    <!-- 连接池配置 -->    <bean id="jedisPoolConfig" class="redis.clients.jedis.JedisPoolConfig">        <!-- 最大连接数 -->        <property name="maxTotal" value="30" />        <!-- 最大空闲连接数 -->        <property name="maxIdle" value="10" />        <!-- 每次释放连接的最大数目 -->        <property name="numTestsPerEvictionRun" value="1024" />        <!-- 释放连接的扫描间隔(毫秒) -->        <property name="timeBetweenEvictionRunsMillis" value="30000" />        <!-- 连接最小空闲时间 -->        <property name="minEvictableIdleTimeMillis" value="1800000" />        <!-- 连接空闲多久后释放, 当空闲时间>该值 且 空闲连接>最大空闲连接数 时直接释放 -->        <property name="softMinEvictableIdleTimeMillis" value="10000" />        <!-- 获取连接时的最大等待毫秒数,小于零:阻塞不确定的时间,默认-1 -->        <property name="maxWaitMillis" value="1500" />        <!-- 在获取连接的时候检查有效性, 默认false -->        <property name="testOnBorrow" value="true" />        <!-- 在空闲时检查有效性, 默认false -->        <property name="testWhileIdle" value="true" />        <!-- 连接耗尽时是否阻塞, false报异常,ture阻塞直到超时, 默认true -->        <property name="blockWhenExhausted" value="false" />    </bean>        <!-- jedis客户端单机版 -->    <!--<bean id="redisClient" class="redis.clients.jedis.JedisPool">        <constructor-arg name="host" value="localhost"></constructor-arg>        <constructor-arg name="port" value="6379"></constructor-arg>        <constructor-arg name="poolConfig" ref="jedisPoolConfig"></constructor-arg>    </bean>    <bean id="jedisClient" class="com.xuebusi.xssm.dao.impl.JedisClientSingle"/>-->            <!-- jedis集群版配置 -->        <bean id="redisClient" class="redis.clients.jedis.JedisCluster">        <constructor-arg name="nodes">            <set>                <bean class="redis.clients.jedis.HostAndPort">                    <constructor-arg name="host" value="192.168.71.13"></constructor-arg>                    <constructor-arg name="port" value="7001"></constructor-arg>                </bean>                <bean class="redis.clients.jedis.HostAndPort">                    <constructor-arg name="host" value="192.168.71.13"></constructor-arg>                    <constructor-arg name="port" value="7002"></constructor-arg>                </bean>                <bean class="redis.clients.jedis.HostAndPort">                    <constructor-arg name="host" value="192.168.71.13"></constructor-arg>                    <constructor-arg name="port" value="7003"></constructor-arg>                </bean>                <bean class="redis.clients.jedis.HostAndPort">                    <constructor-arg name="host" value="192.168.71.13"></constructor-arg>                    <constructor-arg name="port" value="7004"></constructor-arg>                </bean>                <bean class="redis.clients.jedis.HostAndPort">                    <constructor-arg name="host" value="192.168.71.13"></constructor-arg>                    <constructor-arg name="port" value="7005"></constructor-arg>                </bean>                <bean class="redis.clients.jedis.HostAndPort">                    <constructor-arg name="host" value="192.168.71.13"></constructor-arg>                    <constructor-arg name="port" value="7006"></constructor-arg>                </bean>            </set>        </constructor-arg>        <constructor-arg name="poolConfig" ref="jedisPoolConfig"></constructor-arg>    </bean>    <bean id="jedisClientCluster" class="com.xuebusi.xssm.dao.impl.JedisClientCluster"></bean>    </beans>
复制代码

 

(10)在MySQL中创建一张x_user表

复制代码
CREATE TABLE `x_user` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(255) DEFAULT NULL,  `address` varchar(255) DEFAULT NULL,  `age` int(11) DEFAULT NULL,  `phone` varchar(255) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
复制代码

往表里插入几条测试数据:

 

(11)通过mybatis的逆向工程生成x_user表对应的实体类、接口类、Example类以及Mapper.xml配置文件,具体方法移步另一篇文章《mybatis逆向工程自动生成实体类、接口以及映射Mapper.xml配置文件》,地址:http://www.cnblogs.com/jun1019/p/8073229.html

 

(12)编写Controller类测试下

复制代码
package com.xuebusi.xssm.controller;import com.xuebusi.xssm.pojo.XUser;import com.xuebusi.xssm.service.XUserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import java.util.List;/** * Created by SYJ on 2017/12/18. */@Controller@RequestMapping(value = "/user")public class XUserController {    @Autowired    private XUserService userService;    /**     * 根据id查询用户     * @param id     * @return     */    @RequestMapping(value = "/{id}")    @ResponseBody    public XUser get(@PathVariable("id") Integer id) {        return userService.selectByPrimaryKey(id);    }    /**     * 查询所有用户     * @return     */    @RequestMapping(value = "/list")    @ResponseBody    public List<XUser> list() {        return userService.findAll();    }    /**     * 添加用户     * @return     */    @RequestMapping(value = "/add")    @ResponseBody    public int insert() {        XUser user = new XUser();        user.setName("王五");        user.setAge(25);        user.setPhone("13910108899");        user.setAddress("重庆");        return userService.insert(user);    }}
复制代码

(13) 编写Service接口:

复制代码
package com.xuebusi.xssm.service;import com.xuebusi.xssm.pojo.XUser;import java.util.List;/** * Created by SYJ on 2017/12/18. */public interface XUserService {    XUser selectByPrimaryKey(Integer id);    int insert(XUser user);    List<XUser> findAll();}
复制代码

(14)编写Service实现类:

复制代码
package com.xuebusi.xssm.service.impl;import com.xuebusi.xssm.mapper.XUserMapper;import com.xuebusi.xssm.pojo.XUser;import com.xuebusi.xssm.service.XUserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;/** * Created by SYJ on 2017/12/18. */@Servicepublic class XUserServiceImpl implements XUserService {    @Autowired    private XUserMapper userMapper;    /**     * 根据id查询用户     * @param id     * @return     */    @Override    public XUser selectByPrimaryKey(Integer id) {        XUser user = userMapper.selectByPrimaryKey(id);        return user;    }    /**     * 添加用户     * @param user     * @return     */    @Override    public int insert(XUser user) {        return userMapper.insert(user);    }    /**     * 查询所有用户     * @return     */    @Override    public List<XUser> findAll() {        return userMapper.selectByExample(null);    }}
复制代码

(15)启动项目,通过浏览器访问下: