一、/WEB-INF/web.xml????? (配置WebWork + Spring)
?
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<filter>
<filter-name>webwork</filter-name>
<filter-class>com.opensymphony.webwork.dispatcher.FilterDispatcher</filter-class>
</filter>
<filter-mapping>
<filter-name>webwork</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
</web-app>
?
二、/WEB-INF/applicationContext.xml (配置Spring + iBatis)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN"
"http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans default-autowire="autodetect">
<!-- 读取Mysql驱动信息参数文件 -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>WEB-INF/jdbc.properties</value>
</list>
</property>
</bean>
<!-- C3P0 数据源 -->
<bean id="dataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="${jdbc.driverClassName}" />
<property name="jdbcUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<bean id="sqlMapClient"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation"
value="WEB-INF/sql-map-config.xml" />
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="userservices" class="userServices"/>
<bean id="mymysqldriver" class="MyMysqlDriver"/>
<!-- 在personservices 对象中注入 sqlMapClient -->
<bean id="personservices" class="PersonServices">
<property name="sqlMapClient" ref="sqlMapClient"/>
</bean>
</beans>
?
三、/WEB-INF/jdbc.properties (配置 iBatis 的数据库驱动(MySql驱动))
?
jdbc.driverClassName=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/mysql1 jdbc.username=root jdbc.password=1234
??
四、/classes/xwork.xml (配置 WebWork )
?
<!DOCTYPE xwork PUBLIC "-//OpenSymphony Group//XWork 1.1.1//EN" "http://www.opensymphony.com/xwork/xwork-1.1.1.dtd"> <!-- START SNIPPET: xworkSample --> <xwork> <include file="webwork-default.xml"/> <include file="xwork-Global.xml"/> <include file="xwork-PersonAction.xml"/> </xwork>
?
五、/classes/xwork-Global.xml (配置 WebWork )
<!DOCTYPE xwork PUBLIC "-//OpenSymphony Group//XWork 1.1.1//EN"
"http://www.opensymphony.com/xwork/xwork-1.1.1.dtd">
<xwork>
<package name="global" extends="webwork-default">
<global-results>
<result name="error" type="redirect">/isnull.jsp</result>
</global-results>
</package>
</xwork>
?
六、/classes/xwork-PersonAction.xml (配置 WebWork )
?
<!DOCTYPE xwork PUBLIC "-//OpenSymphony Group//XWork 1.1.1//EN"
"http://www.opensymphony.com/xwork/xwork-1.1.1.dtd">
<xwork>
<package name="ppp" extends="global">
<action name="personaction" class="PersonAction">
<result name="success" type="dispatcher">/Person.jsp</result>
<interceptor-ref name="params"/>
</action>
</package>
</xwork>
?
七、/WEB-INF/sql-map-config.xml (配置 iBatis)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
maxRequests="32"
maxSessions="10"
maxTransactions="5"
useStatementNamespaces="false"
/>
<sqlMap resource="/PersonDataEntity.xml" />
</sqlMapConfig>
?
八、/classes/PersonDataEntity.xml
?
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Person">
<select id="selectPerson" resultClass="fizi.PersonDataEntity">
SELECT PER_ID as id,
PER_FIRST_NAME as firstName,
PER_LAST_NAME as lastName,
PER_BIRTH_DATE as birthDate,
PER_WEIGHT_KG as weightInKilograms,
PER_HEIGHT_M as heightInMeters
FROM PERSON
WHERE PER_ID = #value#
</select>
<insert id="insertPerson" parameterClass="fizi.PersonDataEntity">
<![CDATA[
INSERT INTO
PERSON (PER_ID, PER_FIRST_NAME, PER_LAST_NAME,
PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M)
VALUES (#id#, #firstName#, #lastName#,
#birthDate#, #weightInKilograms#, #heightInMeters#)
]]>
</insert>
<update id="updatePerson" parameterClass="fizi.PersonDataEntity">
<![CDATA[
UPDATE PERSON
SET PER_FIRST_NAME = #firstName#,
PER_LAST_NAME = #lastName#, PER_BIRTH_DATE = #birthDate#,
PER_WEIGHT_KG = #weightInKilograms#,
PER_HEIGHT_M = #heightInMeters#
WHERE PER_ID = #id#
]]>
</update>
<delete id="deletePerson" parameterClass="fizi.PersonDataEntity">
<![CDATA[
DELETE PERSON
WHERE PER_ID = #id#
]]>
</delete>
</sqlMap>
?
九、/classes/webwork.properties (配置????? WebWork )
?
### extension for actions webwork.action.extension=action,java,aspx,jhtml ### Configuration reloading ### This will cause the configuration to reload xwork.xml when it is changed webwork.i18n.reload=true webwork.configuration.xml.reload=true ### Load custom default resource bundles webwork.custom.i18n.resources=default ### character encoding ### webwork.locale=zh_CN webwork.i18n.encoding=UTF-8 ### upload jakarta, temp dir, maxSize = 10M webwork.multipart.parser=jakarta ### webwork.ui.theme=xhtml webwork.ui.theme=simple ### WebWork-Spring Integration webwork.objectFactory = spring webwork.objectFactory.spring.autoWire = name
?
十、部分代码 PersonDataEntity.java
?
import java.util.Date;
public class PersonDataEntity {
private int id;
private String firstName;
private String lastName;
private Date birthDate;
private double weightInKilograms;
private double heightInMeters;
public int getId () {
return id;
}
public void setId (int id) {
this.id = id;
}
public Date getBirthDate() {
return birthDate;
}
public void setBirthDate(Date birthDate) {
this.birthDate = birthDate;
}
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public double getHeightInMeters() {
return heightInMeters;
}
public void setHeightInMeters(double heightInMeters) {
this.heightInMeters = heightInMeters;
}
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public double getWeightInKilograms() {
return weightInKilograms;
}
public void setWeightInKilograms(double weightInKilograms) {
this.weightInKilograms = weightInKilograms;
}
}
?十一、PersonServices.java (要使用iBatis 则需要 继承 类 SqlMapClientDaoSupport )
?
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.ibatis.sqlmap.client.SqlMapClient;
public class PersonServices extends SqlMapClientDaoSupport {
public PersonDataEntity GetPerson(Integer pID) {
return (PersonDataEntity) getSqlMapClientTemplate()
.queryForObject("selectPerson", pID);
}
}
?
十二、PersonAction.java 在WebWork中方便调用的Action所以需要实现 接口Action
?
import Socket.sclient;
import com.opensymphony.xwork.Action;
public class PersonAction implements Action{
private PersonDataEntity persondataentity = new PersonDataEntity();
private PersonServices personservices;
public String execute() throws Exception {
// TODO Auto-generated method stub
Integer pid = new Integer(100001);
sclient client = new sclient(); //调用Socket，这里你可以不需要(我写的:)
client.ReadServer();
persondataentity = personservices.GetPerson(pid);
if (persondataentity!=null)
{
return SUCCESS;
}
else
{
return ERROR;
}
}
public void setPersondataentity(PersonDataEntity persondataentity) {
this.persondataentity = persondataentity;
}
public void setPersonservices(PersonServices personservices) {
this.personservices = personservices;
}
public PersonDataEntity getPersondataentity() {
return persondataentity;
}
}
?
十三、实际调用 PersonAction的 jsp文件 QueryPerson.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Person查询</title>
</head>
<body>
<table border=0 width=97%>
<tr><td align="left">
<form name="personaction" action="personaction.action" method="post">
<form name="personaction" action="personaction.aspx" method="post">
PersonID: <input type="text" name="persondataentity.id"><br>
<input type="submit" name="查询"><br>
</form>
</td></tr>
</table>
</body>
</html>
?十四、做个简单的查询结果返回页面 person.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"%> <%@taglib uri="/webwork" prefix="ww" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> 人员:<label style="color: red;" ><ww:property value='persondataentity.firstName'/></label>查询成功! </body> </html>
?
?