WebWork + Spring + iBatis + MySql 实例(Jonson)

客官°小女子只卖身不卖艺 2022-08-07 09:44 84阅读 0赞

一、/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][http_java.sun.com_xml_ns_j2ee]"  
xmlns:xsi="[http://www.w3.org/2001/XMLSchema-instance][http_www.w3.org_2001_XMLSchema-instance]"  
xsi:schemaLocation="[http://java.sun.com/xml/ns/j2ee][http_java.sun.com_xml_ns_j2ee][http://java.sun.com/xml/ns/j2ee/web-app\_2\_4.xsd][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][http_www.springframework.org_dtd_spring-beans-2.0.dtd]">

<bean id="propertyConfigurer"  
    class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">  
    <property name="locations">  
     <list>  
      <value>WEB-INF/jdbc.properties</value>  
     </list>  
    </property>  
</bean>

<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>

</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][http_www.opensymphony.com_xwork_xwork-1.1.1.dtd]">

五、/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][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][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][http_www.ibatis.com_dtd_sql-map-config-2.dtd]">  
<sqlMapConfig>

八、/classes/PersonDataEntity.xml (配置    iBatis    说白了就是写Sql)

<?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][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][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">  
     //想开个玩笑的话也可以写成，嘿嘿，原因参见文件：webwork.properties  
     <form name="personaction" action="personaction.**aspx**" method="post">  
      PersonID:&nbsp;<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**][taglib] **uri="/webwork" prefix="ww" %>**  
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "[http://www.w3.org/TR/html4/loose.dtd][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>

[http_java.sun.com_xml_ns_j2ee]: http://java.sun.com/xml/ns/j2ee
[http_www.w3.org_2001_XMLSchema-instance]: http://www.w3.org/2001/XMLSchema-instance
[http_java.sun.com_xml_ns_j2ee_web-app_2_4.xsd]: http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd
[http_www.springframework.org_dtd_spring-beans-2.0.dtd]: http://www.springframework.org/dtd/spring-beans-2.0.dtd
[http_www.opensymphony.com_xwork_xwork-1.1.1.dtd]: http://www.opensymphony.com/xwork/xwork-1.1.1.dtd
[http_www.ibatis.com_dtd_sql-map-config-2.dtd]: http://www.ibatis.com/dtd/sql-map-config-2.dtd
[http_www.ibatis.com_dtd_sql-map-2.dtd]: http://www.ibatis.com/dtd/sql-map-2.dtd
[http_www.w3.org_TR_html4_loose.dtd]: http://www.w3.org/TR/html4/loose.dtd
[taglib]: mailto:%@taglib