maven-sprigmvc-mybatis配置
pom.xml配置
<?xml version="1.0"?> <project xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd" xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>com.zx</groupId> <artifactId>qyxx</artifactId> <version>1.0.0-snapshot</version> </parent> <artifactId>qyxx-web</artifactId> <name>qyxx-web</name> <url>http://maven.apache.org</url> <packaging>war</packaging> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties> <dependencies> <dependency> <groupId>com.zx</groupId> <artifactId>qyxx-core</artifactId> <version>${project.version}</version> </dependency> <!-- sitemesh开始 --> <dependency> <groupId>opensymphony</groupId> <artifactId>sitemesh</artifactId> <version>2.4.2</version> </dependency> <!-- sitemesh结束 --> <!-- junit --> <dependency> <groupId>org.hamcrest</groupId> <artifactId>hamcrest-core</artifactId> <version>1.3.RC2</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <!-- QQ快捷登陆jar包 --> <!-- <dependency> <groupId>com.tencent</groupId> <artifactId>qq.connect</artifactId> <version>2.0</version> </dependency> --> </dependencies> <profiles> <!-- 开发环境 --> <profile> <id>local</id> <properties> <env.type>local</env.type> </properties> <activation> <activeByDefault>true</activeByDefault> </activation> </profile> <!-- 测试环境 --> <profile> <id>dev</id> <properties> <env.type>dev</env.type> </properties> </profile> <!-- 生产正式环境 --> <profile> <id>pro</id> <properties> <env.type>pro</env.type> </properties> </profile> </profiles> <build> <finalName>qyxx</finalName> <!-- 使用指定的配置 --> <filters> <filter>src/main/resources/config/${env.type}.properties</filter> </filters> <resources> <resource> <directory>src/main/resources</directory> <excludes> <exclude>config/*.properties</exclude> </excludes> <filtering>true</filtering> </resource> </resources> <plugins> <!-- compiler插件, 设定JDK版本 --> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>3.0</version> <configuration> <source>1.7</source> <target>1.7</target> <encoding>UTF-8</encoding> </configuration> </plugin> <!-- 自动部署 --> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <configuration> <url>http://10.60.10.63/manager/text</url> <username>tomcat</username> <password>zxkj8888</password> <update>true</update> <path>/</path> </configuration> </plugin> </plugins> </build> </project>
applicationContext.xml配置
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:util="http://www.springframework.org/schema/util" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:cache="http://www.springframework.org/schema/cache" xmlns:p="http://www.springframework.org/schema/p" xmlns:task="http://www.springframework.org/schema/task" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.0.xsd" default-lazy-init="true"> <description>Spring公共配置 </description> <util:properties id="common" location="classpath:common.properties" /> <!-- <util:properties id="qqconfig" location="classpath:qqconnectconfig.properties" /> --> <!-- 使用annotation 自动注册bean, 并保证@Required、@Autowired的属性被注入 --> <context:component-scan base-package="com.zx"> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" /> </context:component-scan> <!-- 支持异步方法执行 --> <task:annotation-driven /> <!-- 缓存配置 --> <cache:annotation-driven /> <bean id="cacheManager" class="org.springframework.cache.support.SimpleCacheManager"> <property name="caches"> <set> <bean class="org.springframework.cache.concurrent.ConcurrentMapCacheFactoryBean" p:name="default" /> </set> </property> </bean> <!-- 数据源配置,使用应用内的DBCP数据库连接池 --> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <!-- 数据源驱动类可不写，Druid默认会自动根据URL识别DriverClass --> <property name="driverClassName" value="#{common['jdbc.driver']}" /> <!-- 基本属性 url、user、password --> <property name="url" value="#{common['jdbc.url']}" /> <property name="username" value="#{common['jdbc.username']}" /> <property name="password" value="#{common['jdbc.password']}" /> <!-- 初始化连接数量 --> <property name="initialSize" value="#{common['jdbc.minIdle']}" /> <!-- 最小空闲连接数 --> <property name="minIdle" value="#{common['jdbc.minIdle']}" /> <!-- 最大并发连接数 --> <property name="maxActive" value="#{common['jdbc.maxActive']}" /> <!-- 获取连接等待超时的时间 --> <property name="maxWait" value="60000" /> <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="300000" /> <property name="validationQuery" value="select 'x'" /> <!-- 申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效。 --> <property name="testWhileIdle" value="true" /> <property name="testOnBorrow" value="false" /> <property name="testOnReturn" value="false" /> <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 以下正常要注释掉,排查问题用 --> <!-- 打开removeAbandoned功能 --> <property name="removeAbandoned" value="true" /> <!-- 1800秒，也就是30分钟 --> <property name="removeAbandonedTimeout" value="1800" /> <!-- 关闭abanded连接时输出错误日志 --> <property name="logAbandoned" value="true" /> <!-- 打开PSCache，并且指定每个连接上PSCache的大小（Oracle:true mysql:false） --> <property name="poolPreparedStatements" value="false" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> <!-- 配置监控统计拦截的filters --> <property name="filters" value="stat" /> </bean> <!--事务管理DataSourceTransactionManager --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!-- 使用annotation定义事务 --> <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" /> <!-- Spring iBatis SqlMapClient --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="mapperLocations"> <value>classpath:mapper/**/*Mapper.xml</value> </property> <property name="configLocation" value="classpath:mybatis-config.xml" /> </bean> <!-- 自动扫描mapper配置和dao映射，无需写mybatis-config.xml --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.zx.qyxx.dao" /> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> <!-- <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> --> </bean> <!-- 用于持有ApplicationContext,可以使用SpringContextHolder.getBean('xxxx')的静态方法得到spring bean对象 --> <bean id="springContextHolder" class="com.zx.qyxx.utils.SpringContextHolder" lazy-init="false" /> <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <property name="maxUploadSize" value="104857600" /> <property name="maxInMemorySize" value="4096" /> </bean> </beans>
spring-mvc.xml配置<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:beans="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance xmlns:context="http://www.springframework.org/schema/context" xmlns:util="http://www.springframework.org/schema/util" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <!-- 使用CoC,惯例优先原则(convention over configuration)的方式来配置SpringMVC可以帮我们声明Controller的时候省下很多功夫。 只要我们的Controller是以XXXController的方式命名的话就可以使用到CoC带来的好处。 例如，对于普通的Controller（非MultiActionController），CoC帮我们做以下的映射： HomeController映射到/home*请求URL --> <bean class="org.springframework.web.servlet.mvc.support.ControllerClassNameHandlerMapping" /> <!-- 使用annocation创建Controller的bean --> <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter" /> <!-- 自动扫描 --> <context:component-scan base-package="com.zx"> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service" /> </context:component-scan> <!-- 注解映射的支持 默认 --> <mvc:annotation-driven> <mvc:message-converters register-defaults="true"> <bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter"> <property name="supportedMediaTypes"> <list> <value>text/html;charset=UTF-8</value> <value>application/json;charset=UTF-8</value> </list> </property> </bean> </mvc:message-converters> </mvc:annotation-driven> <!-- 对静态资源文件的访问方案 默认 --> <mvc:default-servlet-handler /> <mvc:interceptors> <mvc:interceptor> <mvc:mapping path="/**" /> <mvc:exclude-mapping path="/login/**" /> <mvc:exclude-mapping path="/isLogin" /> <mvc:exclude-mapping path="/logOut" /> <mvc:exclude-mapping path="/forget" /> <mvc:exclude-mapping path="/verify/**" /> <mvc:exclude-mapping path="/callBack/**" /> <!-- <mvc:exclude-mapping path="/oauth" /> --> <bean class="com.zx.qyxx.intercepter.SignInterceptor" /> </mvc:interceptor> </mvc:interceptors> <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> <!-- one of the properties available; the maximum file size in bytes --> <property name="maxUploadSize" value="10485760" /> <property name="maxInMemorySize" value="4096" /> <property name="resolveLazily" value="true" /> </bean> <!-- 定义首页 --> <mvc:view-controller path="/" view-name="redirect:/index.html" /> <!-- 定义JSP --> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/pages/" /> <property name="suffix" value=".jsp" /> </bean> <!-- end --> <!-- 将Controller抛出的异常转到特定View, 保持SiteMesh的装饰效果 --> <!-- <bean class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver"> <property name="exceptionMappings"> <props> <prop key="java.lang.Throwable">error/500</prop> </props> </property> </bean> --> <!-- 支持跨域 --> <mvc:cors> <mvc:mapping path="/**" allowed-origins="*" allowed-methods="POST, GET, OPTIONS, DELETE, PUT" allowed-headers="Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With" allow-credentials="true" /> </mvc:cors> <!-- 0/86400 * * * * ?定时任务配置 0 0 1 * * ? --> <task:executor id="executor" pool-size="1" /> <task:scheduler id="scheduler" pool-size="1" /> <task:annotation-driven executor="executor" scheduler="scheduler" /> <task:scheduled-tasks> <task:scheduled ref="listenerService" method="logout" cron="0 0 0/2 * * ?" /> <!-- <task:scheduled ref="listenerService" method="buildIp" cron="0 0/5 * * * ?" /> <task:scheduled ref="listenerService" method="getIps" cron="0 0 0/1 * * ?" /> --> </task:scheduled-tasks> </beans>
commen.properties配置
#数据库信息
#jdbc.driver=${jdbc.driver}
jdbc.driver=net.sf.log4jdbc.DriverSpy
jdbc.url=${jdbc.url}
jdbc.username=${jdbc.username}
jdbc.password=${jdbc.password}
jdbc.minIdle=10
jdbc.maxActive=30
#微信开放平台
AppID=${AppID}
AppSecret=${AppSecret}
WechatRedirectUrl=${WechatRedirectUrl}
#QQ互联
QQAppID=${QQAppID}
QQAppKey=${QQAppKey}
QQRedirectUrl=${QQRedirectUrl}
getUserInfoURL = https://graph.qq.com/user/get_user_info
accessTokenURL = https://graph.qq.com/oauth2.0/token
getOpenIDURL = https://graph.qq.com/oauth2.0/me
#Redis配置信息
redis.Host=10.211.55.3
redis.Port=6379
redis.Password=hujinhu
log4j.properties配置
# Output pattern : date [thread] priority category - message
#log4j.rootLogger=warn, Console, RollingFile,Cat
log4j.rootLogger=warn, Console, RollingFile,ErrorFile
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
#RollingFile
log4j.appender.RollingFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.RollingFile.File=logs/log.log
log4j.appender.RollingFile.DatePattern=yyyy-MM-dd-HH'.log'
log4j.appender.RollingFile.layout=org.apache.log4j.PatternLayout
log4j.appender.RollingFile.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.appender.RollingFile.Threshold=INFO
#ErrorFile
log4j.appender.ErrorFile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.ErrorFile.File=logs/error.log
log4j.appender.ErrorFile.DatePattern=yyyy-MM-dd-HH'.log'
log4j.appender.ErrorFile.layout=org.apache.log4j.PatternLayout
log4j.appender.ErrorFile.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.appender.ErrorFile.Threshold=ERROR
#Project defalult level
log4j.logger.com.zx=INFO
#log4jdbc
#log4j.logger.jdbc.sqltiming=INFO
config路径下的local.properties配置
#线下地址 #数据库信息 jdbc.url=jdbc:log4jdbc:mysql://xx.xx.xx.xx:xxxx/enterprise_info?characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true jdbc.username=xxxx jdbc.password=xxxx #微信开放平台 AppID=wx3e90b218c6d22e17 AppSecret=xxxxxxxx WechatRedirectUrl=http://xxxxx/callBack/wechat #QQ互联 QQAppID=101357725 QQAppKey=xxxxxxxxx QQRedirectUrl=http://xxxxxxxx/callBack/qq
浙公网安备 33010602011771号