in9_db.htm

struts开发实例

<p class="MsoNormal"><span lang="EN-US">&nbsp;</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"><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_s1034" type="#_x0000_t75" style='width:468pt;height:314.25pt'>
 <v:imagedata src="in9_db_files/image019.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=419
src="in9_db_files/image020.jpg" v:shapes="_x0000_s1034"><![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 lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1035" type="#_x0000_t75" style='width:333.75pt;height:282.75pt'>
 <v:imagedata src="in9_db_files/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=445 height=377
src="in9_db_files/image022.jpg" v:shapes="_x0000_s1035"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1036" type="#_x0000_t75" style='width:467.25pt;height:312.75pt'>
 <v:imagedata src="in9_db_files/image023.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=623 height=417
src="in9_db_files/image024.jpg" v:shapes="_x0000_s1036"><![endif]></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"><!--[if gte vml 1]><v:shape
 id="_x0000_s1037" type="#_x0000_t75" style='width:468.75pt;height:314.25pt'>
 <v:imagedata src="in9_db_files/image025.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=625 height=419
src="in9_db_files/image026.jpg" v:shapes="_x0000_s1037"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</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:314.25pt'>
 <v:imagedata src="in9_db_files/image027.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=419
src="in9_db_files/image028.jpg" v:shapes="_x0000_s1038"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">
接下来配置数据库连接池，其它属性页可采用默认的就行了，下面直接转去数据连接配置属性页即可。</span></p>
<p class="MsoNormal"><span lang="EN-US">(4)</span><span style="font-family: 宋体">配置数据库连接池：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1039" type="#_x0000_t75" style='width:466.5pt;height:312.75pt'>
 <v:imagedata src="in9_db_files/image029.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=622 height=417
src="in9_db_files/image030.jpg" v:shapes="_x0000_s1039"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span style="font-family: 宋体">
本例只采用了系统默认的一个变量</span><span lang="EN-US">mybeanvariable1</span><span style="font-family: 宋体">，就用它保存输入数据。</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">4</span><span style="font-family: 宋体">、项目文件结构</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1040" type="#_x0000_t75" style='width:255pt;height:309.75pt'>
 <v:imagedata src="in9_db_files/image031.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=340 height=413
src="in9_db_files/image032.jpg" v:shapes="_x0000_s1040"><![endif]></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" style="text-indent: 21.0pt"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US">dbList.jsp</span><span style="font-family: 宋体">文件：</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1041" type="#_x0000_t75" style='width:468pt;height:282pt'>
 <v:imagedata src="in9_db_files/image033.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=376
src="in9_db_files/image034.jpg" v:shapes="_x0000_s1041"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">dbListOut.jsp</span><span style="font-family: 宋体">文件：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1042" type="#_x0000_t75" style='width:468pt;height:312pt'>
 <v:imagedata src="in9_db_files/image035.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=416
src="in9_db_files/image036.jpg" v:shapes="_x0000_s1042"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">5</span><span style="font-family: 宋体">、编译、启动服务器、运行：</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp; </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_s1043" type="#_x0000_t75" style='width:468pt;height:327.75pt'>
 <v:imagedata src="in9_db_files/image037.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=437
src="in9_db_files/image038.jpg" v:shapes="_x0000_s1043"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span style="font-family: 宋体">
　　首先试一下全部显示功能，点击“全部显示”接钮，如果如下图所示：</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1044" type="#_x0000_t75" style='width:468pt;height:326.25pt'>
 <v:imagedata src="in9_db_files/image039.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=435
src="in9_db_files/image040.jpg" v:shapes="_x0000_s1044"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">　接一来试一下查找功能，在文本框中输入数字</span><span lang="EN-US">3</span><span style="font-family: 宋体">，点击“查找”接钮，如果如下图所示：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1045" type="#_x0000_t75" style='width:468pt;height:327pt'>
 <v:imagedata src="in9_db_files/image041.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=436
src="in9_db_files/image042.jpg" v:shapes="_x0000_s1045"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1046" type="#_x0000_t75" style='width:468pt;height:327pt'>
 <v:imagedata src="in9_db_files/image043.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=436
src="in9_db_files/image044.jpg" v:shapes="_x0000_s1046"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span style="font-family: 宋体">通过上述步骤，实现了预计的目标功能。</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</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"><span lang="EN-US">dbList.jsp</span><span style="font-family: 宋体">文件：</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US">&nbsp;</span></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">&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;html:form&nbsp; 
action=&quot;/dblistAction.do?action=search&amp;search=search&amp;expression=NULL&quot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
method=&quot;post&quot;&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>
<span style="font-family: 宋体">请输入要查找的</span> <span style="font-family: 宋体">序号</span>
<span style="font-family: 宋体">：</span><span lang="EN-US"> &lt;html:text property=&quot;</span><span style="font-family: 宋体">序号</span><span lang="EN-US">&quot;