MyEclipse搭建S2SH框架

1.创建web工程，创建数据库

2.添加连接池：

（1）需要添加的jar包：commons-logging.jar,proxool-0.9.1.jar,proxool-cglib.jar和mysql-connector-java-5.1.8-bin.jar

(2)在WEB-INF下创建proxool.xml文件：

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>mysql</alias>
<driver-url>jdbc:mysql://localhost:3306/s2sh_test?characterEncoding=utf8</driver-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<driver-properties>
<property name="user" value="root" />
<property name="password" value="1234" />
</driver-properties>
<maximum-connection-count>10</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>

(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/proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- proxool测试 -->
<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>

(4)测试连接池是否成功：

启动tomcat，浏览器里面输入：

http://localhost:8080/s2sh_test/Admin

如果出现蓝色的数据库信息界面则证明配置成功

3.创建数据库透视图

（1）切换myeclipse database explorer

（2）在DB Brower右键 ->new

(3)在Driver template中选择Mysql Connector

（4）Connection Url填写：jdbc:mysql://localhost:3306/s2sh_test?characterEncoding=utf8

Driver name填写数据库名字即可

（5）填写数据库连接用户名密码

（6）Add JARS选择mysql-connector-java-5.1.8-bin.jar

（7）Test Driver,填写密码，成功点击next

（8）选择Display the selected schemas,输入数据库连接密码，选择要操作的数据库，点击finish

4.添加hibernate支持：

（1）选中s2sh_test工程->右键->MyEclipse->Add Hibernate for Myeclipse

(2)选择copy checked...选项->next

(3)DB Driver选择数据库透视图名称->next

(4)取消选中Create SessionFactory class->finish 如果有重复的jar，replace即可

5.添加spring支持：

（1）选中s2sh_test工程->右键->MyEclipse->Add Spring Capabilities

(2)Library选中前四个和Spring3.0 web Libraries

(3)选择copy checked...->next一路点到finish

(4)web.xml中添加：

<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>


<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

6.添加struts2：

（1）需添加如下jar包：

commons-fileupload-1.2.1.jar，commons-io-1.4.jar，freemarker-2.3.15.jar，javassist-3.9.0.GA.jar，ognl-2.7.3.jar，struts2-core-2.1.8.jar，struts2-json-plugin-2.1.8.1.jar，struts2-spring-plugin-2.0.11.1.jar和xwork-core-2.1.6.jar

如果提示重复替换即可

（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>*.action</url-pattern>
</filter-mapping>

（3）在src下建struts.xml，添加：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
<struts>
<!-- 将控制权交给spring -->
<constant name="struts.objectFactory" value="spring" />
<include file="struts-default.xml" />
<package name="struts2.1" extends="json-default">
</package>
</struts> 

7.spring整合连接池，hibernate：

（1）在applicationContext.xml添加：

<!-- spring管理连接池 -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="org.logicalcobwebs.proxool.ProxoolDriver">
</property>
<property name="url" value="proxool.mysql">
</property>
</bean>
<!-- spring管理hibernate -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource">
</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">false</prop>
<prop key="hibernate.current_session_context_class">thread</prop>
<prop key="hibernate.connection.autocommit">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<!--<value>com/yb/bean/Introduction.hbm.xml</value>-->
</list>
</property>
</bean>

删除下面：

<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="configLocation"
value="classpath:hibernate.cfg.xml">
</property>
</bean>

（2）删除hibernate.cfg.xml

8.接下来就是反向工程和依赖注入测试配置是否成功，由于时间不足我就不介绍反向工程和依赖注入的使用了。

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

如有疑问和不足请提出指正！！！