📄 jb4-1-13.htm
字号:
color="#FF0000">注意</font>：一些例程只能运行于企业版中。</span></p>
<p><span
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;
font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman";mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;
mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">要创建数据库应用程序，必须先连接数据库向</span><span
lang="EN-US"
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:"Times New Roman";
mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;mso-ansi-language:EN-US;
mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">DataSet</span><span
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA">组件提供数据。</span><span lang="EN-US"
style="font-size:
10.5pt;mso-bidi-font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
宋体;mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;
mso-bidi-language:AR-SA">Retrieving data forthe tutorials</span><span
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA">（教程例程的数据返回）一部分内容中建立了一个查询，后面的每一个数据库教程都要使用它。下面列出的附加数据库功能选项（过滤，排序和定位数据）可以以任意组合来使用，例如，可以选择将姓是以</span><span
lang="EN-US"
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:"Times New Roman";
mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;mso-ansi-language:EN-US;
mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">M</span><span
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA">和</span><span lang="EN-US"
style="font-size:10.5pt;
mso-bidi-font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
宋体;mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;
mso-bidi-language:AR-SA">Z</span><span
style="font-size:10.5pt;mso-bidi-font-size:
12.0pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman";mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;
mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">开头的所有雇员暂时隐藏。</span></p>
<ul>
<li>
<p class="MsoNormal" style="margin-left:21.0pt;text-indent:-21.0pt;mso-char-indent-count:
-2.0;mso-char-indent-size:10.5pt"><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">过滤数据：过滤</span><span lang="EN-US">DataSet</span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">组件中暂时隐藏的行。</span></li>
<li>
<p class="MsoNormal" style="margin-left:21.0pt;text-indent:-21.0pt;mso-char-indent-count:
-2.0;mso-char-indent-size:10.5pt"><span
style="font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"">排序数据：排序改变一个已过滤或未过滤的</span><span
lang="EN-US">DataSet</span><span
style="font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"">组件次序。</span></li>
<li><span
style="mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"><span
style="mso-bidi-font-size: 12.0pt; font-family: 宋体; mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman; mso-bidi-font-family: Times New Roman; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">定位数据：在已过滤或未过滤的</span><span
lang="EN-US"
style="mso-bidi-font-size: 12.0pt; font-family: Times New Roman; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">DataSet</span><span
style="mso-bidi-font-size: 12.0pt; font-family: 宋体; mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman; mso-bidi-font-family: Times New Roman; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">组件中定位光标。</span></span></li>
</ul>
<hr>
<p class="MsoNormal" style="margin-left:21.0pt;text-indent:-21.0pt;mso-char-indent-count:
-2.0;mso-char-indent-size:10.5pt"><span
style="font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman""><font size="3" color="#000080"><b>教程例程的数据返回</b></font></span><span
style="mso-tab-count: 1; font-size: 10.5pt; mso-bidi-font-size: 12.0pt; font-family: Times New Roman; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA"
lang="EN-US"> </span></p>
<p><span
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;
font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman";mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;
mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">本主题提供了设置一个基本的数据库应用程序的步骤，该应用程序可在本章中教程中使用。我们将要在教程应用查询</span><span
lang="EN-US"
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:"Times New Roman";
mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;mso-ansi-language:EN-US;
mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">SELECT * FROM EMPLOYEE</span><span
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA">。这条</span><span lang="EN-US"
style="font-size:
10.5pt;mso-bidi-font-size:12.0pt;font-family:"Times New Roman";mso-fareast-font-family:
宋体;mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;
mso-bidi-language:AR-SA">SQL</span><span
style="font-size:10.5pt;mso-bidi-font-size:
12.0pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman";mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;
mso-ansi-language:EN-US;mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">语句选择表</span><span lang="EN-US"
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:"Times New Roman";
mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;mso-ansi-language:EN-US;
mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">EMPLOYEE</span><span
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA">中所有行，这些行包括在例程</span><span lang="EN-US"
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:"Times New Roman";
mso-fareast-font-family:宋体;mso-font-kerning:1.0pt;mso-ansi-language:EN-US;
mso-fareast-language:ZH-CN;mso-bidi-language:AR-SA">JdataStore</span><span
style="font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-bidi-font-family:
"Times New Roman";mso-font-kerning:1.0pt;mso-ansi-language:EN-US;mso-fareast-language:
ZH-CN;mso-bidi-language:AR-SA">中。</span></p>
<p class="MsoNormal" style="margin-left:21.0pt;text-indent:-21.0pt;mso-char-indent-count:
-2.0;mso-char-indent-size:10.5pt"><span
style="font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"">要结合教程设置应用程序:</span></p>
<p class="MsoNormal" style="margin-left:39.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo1;
tab-stops:list 39.0pt"><span lang="EN-US">1、<span style="font:7.0pt "Times New Roman""> </span></span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">关闭所有工程。（选择菜单项</span><span lang="EN-US">File | Close Project</span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">）</span></p>
<p class="MsoNormal" style="margin-left:39.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo1;
tab-stops:list 39.0pt"><span lang="EN-US">2、<span style="font:7.0pt "Times New Roman""> </span></span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">选择菜单项</span><span lang="EN-US">File | New Project</span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">。</span></p>
<p class="MsoNormal" style="margin-left:39.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo1;
tab-stops:list 39.0pt"><span lang="EN-US">3、<span style="font:7.0pt "Times New Roman""> </span></span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">在</span><span lang="EN-US">Project Wizard</span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">（工程向导）中输入工程名和定位。再点击</span><span lang="EN-US">Finish</span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">按纽。</span></p>
<p class="MsoNormal" style="margin-left:39.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo1;
tab-stops:list 39.0pt"><span lang="EN-US">4、<span style="font:7.0pt "Times New Roman""> </span></span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">选择菜单项</span><span lang="EN-US">File | New</span><span
style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -