📄 in10_db_page.htm
字号:
<p class="MsoNormal"><span lang="EN-US">2</span><span style="font-family: 宋体">、建立一个“空的</span><span lang="EN-US">Struts</span><span style="font-family: 宋体">数据库应用模板”应用程序：</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span>
<span style="font-family: 宋体">选择菜单“文件”</span><span lang="EN-US">—</span><span style="font-family: 宋体">“新建”</span><span lang="EN-US">—</span><span style="font-family: 宋体">“新建项目”，弹出新建项目对话框，如图</span><span lang="EN-US">3-1</span><span style="font-family: 宋体">所示：</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span style="font-family: 宋体">
在对话框中选择“空的</span><span lang="EN-US">Struts</span><span style="font-family: 宋体">数据库应用模板”，在项目名称中输入“</span><span lang="EN-US">DBApp</span><span style="font-family: 宋体">”，</span><span lang="EN-US">package
(</span><span style="font-family: 宋体">包名</span><span lang="EN-US">)</span><span style="font-family: 宋体">和位置（项目的路径）采用默认的值就行，当然也可以根据需要改变。最后点击“确定”按钮完成新项目的建立。</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span style="font-family: 宋体">在</span><span lang="EN-US">DBApp</span><span style="font-family: 宋体">项目根目录下包含四个子目录和两个文件，这是</span><span lang="EN-US">JSPStudio</span><span style="font-family: 宋体">项目的标准结构，最好不要改变它们默认的名称，否则会出现问题。</span></p>
<p class="MsoNormal"><span lang="EN-US">3</span><span style="font-family: 宋体">、利用</span><span lang="EN-US">Struts</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">Struts</span><span style="font-family: 宋体">数据库应用文件向导”进入</span><span lang="EN-US">Struts</span><span style="font-family: 宋体">文件向导对话框，也可以选择菜单“文件”</span><span lang="EN-US">—</span><span style="font-family: 宋体">“新建”</span><span lang="EN-US">—</span><span style="font-family: 宋体">“</span><span lang="EN-US">Struts</span><span style="font-family: 宋体">数据库应用文件向导”进入</span><span lang="EN-US">Struts</span><span style="font-family: 宋体">文件向导对话框。</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span style="font-family: 宋体">在</span><span lang="EN-US">Struts</span><span style="font-family: 宋体">文件向导对话框</span><span lang="EN-US">JSP</span><span style="font-family: 宋体">文件标签下的文件名输入栏中输入“</span><span lang="EN-US">HellWord</span><span style="font-family: 宋体">”文件名，其它文件采用默认的设置。</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-family: 宋体">（</span><span lang="EN-US">1</span><span style="font-family: 宋体">）输入文件名：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1030" type="#_x0000_t75" style='width:468pt;height:314.25pt'>
<v:imagedata src="in10_db_page_files/image011.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=419
src="in10_db_page_files/image012.jpg" v:shapes="_x0000_s1030"><![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_s1031" type="#_x0000_t75" style='width:468pt;height:314.25pt'>
<v:imagedata src="in10_db_page_files/image013.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=419
src="in10_db_page_files/image014.jpg" v:shapes="_x0000_s1031"><![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_s1032" type="#_x0000_t75" style='width:468pt;height:312.75pt'>
<v:imagedata src="in10_db_page_files/image015.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=417
src="in10_db_page_files/image016.jpg" v:shapes="_x0000_s1032"><![endif]></span></p>
<p class="MsoNormal" style="text-indent: 17.7pt"><b>
<span style="font-size: 9.0pt; font-family: 宋体">JSPOUT属性页的设置是唯一与《如何实现Struts
数据库应用程序》中的步骤不同之处，这是本例的核心内容。从上图可看出，我们要做的仅仅是把“自动分页”选择项选定并输入每页记录数即可，由于本例测试数据记录少，所以这里每页只显示3条记录。</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"><span lang="EN-US"> </span></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_s1033" type="#_x0000_t75" style='width:468pt;height:327.75pt'>
<v:imagedata src="in10_db_page_files/image017.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=437
src="in10_db_page_files/image018.jpg" v:shapes="_x0000_s1033"><![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_s1034" type="#_x0000_t75" style='width:468pt;height:327.75pt'>
<v:imagedata src="in10_db_page_files/image019.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=437
src="in10_db_page_files/image020.jpg" v:shapes="_x0000_s1034"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">接下来试一下切换到第</span><span lang="EN-US">5</span><span style="font-family: 宋体">页：</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:327.75pt'>
<v:imagedata src="in10_db_page_files/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=437
src="in10_db_page_files/image022.jpg" v:shapes="_x0000_s1035"><![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"><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"></tr></span></p>
<p class="MsoNormal"><span lang="EN-US"><logic:iterate name='dbList' id='dbList'
type='emptyprj.dbList' scope='request'></span></p>
<p class="MsoNormal"><span lang="EN-US"><logic:notEqual name='dbListForm'
property='action' value='edit'> </span></p>
<p class="MsoNormal"><span lang="EN-US"><tr></span></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -