spring终结篇 -- 使用spring web应用程序配置,整合所有部分(数据库)
1.web.xml中添加spring的dispatch servlet
<servlet> <servlet-name>controller</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value> <!-- 注意文件名 --> /WEB-INF/controller-servlet.xml </param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet>
2.添加spring的bean配置文件,注意配置文件的名字需要如下格式[Servlet-Name]-servlet.xml
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>WEB-INF/classes/datasource.properties</value> </list> </property> </bean> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName"> <value>${DATABASE.DriverClassName}</value> </property> <property name="url"> <value>${DATABASE.URL}</value> </property> <property name="username"> <value>${DATABASE.UserName}</value> </property> <property name="password"> <value>${DATABASE.Password}</value> </property> <property name="maxActive"> <value>${DATABASE.POOL.MaxActive}</value> </property> <property name="maxWait"> <value>${DATABASE.POOL.MaxWait}</value> </property> <property name="maxIdle"> <value>${DATABASE.POOL.MaxIdle}</value> </property> </bean> <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass"> <value>org.springframework.web.servlet.view.JstlView</value> </property> <property name="prefix"> <value>/</value> </property> <property name="suffix"> <value>.jsp</value> </property> </bean> <bean id="handlerMapping" class="org.springframework.web.servlet.handler.BeanNameUrlHandlerMapping" /> <bean id="methodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.ParameterMethodNameResolver"> <property name="paramName"> <value>method</value> </property> <property name="defaultMethodName"> <value>execute</value> </property> </bean> <!-- 其他bean的定义--> </beans>
3.数据库的配置,添加datasource.properties配置文件(src中)
DATABASE.URL= DATABASE.DriverClassName=com.mysql.jdbc.Driver DATABASE.UserName= DATABASE.Password= DATABASE.POOL.MaxActive=20 DATABASE.POOL.MaxWait=5000 DATABASE.POOL.MaxIdle=10
4.添加log4j的配置文件
log4j.rootLogger=debug,file,console log4j.appender.console=org.apache.log4j.ConsoleAppender log4j.appender.console.Threshold=debug log4j.appender.console.layout=org.apache.log4j.PatternLayout log4j.appender.console.layout.ConversionPattern=[%d] %5p [%C{1}:%M] - %m%n log4j.appender.file=org.apache.log4j.DailyRollingFileAppender log4j.appender.file.File=D:/reip.log log4j.appender.file.layout=org.apache.log4j.PatternLayout log4j.appender.file.layout.ConversionPattern=[%d] %5p [%C{1}/:%M] - %m%n