📄 in11_db_update.htm
字号:
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=419
src="in11_db_update_files/image014.jpg" v:shapes="_x0000_s1031"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">（</span><span lang="EN-US">2</span><span style="font-family: 宋体">）从数据源中导入</span><span lang="EN-US">SQL</span><span style="font-family: 宋体">语句及数据表的字段信息（字段名和字段类型）：</span></p>
<p class="MsoNormal"><span style="font-family: 宋体">（</span><span lang="EN-US">3</span><span style="font-family: 宋体">）从数据据表中选择所需的表“</span><span lang="EN-US">Test</span><span style="font-family: 宋体">”。</span></p>
<p class="MsoNormal"><span style="font-family: 宋体">需要特别注意的是，这里的“从数据源中导入</span><span lang="EN-US">SQL</span><span style="font-family: 宋体">语句及数据表的字段信息”及“从数据据表中选择所需的表”仅仅是为了自动生成</span><span lang="EN-US">SQL</span><span style="font-family: 宋体">语句及读取字段信息，这里完成可以直接手工输入，与该项目的数据库连接池的配置无关，下面第（</span><span lang="EN-US">4</span><span style="font-family: 宋体">）点将另行配置数据库连接池。</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1032" type="#_x0000_t75" style='width:468pt;height:314.25pt'>
<v:imagedata src="in11_db_update_files/image015.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=419
src="in11_db_update_files/image016.jpg" v:shapes="_x0000_s1032"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">
接下来配置数据库连接池，其它属性页可采用默认的就行了，下面直接转去数据连接配置属性页即可。</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-family: 宋体">（</span><span lang="EN-US">4</span><span style="font-family: 宋体">）</span><b><span style="font-size: 9.0pt; font-family: 宋体">JSPOUT属性页设置:</span></b></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1033" type="#_x0000_t75" style='width:468.75pt;height:315pt'>
<v:imagedata src="in11_db_update_files/image017.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=625 height=420
src="in11_db_update_files/image018.jpg" v:shapes="_x0000_s1033"><![endif]></span></p>
<p class="MsoNormal" style="text-indent: 17.7pt"><b>
<span style="font-size: 9.0pt; font-family: 宋体">JSPOUT属性页的设置是唯一与《如何实现Struts
数据库应用程序》中的步骤不同之处，这是本例的核心内容。从上图可看出，我们要做的仅仅是把JSPOUT属性页的设置中把“记录操作”选择项中分别选定记录的删除、更新及链接即可。</span></b></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">(5)</span><span style="font-family: 宋体">配置数据库连接池：</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US">(</span><span style="font-family: 宋体">省略</span><span lang="EN-US">)</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">4</span><span style="font-family: 宋体">、项目文件结构</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span style="font-family: 宋体">
项目目录结构分析见</span><b><span style="font-size:9.0pt;font-family:宋体">《</span><span style="font-size: 9.0pt; font-family: 宋体; color: #333333">如何实现最简单的<span lang="EN-US">Struts程序</span></span><span style="font-size:9.0pt;font-family:宋体">》</span></b><span lang="EN-US" style="font-size:9.0pt;font-family:宋体">,这次</span><span lang="EN-US">Struts</span><span style="font-family: 宋体">数据库应用文件向导自动生成了六个文件，其中</span><span lang="EN-US">web</span><span style="font-family: 宋体">目录下是输入、输出两个</span><span lang="EN-US">JSP</span><span style="font-family: 宋体">文件，</span><span lang="EN-US">src</span><span style="font-family: 宋体">目录下是</span><span lang="EN-US">Java</span><span style="font-family: 宋体">文件。除了文件名是我们输入之外，所有程序源代码都是文件向导自动生成的，所有的配置也是自动完成的。</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span style="font-family: 宋体">
刷新</span><span lang="EN-US">JSPStudio</span><span style="font-family: 宋体">文件管理器，这时发现</span><span lang="EN-US">web</span><span style="font-family: 宋体">目录下自动生成了两个文件，分别是</span><span lang="EN-US">DbList.jsp</span><span style="font-family: 宋体">和</span><span lang="EN-US">DbList.jsp</span><span style="font-family: 宋体">，前者是输入</span><span lang="EN-US">JSP</span><span style="font-family: 宋体">文件，后者是输出</span><span lang="EN-US">JSP</span><span style="font-family: 宋体">文件；</span><span lang="EN-US">src\emptyprj</span><span style="font-family: 宋体">目录下自动生成了四个文件，分别是</span><span lang="EN-US">DbList
Action.java</span><span style="font-family: 宋体">和</span><span lang="EN-US">DbList
Form.java</span><span style="font-family: 宋体">，前者是</span><span lang="EN-US">Action</span><span style="font-family: 宋体">文件，后者是</span><span lang="EN-US">FormAction</span><span style="font-family: 宋体">文件；还有是数据库操作文件</span><span lang="EN-US">DbList.java</span><span style="font-family: 宋体">和</span><span lang="EN-US">DbListDAO.java</span><span style="font-family: 宋体">，前者用于保存数据表记录的</span><span lang="EN-US">Bean</span><span style="font-family: 宋体">，后者是数据库操作</span><span lang="EN-US">DAO</span><span style="font-family: 宋体">文件。</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size:14.0pt;font-family:黑体">[特别提示]如果数据选择的是SQL
Server 2000,需要把DAO文件中的下面代码：</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 黑体"> //用SQL
Server请加入下行: </span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 黑体">
//con.setAutoCommit(true);</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 黑体"> //SQL
Server</span></b></p>
<p class="MsoNormal"><b><span style="font-size:14.0pt;font-family:黑体">都改写成如下代码：</span></b></p>
<p class="MsoNormal" style="text-indent: 31.0pt"><b>
<span lang="EN-US" style="font-family: 黑体">//用SQL Server请加入下行: </span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 黑体">
<span style="color:red"> con.setAutoCommit(true);
//注意啦!!就是这一行，原来是注解掉了，现在是把注解去掉!!</span></span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 黑体"> //SQL
Server</span></b></p>
<p class="MsoNormal"><b><span style="font-size:14.0pt;font-family:黑体">
通过上述改写，才能通过<span lang="EN-US">JDBC对SQL Server 2000进行记录更新、删除和添加等操作。</span></span></b></p>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size:14.0pt;font-family:黑体"> </span></b></p>
<p class="MsoNormal"><span lang="EN-US">5</span><span style="font-family: 宋体">、编译、启动服务器、运行：</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span><span style="font-family: 宋体">
通过工具条上的按键分别编译项目及启动服务器，然后把开</span><span lang="EN-US">dbList.jsp</span><span style="font-family: 宋体">并通过工具条上的“运行”按键运行</span><span lang="EN-US">dbList.jsp</span><span style="font-family: 宋体">：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1034" type="#_x0000_t75" style='width:468pt;height:327.75pt'>
<v:imagedata src="in11_db_update_files/image019.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=437
src="in11_db_update_files/image020.jpg" v:shapes="_x0000_s1034"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-family: 宋体">
首先试一下全部显示功能，点击“全部显示”接钮，如果如下图所示：</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1035" type="#_x0000_t75" style='width:468pt;height:327pt'>
<v:imagedata src="in11_db_update_files/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=436
src="in11_db_update_files/image022.jpg" v:shapes="_x0000_s1035"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">接下来试一下“编辑”功能：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1036" type="#_x0000_t75" style='width:468pt;height:326.25pt'>
<v:imagedata src="in11_db_update_files/image023.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=435
src="in11_db_update_files/image024.jpg" v:shapes="_x0000_s1036"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">接下来是实现编辑一下表格内的数据：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1037" type="#_x0000_t75" style='width:468pt;height:327.75pt'>
<v:imagedata src="in11_db_update_files/image025.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=437
src="in11_db_update_files/image026.jpg" v:shapes="_x0000_s1037"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">接下来是实现“更新”功能：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1038" type="#_x0000_t75" style='width:468pt;height:328.5pt'>
<v:imagedata src="in11_db_update_files/image027.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=438
src="in11_db_update_files/image028.jpg" v:shapes="_x0000_s1038"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-family: 宋体">通过上述步骤，实现了预计的目标功能。</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size:14.0pt;font-family:黑体">[程序源代码]</span></b></p>
<p class="MsoNormal" style="text-indent:21.0pt"><b>
<span style="font-family: 黑体">对于程序源代码，本例唯一与《如何实现Struts 数据库应用程序》中的程序源代码不同之处，是</span><span lang="EN-US" style="font-family: 黑体">dbListOut.jsp文件</span><span style="font-family: 黑体">。不同之处在于在表格多了记录的删除、编辑、更新和分页功能，内容如下：</span></b></p>
<p class="MsoNormal"><span lang="EN-US"><tr><td align=middle colSpan=4 ></span></p>
<p class="MsoNormal" style="text-indent: 41.3pt"><b>
<span lang="EN-US" style="font-family:黑体"><bean:write property='pagestr'
name='dbListForm' filter='false' /></span></b></p>
<p class="MsoNormal"><span lang="EN-US"></td></tr></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"><%@ page
contentType="text/html;charset=GB2312" language="java" %></span></p>
<p class="MsoNormal"><span lang="EN-US"><%@ taglib
uri="/WEB-INF/struts-bean.tld" prefix="bean" %></span></p>
<p class="MsoNormal"><span lang="EN-US"><%@ taglib
uri="/WEB-INF/struts-html.tld" prefix="html" %></span></p>
<p class="MsoNormal"><span lang="EN-US"><%@ taglib
uri="/WEB-INF/struts-logic.tld" prefix="logic" %></span></p>
<p class="MsoNormal"><span lang="EN-US"><%@ taglib
uri="/WEB-INF/struts-template.tld" prefix="template" %></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"><html:html></span></p>
<p class="MsoNormal"><span lang="EN-US"><head></span></p>
<p class="MsoNormal"><span lang="EN-US"><title></title></span></p>
<p class="MsoNormal"><span lang="EN-US"><html:base/></span></p>
<p class="MsoNormal"><span lang="EN-US"></head></span></p>
<p class="MsoNormal"><span lang="EN-US"><body bgcolor="white"></span></p>
<p class="MsoNormal"><span lang="EN-US"><table width="98%" border="1"
bgColor="#E6F2E7" </span></p>
<p class="MsoNormal"><span lang="EN-US">borderColorDark="#FFFFFF"
borderColorLight="#008000" cellPadding="3" cellSpacing="0" ></span></p>
<p class="MsoNormal"><span lang="EN-US"><tr bgcolor='#90C090'></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><span CONTENTEDITABLE=true></span><span style="font-family: 宋体">序号</span><span lang="EN-US"></span></td></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><span CONTENTEDITABLE=true></span><span style="font-family: 宋体">姓名</span><span lang="EN-US"></span></td></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><span CONTENTEDITABLE=true></span><span style="font-family: 宋体">备注</span><span lang="EN-US"></span></td></span></p>
<p class="MsoNormal"><span lang="EN-US"><td><span CONTENTEDITABLE=true></span><span style="font-family: 宋体">删除</span><span lang="EN-US"></span></td></span></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -