SSM模板

jdbc.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/mybatis
name=root
password=root

log4j.properties

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=debug, stdout

mybatis-config.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>

	<!-- 行为参数 -->
	<settings>
		<!-- 开启驼峰匹配 , 如果不开启的话, 就需要在select sql 语句添加对应属性名的别名 -->
		<setting name="mapUnderscoreToCamelCase" value="true" />
		<!-- 关闭二级缓存 -->
		<setting name="cacheEnabled" value="false" />
		<!-- 懒加载开关, 默认为关 -->
		<setting name="lazyLoadingEnabled" value="true" />
		<!-- true表示调用对象中的属性, 就会进行懒加载 -->
		<setting name="aggressiveLazyLoading" value="false" />
	</settings>

	<plugins>
	
		<!-- 通用mapper插件 -->
		<plugin interceptor="com.github.abel533.mapperhelper.MapperInterceptor">
			<!--================================================ -->
			<!--可配置参数说明(一般无需修改) -->
			<!--================================================ -->
			<!--UUID生成策略 -->
			<!--配置UUID生成策略需要使用OGNL表达式 -->
			<!--默认值32位长度:@java.util.UUID@randomUUID().toString().replace("-", "") -->
			<!--<property name="UUID" value="@java.util.UUID@randomUUID().toString()"/> -->
			<!--主键自增回写方法,默认值MYSQL,详细说明请看文档 -->
			<property name="IDENTITY" value="MYSQL" />
			<!--序列的获取规则,使用{num}格式化参数，默认值为{0}.nextval，针对Oracle -->
			<!--可选参数一共3个，对应0,1,2,分别为SequenceName，ColumnName,PropertyName -->
			<property name="seqFormat" value="{0}.nextval" />
			<!--主键自增回写方法执行顺序,默认AFTER,可选值为(BEFORE|AFTER) -->
			<!--<property name="ORDER" value="AFTER"/> -->
			<!--通用Mapper接口，多个通用接口用逗号隔开 -->
			<property name="mappers" value="com.github.abel533.mapper.Mapper" />
		</plugin>
		
		
		<!-- 分页需要的插件 -->
		<plugin interceptor="com.github.pagehelper.PageHelper">
			<property name="dialect" value="mysql" />
			<!-- 默认为false, 使用rowbounds分页会进行count查询 -->
			<property name="rowBoundsWithCount" value="true" />
		</plugin>
	</plugins>
</configuration>

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" version="2.5">
  <display-name>usermanage</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>
  <!-- spring配置 -->
  <listener>
  	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  
 <!--  编码过滤器, 对post请求以UTF-8编码 -->
 <filter>
 	<filter-name>encodingFilter</filter-name>
 	<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
	<init-param>
		<param-name>encoding</param-name>
		<param-value>UTF8</param-value>
	</init-param>
 </filter>
 <filter-mapping>
 	<filter-name>encodingFilter</filter-name>
 	<url-pattern>/*</url-pattern>
 </filter-mapping>
  
 <!--  配置springMVC -->
  <servlet>
  	<servlet-name>usermanage</servlet-name>
  	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  	<!-- 初始化参数, 指定springMVC的配置文件路径 -->
  	<init-param>
  		<param-name>contextConfigLocation</param-name>
  		<param-value>classpath:spring/usermanage-servlet.xml</param-value>
  	</init-param>
  	<load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
  	<servlet-name>usermanage</servlet-name>
  	<!-- /是指所有的请求都会进入springmvc框架 -->
  	<url-pattern>/</url-pattern>
  </servlet-mapping>
  
</web-app>

spring/applicationContext.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:p="http://www.springframework.org/schema/p"
	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/context http://www.springframework.org/schema/context/spring-context-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
	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">

	<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>classpath:jdbc.properties</value>
			</list>
		</property>
	</bean>
	<context:component-scan base-package="cn.itcast.usermanage.service.impl"/>
	
	
	<!-- 配置连接池 -->
	<!-- 使用Druid连接池 -->
	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
		init-method="init" destroy-method="close">
		<!-- 基本属性 url、user、password -->
		<property name="url" value="${url}" />
		<property name="username" value="${name}" />
		<property name="password" value="${password}" />
		<property name="connectionProperties" value="${driver}" />
	</bean>
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  		<property name="dataSource" ref="dataSource" />
  		<!-- 加载mybatis-config.xml -->
  		<property name="configLocation" value="classpath:mybatis-config.xml"/>
  		<!-- 指定目录下扫描mapper -->
  		<property name="mapperLocations" value="classpath:mapper/*.xml"/>
  		<!-- 开启别名扫描 -->
  		<property name="typeAliasesPackage" value="cn.itcast.usermanage.pojo"/>
  		
	</bean>
	
	<!-- 使用Scanner扫描指定包, 这样就不需要配置所有的Mapper bean了 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	  <property name="basePackage" value="cn.itcast.usermanage.mapper" />
	</bean>
	
</beans>

spring/applicationContext-tx.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:p="http://www.springframework.org/schema/p"
	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/context http://www.springframework.org/schema/context/spring-context-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
	http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-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>
			<!--所有以query开头的方法都是只读的 -->
			<tx:method name="query*" read-only="true" />
			<!--其他方法使用默认事务策略 -->
			<tx:method name="*" />
		</tx:attributes>
	</tx:advice>

	<aop:config>
		<!--pointcut元素定义一个切入点，execution中的第一个星号 用以匹配方法的返回类型，
			这里星号表明匹配所有返回类型。 com.abc.dao.*.*(..)表明匹配cn.itcast.mybatis.service包下的所有类的所有 
			方法 -->
		<aop:pointcut id="myPointcut" expression="execution(* cn.itcast.mybatis.service.*.*(..))" />
		<!--将定义好的事务处理策略应用到上述的切入点 -->
		<aop:advisor advice-ref="txAdvice" pointcut-ref="myPointcut" />
	</aop:config>
	
</beans>

spring/usermanage-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.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">
	
	
	<!-- 配置注解驱动, 这样就不需要配置handlerMapping 和 handlerAdaptor了-->
	<mvc:annotation-driven />
	
	<!-- 处理静态资源被"/"所拦截的问题 -->
	<mvc:default-servlet-handler/>
	
	<!-- 开启包扫描 -->
	<context:component-scan base-package="cn.itcast.usermanage.controller"></context:component-scan>
	
	<!-- 定义Excel视图对象, 并指定视图名称 -->
	<bean name="excelView" class="cn.itcast.usermanage.pojo.UserExcelView"></bean>
	
	<!-- 定义视图解析器, 通过bean的名称查找视图对象 -->
	<bean class="org.springframework.web.servlet.view.BeanNameViewResolver">
		<!-- 设置视图解析器的顺序 -->
		<property name="order" value="1"/>
	</bean>
	
	
	<!-- 配置试图解析器 -->
	<!-- prefix="/WEB-INF/jsp/", suffix=".jsp", viewname="test" -> "/WEB-INF/jsp/test.jsp"  -->
	<!-- prefix+viewName+suffix -->
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/view/"></property>
		<property name="suffix" value=".jsp"></property>
	</bean>
	
</beans>

mapper/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="cn.itcast.usermanage.mapper.UserMapper">
		<!--查询的statement, id随便写, 但是同一个命名空间(namespace) 下必须唯一, resultType:指定返回结果集的包装类型  -->
		<select id="findAll" resultType="User">
			select * from tb_user
		</select>
		
		<insert id="addUser" parameterType="User" useGeneratedKeys="true" keyColumn="id" keyProperty="id">
			INSERT INTO tb_user(
				id,user_name,password,name,age,sex,birthday,created,updated
			)
			VALUES
			(
				null,#{userName},#{password},#{name},#{age},#{sex},#{birthday},now(),now()
			)
		</insert>
		
		<delete id="deleteUsers">
			delete from tb_user where id in
			<foreach collection="ids" item="id" open="(" separator="," close=")">
				#{id}
			</foreach>
		</delete>
		
</mapper>