in12_db_insert.htm

struts开发实例

&lt;html:reset&nbsp; value=&quot;重写&quot;&nbsp;&nbsp; /&gt;&nbsp; &lt;/html:form &gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;/body&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;/html:html &gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt"><b>
<span lang="EN-US" style="font-family: 黑体">&nbsp;</span></b></p>
<p class="MsoNormal" style="text-indent:21.0pt"><b>
<span lang="EN-US" style="font-family: 黑体">dbListOut.jsp文件</span><span style="font-family: 黑体">：</span></b></p>
<p class="MsoNormal" style="text-indent:21.0pt"><b>
<span style="font-family: 黑体">与《如何实现Struts 
数据库应用程序》不同之处在于在表格多了记录的删除、编辑、更新和分页功能，内容如下：</span></b></p>
<p class="MsoNormal"><span lang="EN-US">&lt;tr&gt;&lt;td&nbsp; align=middle colSpan=4 &gt;</span></p>
<p class="MsoNormal" style="text-indent: 41.3pt"><b>
<span lang="EN-US" style="font-family:黑体">&lt;bean:write property='pagestr' 
name='dbListForm' filter='false' /&gt;</span></b></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/td&gt;&lt;/tr&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt"><b>
<span style="font-family: 黑体">其它文件完全相同，下页是<span lang="EN-US">dbListOut.jsp文件源代码</span>：</span></b></p>
<p class="MsoNormal"><span lang="EN-US">&lt;%@ page 
contentType=&quot;text/html;charset=GB2312&quot; language=&quot;java&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;%@ taglib 
uri=&quot;/WEB-INF/struts-bean.tld&quot; prefix=&quot;bean&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;%@ taglib 
uri=&quot;/WEB-INF/struts-html.tld&quot; prefix=&quot;html&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;%@ taglib 
uri=&quot;/WEB-INF/struts-logic.tld&quot; prefix=&quot;logic&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;%@ taglib 
uri=&quot;/WEB-INF/struts-template.tld&quot; prefix=&quot;template&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;html:html&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;head&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;title&gt;&lt;/title&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;html:base/&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/head&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;body bgcolor=&quot;white&quot;&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;table width=&quot;98%&quot; border=&quot;1&quot; 
bgColor=&quot;#E6F2E7&quot; </span></p>
<p class="MsoNormal"><span lang="EN-US">borderColorDark=&quot;#FFFFFF&quot; 
borderColorLight=&quot;#008000&quot; cellPadding=&quot;3&quot; cellSpacing=&quot;0&quot; &gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;tr bgcolor='#90C090'&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;span CONTENTEDITABLE=true&gt;</span><span style="font-family: 宋体">序号</span><span lang="EN-US">&lt;/span&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;span CONTENTEDITABLE=true&gt;</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">&lt;/span&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;span CONTENTEDITABLE=true&gt;</span><span style="font-family: 宋体">备注</span><span lang="EN-US">&lt;/span&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;span CONTENTEDITABLE=true&gt;</span><span style="font-family: 宋体">删除</span><span lang="EN-US">&lt;/span&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;span CONTENTEDITABLE=true&gt;</span><span style="font-family: 宋体">编辑</span><span lang="EN-US">&lt;/span&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;span CONTENTEDITABLE=true&gt;</span><span style="font-family: 宋体">链接</span><span lang="EN-US">&lt;/span&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/tr&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;logic:iterate name='dbList' id='dbList' 
type='emptyprj.dbList' scope='request'&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;logic:notEqual name='dbListForm' 
property='action' value='edit'&gt; </span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;tr&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">' 
/&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">备注</span><span lang="EN-US">' 
/&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;a 
href=&quot;dbListAction.do?action=delete&amp;search=search&amp;expression=</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&quot;&gt;</span><span style="font-family: 宋体">删除</span><span lang="EN-US">&lt;/a&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;a 
href=&quot;dbListAction.do?action=edit&amp;search=search&amp;expression=</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&quot;&gt;</span><span style="font-family: 宋体">编辑</span><span lang="EN-US">&lt;/a&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;a 
href=&quot;dbListAction.do?action=link&amp;search=search&amp;expression=</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&quot;&gt;</span><span style="font-family: 宋体">链接</span><span lang="EN-US">&lt;/a&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/tr&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/logic:notEqual&gt; </span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;logic:equal name='dbListForm' 
property='action' value='edit'&gt; </span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;tr&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;form&nbsp; method='post' name='dbListForm' 
action=</span></p>
<p class="MsoNormal"><span lang="EN-US">
&quot;/DBApp/dbListAction.do?action=update&amp;search=search&amp;expression=</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&quot;&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;html:text name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;html:text name='dbList' property='</span><span style="font-family: 宋体">姓名</span><span lang="EN-US">' 
/&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;html:text name='dbList' property='</span><span style="font-family: 宋体">备注</span><span lang="EN-US">' 
/&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;a 
href=&quot;dbListAction.do?action=delete&amp;search=search&amp;expression=</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&quot;&gt;</span><span style="font-family: 宋体">删除</span><span lang="EN-US">&lt;/a&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;html:submit value='</span><span style="font-family: 宋体">更新</span><span lang="EN-US">'&gt;&lt;/html:submit&gt;&lt;/form 
&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;form&nbsp; method='post' 
action=&quot;dbListAction.do?action=reset&amp;search=search&amp;expression=</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&quot; &gt;&lt;html:submit value='</span><span style="font-family: 宋体">取消</span><span lang="EN-US">'&gt;&lt;/html:submit&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/form &gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;td&gt;&lt;a 
href=&quot;dbListAction.do?action=link&amp;search=search&amp;expression=</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;bean:write name='dbList' property='</span><span style="font-family: 宋体">序号</span><span lang="EN-US">' 
/&gt;&quot;&gt;</span><span style="font-family: 宋体">链接</span><span lang="EN-US">&lt;/a&gt;&lt;/td&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/tr&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/logic:equal&gt; </span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/logic:iterate&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;tr&gt;&lt;td&nbsp; align=middle colSpan=7 
&gt;&lt;bean:write property='pagestr' name='dbListForm' filter='false' /&gt;&lt;/td&gt;&lt;/tr&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/tr&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/table&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/body&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&lt;/html:html&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family:黑体">
dbListDAO.java文件：</span></b></p>
<p class="MsoNormal"><span style="font-family: 宋体">　　这里定义一个</span><span lang="EN-US">DAO</span><span style="font-family: 宋体">类，用于实现数据加的查找、删除、更新、添加及生成分页字符串等功能。</span><span lang="EN-US">getPagestr(int 
ipage)</span><span style="font-family: 宋体">函数用于生成分页字符串，</span><span lang="EN-US">int 
ipage</span><span style="font-family: 宋体">参数用于转递当前页码。</span><span lang="EN-US">findSQL(String 
sql,int ipage)</span><span style="font-family: 宋体">函数用于查找数据库数据，</span><span lang="EN-US">String 
sql</span><span style="font-family: 宋体">参数用于转递</span><span lang="EN-US">SQL</span><span style="font-family: 宋体">查询语句字符串，</span><span lang="EN-US">int 
ipage</span><span style="font-family: 宋体">参数用于转递当前页码。</span></p>
<p class="MsoNormal"><b><span style="font-family:黑体">。。。。。。。。。。<span lang="EN-US">(省略)</span></span></b></p>
<p class="MsoNormal"><span lang="EN-US">public class dbListDAO {</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp; </span><b>
<span style="font-family: 宋体">与记录更新、删除和添加无关的代码省略。</span></b></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp; &nbsp;public void create(dbList m_dbList) 
throws SQLException {</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp; PreparedStatement ps = null;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp; //&lt;createSQL&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp; String sql = &quot;INSERT INTO dbo.Test