spring配置文件applicationContext.xml,放在resources下
<?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.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd"> <!--Spring配置文件的核心点( 1、数据源 2、与mybatis的整合 3、事务控制 )--> <!--业务逻辑组件扫描进来--> <context:component-scan base-package="club.iashe"> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/> </context:component-scan> <!--==================================================================================================================--> <!--数据源的配置--> <!--引入外部的配置文件--> <context:property-placeholder ignore-unresolvable="true" location="classpath:dbconfig.properties"/> <!-- 数据库连接池c3p0配置数据源 --> <bean id="pooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="jdbcUrl" value="${jdbc.jdbcUrl}"/> <property name="driverClass" value="${jdbc.driverClass}"/> <property name="user" value="${jdbc.user}"/> <property name="password" value="${jdbc.password}"/> </bean> <!--==================================================================================================================--> <!--配置和mybatis整合--> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!--指定mybatis全局配置文件的位置--> <property name="configLocation" value="classpath:mybatis-config.xml"/> <!--指定数据源--> <property name="dataSource" ref="pooledDataSource"/> <!--指定mybatis映射文件的位置--> <property name="mapperLocations" value="classpath:mapper/*Mapper.xml"/> </bean> <!--配置扫描器,将mybatis接口的实现,即DAO接口所在包名,加入到IOC容器中--> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!--扫描所有dao接口的实现,加入到IOC容器中--> <property name="basePackage" value="club.iashe.dao"/> </bean> <!--配置一个可以执行批量的sqlSession--> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate" > <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/> <!--<constructor-arg name="executorType" value="BATCH" />--> </bean> <!--==================================================================================================================--> <!-- 事务控制的配置,spring声明式事务 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <!--控制住数据源--> <property name="dataSource" ref="pooledDataSource"/> </bean> <!--开启基于注解的事务/使用xml配置形式的事务(一般比较重要的都使用xml形式)--> <aop:config> <!--切入点表达式--> <aop:pointcut expression="execution(* club.iashe.service..*(..))" id="txPoint"/> <!--<aop:pointcut id="txPoint" expression="execution(* cn.crud.service..*(..))"/>--> <!--配置事务增强--> <aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/> </aop:config> <!--配置事务增强,也就是事务如何切入--> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <!--代表这个切入点的所有方法都是事务方法--> <tx:method name="*"/> <!--以get开始的所有方法,进行调优--> <tx:method name="get*" read-only="true"/> </tx:attributes> </tx:advice> <!--==================================================================================================================--> </beans>
springMVC配置文件,dispatcherServlet-servlet.xml,放在WEB-INF下
<?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/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd"> <!--两个标准配置--> <!--将springMVC不能处理的请求交给tomcat--> <mvc:default-servlet-handler /> <!--能支持springMVC一些更高级的功能,注释替代XML配置,jrs303校验,快捷的ajax,映射动态请求--> <!--<mvc:annotation-driven />--> <!-- 使用fastjson替换springMVC默认的Jackson --> <mvc:annotation-driven> <mvc:message-converters register-defaults="true"> <!-- 配置fastjson支持 --> <bean class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter"> <property name="defaultCharset" value="UTF-8" /> <property name="supportedMediaTypes"> <list> <value>text/html;charset=UTF-8</value> <value>application/json</value> </list> </property> </bean> </mvc:message-converters> </mvc:annotation-driven> <!-- springMVC的配置文件,包含网站跳转逻辑的控制、配置 注释改掉默认扫描所有use-default-filters,设为false --> <context:component-scan base-package="club.iashe" use-default-filters="false"> <!--只扫描控制器--> <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller" /> </context:component-scan> <!-- 配置视图解析器,方便页面返回信息 --> <!-- 配置 HTML 视图解析器 --> <!-- html视图解析器,必须先配置freemarkerConfig,html没有prefix属性 --> <!--<bean id="freemarkerConfig" class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer"> <property name="resourceLoader"> <value>/html/</value> </property> </bean> <bean id="htmlViewResolver" class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver"> <property name="suffix" value="html" /> <property name="order" value="0"/> <property name="contentType" value="text/html;charset=UTF-8" /> </bean>--> <!-- 配置 jsp 视图解析器 --> <bean id="jspViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <!--<property name="prefix" value="WEB-INF/views/" /> <!–前缀–>--> <property name="prefix" value="WEB-INF/admin/views/" /> <!--前缀--> <property name="suffix" value=".jsp" /> <!--后缀--> </bean> </beans>
mybatis配置文件,mybatis-config.xml,resources下
<?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> <!-- Globally enables or disables any caches configured in any mapper under this configuration --> <setting name="cacheEnabled" value="false"/> <!-- Sets the number of seconds the driver will wait for a response from the database --> <setting name="defaultStatementTimeout" value="5"/> <!-- Enables automatic mapping from classic database column names A_COLUMN to camel case classic Java property names aColumn --> <!-- 数据库下划线转为驼峰 --> <setting name="mapUnderscoreToCamelCase" value="true"/> <!-- Allows JDBC support for generated keys. A compatible driver is required. This setting forces generated keys to be used if set to true, as some drivers deny compatibility but still work --> <setting name="useGeneratedKeys" value="true"/> </settings> <!-- Continue editing here --> <!--起别名--> <typeAliases> <package name="club.iashe.pojo" /> </typeAliases> <!--配置PageHelper插件--> <plugins> <!-- com.github.pagehelper为PageHelper类所在包名 --> <plugin interceptor="com.github.pagehelper.PageInterceptor"> <!-- 使用下面的方式配置参数,后面会有所有的参数介绍 --> <!--<property name="param1" value="value1"/>--> <!-- 分页参数合理化 --> <property name="reasonable" value="true" /> </plugin> </plugins> </configuration>
mybatis-generator-config配置文件
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration> <!-- 引入配置文件 --> <properties resource="dbconfig.properties" /> <context id="DB2Tables" targetRuntime="MyBatis3"> <!--配置生成的增删改查方法不要注释--> <commentGenerator> <property name="suppressAllComments" value="true" /> </commentGenerator> <!--配置数据库链接信息--> <jdbcConnection driverClass="${jdbc.driverClass}" connectionURL="${jdbc.jdbcUrl}" userId="${jdbc.user}" password="${jdbc.password}"> </jdbcConnection> <javaTypeResolver > <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <!--java模型生成,指定JavaBean生成的位置--> <javaModelGenerator targetPackage="club.iashe.pojo" targetProject=".\src\main\java"> <property name="enableSubPackages" value="true" /> <property name="trimStrings" value="true" /> </javaModelGenerator> <!--指定sql映射文件的位置--> <sqlMapGenerator targetPackage="mapper" targetProject=".\src\main\resources"> <property name="enableSubPackages" value="true" /> </sqlMapGenerator> <!--指定DAO接口生成的位置--> <javaClientGenerator type="XMLMAPPER" targetPackage="club.iashe.dao" targetProject=".\src\main\java"> <property name="enableSubPackages" value="true" /> </javaClientGenerator> <!--指定每个表的生成策略--> <!--<table tableName="resident_tag" domainObjectName="ResidentTag" />--> <table tableName="resident_info" domainObjectName="ResidentInfo" /> </context> </generatorConfiguration>
数据库配置文件dbconfig.properties
jdbc.jdbcUrl=jdbc:mysql://localhost:3306/community?serverTimezone=UTC&zeroDateTimeBehavior=round jdbc.driverClass=com.mysql.cj.jdbc.Driver jdbc.user=root jdbc.password=
最后,web.xml的配置
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1"> <!-- web.xml文件的配置 --> <!-- 1.启动spring容器 --> <context-param> <param-name>contextConfigLocation</param-name> <!-- spring配置文件路径 --> <param-value>classpath:applicationContext.xml</param-value> </context-param> <!-- spring监听器 --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- 2、springMVC的前端控制器,拦截所有请求 --> <servlet> <!-- 配置springMVC的dispatcherServlet分发请求,实际上它是一个前端控制器 --> <servlet-name>dispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>dispatcherServlet</servlet-name> <!--拦截所有页面请求--> <url-pattern>/</url-pattern> </servlet-mapping> <!--3、字符编码过滤器,第一位的过滤器--> <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>forceRequestEncoding</param-name> <param-value>true</param-value> </init-param> <init-param> <param-name>forceResponseEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>CharacterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 4、使用rest风格的URI,将页面普通的post请求转为指定的delete或者put请求 --> <filter> <!-- hiddenHttpMethodFilter 可以把把post请求转船成 put delete --> <filter-name>HiddenHttpMethodFilter</filter-name> <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class> </filter> <filter-mapping> <filter-name>HiddenHttpMethodFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> </web-app>