SpringMVC数据库链接池,以及其他相关配置详解编程语言

<?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:mvc="http://www.springframework.org/schema/mvc" 
    xmlns:context="http://www.springframework.org/schema/context" 
    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.xsd      
        http://www.springframework.org/schema/context 
        http://www.springframework.org/schema/context/spring-context.xsd"> 
    <!-- 扫描的包 --> 
    <!-- <context:component-scan base-package="app04"/> --> 
    <!-- 使用转换器 --> 
    <!--<mvc:annotation-driven conversion-service="conversionService"/>--> 
    <!-- 使用格式化 --> 
    <!-- conversionService2 --> 
   <!--  <mvc:annotation-driven conversion-service="conversionService2"/> --> 
    
    <!-- 使用注册器替代格式化 --> 
    <!-- <mvc:annotation-driven />意思是开启使用注释的功能--> 
    <!-- conversionService3是格式化或者转换器 --> 
    <!-- <mvc:annotation-driven conversion-service="conversionService3"/> --> 
    
    <!-- 扫描的包 --> 
    <context:component-scan base-package="sfk.bbs.test.testSpringMVCConfig.action"/> 
    <!-- 这个的作用是让DispatcherServlet不将下列路径理解为一个request请求, 
    在项目中,这个是必须的,如果没有加这些就可能造成上述问题 --> 
    <mvc:annotation-driven /> 
    <mvc:resources mapping="/css/**" location="/css/"/> 
    <mvc:resources mapping="/js/**" location="/js/"/> 
    <mvc:resources mapping="/*.html" location="/"/> 
     
    <!-- 视图解析器 -->    
    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 
        <property name="prefix" value="/WEB-INF/pages/"/> 
        <property name="suffix" value=".jsp"/> 
    </bean> 
    <!-- 读取配置文件信息,在Spring的配置文件中使用EL表达式填充值 --> 
    <context:property-placeholder location="classpath:jdbc.properties"/> 
    <!-- 配置数据库连接池 --> 
    <bean id="dataSourceLocal" name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> 
<!-- 指定连接数据库的驱动--> 
<property name="driverClass" value="${jdbc.driverClassName}"/> 
<!-- 指定连接数据库的URL--> 
<property name="jdbcUrl" value="${jdbc.url}"/> 
<!-- 指定连接数据库的用户名--> 
<property name="user" value="${jdbc.username}"/> 
<!-- 指定连接数据库的密码--> 
<property name="password" value="${jdbc.password}"/> 
<!-- 指定连接池中保留的最大连接数. Default:15--> 
<property name="maxPoolSize" value="${jdbc.maxPoolSize}"/> 
<!-- 指定连接池中保留的最小连接数--> 
<property name="minPoolSize" value="${jdbc.minPoolSize}"/> 
<!-- 指定连接池的初始化连接数 取值应在minPoolSize 与 maxPoolSize 之间.Default:3--> 
<property name="initialPoolSize" value="${jdbc.initialPoolSize}"/> 
<!-- 最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。 Default:0--> 
<property name="maxIdleTime" value="${jdbc.maxIdleTime}"/> 
<!-- 当连接池中的连接耗尽的时候c3p0一次同时获取的连接数. Default:3--> 
<property name="acquireIncrement" value="${jdbc.acquireIncrement}"/> 
<!-- JDBC的标准,用以控制数据源内加载的PreparedStatements数量。 
但由于预缓存的statements属于单个connection而不是整个连接池所以设置这个参数需要考虑到多方面的因数.如果maxStatements与maxStatementsPerConnection均为0,则缓存被关闭。Default:0--> 
<property name="maxStatements" value="${jdbc.maxStatements}"/> 
<!-- 每60秒检查所有连接池中的空闲连接.Default:0 --> 
<property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/> 
</bean> 
     
     
     
    <!-- <bean id="dataSourceLocal" name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> 
        制定连接数据库的驱动 
        <property name="driverClass" value="${jdbc.driverClassName}" /> 
        制定连接数据库的URL 
        <property name="jdbcUrl" value="${jdbc.url}" /> 
        指定连接数据库的用户名 
        <property name="user" value="${jdbc.username}" /> 
        指定数据库的密码 
        <property name="password" value="${jdbc.password}"/> 
        指定连接池中保留的最大连接数 default:15 
        <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/> 
        指定连接池中保留的最小连接数  
        <property name="minPoolSize" value="${jdbc.minPoolSize}" /> 
        指定连接池的初始化连接数 取值应在minPoolSize 与MaxPoolSize之间,Default:3 
        <property name="initialPoolSize" value="${jdbc.initialPoolSize}"/> 
        最大空闲时间,60秒内未使用连接被丢弃,若为0则永不丢弃,Default:0 
        <property name="maxIdleTime" value="${jdbc.maxIdleTime}"/> 
        当连接池中的连接耗尽的时候c3p0一次同时获取的连接数. default: 3 
        <property name="acquireIncrement" value="${jdbc.acquireIncrement}" /> 
        JDBC的标准,用以控制数据源内加载的prepareedStatement数量.但是由于预缓存的statements 
        属于单个connection而不是整个连接池所以色绘制这个参数需要考虑到多方面的因素,如果maxStatements 
        与maxStatementsPerConnection均为0,则缓存被关闭,Default:0  
        <property name="maxStatements" value="${jdbc.maxStatements}"/> 
        每60秒检查所有连接池中的空闲连接default:0 
        <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}" /> 
    </bean> --> 
    <!-- 错误提示信息配置,用配置文件管理错误信息 --> 
    <!-- <bean id="messageSource" class="org.springframework.context.support.ReloadableResourceBundleMessageSource"> 
        <property name="basename" value="/WEB-INF/resource/messages" /> 
    </bean> --> 
    <!-- org.springframework.context.support.ConversionServiceFactoryBean.class --> 
    <!-- 使用转换器的bean --> 
<!--     <bean id="conversionService" class="org.springframework.context.support.ConversionServiceFactoryBean"> 
        <property name="converters"> 
            <list> 
                <bean class="app06a.converter.StringToDateConverter" > 
                    <constructor-arg type="java.lang.String" value="MM-dd-yyyy"/> 
                </bean> 
            </list> 
        </property> 
    </bean> 
     --> 
    <!-- 使用Formatter的格式化 --> 
<!--     <bean id="conversionService2" class="org.springframework.format.support.FormattingConversionServiceFactoryBean"> 
        <property name="formatters"> 
            <set> 
             
            /springMVC/src/app06a/formatter/DateFormatter.java 
                <bean class="app06a.formatter.DateFormatter"> 
                    <constructor-arg type="java.lang.String" value="MM-dd-yyyy"/> 
                </bean> 
            </set> 
        </property> 
    </bean> --> 
     
        <!-- 使用注册器替代Formatter的格式化 --> 
<!--     <bean id="conversionService3" class="org.springframework.format.support.FormattingConversionServiceFactoryBean"> 
        <property name="formatterRegistrars"> 
            <set> 
            /springMVC/src/app06a/formatter/DateFormatter.java 
                <bean class="app06a.formatter.MyFormatterRigistrar"> 
                    <constructor-arg type="java.lang.String" value="MM-dd-yyyy"/> 
                </bean> 
            </set> 
        </property> 
    </bean> --> 
     
     
</beans>

<?xml version="1.0" encoding="UTF-8"?> 
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1"> 
  <display-name>sfk_BBS02</display-name> 
  
          <!-- <context-param> 
            <param-name>contextConfigLocation</param-name> 
             <param-value>classpath:applicationContext.xml</param-value> 
        </context-param> --> 
<!--   <context-param> 
        <param-name>contextConfigLocation</param-name> 
        <param-value>/WEB-INF/resource/applicationContext.xml</param-value> 
    </context-param> --> 
     
    <!-- config log4j  first Part --> 
     <context-param> 
        <param-name>log4jConfigLocation</param-name> 
        <param-value>classpath:log4j.properties</param-value> 
    </context-param>   
    <!-- /WEB-INF/classes/applicationContext-*.xml --> 
    <context-param> 
        <param-name>contextConfigLocation</param-name> 
         <param-value>/WEB-INF/classes/applicationContext.xml</param-value> 
    </context-param>  
        <!-- Srping监听器 --> 
    <listener> 
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> 
    </listener>  
    <!-- config log4j  second Part --> 
    <!-- 加载log4j配置文件 --> 
    <listener> 
        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class> 
    </listener> 
    <servlet> 
        <servlet-name>springMVC</servlet-name> 
        <servlet-class> 
            org.springframework.web.servlet.DispatcherServlet 
        </servlet-class> 
         <init-param> 
             <param-name>contextConfigLocation</param-name> 
             <param-value>classpath:applicationContext.xml</param-value> 
     
         </init-param> 
     
        <load-on-startup>1</load-on-startup> 
    </servlet> 
    <!-- 有的项目中这里写的是.do,这样分发器只会分发带有.do的请求, 
         就可以规避将js.css,.png等文件的路径当作一个请求,当前没有写.do,就要用到 
          <mvc:annotation-driven /> 
          <mvc:resources mapping="/css/**" location="/css/"/> 
          将.css等文件不当作一个请求 --> 
    <servlet-mapping> 
        <servlet-name>springMVC</servlet-name> 
        <url-pattern>/</url-pattern> 
    </servlet-mapping> 
 
     <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> 
   
</web-app>

#log4j.rootLogger=INFO,C,F 
#first way log All 
########## 
# C,System.out 
#log4j.appender.C.Threshold=INFO print info or above 
########## 
log4j.logger.sfk.bbs=INFO,C,F 
#second way set log package  
log4j.appender.C=org.apache.log4j.ConsoleAppender 
log4j.appender.C.Threshold=INFO  
log4j.appender.C.layout=org.apache.log4j.PatternLayout 
log4j.appender.C.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %L %p %C{1} - %m%n 
 
########### 
#save in file 
#log4j.appender.F.Threshold=INFO ,info or above 
########### 
log4j.appender.F=org.apache.log4j.DailyRollingFileAppender 
# save file path 
log4j.appender.F.File=/home/rocky/develop/luna/eclipse/logInfo/SpringMVC_log 
log4j.appender.F.Append=true 
log4j.appender.F.Threshold=INFO 
log4j.appender.F.layout=org.apache.log4j.PatternLayout 
log4j.appender.F.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %L %p %C{1} - %m%n

package sfk.bbs.common.SpringUtil; 
 
import org.springframework.beans.BeansException; 
import org.springframework.context.ApplicationContext; 
import org.springframework.context.ApplicationContextAware; 
import org.springframework.context.support.ClassPathXmlApplicationContext; 
 
/** 
 * 1.Spring的工具类,现在主要用来获取Spring配置文件中的bean 
 * 2.这个方法里比较遗憾的是没有用到implements ApplicationContextAware 
 * 原因是在web.xml文件中没有配置正确 
 * @author rocky 
 * 
 */ 
public class SpringHelper 
{ 
    private static  ApplicationContext applicationContext; 
 
     
    @SuppressWarnings("static-access") 
    public SpringHelper() 
    { 
        this.applicationContext =new ClassPathXmlApplicationContext("classpath:applicationContext.xml"); 
    } 
 
   /* @Override 
    public void setApplicationContext(ApplicationContext applicationContext) 
            throws BeansException 
    { 
        System.out.println("setApplicationContext : "+this.applicationContext); 
        this.applicationContext = applicationContext; 
 
    }*/ 
     
    public Object getBean(String beanId) 
    { 
        System.out.println("applicationContext : "+applicationContext); 
        System.out.println("getBean : " + beanId); 
        return applicationContext.getBean(beanId); 
    } 
 
}

package sfk.bbs.test.testSpringMVCConfig.action; 
 
 
import java.sql.Connection; 
import java.sql.SQLException; 
 
import javax.servlet.http.HttpServletRequest; 
import javax.servlet.http.HttpServletResponse; 
import javax.sql.DataSource; 
 
import org.apache.log4j.Logger; 
import org.springframework.context.ApplicationContext; 
import org.springframework.context.support.ClassPathXmlApplicationContext; 
import org.springframework.stereotype.Controller; 
import org.springframework.ui.Model; 
import org.springframework.web.bind.annotation.RequestMapping; 
 
import com.mchange.v2.c3p0.ComboPooledDataSource; 
 
import sfk.bbs.common.SpringUtil.SpringHelper; 
import sfk.bbs.common.constance.ActionURL; 
import sfk.bbs.common.constance.PagePath; 
 
@Controller 
public class StudentAction 
{ 
    private static Logger log = Logger.getLogger(StudentAction.class); 
    /** 
     * 1.现在的想法是把pages文件夹写在SpringMVC的配置文件中,将后缀.jsp也写在SpringMVC的配置文件中 
     * 在Controller中page页面写成这样"testPage/studentList 
     * 斜杠左边的pages文件夹下面的下一层文件夹,斜杠右边的是jsp文件 
     * 2.jsp文件名和requestMapping中的value相同 
     * 3.注意:requestMapping不写.do,页面不写.jsp 
     *  
     * 查找所有的student列表 
     * @param request request 
     * @param response response 
     * @param model model 
     * @return studentList 
     */ 
    @RequestMapping(value=ActionURL.STUDENT_LIST) 
    public String findAllStudent(HttpServletRequest request, 
            HttpServletResponse response,Model model) 
    { 
       SpringHelper springHelper = new SpringHelper(); 
        DataSource  datasource = (ComboPooledDataSource) springHelper.getBean("dataSourceLocal"); 
        Connection conn = null; 
        try 
        { 
            conn = datasource.getConnection(); 
        } catch (SQLException e) 
        { 
            // TODO Auto-generated catch block 
            e.printStackTrace(); 
        } 
        finally 
        { 
            try 
            { 
                conn.close(); 
            } catch (SQLException e) 
            { 
                // TODO Auto-generated catch block 
                e.printStackTrace(); 
            } 
        } 
        System.out.println(conn); 
         
         //ctx = new ("classpath:applicationContext.xml"); 
       // ApplicationContext ctx = new ClassPathXmlApplicationContext("classpath:applicationContext.xml"); 
        //System.out.println("ctx : " + ctx); 
        log.info("into findAllStudent"); 
        return PagePath.STUDENT_LIST; 
    } 
     
}