Struts2 整合Spring使用jdbc连接数据库

1.首先添加spring的兼容性即架包

2.添加struts2的架包及spring和struts2的plugin，即struts2-spring-plugin2.1.8.1.jar

3.在Src下新建一个applicationContext.xml文件，内容如下：
<?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:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<bean id="DbConnection" class="com.cl.util.DbConnection">
<property name="url">
<value>jdbc:oracle:thin:@localhost:1521:orcl</value>
</property>
<property name="user">
<value>test</value>
</property>
<property name="passwrod">
<value>test</value>
</property>
</bean>
<bean id="UserDao" class="com.cl.dao.UserDao">
<property name="jdbc">
<ref bean="DbConnection" />
</property>
</bean>

<bean id="ui" class="com.cl.service.UserImpl">
<property name="dao">
     <ref bean="UserDao" />
</property>
</bean>

</beans>



4.编写连接数据库类DbConnection.java

package com.cl.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;



/**
* @author cl
* @function 创建数据库连接
* @version 2012年8月9日16:38:56
*
*/

public class DbConnection {

private String url;

private String user;

private String password;


public void setUrl(String url) {

this.url = url;

}

public void setUser(String user) {

this.user = user;

}

public void setPasswrod(String passwrod) {

this.password = passwrod;

}

static {

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

}

public Connection getConn() {

Connection conn = null;
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {
          e.printStackTrace();
}

   return conn;
  }

}



注：url、user、password对应applicationContext.xml中的url、user、password(注，其实也可以把driverClassName添加进来，以便于以后修改统一管理)。这里使用Spring的注入思想；配置方法为：


<bean id="DbConnection" class="com.hw.util.DbConnection">
<property name="url">
         <value>jdbc:oracle:thin:@localhost:1521:orcl</value>
</property>
<property name="user">
<value>test</value>
</property>
<property name="passwrod">
<value>test</value>
</property>

</bean>





5.编写UserDao做CRUD操作，这里不再书写，这里需要在applicationContext.xml 中做注册配置如下

<bean id="UserDao" class="com.cl.dao.UserDao">
<property name="dbc">
<ref bean="DbConnection" />
</property>
</bean>

注：userDao中必须注入dbc属性，添加一个set方法，使用jdbc进行数据库连接。



6.编写业务层代码：UserImpl.java,这里代码不再书写，在applicationContext.xml 中做注册配置如下



<bean id="ui" class="com.cl.service.UserImpl">
<property name="dao">
<ref bean="UserDao" />
</property>
</bean>

注：UserImpl中必须注入dao属性，添加一个set方法，使用dao进行数据库的操作；



7.编写控制层代码：userAciton.java



注：userAciton.java 中必须注入ui属性，添加一个set方法，使用ui调用相应的业务逻辑



8.编写struts.xml 配置文件



<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<package name="default" extends="struts-default" namespace="/">
<action name="addAction" class="com.hw.action.UserAction"
method="add">
<result name="success">/index.jsp</result>
</action>
<action name="queryAllAction" class="com.hw.action.UserAction"
method="query">
<result name="success">/queryall.jsp</result>
</action>
<action name="queryById" class="com.hw.action.UserAction"
method="queryById">
<result name="success">/modifyuser.jsp</result>
</action>
<action name="update" class="com.hw.action.UserAction" method="modify">
<result type="redirect">queryAllAction</result>
</action>
<action name="del" class="com.hw.action.UserAction" method="move">
<result type="redirect">queryAllAction</result>
</action>
</package>
</struts>



9.配置web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>


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


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


</web-app>