⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 in12_db_insert.htm

📁 struts开发实例
💻 HTM
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
 id="_x0000_s1031" type="#_x0000_t75" style='width:468pt;height:314.25pt'>
 <v:imagedata src="in12_db_insert_files/image013.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=419
src="in12_db_insert_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">&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_s1032" type="#_x0000_t75" style='width:469.5pt;height:315pt'>
 <v:imagedata src="in12_db_insert_files/image015.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=626 height=420
src="in12_db_insert_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 
数据库应用程序》中的步骤不同之处，这是本例的核心内容。从上图可看出，我们要做的仅仅是把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">(</span><span style="font-family: 宋体">省略</span><span lang="EN-US">)</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"><!--[if gte vml 1]><v:shape
 id="_x0000_s1033" type="#_x0000_t75" style='width:235.5pt;height:326.25pt'>
 <v:imagedata src="in12_db_insert_files/image017.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=314 height=435
src="in12_db_insert_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">JSPStudio</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">DbList.jsp</span><span style="font-family: 宋体">和</span><span lang="EN-US">DbList.jsp</span><span style="font-family: 宋体">和</span><b><span lang="EN-US" style="font-family:黑体">dbListInsert.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">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">&nbsp;</span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 黑体">[特别提示]与</span><span style="font-size: 9.0pt; font-family: 宋体">《如何在Struts 
数据库应用程序中实现记录的删除、更新及链接》的例子相比，本例多了一个文件dbListInsert.jsp，是</span><span style="font-family:黑体">添加记录页面文件。</span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-family: 黑体">&nbsp;</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"><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><b><span lang="EN-US" style="font-family:黑体">dbListInsert.jsp</span></b><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:326.25pt'>
 <v:imagedata src="in12_db_insert_files/image019.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=435
src="in12_db_insert_files/image020.jpg" v:shapes="_x0000_s1034"><![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_s1035" type="#_x0000_t75" style='width:468pt;height:326.25pt'>
 <v:imagedata src="in12_db_insert_files/image021.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=435
src="in12_db_insert_files/image022.jpg" v:shapes="_x0000_s1035"><![endif]></span></p>
<p class="MsoNormal"><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_s1036" type="#_x0000_t75" style='width:468pt;height:327pt'>
 <v:imagedata src="in12_db_insert_files/image023.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img border=0 width=624 height=436
src="in12_db_insert_files/image024.jpg" v:shapes="_x0000_s1036"><![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"><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 style="font-size: 9.0pt; font-family: 宋体">dbListInsert.jsp文件，是</span><span style="font-family:黑体">添加记录页面文件。</span></b></p>
<p class="MsoNormal" style="text-indent:21.0pt"><b>
<span style="font-size: 9.0pt; font-family: 宋体">dbListInsert.jsp文件：</span></b></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<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" style="text-indent:21.0pt">
<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" style="text-indent:21.0pt">
<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" style="text-indent:21.0pt">
<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" style="text-indent:21.0pt">
<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" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&nbsp;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;html:html &gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;head&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;title&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;/title&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;META http-equiv=Content-Type 
content=&quot;text/html; charset=gb2312&quot;&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&nbsp;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;/head&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;body bgColor=white&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;html:base /&gt;&nbsp; &lt;html:form&nbsp; 
method=&quot;post&quot; 
action=&quot;/dbListAction.do?action=insert&amp;search=search&amp;expression=NULL&quot;&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;table cellPadding=2 width=&quot;80%&quot; 
border=2&gt;&lt;tr&gt;&lt;td&gt;序号&lt;/td&gt;&lt;td&gt;&lt;html:text&nbsp; property='序号' /&gt;&lt;/td&gt;&lt;/tr&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;tr&gt;&lt;td&gt;姓名&lt;/td&gt;&lt;td&gt;&lt;html:text&nbsp; 
property='姓名' /&gt;&lt;/td&gt;&lt;/tr&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;tr&gt;&lt;td&gt;备注&lt;/td&gt;&lt;td&gt;&lt;html:text&nbsp; 
property='备注' /&gt;&lt;/td&gt;&lt;/tr&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;/table&gt;</span></p>
<p class="MsoNormal" style="text-indent:21.0pt">
<span lang="EN-US" style="font-family: 宋体">&lt;html:submit&nbsp; value=&quot;添加新记录&quot;&nbsp;&nbsp; /&gt;&nbsp;
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -