SSH框架整合

1、spring和proxool整合
1.1 添加proxool的相应jar包
1.2 在src目录下创建proxool.xml文件，配置如下：

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE proxool><proxool>    <alias>database</alias> <!--数据源的别名 -->    <driver-url>jdbc:mysql://localhost/test?characterencoding=UTF8</driver-url>    <driver-class>com.mysql.jdbc.Driver</driver-class> <!--驱动类 -->    <driver-properties>        <property name="user" value="root" /> <!--用户名 -->        <property name="password" value="1234" /><!--密码 -->    </driver-properties>    <!--最大连接数(默认5个),超过了这个连接数,再有请求时,就排在队列中等候,最大的等待请求数由maximum-new-connections决定 -->    <maximum-connection-count>100</maximum-connection-count>    <!--最小连接数(默认2个) -->    <minimum-connection-count>10</minimum-connection-count>    <!--proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁 默认30秒 -->    <house-keeping-sleep-time>90000</house-keeping-sleep-time>    <!--没有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受 -->    <maximum-new-connections>10</maximum-new-connections>    <!--最少保持的空闲连接数(默认2个) -->    <prototype-count>5</prototype-count>    <!--在使用之前测试 -->    <test-before-use>true</test-before-use>    <!--用于保持连接的测试语句 -->    <house-keeping-test-sql>select 1</house-keeping-test-sql></proxool>

1.3 web.xml添加内容如下：

  <servlet>    <servlet-name>ServletConfigurator</servlet-name>    <servlet-class>      org.logicalcobwebs.proxool.configuration.ServletConfigurator     </servlet-class>    <init-param>      <param-name>xmlFile</param-name>      <param-value>WEB-INF/classes/proxool.xml</param-value>    </init-param>    <load-on-startup>1</load-on-startup>  </servlet>  <!--   连接池管理 -->  <servlet>    <servlet-name>Admin</servlet-name>    <servlet-class>      org.logicalcobwebs.proxool.admin.servlet.AdminServlet     </servlet-class>  </servlet>  <servlet-mapping>    <servlet-name>Admin</servlet-name>    <url-pattern>/admin</url-pattern></servlet-mapping>

1.4 测试
1.5 添加spring框架的jar包
1.6 web.xml添加内容如下：

 <listener>    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><context-param>    <param-name>contextConfigLocation</param-name>    <param-value>WEB-INF/classes/spring.xml</param-value></context-param>

1.7 在src目录下新建一个spring.xml文件添加如下内容：

7.<?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"    xmlns:p="http://www.springframework.org/schema/p"    xsi:schemaLocation="http://www.springframework.org/schema/beans             http://www.springframework.org/schema/beans/spring-beans-3.0.xsd           http://www.springframework.org/schema/context            http://www.springframework.org/schema/context/spring-context-3.0.xsd           http://www.springframework.org/schema/aop            http://www.springframework.org/schema/aop/spring-aop-3.0.xsd           http://www.springframework.org/schema/tx            http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">    <!—整合proxool连接池-->             <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">        <property name="driverClassName">            <value>org.logicalcobwebs.proxool.ProxoolDriver</value>        </property>        <property name="url">            <value>proxool.database</value>        </property>    </bean>      </beans>

开始运行如果没有异常抛出就表示整合成功了
2、Sping 整合hibernate
2.1 添加hibernate的jar文件
2.2 修改spring配置文件我的项目叫spring.xml 添加如下内容：

2.  <bean id="sessionFactory"        class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">        <property name="dataSource" ref="dataSource" />        <property name="annotatedClasses">            <list>                <value></value>            </list>        </property>        <property name="hibernateProperties">            <props>                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>                <prop key="hibernate.show_sql">true</prop>                <prop key="hibernate.format_sql">true</prop>                <prop key="hibernate.hbm2ddl.auto">update</prop>            </props>        </property></bean>

2.3 运行没有异常发生说明整合正确
3、Sping整合struts2
3.1 导入strut2 jar包
3.2 修改web.xml文件：

<filter>    <filter-name>struts2</filter-name>    <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class></filter><filter-mapping>    <filter-name>struts2</filter-name>    <url-pattern>/*</url-pattern></filter-mapping>

3.3 在src目录下添加struts 配置文件struts.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE struts PUBLIC    "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"    "http://struts.apache.org/dtds/struts-2.3.dtd"><struts>    <constant name="struts.objectFactory" value="spring"></constant>    <package name="deafult" namespace="/" extends="struts-default">    <!-- 添加自己项目的控制器 -->        <action name="index" class="testAction">            <result>/index.jsp</result>        </action>    </package></struts>

4、编写测试类（bean、dao、service、action）
spring添加内容：（根据自己项目修改）

   <bean id="userDao" class="com.company.project.dao.UserDAO">        <property name="sessionFactory" ref="sessionFactory"></property>    </bean>    <bean id="userService" class="com.company.project.service.UserService">        <property name="userDao" ref="userDao"></property>    </bean>    <bean id="testAction" class="com.company.project.action.TestAction">        <property name="userService" ref="userService"></property>    </bean>