in13_logon.htm

struts开发实例

<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:468.75pt;height:315pt'>
 <v:imagedata src="in13_Logon_files/image019.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=625 height=420
src="in13_Logon_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 style="font-family: 宋体">（</span><span lang="EN-US">3</span><span style="font-family: 宋体">）从数据据表中选择所需的表“</span><span lang="EN-US">Users</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">&nbsp;</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_s1035" type="#_x0000_t75" style='width:469.5pt;height:315.75pt'>
 <v:imagedata src="in13_Logon_files/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=626 height=421
src="in13_Logon_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">&nbsp;</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_s1036" type="#_x0000_t75" style='width:468.75pt;height:315pt'>
 <v:imagedata src="in13_Logon_files/image023.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=625 height=420
src="in13_Logon_files/image024.jpg" v:shapes="_x0000_s1036"><![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">&nbsp;</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"><!--[if gte vml 1]><v:shape
 id="_x0000_s1037" type="#_x0000_t75" style='width:469.5pt;height:315.75pt'>
 <v:imagedata src="in13_Logon_files/image025.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=626 height=421
src="in13_Logon_files/image026.jpg" v:shapes="_x0000_s1037"><![endif]></span></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span style="font-family: 宋体">这里需要注意的是用户登陆也是用到这个数据库连接配置。</span></b></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US">(6)</span><span style="font-family: 宋体">在新生成的</span><span lang="EN-US">JSP</span><span style="font-family: 宋体">文件中加上用户登陆检查标签</span><span lang="EN-US">&lt;app:checkLogon/&gt;</span><span style="font-family: 宋体">：</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span style="font-family: 宋体">
新生成的</span><span lang="EN-US">JSP</span><span style="font-family: 宋体">文件有三个，查询条件输入文件</span><span lang="EN-US">UserEdit.jsp</span><span style="font-family: 宋体">、添加新记录输入文件</span><span lang="EN-US">UserEditInsert.jsp</span><span style="font-family: 宋体">和查询结果显示文件</span><span lang="EN-US">UserEditOut.jsp</span><span style="font-family: 宋体">。分别在这三个文件的</span><span lang="EN-US">&lt;/head&gt;</span><span style="font-family: 宋体">标签后加上用户登陆检查标签</span><span lang="EN-US">&lt;app:checkLogon/&gt;</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"><!--[if gte vml 1]><v:shape
 id="_x0000_s1038" type="#_x0000_t75" style='width:468pt;height:327.75pt'>
 <v:imagedata src="in13_Logon_files/image027.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=437
src="in13_Logon_files/image028.jpg" v:shapes="_x0000_s1038"><![endif]></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" 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 lang="EN-US">&nbsp;</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt"><span style="font-family: 宋体">
刷新</span><span lang="EN-US">JavaWebStudio</span><span style="font-family: 宋体">文件管理器，这时发现</span><span lang="EN-US">web</span><span style="font-family: 宋体">目录下自动生成了</span><b><span style="font-family:黑体">三个文件</span></b><span style="font-family: 宋体">，分别是</span><span lang="EN-US">UserEdit.jsp</span><span style="font-family: 宋体">和</span><span lang="EN-US">UserEdit.jsp</span><span style="font-family: 宋体">和</span><b><span lang="EN-US" style="font-family:黑体">UserEditInsert.jsp</span></b><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><b><span style="font-family:黑体">后者是添加记录页面文件</span></b><span style="font-family: 宋体">；</span><span lang="EN-US">src\emptyprj</span><span style="font-family: 宋体">目录下自动生成了四个文件，分别是</span><span lang="EN-US">UserEdit 
Action.java</span><span style="font-family: 宋体">、</span><span lang="EN-US">UserEdit 
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">UserEdit.java</span><span style="font-family: 宋体">和</span><span lang="EN-US">UserEditDAO.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">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:宋体">&nbsp;</span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 宋体">4．1、修改DAO文件：</span></b></p>
<p class="MsoNormal"><b><span style="font-family: 宋体">如果数据选择的是<span lang="EN-US">SQL 
Server 2000,需要把DAO文件中的下面代码：</span></span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //用SQL 
Server请加入下行: </span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
//con.setAutoCommit(true);</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //SQL 
Server</span></b></p>
<p class="MsoNormal"><b><span style="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: 宋体">&nbsp;&nbsp;&nbsp;
<span style="color:red">&nbsp;&nbsp;con.setAutoCommit(true);&nbsp;&nbsp; 
//注意啦!!就是这一行，原来是注解掉了，现在是把注解去掉!!</span></span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //SQL 
Server</span></b></p>
<p class="MsoNormal"><b><span style="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:宋体">&nbsp;</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 宋体">4．2 
在需要进行用户登陆识别的地方加入登陆识别标签</span></b></p>
<p class="MsoNormal"><b><span style="font-family: 宋体">（<span lang="EN-US">1）UserEdit.jsp文件：</span></span></b></p>
<p class="MsoNormal"><b><span style="font-family: 宋体">在</span></b><span lang="EN-US" style="font-family: 宋体">&lt;body&gt;前加上<b>&lt;app:checkLogon/&gt;标签</b></span></p>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size:14.0pt;font-family:黑体"><!--[if gte vml 1]><v:shape
 id="_x0000_s1039" type="#_x0000_t75" style='width:468pt;height:328.5pt'>
 <v:imagedata src="in13_Logon_files/image029.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=438
src="in13_Logon_files/image030.jpg" v:shapes="_x0000_s1039"><![endif]></span></b></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;%@ page 
contentType=&quot;text/html;charset=GB2312&quot; language=&quot;java&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;%@ taglib 
uri=&quot;/WEB-INF/struts-bean.tld&quot; prefix=&quot;bean&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;%@ taglib 
uri=&quot;/WEB-INF/struts-html.tld&quot; prefix=&quot;html&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;%@ taglib 
uri=&quot;/WEB-INF/struts-logic.tld&quot; prefix=&quot;logic&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;%@ taglib 
uri=&quot;/WEB-INF/struts-template.tld&quot; prefix=&quot;template&quot; %&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;html:html&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;head&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;title&gt;&lt;/title&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;html:base/&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;/head&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp;</span></p>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size: 12.0pt; font-family: 黑体">&lt;app:checkLogon/&gt;</span></b></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;body 
bgcolor=&quot;white&quot;&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;html:form&nbsp; 
action=&quot;/UserEditAction.do?action=search&amp;search=search&amp;expression=NULL&quot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
method=&quot;post&quot;&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 请输入要查找的 
username ： &lt;html:text property=&quot;username&quot; /&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&lt;html:submit value=&quot;查找&quot; /&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&lt;html:reset value=&quot;重写&quot; /&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp; &lt;/html:form&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;html:form 
action=&quot;UserEditAction.do?action=search&amp;expression=NULL&quot; method=&quot;post&quot;&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&lt;html:submit value=&quot;全部显示&quot; /&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp; &lt;/html:form&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;/body&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&lt;/html:html&gt;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">&nbsp;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体">4．3 在</span><b><span lang="EN-US" style="font-family: 黑体">mainMenu.jsp主菜单页面的左页面left.htm中加入一个新菜单项“用户查查询”：</span></b></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family: 宋体"><!--[if gte vml 1]><v:shape
 id="_x0000_s1040" type="#_x0000_t75" style='width:468pt;height:328.5pt'>
 <v:imagedata src="in13_Logon_files/image031.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=438
src="in13_Logon_files/image032.jpg" v:shapes="_x0000_s1040"><![endif]></span></p>
<p class="MsoNormal"><span style="font-family: 宋体">加入的代码主要是：<span lang="EN-US">&lt;A 
href=&quot;UserEdit.jsp&quot; target=main&gt;用户查询&lt;/A&gt;</span></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">index.htm</span><span style="font-family: 宋体">并通过工具条上的“运行”按键运行</span><span lang="EN-US">index.htm</span><span style="font-family: 宋体">，并输入相应的数据：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape
 id="_x0000_s1041" type="#_x0000_t75" style='width:468pt;height:327.75pt'>
 <v:imagedata src="in13_Logon_files/image033.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=437
src="in13_Logon_files/image034.jpg" v:shapes="_x0000_s1041"><![endif]></span></p>
<p class="MsoNormal"><span lang="EN-US">&nbsp;</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:328.5pt'>
 <v:imagedata src="in13_Logon_files/image035.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=438
src="in13_Logon_files/image036.jpg" v:shapes="_x0000_s1042"><![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_s1043" type="#_x0000_t75" style='width:468pt;height:328.5pt'>
 <v:imagedata src="in13_Logon_files/image037.png" o:title=""/>