📄 jspyy.htm
字号:
mso-hansi-font-family:"Times New Roman"">使用</span><span lang="EN-US">JDBC
</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">来存取数据库中的资料</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">将一般常用于对数据库的建立、新增、删除、修改等功能，经由</span><span lang="EN-US">
JSP </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">语法，透过</span><span lang="EN-US">
JDBC </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">来达成数据库中资料的存取。</span></p>
<p class="MsoNormal"><b><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">安装说明</span><span lang="EN-US"><o:p>
</o:p>
</span></b></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">在执行</span><span lang="EN-US">
JSP </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">应用程序范例前，必须先执行相关的安装及设定。以下我们以使用</span></p>
<p class="MsoNormal"><span lang="EN-US">Red Hat Linux 6.0</span></p>
<p class="MsoNormal"><span lang="EN-US">JDK ( Java Develop Kit ) 1.2.2</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">或</span><span lang="EN-US"> JDK 1.1.7</span></p>
<p class="MsoNormal"><span lang="EN-US">Apache Web Server</span></p>
<p class="MsoNormal"><span lang="EN-US">Allaire JRun 2.3.3 (<a href="http://www.dbmaker.com.tw/linux/tech/#Anc-1"><span style="font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"">注一</span></a>)</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">为例，说明安装的程序，您可以依照下列的程序来操作。</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">安装</span><span lang="EN-US">
JRun</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">。您可以参考</span><span lang="EN-US">
DBMaker </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">光盘上的</span><span lang="EN-US">
jsp-startup.html </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">档案，那里有如何安装</span><span lang="EN-US">
JRun </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">详细的说明。</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">将</span><span lang="EN-US">
JRun </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">安装完成后，我们先做</span><span lang="EN-US">
dmjdbc.zip </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">这个档案的路径设定。请从</span><span lang="EN-US">
JRun </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">所在的目录中找到</span><span lang="EN-US">
jsm.properties </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">的档案，将下列路径加到</span><span lang="EN-US">
jsm.properties </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">档案</span><span lang="EN-US"> java.classpath </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">设定中</span></p>
<p class="MsoNormal"><span lang="EN-US"><DBMaker>/3.5/samples/driver/JDBC/dmjdbc.zip</span></p>
<p class="MsoNormal"><span lang="EN-US">*<DBMaker></span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">代表的是您</span><span lang="EN-US"> DBMaker </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">的安装路径</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">接下来您必须要确定在</span><span lang="EN-US">Java
</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">程序执行时，能够找到</span><span lang="EN-US">
libdmjdbc.so </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">这个档案。有下列两种方法可以达成：</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">修改</span><span lang="EN-US">
jsm.properties </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">档案中</span><span lang="EN-US">
java.exe </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">的设定</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">我们提供了一个</span> <span style="font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"">“</span><span lang="EN-US">dmjava</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">”</span><span lang="EN-US">
sample script</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">，您可以在</span><span lang="EN-US">
jsm.properties </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">档案中更改</span><span lang="EN-US">
java.exe </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">如下，以执行这个</span><span lang="EN-US">
sample script</span></p>
<p class="MsoNormal"><span lang="EN-US">java.exe = <DBMaker>/3.5/samples/JSP/dmjava</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">将</span><span lang="EN-US">
libdmjdbc.so </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">档案放置在指定目录下。</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">例如，假设您安装的是</span><span lang="EN-US">
JDK1.2.2</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">，</span><span lang="EN-US">libdmjdbc.so
</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">档案将放置在下列路径下</span></p>
<p class="MsoNormal"><span lang="EN-US"><JDK1.2.2>/jre/lib/i386/libdmjdbc.so</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">请确定安装完成的</span><span lang="EN-US">JRun
</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">是否支持</span><span lang="EN-US"> Sun
Microsystem </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">的</span><span lang="EN-US"> JSP1.0 spec.(<a href="http://www.dbmaker.com.tw/linux/tech/#Anc-2"><span style="font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"">注二</span></a>)</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">复制</span><span lang="EN-US">
<DBMaker>/3.5/samples/JSP/ </span><span style="font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"">路径下所有档案到您网页服务器的</span><span lang="EN-US">
html</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">目录下</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">例如，假设您的帐号为</span><span lang="EN-US">
tony</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">，则您需要在使用者根目录下建立一个</span><span lang="EN-US">
html </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">的目录，将档案复制到</span></p>
<p class="MsoNormal"><span lang="EN-US"><span style="mso-spacerun: yes"> </span>$
~tony/html/ </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">的目录下</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">激活</span><span lang="EN-US">
Apache web server</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">激活</span><span lang="EN-US">
Jrun</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">将</span><span lang="EN-US">
DBMaker </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">‘</span><span lang="EN-US">DBSAMPLE</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">’</span> <span style="font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"">数据库激活成为</span><span lang="EN-US">
client-server </span><span style="font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"">的模式</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">激活浏览器，输入范例的</span><span lang="EN-US">
URL </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">地址</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">例如，承上例，输入</span></p>
<p class="MsoNormal"><span lang="EN-US">http:// <MACHINE URL>/~tony/StartUp.jsp</span></p>
<p class="MsoNormal"><span lang="EN-US"><MACHINE URL> </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">指的是您网页服务器的</span><span lang="EN-US">
IP </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">地址</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">若您成功的开启网页，恭喜您，您已成功的完成安装程序，接下来，就请您依照网页上的指示，一步一步的操作范例程序。</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">范例展示</span></p>
<p class="MsoNormal"><b><span lang="EN-US">JSP </span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">基本卷标</span><span lang="EN-US">( tag )</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">介绍</span><span lang="EN-US"><o:p>
</o:p>
</span></b></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -