一个基本的spring+mybatis所需要的包
spring+mybatis需要的包:
org.springframework.spring-webmvc(spring框架DispatcherServlet需要,spring-webmvc会依赖spring-context,spring-context依赖其它主要spring包)
org.springframework.spring-jdbc(jdbc需要,依赖spring-tx)
org.mybatis.mybatis(mybatis-spring需要)
org.mybatis.mybatis-spring(SqlSessionFactory创建需要,mybatis需要)
mysql.mysql-connector-java(mysql数据库驱动需要)
其它包:
javax.servlet.javax.servlet-api(HttpServletRequest,HttpServletResponse需要)
org.apache.httpcomponents.httpclient(调用其它工程的接口时需要)
log4j.log4j(mybatis需要)
junit.junit(test需要)
druid连接池:需要的包:
com.alibaba.druid(创建数据源需要,druid数据库连接池需要)
可展示Druid的统计信息
c3p0连接池:需要的包
c3p0.c3p0
DBCP连接池:需要的包
commons-dbcp.commons-dbcp
JNDI连接池:需要的包
spring-context
log4j:需要的包
log4j.log4j(mybatis需要)
logback:需要的包
ch.qos.logback.logback-classic(依赖logback-core)
pom.xml
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.jmu.ccjoin</groupId> 5 <artifactId>Spring-mybatis</artifactId> 6 <packaging>war</packaging> 7 <version>0.0.1-SNAPSHOT</version> 8 <name>Spring-mybatis</name> 9 <url>http://maven.apache.org</url> 10 11 <properties> 12 <spring.version>4.3.0.RELEASE</spring.version> 13 </properties> 14 <dependencies> 15 <!-- servlet --> 16 <dependency> 17 <groupId>javax.servlet</groupId> 18 <artifactId>javax.servlet-api</artifactId> 19 <version>4.0.1</version> 20 <scope>provided</scope> 21 </dependency> 22 23 <!-- spring-webmvc 依赖了这个包,会自动依赖其它的spring包 --> 24 <dependency> 25 <groupId>org.springframework</groupId> 26 <artifactId>spring-webmvc</artifactId> 27 <version>${spring.version}</version> 28 </dependency> 29 30 <dependency> 31 <groupId>org.springframework</groupId> 32 <artifactId>spring-jdbc</artifactId> 33 <version>${spring.version}</version> 34 </dependency> 35 36 <!-- Mybatis --> 37 <dependency> 38 <groupId>org.mybatis</groupId> 39 <artifactId>mybatis</artifactId> 40 <version>3.2.0</version> 41 </dependency> 42 43 <!-- Mybatis+Spring整合 --> 44 <dependency> 45 <groupId>org.mybatis</groupId> 46 <artifactId>mybatis-spring</artifactId> 47 <version>1.2.0</version> 48 </dependency> 49 50 <!-- mysql数据库驱动 --> 51 <dependency> 52 <groupId>mysql</groupId> 53 <artifactId>mysql-connector-java</artifactId> 54 <version>5.1.40</version> 55 </dependency> 56 57 <!-- druid数据源 --> 58 <dependency> 59 <groupId>com.alibaba</groupId> 60 <artifactId>druid</artifactId> 61 <version>1.0.13</version> 62 </dependency> 63 64 <!-- c3p0数据源 --> 65 <dependency> 66 <groupId>c3p0</groupId> 67 <artifactId>c3p0</artifactId> 68 <version>0.9.1.2</version> 69 </dependency> 70 71 <!-- DBCP --> 72 <dependency> 73 <groupId>commons-dbcp</groupId> 74 <artifactId>commons-dbcp</artifactId> 75 <version>1.4</version> 76 </dependency> 77 78 <!-- log4j --> 79 <dependency> 80 <groupId>log4j</groupId> 81 <artifactId>log4j</artifactId> 82 <version>1.2.17</version> 83 </dependency> 84 85 <!-- logback --> 86 <dependency> 87 <groupId>ch.qos.logback</groupId> 88 <artifactId>logback-classic</artifactId> 89 <version>1.0.6</version> 90 </dependency> 91 92 <!-- 测试 --> 93 <dependency> 94 <groupId>junit</groupId> 95 <artifactId>junit</artifactId> 96 <version>3.8.1</version> 97 <scope>test</scope> 98 </dependency> 99 100 <!-- 支持CGLIB代理 --> 101 <dependency> 102 <groupId>cglib</groupId> 103 <artifactId>cglib</artifactId> 104 <version>3.1</version> 105 </dependency> 106 107 <!-- httpClient --> 108 <dependency> 109 <groupId>org.apache.httpcomponents</groupId> 110 <artifactId>httpclient</artifactId> 111 <version>4.3.5</version> 112 <scope>compile</scope> 113 </dependency> 114 </dependencies> 115 <build> 116 <finalName>Spring-mybatis</finalName> 117 </build> 118 </project>
web.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 3 xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee" 4 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" 5 version="2.5"> 6 <display-name>spring-mybatis</display-name> 7 <context-param> 8 <param-name>contextConfigLocation</param-name> 9 <param-value>classpath:applicationContext.xml</param-value> 10 </context-param> 11 <context-param> 12 <param-name>log4jConfigLocation</param-name> 13 <param-value>classpath:logback.xml</param-value> 14 </context-param> 15 <listener> 16 <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> 17 </listener> 18 19 <!-- <listener> 20 <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class> 21 </listener> --> 22 23 <servlet> 24 <servlet-name>servlet</servlet-name> 25 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> 26 <init-param> 27 <param-name>contextConfigLocation</param-name> 28 <param-value>classpath:servlet.xml</param-value> 29 </init-param> 30 </servlet> 31 <servlet-mapping> 32 <servlet-name>servlet</servlet-name> 33 <url-pattern>*.action</url-pattern> 34 </servlet-mapping> 35 36 </web-app>
applicationContext.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" 4 xsi:schemaLocation="http://www.springframework.org/schema/beans 5 http://www.springframework.org/schema/beans/spring-beans.xsd 6 http://www.springframework.org/schema/context 7 http://www.springframework.org/schema/context/spring-context.xsd"> 8 9 <!-- 加载配置文件 --> 10 <context:property-placeholder 11 ignore-resource-not-found="true" ignore-unresolvable="true" 12 location="file:/var/opt/spring-mybatis/config.properties" /> 13 <context:component-scan 14 base-package="com.jmu.ccjoin.entity,com.jmu.ccjoin.service,com.jmu.ccjoin.core,com.jmu.ccjoin.controller" /> 15 16 <context:annotation-config /> 17 <import resource="classpath:applicationContext_datasource.xml"/> 18 </beans>
applicationContext_datasource.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <beans xmlns="http://www.springframework.org/schema/beans" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" 4 xsi:schemaLocation="http://www.springframework.org/schema/beans 5 http://www.springframework.org/schema/beans/spring-beans.xsd 6 http://www.springframework.org/schema/context 7 http://www.springframework.org/schema/context/spring-context.xsd"> 8 9 <!-- 自带的jndi连接池/这里使用了tomcat下的数据源 --> 10 <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> 11 <property name="jndiName" value="java:comp/env/ccjoinDataSource" /> 12 </bean> 13 14 <!-- 配置Druid数据源 --> 15 <!-- <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" 16 init-method="init" destroy-method="close"> <property name="driverClassName" 17 value="${jdbc.driverClassName}" /> <property name="url" value="${jdbc.url}" 18 /> <property name="username" value="${jdbc.username}" /> <property name="password" 19 value="${jdbc.password}" /> <property name="maxActive" value="${jdbc.maxPoolSize}" 20 /> <property name="initialSize" value="${jdbc.initialPoolSize}" /> <property 21 name="maxWait" value="${jdbc.maxIdleTime}" /> <property name="filters" value="stat,log4j" 22 /> </bean> --> 23 24 <!-- c3p0连接池 --> 25 <!-- <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" 26 destroy-method="close"> <property name="driverClass" value="${jdbc.driverClassName}"></property> 27 <property name="jdbcUrl" value="${jdbc.url}"></property> <property name="user" 28 value="${jdbc.username}"></property> <property name="password" value="${jdbc.password}"></property> 29 <property name="minPoolSize" value="${jdbc.minPoolSize}" /> <property name="maxPoolSize" 30 value="${jdbc.maxPoolSize}" /> <property name="initialPoolSize" value="${jdbc.initialPoolSize}" 31 /> <property name="maxIdleTime" value="${jdbc.maxIdleTime}" /> </bean> --> 32 33 <!-- DBCP连接池 --> 34 <!-- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" 35 destroy-method="close"> <property name="driverClassName" value="${jdbc.driverClassName}" 36 /> <property name="url" value="${jdbc.url}" /> <property name="username" 37 value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" 38 /> <property name="initialSize" value="${jdbc.initialPoolSize}" /> <property 39 name="maxIdle" value="${jdbc.maxPoolSize}" /> <property name="minIdle" value="${jdbc.minPoolSize}" 40 /> <property name="maxActive" value="${jdbc.maxIdleTime}" /> </bean> --> 41 42 <!-- MyBatis SqlSessionFactoryBean 配置 --> 43 <!-- <bean id="sqlSessionFactory" class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean"> 44 <property name="dataSource" ref="dataSource" /> <property name="configLocation" 45 value="classpath:mybatis/mybatis-config.xml" /> <property name="typeAliasesPackage" 46 value="com.jmu.ccjoin.entity" /> <property name="mapperLocations" value="classpath:mybatis/mapper/*Mapper.xml" 47 /> </bean> --> 48 49 <!-- <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 50 <property name="dataSource"> <ref bean="dataSource" /> </property> <property 51 name="configLocation" value="classpath:mybatis/mybatis-config.xml"></property> 52 <property name="typeAliasesPackage" value="com.jmu.ccjoin.entity" /> <property 53 name="mapperLocations" value="classpath:mybatis/mapper/*Mapper.xml" /> </bean> --> 54 <!-- mybatis文件 --> 55 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 56 <property name="dataSource" ref="dataSource"></property> 57 <!-- <property name="configLocation" value="classpath:mybatis/mybatis-config.xml"></property> --> 58 <!-- 批量定义别名 ,指定包名,自动扫描包中的类,别名即为类名,首字母大小写无所谓 --> 59 <!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 --> 60 <property name="typeAliasesPackage" value="com.jmu.ccjoin.entity"></property> 61 <property name="mapperLocations" value="classpath:mybatis/mapper/*Mapper.xml"></property> 62 </bean> 63 64 <!-- 配置事务 --> 65 <bean id="transactionManager" 66 class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 67 <property name="dataSource" ref="dataSource" /> 68 </bean> 69 70 71 <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 72 <property name="basePackage" value="com.jmu.ccjoin.dao"></property> 73 <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property> 74 </bean> 75 </beans>
file:/var/opt/spring-mybatis/config.properties
1 jdbc.driverClassName=com.mysql.jdbc.Driver 2 jdbc.url=jdbc:mysql://172.16.1.23:3306/jmuv3?useUnicode=true&characterEncoding=utf8 3 jdbc.username=root 4 jdbc.password=123.com 5 jdbc.minPoolSize=5 6 jdbc.maxPoolSize=30 7 jdbc.initialPoolSize=10 8 jdbc.maxIdleTime=1800
servlet.xml
1 <?xml version="1.0" encoding="UTF-8"?> 2 <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" 3 xmlns:mvc="http://www.springframework.org/schema/mvc" 4 xsi:schemaLocation=" 5 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd 6 http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd 7 http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd"> 8 9 <context:component-scan 10 base-package="com.jmu.ccjoin.controller" /> 11 12 <!-- 避免IE执行AJAX时,返回JSON出现下载文件 --> 13 <!-- <bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter" /> --> 14 15 <!-- <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> 16 <property name="messageConverters"> 17 <list> 18 <ref bean="mappingJacksonHttpMessageConverter" />json转换器 19 </list> 20 </property> 21 </bean> --> 22 23 <!-- <bean id="velocityConfigurer" class="org.springframework.web.servlet.view.velocity.VelocityConfigurer"> 24 <property name="resourceLoaderPath"> 25 <value>/WEB-INF/view</value> 26 </property> 27 <property name="velocityProperties"> 28 <props> 29 <prop key="input.encoding">UTF-8</prop> 30 <prop key="output.encoding">UTF-8</prop> 31 <prop key="velocimacro.library">control/macros.vm</prop> 32 </props> 33 </property> 34 </bean> --> 35 36 <!-- 拦截器 --> 37 <mvc:interceptors> 38 <bean class="com.jmu.ccjoin.interceptor.LogInterceptor" /> 39 </mvc:interceptors> 40 </beans>
logback.xml
1 <?xml version="1.0" encoding="UTF-8" ?> 2 3 <!-- 级别从高到低 OFF 、 FATAL 、 ERROR 、 WARN 、 INFO 、 DEBUG 、 TRACE 、 ALL --> 4 <!-- 日志输出规则 根据当前ROOT 级别,日志输出时,级别高于root默认的级别时 会输出 --> 5 <!-- 以下 每个配置的 filter 是过滤掉输出文件里面,会出现高级别文件,依然出现低级别的日志信息,通过filter 过滤只记录本级别的日志 --> 6 <!-- scan 当此属性设置为true时,配置文件如果发生改变,将会被重新加载,默认值为true。 --> 7 <!-- scanPeriod 设置监测配置文件是否有修改的时间间隔,如果没有给出时间单位,默认单位是毫秒。当scan为true时,此属性生效。默认的时间间隔为1分钟。 --> 8 <!-- debug 当此属性设置为true时,将打印出logback内部日志信息,实时查看logback运行状态。默认值为false。 --> 9 <configuration scan="true" scanPeriod="60 seconds" debug="false"> 10 11 <!-- 动态日志级别 --> 12 <jmxConfigurator/> 13 14 <!-- 定义日志文件 输出位置 --> 15 <!-- <property name="log_dir" value="logs"/> --> 16 17 <!-- 日志最大的历史 30天 --> 18 <!-- <property name="maxHistory" value="30"/> --> 19 20 <!-- ConsoleAppender 控制台输出日志 --> 21 <appender name="console" class="ch.qos.logback.core.ConsoleAppender"> 22 <encoder> 23 <pattern> 24 <!-- 设置日志输出格式 --> 25 %d{yyyy-MM-dd HH:mm:ss.SSS} [%-5level] %logger - %msg%n 26 </pattern> 27 </encoder> 28 </appender> 29 30 <!-- ERROR级别日志 --> 31 <!-- 滚动记录文件,先将日志记录到指定文件,当符合某个条件时,将日志记录到其他文件 RollingFileAppender --> 32 <appender name="ERROR" class="ch.qos.logback.core.rolling.RollingFileAppender"> 33 <!-- 过滤器,只记录WARN级别的日志 --> 34 <!-- 果日志级别等于配置级别,过滤器会根据onMath 和 onMismatch接收或拒绝日志。 --> 35 <filter class="ch.qos.logback.classic.filter.LevelFilter"> 36 <!-- 设置过滤级别 --> 37 <level>ERROR</level> 38 <!-- 用于配置符合过滤条件的操作 --> 39 <onMatch>ACCEPT</onMatch> 40 <!-- 用于配置不符合过滤条件的操作 --> 41 <onMismatch>DENY</onMismatch> 42 </filter> 43 <!-- 最常用的滚动策略,它根据时间来制定滚动策略.既负责滚动也负责出发滚动 --> 44 <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> 45 <!--日志输出位置 可相对、和绝对路径 --> 46 <fileNamePattern> 47 ${log.home_url}/error/%d{yyyy-MM-dd}/shop-admin.log 48 </fileNamePattern> 49 <!-- 可选节点,控制保留的归档文件的最大数量,超出数量就删除旧文件假设设置每个月滚动,且<maxHistory>是6, 则只保存最近6个月的文件,删除之前的旧文件。注意,删除旧文件是,那些为了归档而创建的目录也会被删除 --> 50 <maxHistory>${log.maxHistory}</maxHistory> 51 </rollingPolicy> 52 <encoder> 53 <pattern> 54 <!-- 设置日志输出格式 --> 55 %d{yyyy-MM-dd HH:mm:ss.SSS} [%-5level] %logger - %msg%n 56 </pattern> 57 </encoder> 58 </appender> 59 60 61 <!-- WARN级别日志 appender --> 62 <appender name="WARN" class="ch.qos.logback.core.rolling.RollingFileAppender"> 63 <!-- 过滤器,只记录WARN级别的日志 --> 64 <!-- 果日志级别等于配置级别,过滤器会根据onMath 和 onMismatch接收或拒绝日志。 --> 65 <filter class="ch.qos.logback.classic.filter.LevelFilter"> 66 <!-- 设置过滤级别 --> 67 <level>WARN</level> 68 <!-- 用于配置符合过滤条件的操作 --> 69 <onMatch>ACCEPT</onMatch> 70 <!-- 用于配置不符合过滤条件的操作 --> 71 <onMismatch>DENY</onMismatch> 72 </filter> 73 <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> 74 <!--日志输出位置 可相对、和绝对路径 --> 75 <fileNamePattern>${log.home_url}/warn/%d{yyyy-MM-dd}/shop-admin.log</fileNamePattern> 76 <maxHistory>${log.maxHistory}</maxHistory> 77 </rollingPolicy> 78 <encoder> 79 <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%-5level] %logger - %msg%n</pattern> 80 </encoder> 81 </appender> 82 83 84 <!-- INFO级别日志 appender --> 85 <appender name="INFO" class="ch.qos.logback.core.rolling.RollingFileAppender"> 86 <filter class="ch.qos.logback.classic.filter.LevelFilter"> 87 <level>INFO</level> 88 <onMatch>ACCEPT</onMatch> 89 <onMismatch>DENY</onMismatch> 90 </filter> 91 <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> 92 <fileNamePattern>${log.home_url}/info/%d{yyyy-MM-dd}/shop-admin.log</fileNamePattern> 93 <maxHistory>${log.maxHistory}</maxHistory> 94 </rollingPolicy> 95 <encoder> 96 <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%-5level] %logger - %msg%n</pattern> 97 </encoder> 98 </appender> 99 100 101 <!-- DEBUG级别日志 appender --> 102 <appender name="DEBUG" class="ch.qos.logback.core.rolling.RollingFileAppender"> 103 <filter class="ch.qos.logback.classic.filter.LevelFilter"> 104 <level>DEBUG</level> 105 <onMatch>ACCEPT</onMatch> 106 <onMismatch>DENY</onMismatch> 107 </filter> 108 <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> 109 <fileNamePattern>${log.home_url}/debug/%d{yyyy-MM-dd}/shop-admin.log</fileNamePattern> 110 <maxHistory>${log.maxHistory}</maxHistory> 111 </rollingPolicy> 112 <encoder> 113 <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%-5level] %logger - %msg%n</pattern> 114 </encoder> 115 </appender> 116 117 118 <!-- TRACE级别日志 appender --> 119 <appender name="TRACE" class="ch.qos.logback.core.rolling.RollingFileAppender"> 120 <filter class="ch.qos.logback.classic.filter.LevelFilter"> 121 <level>TRACE</level> 122 <onMatch>ACCEPT</onMatch> 123 <onMismatch>DENY</onMismatch> 124 </filter> 125 <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> 126 <fileNamePattern>${log.home_url}/trace/%d{yyyy-MM-dd}/shop-admin.log</fileNamePattern> 127 <maxHistory>${log.maxHistory}</maxHistory> 128 </rollingPolicy> 129 <encoder> 130 <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%-5level] %logger - %msg%n</pattern> 131 </encoder> 132 </appender> 133 134 135 <!-- root级别 DEBUG --> 136 <root> 137 <!-- 打印debug级别日志及以上级别日志 --> 138 <level value="debug"/> 139 <!-- 控制台输出 --> 140 <appender-ref ref="console"/> 141 <!-- 文件输出 --> 142 <appender-ref ref="ERROR"/> 143 <appender-ref ref="INFO"/> 144 <appender-ref ref="WARN"/> 145 <appender-ref ref="DEBUG"/> 146 <appender-ref ref="TRACE"/> 147 </root> 148 </configuration>