1、基本概念
ssm：spring+springMVC+mybatis
2、开发环境
Eclipse mars + jdk1.7 + maven + tomcat7
3、使用maven构建web项目
3.1、首先，创建一个maven object
3.2、创建一个新的路径、next
3.3、选择 maven-archetype-webapp next
3.4 输入artifact id 这个是项目的唯一标识 实际对应项目的名称 group id一般是公司，组织的名称反写，groupid+artifactid就保证了一个项目的唯一性。
4.1、在pom.xml文件中引入jar包，各个包是干嘛的 都有说明，此处不在赘述。
1 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 2 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> 3 <modelVersion>4.0.0</modelVersion> 4 <groupId>com.hbst.www</groupId> 5 <artifactId>BaseSsm_3</artifactId> 6 <packaging>war</packaging> 7 <version>0.0.1-SNAPSHOT</version> 8 <name>BaseSsm_3 Maven Webapp</name> 9 <url>http://maven.apache.org</url> 10 <properties> 11 <!-- spring版本号 --> 12 <spring.version>4.0.2.RELEASE</spring.version> 13 <!-- mybatis版本号 --> 14 <mybatis.version>3.2.6</mybatis.version> 15 <!-- log4j日志文件管理包版本 --> 16 <slf4j.version>1.7.7</slf4j.version> 17 <log4j.version>1.2.17</log4j.version> 18 </properties> 19 20 21 <dependencies> 22 <dependency> 23 <groupId>junit</groupId> 24 <artifactId>junit</artifactId> 25 <version>3.8.1</version> 26 <scope>test</scope> 27 </dependency> 28 29 <!-- spring核心包 --> 30 <dependency> 31 <groupId>org.springframework</groupId> 32 <artifactId>spring-core</artifactId> 33 <version>${spring.version}</version> 34 </dependency> 35 36 <dependency> 37 <groupId>org.springframework</groupId> 38 <artifactId>spring-web</artifactId> 39 <version>${spring.version}</version> 40 </dependency> 41 <dependency> 42 <groupId>org.springframework</groupId> 43 <artifactId>spring-oxm</artifactId> 44 <version>${spring.version}</version> 45 </dependency> 46 <dependency> 47 <groupId>org.springframework</groupId> 48 <artifactId>spring-tx</artifactId> 49 <version>${spring.version}</version> 50 </dependency> 51 52 <dependency> 53 <groupId>org.springframework</groupId> 54 <artifactId>spring-jdbc</artifactId> 55 <version>${spring.version}</version> 56 </dependency> 57 58 <dependency> 59 <groupId>org.springframework</groupId> 60 <artifactId>spring-webmvc</artifactId> 61 <version>${spring.version}</version> 62 </dependency> 63 <dependency> 64 <groupId>org.springframework</groupId> 65 <artifactId>spring-aop</artifactId> 66 <version>${spring.version}</version> 67 </dependency> 68 69 <dependency> 70 <groupId>org.springframework</groupId> 71 <artifactId>spring-context-support</artifactId> 72 <version>${spring.version}</version> 73 </dependency> 74 75 <dependency> 76 <groupId>org.springframework</groupId> 77 <artifactId>spring-test</artifactId> 78 <version>${spring.version}</version> 79 </dependency> 80 <!-- mybatis核心包 --> 81 <dependency> 82 <groupId>org.mybatis</groupId> 83 <artifactId>mybatis</artifactId> 84 <version>${mybatis.version}</version> 85 </dependency> 86 <!-- mybatis/spring包 --> 87 <dependency> 88 <groupId>org.mybatis</groupId> 89 <artifactId>mybatis-spring</artifactId> 90 <version>1.2.2</version> 91 </dependency> 92 93 <!-- 导入java ee jar 包 --> 94 <dependency> 95 <groupId>javax</groupId> 96 <artifactId>javaee-api</artifactId> 97 <version>7.0</version> 98 </dependency> 99 100 <!-- 导入Mysql数据库链接jar包 --> 101 <dependency> 102 <groupId>mysql</groupId> 103 <artifactId>mysql-connector-java</artifactId> 104 <version>5.1.36</version> 105 </dependency> 106 <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 --> 107 <dependency> 108 <groupId>commons-dbcp</groupId> 109 <artifactId>commons-dbcp</artifactId> 110 <version>1.2.2</version> 111 </dependency> 112 113 <!-- JSTL标签类 --> 114 <dependency> 115 <groupId>jstl</groupId> 116 <artifactId>jstl</artifactId> 117 <version>1.2</version> 118 </dependency> 119 <!-- 日志文件管理包 --> 120 <!-- log start --> 121 <dependency> 122 <groupId>log4j</groupId> 123 <artifactId>log4j</artifactId> 124 <version>${log4j.version}</version> 125 </dependency> 126 127 128 <!-- servlet api --> 129 <dependency> 130 <groupId>javax.servlet</groupId> 131 <artifactId>javax.servlet-api</artifactId> 132 <version>3.0.1</version> 133 <scope>provided</scope> 134 </dependency> 135 136 <!-- 格式化对象，方便输出日志 --> 137 <dependency> 138 <groupId>com.alibaba</groupId> 139 <artifactId>fastjson</artifactId> 140 <version>1.1.41</version> 141 </dependency> 142 143 144 <dependency> 145 <groupId>org.slf4j</groupId> 146 <artifactId>slf4j-api</artifactId> 147 <version>${slf4j.version}</version> 148 </dependency> 149 150 <dependency> 151 <groupId>org.slf4j</groupId> 152 <artifactId>slf4j-log4j12</artifactId> 153 <version>${slf4j.version}</version> 154 </dependency> 155 <!-- log end --> 156 <!-- 映入JSON --> 157 <dependency> 158 <groupId>org.codehaus.jackson</groupId> 159 <artifactId>jackson-mapper-asl</artifactId> 160 <version>1.9.13</version> 161 </dependency> 162 <!-- 上传组件包 --> 163 <dependency> 164 <groupId>commons-fileupload</groupId> 165 <artifactId>commons-fileupload</artifactId> 166 <version>1.3.1</version> 167 </dependency> 168 <dependency> 169 <groupId>commons-io</groupId> 170 <artifactId>commons-io</artifactId> 171 <version>2.4</version> 172 </dependency> 173 <dependency> 174 <groupId>commons-codec</groupId> 175 <artifactId>commons-codec</artifactId> 176 <version>1.9</version> 177 </dependency> 178 </dependencies> 179 <build> 180 <finalName>BaseSsm_3</finalName> 181 </build> 182 </project>
4.2、Spring与MyBatis的整合
此次整合，并没有使用mapper接口 而是使用sqlSessionTemplate接口来实现，使用mapper接口开发，会对每张表分别生成一个model，dao和一个mapper.xml，造成文件数过多。
4.2.1、SqlSessionTemplate
SqlSessionTemplate是MyBatis-spring的核心。这个类负责管理MyBatis的SqlSession,调用MyBatis的SQL方法。SqlSessionTemplate是线程安全的，可以被多个DAO所共享使用。
当调用SQL方法时，包含从映射器getMapper()方法返回的方法，SqlSessionTemplate将会保证使用的SqlSession是和当前Spring的事务相关的。此外，它管理session的生命周期，包含必要的关闭，提交或回滚操作。
SqlSessionTemplate实现了SqlSession，这就是说要对MyBatis的SqlSession进行简易替换。
SqlSessionTemplate通常是被用来替代默认的MyBatis实现的DefaultSqlSession，因为它不能参与到Spring的事务中也不能被注入，因为它是线程不安全的。相同应用程序中两个类之间的转换可能会引起数据一致性的问题。
SqlSessionTemplate对象可以使用SqlSessionFactory作为构造方法的参数来创建。
4.2.2、介绍完基本概念，现在开始正式整合，首先创建jdbc.propreties文件 （文件编码修改为 utf-8 ）
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/db3
jdbc.username=root
jdbc.password=123456
jdbc.minIdle=30
jdbc.maxIdle=80
jdbc.maxWait=60000
jdbc.maxActive=80
jdbc.initialSize=20
jdbc.testWhileIdle=true
jdbc.testOnBorrow=false
jdbc.testOnReturn=false
jdbc.validationQuery=select 1
jdbc.validationQueryTimeout=1
jdbc.timeBetweenEvictionRunsMillis=600000
jdbc.numTestsPerEvictionRun=40
4.2.3、建立spring-mybatis.xml配置文件
这个文件就是用来完成spring和mybatis的整合的。这里面也没多少行配置，主要的就是 自动扫描，自动注入，配置数据库 。
<?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: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/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 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd"> <!-- 自动扫描 --> <context:component-scan base-package="com.hbst.basessm_3" /> <!-- proxy-target-class="true"强制使用CGLib代理，为false则spring会自动选择 --> <aop:aspectj-autoproxy proxy-target-class="true" /> <!-- 引入jdbc配置文件 --> <context:property-placeholder location="classpath:config/jdbc/jdbc.properties" /> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driverClassName}" /> <property name="url" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <!-- 队列中的最小等待数 --> <property name="minIdle" value="${jdbc.minIdle}"></property> <!-- 队列中的最大等待数 --> <property name="maxIdle" value="${jdbc.maxIdle}"></property> <!-- 最长等待时间，单位毫秒 --> <property name="maxWait" value="${jdbc.maxWait}"></property> <!-- 最大活跃数 --> <property name="maxActive" value="${jdbc.maxActive}"></property> <property name="initialSize" value="${jdbc.initialSize}"></property> <property name="testWhileIdle" value="${jdbc.testWhileIdle}"></property> <property name="testOnBorrow" value="${jdbc.testOnBorrow}"></property> <property name="testOnReturn" value="${jdbc.testOnReturn}"></property> <property name="validationQuery" value="${jdbc.validationQuery}" /> <property name="validationQueryTimeout" value="${jdbc.validationQueryTimeout}"></property> <property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}"></property> <property name="numTestsPerEvictionRun" value="${jdbc.numTestsPerEvictionRun}"></property> </bean> <!-- 配置MyBitas SqlSessionFactoryBean --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="configLocation" value="classpath:config/mybatis/typeAliasMapper.xml" /> <property name="mapperLocations" value="classpath:config/mybatis/mappers/*/*Mapper.xml" /> <property name="dataSource" ref="dataSource" /> </bean> <!-- 配置SqlSessionTemplate --> <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate" scope="prototype"> <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" /> </bean> <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 --> <!-- <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> --> <!-- <property name="dataSource" ref="dataSource" /> --> <!-- 自动扫描mapping.xml文件 --> <!-- <property name="mapperLocations" value="classpath:com/cn/hnust/mapping/*.xml"></property> --> <!-- </bean> --> <!-- DAO接口所在包名，Spring会自动查找其下的类 --> <!-- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> --> <!-- <property name="basePackage" value="com.cn.hnust.dao" /> --> <!-- <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property> --> <!-- </bean> --> <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!-- 使用注解的方式配置事务 --> <tx:annotation-driven transaction-manager="transactionManager" /> </beans>
4.2.4、我在上面配置 SqlSessionTemplate 的时候 指定了一个 typeAliasMapper.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> <typeAliases> <typeAlias alias="user" type="com.hbst.basessm_3.pojo.User"/> </typeAliases> <!-- mybatis 分页拦截 --> <plugins> <plugin interceptor="com.hbst.basessm_3.dao.plugin.PageInterceptor"/> </plugins> </configuration>
4.2.5、创建spring配置文件applicationContext.xml 引入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:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:task="http://www.springframework.org/schema/task" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-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 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.0.xsd"> <!-- 采用注释的方式配置bean --> <context:annotation-config /> <task:annotation-driven/> <context:component-scan base-package="com.hbst.basessm_3" /> <!-- proxy-target-class="true"强制使用CGLib代理，为false则spring会自动选择，否则事务不生效 --> <aop:aspectj-autoproxy proxy-target-class="true" /> <import resource="classpath:config/spring/spring-mybatis.xml" /> <!-- 模板引擎 --> <bean id="velocityEngine" class="org.springframework.ui.velocity.VelocityEngineFactoryBean" /> <!-- 异步线程 --> <bean id="taskExecutor" class="org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor"> <property name="corePoolSize" value="10" /> <property name="maxPoolSize" value="30" /> </bean> </beans>
5、至此，spring和mybatis整合完成，下面整合springMVC 我这里创建spring-servlet.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:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 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 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"> <mvc:annotation-driven /> <context:component-scan base-package="com.hbst.basessm_3" /> <bean id="defaultViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="contentType" value="text/html" /> <property name="prefix" value="/" /> <property name="suffix" value=".jsp" /> </bean> <!-- rest json related... start --> <bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"> <property name="supportedMediaTypes"> <list> <value>application/json;charset=UTF-8</value> </list> </property> </bean> <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> <property name="messageConverters"> <list> <ref bean="mappingJacksonHttpMessageConverter"/> </list> </property> </bean> <!-- rest json related... end --> </beans>
6、配置日志管理，创建log4j.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE log4j:configuration SYSTEM "../dtd/log4j.dtd"> <!-- ========================== 自定义输出格式说明================================ --> <!-- %p 输出优先级，即DEBUG，INFO，WARN，ERROR，FATAL --> <!-- %r 输出自应用启动到输出该log信息耗费的毫秒数 --> <!-- %c 输出所属的类目，通常就是所在类的全名 --> <!-- %t 输出产生该日志事件的线程名 --> <!-- %n 输出一个回车换行符，Windows平台为“/r/n”，Unix平台为“/n” --> <!-- %d 输出日志时间点的日期或时间，默认格式为ISO8601，也可以在其后指定格式，比如：%d{yyy MMM dd HH:mm:ss,SSS}，输出类似：2002年10月18日 22:10:28,921 --> <!-- %l 输出日志事件的发生位置，包括类目名、发生的线程，以及在代码中的行数。举例：Testlog4.main(TestLog4.java:10) --> <!-- ========================================================================== --> <!-- ========================== 输出方式说明================================ --> <!-- Log4j提供的appender有以下几种: --> <!-- org.apache.log4j.ConsoleAppender(控制台), --> <!-- org.apache.log4j.FileAppender(文件), --> <!-- org.apache.log4j.DailyRollingFileAppender(每天产生一个日志文件), --> <!-- org.apache.log4j.RollingFileAppender(文件大小到达指定尺寸的时候产生一个新的文件), --> <!-- org.apache.log4j.WriterAppender(将日志信息以流格式发送到任意指定的地方) --> <!-- ========================================================================== --> <!--Threshold是个全局的过滤器，他将把低于所设置的level的信息过滤不显示出来 --> <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="true" threshold="debug"> <!-- 控制台打印日志 --> <appender name="console" class="org.apache.log4j.ConsoleAppender"> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%d{yyyy-MM-dd HH:mm:ss} | %t | %-5p | %c%m%n" /> </layout> </appender> <!-- 输出到日志文件 --> <appender name="filelog_appender" class="org.apache.log4j.RollingFileAppender"> <!-- 设置File参数：日志输出文件名 --> <param name="File" value="${BaseSsm_1.root}/log/BaseSsm_3_debug.log" /> <!-- 设置是否在重新启动服务时，在原有日志的基础添加新日志 --> <param name="Append" value="false" /> <!-- 设置文件大小 --> <param name="MaxFileSize" value="10MB" /> <!-- 设置文件备份 --> <param name="MaxBackupIndex" value="300" /> <!-- 设置输出文件项目和格式 --> <layout class="org.apache.log4j.PatternLayout"> <param name="ConversionPattern" value="%d{yyyy-MM-dd HH:mm:ss} | %t | %-5p | %c %m%n" /> </layout> </appender> <category name="org.apache.log4j"> <priority value="warn" /> </category> <logger name="org.springframework"> <!-- <level value="info" /> --> <level value="debug" /> </logger> <logger name="com.opensymphony.xwork2"> <!-- <level value="info" /> --> <level value="debug" /> </logger> <!-- org.apache.axis2 | org.apache.struts2 --> <logger name="org.apache.axis2"> <level value="info" /> </logger> <logger name="org.apache.axiom"> <level value="warn" /> </logger> <logger name="org.apache.struts2"> <!-- <level value="info" /> --> <level value="debug" /> </logger> <logger name="org.apache.struts2.json"> <level value="debug" /> </logger> <logger name="org.apache.ibatis"> <level value="debug" /> </logger> <logger name="org.mybatis"> <level value="debug" /> </logger> <logger name="java.sql"> <level value="debug" /> </logger> <root> <priority value="debug" /> <appender-ref ref="console" /> <appender-ref ref="filelog_appender" /> </root> </log4j:configuration>
7、配置web.xml 在web.xm中引入spring配置文件、springMVC的配置文件和log4j.xml文件
<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <display-name>Archetype Created Web Application</display-name> <!-- RequestContextListener --> <listener> <listener-class>org.springframework.web.context.request.RequestContextListener</listener-class> </listener> <!-- 指定Web根目录 --> <context-param> <param-name>webAppRootKey</param-name> <param-value>BaseSsm_1.root</param-value> </context-param> <!-- FMT i18n Begin --> <context-param> <param-name>javax.servlet.jsp.jstl.fmt.localizationContext</param-name> <param-value>i18n/lang_messages</param-value> </context-param> <filter> <filter-name>SetCharacterEncoding</filter-name> <filter-class>com.hbst.basessm_1.util.filter.SetCharacterEncodingFilter</filter-class> </filter> <filter-mapping> <filter-name>SetCharacterEncoding</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- FMT i18n End --> <!-- 字符集过滤器 --> <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> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>CharacterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 日志管理配置 --> <listener> <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class> </listener> <context-param> <param-name>log4jConfigLocation</param-name> <param-value>classpath:log4j.xml</param-value> </context-param> <!-- 60s 检测日志配置 文件变化 --> <context-param> <param-name>log4jRefreshInterval</param-name> <param-value>60000</param-value> </context-param> <!-- Spring管理配置 --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- 加载Spring配置文件 --> <context-param> <param-name>contextConfigLocation</param-name> <param-value> classpath:config/spring/applicationContext.xml </param-value> </context-param> <!-- Spring MVC配置 --> <servlet> <servlet-name>Dispatcher</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!-- 自定义spring mvc的配置文件名称和路径 --> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:config/spring/spring-servlet.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <!-- spring mvc 请求后缀 --> <servlet-mapping> <servlet-name>Dispatcher</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> </web-app>
8、最后的目录结构是这样的，源代码已经提交github，有需要的可以下载源码看看，我这里提交的项目是basessm_1，跟basessm_3的结构是一样的，只需要修改下配置文件即可。
github地址是 https://github.com/1428977695/BaseSsm_3/tree/master/BaseSsm_1
9、测试，我这里使用basessm_1来测试
9.1、将项目部署到tomcat上，打开浏览器http://localhost:8080/BaseSsm_1
9.2、出现helloword，说明项目已经启动成功了，下面我们进行数据交互测试，
首先创建数据库，我这里创建user表 就两个字段 将这两个字段的值 显示在页面上
9.3、创建实体
9.4、创建mapper文件
9.5、配置实体别名映射
9.6、创建接口
9.7、创建实现类
9.8、这里将几个基础的类如baseDao.java PageInterceptor.java文件也放上来
9.8.1、接口IBaseDao
package com.hbst.basessm_1.dao; import java.util.List; import java.util.Map; public interface IBaseDao { /** * @Author:Dean * @Description:保存 * @param statement * SQLID * @param parameter * 参数 * @return boolean true 成功，false 失败 * @Date 2015年12月31日 */ public boolean insert(String statement, Object parameter); /** * @Author:Dean * @Description:更新 * @param statement * SQLID * @param parameter * 参数 * @return boolean true 成功，false 失败 * @Date 2015年12月31日 */ public boolean update(String statement, Object parameter); /** * @Author:Dean * @Description:删除 * @param statement * SQLID * @param parameter * 参数 * @return boolean true 成功，false 失败 * @Date 2015年12月31日 */ public boolean delete(String statement, Object parameter); /** * @Author:Dean * @Description:查询单条数据 * @param statement * SQLID * @param parameter * 参数 * @return Object * @Date 2015年12月31日 */ public Object findOneByCustom(String statement, Object parameter); /** * @param <T> * @Author:Dean * @Description: 查询集合列表 * @param statement * SQLID * @param parameter * 参数 * @return List<Object> * @Date 2015年12月31日 */ public <T> List<T> findListByCustom(String statement, Object parameter); /** * @param <T> * @Author:Dean * @Description: 分页查询 * @param statement * SQLID * @param parameter * 参数 * @return List<Object> * @Date 2015年12月31日 */ public Map<String,Object> findPageByCustom(String statement, Object parameter); }
9.8.2、实现类basedao
package com.hbst.basessm_1.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.HashMap; import java.util.List; import java.util.Map; import org.apache.commons.beanutils.PropertyUtils; import org.apache.ibatis.executor.ErrorContext; import org.apache.ibatis.executor.ExecutorException; import org.apache.ibatis.mapping.BoundSql; import org.apache.ibatis.mapping.MappedStatement; import org.apache.ibatis.mapping.ParameterMapping; import org.apache.ibatis.mapping.ParameterMode; import org.apache.ibatis.reflection.MetaObject; import org.apache.ibatis.reflection.property.PropertyTokenizer; import org.apache.ibatis.scripting.xmltags.ForEachSqlNode; import org.apache.ibatis.session.Configuration; import org.apache.ibatis.type.TypeHandler; import org.apache.ibatis.type.TypeHandlerRegistry; import org.mybatis.spring.SqlSessionTemplate; import org.mybatis.spring.SqlSessionUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import com.hbst.basessm_1.dao.IBaseDao; import com.hbst.basessm_1.util.constant.CodeConstant; import com.hbst.basessm_1.util.exception.BusinessException; import net.sf.json.JSONObject; @Repository("baseDao") public class BaseDao implements IBaseDao { @Autowired private SqlSessionTemplate sqlSessionTemplate; private long ROW_NUMBER = 0; private long ZERO = 0; public boolean insert(String statement, Object parameter) { if (null == parameter || null == statement) { throw new IllegalArgumentException(" Parameter Is Null."); } ROW_NUMBER = sqlSessionTemplate.insert(statement, parameter); return ROW_NUMBER > ZERO ? true : false; } public boolean update(String statement, Object parameter) { if (null == parameter || null == statement) { throw new IllegalArgumentException(" Parameter Is Null."); } ROW_NUMBER = sqlSessionTemplate.update(statement, parameter); return ROW_NUMBER > ZERO ? true : false; } public boolean delete(String statement, Object parameter) { if (null == parameter || null == statement) { throw new IllegalArgumentException(" Parameter Is Null."); } ROW_NUMBER = sqlSessionTemplate.delete(statement, parameter); return ROW_NUMBER > ZERO ? true : false; } public Object findOneByCustom(String statement, Object parameter) { if (null == parameter || null == statement) { throw new IllegalArgumentException(" Parameter Is Null."); } return sqlSessionTemplate.selectOne(statement, parameter); } public <T> List<T> findListByCustom(String statement, Object parameter) { if (null == parameter || null == statement) { throw new IllegalArgumentException(" Parameter Is Null."); } return sqlSessionTemplate.selectList(statement, parameter); } @SuppressWarnings("unchecked") public Map<String,Object> findPageByCustom(String statement, Object parameter) { if (null == parameter || null == statement) { throw new IllegalArgumentException(" Parameter Is Null."); } HashMap<String,Object> retMap = new HashMap<String,Object>(); //是否为分页查询 JSONObject jsonObject = JSONObject.fromObject(parameter); if (!(jsonObject.containsKey("pageNO") && null != jsonObject.get("pageNO") && jsonObject.containsKey("records") && null != jsonObject.get("records"))) { throw new BusinessException(CodeConstant.PARAMS_ERROR); } Integer pageNO = (Integer) jsonObject.get("pageNO") ; Integer records = (Integer) jsonObject.get("records"); if(pageNO!=null && pageNO>0 && records!=null && records>0){ retMap.put("recordsTotal", this.getTotalCount(statement, parameter)); retMap.put("data",sqlSessionTemplate.selectList(statement, parameter)); return retMap; } retMap.put("data",sqlSessionTemplate.selectList(statement, parameter)); return retMap; } /** * get total count * * @param sqlSession * @param statementName * @param values * @return */ private Integer getTotalCount(String statementName, Object values) { Map parameterMap = toParameterMap(values); Integer count = 0; try { MappedStatement mst = sqlSessionTemplate.getSqlSessionFactory() .getConfiguration().getMappedStatement(statementName); BoundSql boundSql = mst.getBoundSql(parameterMap); String sql = " select count(*) total_count from (" + boundSql.getSql() + ") as total"; Connection con = SqlSessionUtils .getSqlSession(sqlSessionTemplate.getSqlSessionFactory(), sqlSessionTemplate.getExecutorType(),sqlSessionTemplate.getPersistenceExceptionTranslator()) .getConnection(); PreparedStatement pstmt = con.prepareStatement(sql); // BoundSql countBS = new // BoundSql(mst.getConfiguration(),sql,boundSql.getParameterMappings(),parameterMap); setParameters(pstmt, mst, boundSql, parameterMap); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { count = rs.getInt("total_count"); } rs.close(); con.close(); pstmt.close(); } catch (Exception e) { count = 0; e.printStackTrace(); throw new RuntimeException(e); } return count; } /** * 对SQL参数(?)设值,参考org.apache.ibatis.executor.parameter. * DefaultParameterHandler * * @param ps * @param mappedStatement * @param boundSql * @param parameterObject * @throws SQLException */ private void setParameters(PreparedStatement ps, MappedStatement mappedStatement, BoundSql boundSql, Object parameterObject) throws SQLException { ErrorContext.instance().activity("setting parameters") .object(mappedStatement.getParameterMap().getId()); List<ParameterMapping> parameterMappings = boundSql .getParameterMappings(); if (parameterMappings != null) { Configuration configuration = mappedStatement.getConfiguration(); TypeHandlerRegistry typeHandlerRegistry = configuration .getTypeHandlerRegistry(); MetaObject metaObject = parameterObject == null ? null : configuration.newMetaObject(parameterObject); for (int i = 0; i < parameterMappings.size(); i++) { ParameterMapping parameterMapping = parameterMappings.get(i); if (parameterMapping.getMode() != ParameterMode.OUT) { Object value; String propertyName = parameterMapping.getProperty(); PropertyTokenizer prop = new PropertyTokenizer(propertyName); if (parameterObject == null) { value = null; } else if (typeHandlerRegistry .hasTypeHandler(parameterObject.getClass())) { value = parameterObject; } else if (boundSql.hasAdditionalParameter(propertyName)) { value = boundSql.getAdditionalParameter(propertyName); } else if (propertyName .startsWith(ForEachSqlNode.ITEM_PREFIX) && boundSql.hasAdditionalParameter(prop.getName())) { value = boundSql.getAdditionalParameter(prop.getName()); if (value != null) { value = configuration.newMetaObject(value) .getValue( propertyName.substring(prop .getName().length())); } } else { value = metaObject == null ? null : metaObject .getValue(propertyName); } TypeHandler typeHandler = parameterMapping.getTypeHandler(); if (typeHandler == null) { throw new ExecutorException( "There was no TypeHandler found for parameter " + propertyName + " of statement " + mappedStatement.getId()); } typeHandler.setParameter(ps, i + 1, value, parameterMapping.getJdbcType()); } } } } protected Map toParameterMap(Object parameter) { if (parameter == null) { return new HashMap(); } if (parameter instanceof Map) { return (Map<?, ?>) parameter; } else { try { return PropertyUtils.describe(parameter); } catch (Exception e) { e.printStackTrace(); return null; } } } }
9.8.3、分页拦截器
package com.hbst.basessm_1.dao.plugin;
import java.sql.Connection;
import java.sql.Statement;
import java.util.Properties;
import org.apache.ibatis.executor.resultset.ResultSetHandler;
import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.plugin.Intercepts;
import org.apache.ibatis.plugin.Invocation;
import org.apache.ibatis.plugin.Plugin;
import org.apache.ibatis.plugin.Signature;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.reflection.SystemMetaObject;
import org.apache.ibatis.scripting.defaults.DefaultParameterHandler;
import net.sf.json.JSONObject;
/**
* @author tangguilin
* 分页拦截器
*/
@Intercepts({
@Signature(type = StatementHandler.class, method = "prepare", args = {Connection.class}),
@Signature(type = ResultSetHandler.class, method = "handleResultSets", args = {Statement.class})
})
public class PageInterceptor implements Interceptor {
public Object intercept(Invocation invocation) throws Throwable {
if (invocation.getTarget() instanceof StatementHandler) {
StatementHandler statementHandler = (StatementHandler) invocation.getTarget();
MetaObject metaStatementHandler = SystemMetaObject.forObject(statementHandler);
//获取参数对象
DefaultParameterHandler parameterHander=(DefaultParameterHandler) metaStatementHandler.getValue("delegate.parameterHandler");
Object parameterObject = parameterHander.getParameterObject();
JSONObject jsonParameter = JSONObject.fromObject(parameterObject);
//是否分页
if(jsonParameter!=null && jsonParameter.has("pageNO")){
Integer pageNO = jsonParameter.getInt("pageNO");
Integer records = jsonParameter.getInt("records");
BoundSql boundSql = (BoundSql) metaStatementHandler.getValue("delegate.boundSql");
String sql = boundSql.getSql();
StringBuffer sb=new StringBuffer();
sb.append(sql);
sb.append(" limit ").append((pageNO-1)*records).append(" , ").append(records);
metaStatementHandler.setValue("delegate.boundSql.sql", sb.toString());
}
}
return invocation.proceed();
}
/**
* 拦截类型StatementHandler
*/
public Object plugin(Object target) {
if (target instanceof StatementHandler) {
return Plugin.wrap(target, this);
} else {
return target;
}
}
public void setProperties(Properties properties) {
}
}
9.8.4、返回码文件
package com.hbst.basessm_1.util.constant;
/**
* 返回码
*
* @author lanshiyan description: code码为6位 每两位为一个级别分别代表不同的意思 前两位：级别 00 系统级别 01
*/
public interface CodeConstant {
/****************************************************************************/
/************************ BEGIN 00系统级别公共错误码 *************************/
/****************************************************************************/
/**
* 成功
*/
public static final String SUCCESS = "000000";
/**
* 参数验证错误码
*/
public static final String PARAMS_ERROR = "000001";
public static final String PARAMS_ERROR_DESCRIPTION = "Invalid method required parameter";
/**
* 系统异常错误码
*/
public static final String SYSTEM_ERROR = "000002";
public static final String SYSTEM_ERROR_DESCRIPTION = "Unknow system exception";
/****************************************************************************/
/************************ BEGIN 01业务级别登录错误码 **************************/
/****************************************************************************/
// ===========================================================================
// BEGIN 00公共错误码
// ===========================================================================
/**
* 用户名密码错误
*/
public static final String USERNAME_PWD_ERROR = "010001";
/**
* 参数为空
*/
public static final String PARARM_IS_EMPTY = "010002";
/**
* 不存在此用户
*/
public static final String SYSTEM_USER_NOT_EXISTS = "010003";
public static final String SYSTEM_USER_NOT_EXISTS_DESCRIPTION = "User not exists or bad user ID";
/**
* 密码复杂度不符合要求
*/
public static final String SYSTEM_BAD_PASSWORD_COMPLEXITY = "010004";
public static final String SYSTEM_BAD_PASSWORD_COMPLEXITY_DESCRIPTION = "Invalid password of complexity";
/**
* 旧密码错误
*/
public static final String SYSTEM_BAD_OLD_PASSWORD = "010005";
public static final String SYSTEM_BAD_OLD_PASSWORD_DESCRIPTION = "Invalid old password";
｝
9.8.5、返回实体文件
package com.hbst.basessm_1.util.entity;
import java.io.Serializable;
/**
* 返回消息实体对象定义
*
* @author Dean 20160912
*/
public class ResultMessage implements Serializable {
private static final long serialVersionUID = 1L;
// 成功或失败的错误码，成功时返回000000
private String code;
// 失败时返回的错误消息
private String codeDesc;
// 当需要返回值时返回值对象，如果是查询列表，则返回queryList对象
private Object data;
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getCodeDesc() {
return codeDesc;
}
public void setCodeDesc(String codeDesc) {
this.codeDesc = codeDesc;
}
public Object getData() {
return data;
}
public void setData(Object data) {
this.data = data;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
@Override
public String toString() {
return "ResultMessage [code=" + code + ", codeDes=" + codeDesc + ", data=" + data + "]";
}
}
9.8.6、系统自定义异常类
package com.hbst.basessm_1.util.exception;
import com.hbst.basessm_1.util.baseUtil.ResourceUtils;
import com.hbst.basessm_1.util.constant.CodeConstant;
/**
* 系统自定义异常类。
*
*
*
*/
public class BusinessException extends RuntimeException {
private static final long serialVersionUID = 1L;
/**
* 错误码。
*/
private String errorCode;
/**
* 问题
*/
private String errorDes;
/**
* 指定错误码与错误描述的异常。
*
* @param errorCode
* 错误码
* @param msg
* 异常信息
*/
public BusinessException(String errorCode, String msg) {
super(msg);
this.errorCode = errorCode;
this.errorDes = msg;
}
/**
* 指定错误码与错误描述的异常。
*
* @param errorCode
* 错误码
* @param msg
* 异常信息
*/
public BusinessException(String errorCode) {
super(ResourceUtils.getResultCodeDesc(errorCode));
this.errorCode = errorCode;
this.errorDes = (ResourceUtils.getResultCodeDesc(errorCode));
}
/**
* 未定义异常。
*/
public BusinessException() {
super(ResourceUtils.getResultCodeDesc(CodeConstant.SYSTEM_ERROR));
this.errorCode = CodeConstant.SYSTEM_ERROR;
}
public String getErrorDes() {
return errorDes;
}
public void setErrorDes(String errorDes) {
this.errorDes = errorDes;
}
public String getErrorCode() {
return errorCode;
}
public void setErrorCode(String errorCode) {
this.errorCode = errorCode;
}
}
9.9、现在创建controller
9.10、在index.jsp中加入jquery.js,用jq的ajax方法去请求后台
9.11、刷新页面，点击按钮，会出现数据库里面插入的值。
10、到这里 ssm基础框架的整合，已经前后台交互就算完成。
