//do what you wish with myConnection
} catch (SQLException sqle) {
getServlet().log("Connection.process", sqle);
} finally {
//enclose this in a finally block to make
//sure the connection is closed
if(connection!=null)
try {
connection.close();
} catch (SQLException e) {
getServlet().log("Connection.close", e);
}
}

return (mapping.findForward("success"));
}
}

action.xml和struts-config.xml文件的配置

这里将不再阐述，请参考第一篇《利用Struts结合Jbuilder7、MySql建立Web站点（1）--连接数据库》

struts-config.xml：

<!DOCTYPE struts-config PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 1.0//EN"
"http://jakarta.apache.org/struts/dtds/struts-config_1_0.dtd">

<!--
This is the Struts configuration file for the example application,
using the proposed new syntax.

NOTE: You would only flesh out the details in the "form-bean"
declarations if you had a generator tool that used them to create
the corresponding Java classes for you. Otherwise, you would
need only the "form-bean" element itself, with the corresponding
"name" and "type" attributes.
-->

<struts-config>

<!-- ========== Data Source Configuration =============================== -->
<data-sources>
<data-source>
<set-property property="autoCommit"
value="false"/>
<set-property property="description"
value="Data Source Configuration"/>
<set-property property="driverClass"
value="org.gjt.mm.mysql.Driver"/>
<set-property property="maxCount"
value="200"/>
<set-property property="minCount"
value="20"/>
<set-property property="password"
value="sailing"/>
<set-property property="url"
value="jdbc:mysql://localhost/gdmovie"/>
<set-property property="user"
value="DateBase"/>
</data-source>
</data-sources>

<!-- ========== Form Bean Definitions =================================== -->
<form-beans>

<!-- Football form bean -->
<form-bean name="footballForm"
type="vod.model.footballForm"/>

<!-- Fun form bean -->
<form-bean name="funForm"
type="vod.model.funForm"/>

<!-- Movie form bean -->
<form-bean name="movieForm"
type="vod.model.movieForm"/>

<!-- MTV form bean -->
<form-bean name="mtvForm"
type="vod.model.mtvForm"/>

</form-beans>

<!-- ========== Global Forward Definitions ============================== -->
<global-forwards>
<forward name="welcome" path="/welcome.do"/>
</global-forwards>

<!-- ========== Action Mapping Definitions ============================== -->
<action-mappings>

<!-- Enter into welcome Page -->
<action path="/welcome"
type="vod.controller.DisplayWelcomeAction">
<forward name="success" path="/welcome.jsp"/>
</action>

<!-- Enter into morefootball Page -->
<action path="/morefootball"
type="vod.controller.MoreFootballAction">
<forward name="success" path="/morefootball.jsp"/>
</action>

<!-- Enter into viewfootball Page -->
<action path="/viewfootball"
type="vod.controller.ViewFootballAction">
<forward name="success" path="/viewfootball.jsp"/>
</action>

</action-mappings>

</struts-config>

<action-mappings>

<!-- Global Forward Declarations -->
<forward name="welcome" path="/welcome.do"/>

<!-- Process a user logon -->
<action path="/welcome"
actionClass="vod.controller.DisplayWelcomeAction">
<forward name="success" path="/welcome.jsp"/>
</action>
<action path="/morefootball"
actionClass="vod.controller.MoreFootballAction">
<forward name="success" path="/morefootball.jsp"/>
</action>
<action path="/viewfootball"
actionClass="vod.controller.ViewFootballAction">
<forward name="success" path="/viewfootball.jsp"/>
</action>

</action-mappings>

Jsp页面

welcome.jsp:将在这个页中加入更多足球这个链接，并且调用MoreFootballAction并且指定取第一页。

代码如下：

上一页  [1] [2] [3]  下一页