📄 in9_db.htm
字号:
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<style>
<!--
p.MsoNormal
{mso-style-parent:"";
margin-bottom:.0001pt;
text-align:justify;
text-justify:inter-ideograph;
font-size:10.5pt;
font-family:"Times New Roman";
margin-left:0cm; margin-right:0cm; margin-top:0cm}
-->
</style>
<!--[if !mso]>
<style>
v\:* { behavior: url(#default#VML) }
o\:* { behavior: url(#default#VML) }
.shape { behavior: url(#default#VML) }
</style>
<![endif]-->
<link rel="File-List" href="in9_db_files/filelist.xml">
<!--[if gte mso 9]>
<xml><o:shapedefaults v:ext="edit" spidmax="1027"/>
</xml><![endif]-->
</head>
<body>
<p class="MsoNormal" align="center" style="text-align:center"><b>
<span style="font-size: 24.0pt; font-family: 宋体">如何实现Struts 数据库应用程序</span></b></p>
<p class="MsoNormal"><b><span style="font-size: 24.0pt; font-family: 宋体"> </span></b></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US">[</span><span style="font-family: 宋体">目标</span><span lang="EN-US">]</span></b></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">SQL</span><span style="font-family: 宋体"> </span><span lang="EN-US">Server
2000</span><span style="font-family: 宋体">中读取数据,并以表格的形式在输出页中显示出来。</span></p>
<p class="MsoNormal"><span style="font-family: 宋体">定义一个名为“</span><span lang="EN-US">Test</span><span style="font-family: 宋体">”表的字段:</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US"><!--[if gte vml 1]><v:shapetype id="_x0000_t75"
coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"
filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t75" style='width:249.75pt;
height:108pt'>
<v:imagedata src="in9_db_files/image001.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=333 height=144
src="in9_db_files/image002.jpg" v:shapes="_x0000_s1025"><![endif]></span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><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_s1026" type="#_x0000_t75" style='width:249pt;height:242.25pt'>
<v:imagedata src="in9_db_files/image003.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=332 height=323
src="in9_db_files/image004.jpg" v:shapes="_x0000_s1026"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US">[</span><span style="font-family: 宋体">效果</span><span lang="EN-US">]</span></b></p>
<p class="MsoNormal"><span lang="EN-US">(1)</span><span style="font-family: 宋体">全部显示:</span></p>
<p class="MsoNormal"><span style="font-family: 宋体">输入页面:</span></p>
<p class="MsoNormal" align="center" style="text-align:center">
<span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1027" type="#_x0000_t75" style='width:438pt;height:161.25pt'>
<v:imagedata src="in9_db_files/image005.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=584 height=215
src="in9_db_files/image006.jpg" v:shapes="_x0000_s1027"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">输出页面:</span></p>
<p class="MsoNormal" align="center" style="text-align:center">
<span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1028" type="#_x0000_t75" style='width:438pt;height:332.25pt'>
<v:imagedata src="in9_db_files/image007.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=584 height=443
src="in9_db_files/image008.jpg" v:shapes="_x0000_s1028"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">(2)</span><span style="font-family: 宋体">查询显示:</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1029" type="#_x0000_t75" style='width:438.75pt;height:162pt'>
<v:imagedata src="in9_db_files/image009.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=585 height=216
src="in9_db_files/image010.jpg" v:shapes="_x0000_s1029"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1030" type="#_x0000_t75" style='width:438pt;height:160.5pt'>
<v:imagedata src="in9_db_files/image011.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=584 height=214
src="in9_db_files/image012.jpg" v:shapes="_x0000_s1030"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US">[</span><span style="font-family: 宋体">背景知识</span><span lang="EN-US">]</span></b></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:14.0pt">[</span><span style="font-size: 14.0pt; font-family: 宋体">步骤</span><span lang="EN-US" style="font-size:14.0pt">]</span></b></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">1</span><span style="font-family: 宋体">、打开</span><span lang="EN-US">Visual
Struts</span><span style="font-family: 宋体">开发环境:</span></p>
<p class="MsoNormal" style="text-indent: 26.25pt"><span style="font-family: 宋体">
从桌面</span><span lang="EN-US">JavaWebStudio</span><span style="font-family: 宋体">快揵或</span><span lang="EN-US">BIN</span><span style="font-family: 宋体">目录下的</span><span lang="EN-US">JavaWebStudio.exe</span><span style="font-family: 宋体">文件启动</span><span lang="EN-US">JavaWebStudio</span><span style="font-family: 宋体">的</span><span lang="EN-US">Visual
Struts</span><span style="font-family: 宋体">开发环境。</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<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"><span lang="EN-US"><!--[if gte vml 1]><v:shape
id="_x0000_s1031" type="#_x0000_t75" style='width:249.75pt;height:155.25pt'>
<v:imagedata src="in9_db_files/image013.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=333 height=207
src="in9_db_files/image014.jpg" v:shapes="_x0000_s1031"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US"> </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"><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:407.25pt;height:350.25pt'>
<v:imagedata src="in9_db_files/image015.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=543 height=467
src="in9_db_files/image016.jpg" v:shapes="_x0000_s1032"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">从文件管理器中可看出</span><span lang="EN-US">DBApp</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:172.5pt;height:230.25pt'>
<v:imagedata src="in9_db_files/image017.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=230 height=307
src="in9_db_files/image018.jpg" v:shapes="_x0000_s1033"><![endif]></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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -