📄 c++ builder 程序设计实用教程 - 7_4 sql在数据库中的使用 - 张晋 - 17xie.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<!-- saved from url=(0044)http://www.17xie.com/read.php?bid=303&seq=73 -->
<HTML
xmlns:o><HEAD><TITLE>C++ Builder 程序设计实用教程 - 7.4 SQL在数据库中的使用 - 张晋 - 17xie</TITLE>
<META http-equiv=Content-Type content="text/html; charset=utf-8"><LINK
href="C++ Builder 程序设计实用教程 - 7_4 SQL在数据库中的使用 - 张晋 - 17xie.files/17xie.css"
type=text/css rel=stylesheet><LINK
href="C++ Builder 程序设计实用教程 - 7_4 SQL在数据库中的使用 - 张晋 - 17xie.files/read.css"
type=text/css rel=stylesheet>
<SCRIPT src="C++ Builder 程序设计实用教程 - 7_4 SQL在数据库中的使用 - 张晋 - 17xie.files/core.js"
type=text/javascript></SCRIPT>
<SCRIPT
src="C++ Builder 程序设计实用教程 - 7_4 SQL在数据库中的使用 - 张晋 - 17xie.files/iframe.js"
type=text/javascript></SCRIPT>
<SCRIPT
src="C++ Builder 程序设计实用教程 - 7_4 SQL在数据库中的使用 - 张晋 - 17xie.files/dialog.js"
type=text/javascript></SCRIPT>
<SCRIPT src="C++ Builder 程序设计实用教程 - 7_4 SQL在数据库中的使用 - 张晋 - 17xie.files/ajax.js"
type=text/javascript></SCRIPT>
<SCRIPT
src="C++ Builder 程序设计实用教程 - 7_4 SQL在数据库中的使用 - 张晋 - 17xie.files/cookie.js"
type=text/javascript></SCRIPT>
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV id=m-body>
<DIV id=read-top>
<DIV style="FLOAT: left"><A href="http://www.17xie.com/" target=_blank><IMG
src="C++ Builder 程序设计实用教程 - 7_4 SQL在数据库中的使用 - 张晋 - 17xie.files/booklogo.gif"></A></DIV>
<DIV id=read-menu><NOBR><A
onclick="APIframe.open('快速登录','/m/user/poplogin.php',400,160)"
href="javascript:void(0)">登录</A> <A
onclick="APIframe.open('17xie-快速注册','/m/user/reg.php',480,460)"
href="javascript:void(0)">注册</A> | <A href="http://www.17xie.com/"
target=_blank>首页</A> <A href="http://www.17xie.com/bbs/index.php?ishow=y"
target=_blank>论坛</A> <A href="http://www.17xie.com/user.php"
target=_blank>会员中心</A> <A href="http://www.17xie.com/help/"
target=_blank>帮助</A></NOBR></DIV></DIV>
<DIV id=read-title>
<DIV
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FLOAT: left; PADDING-BOTTOM: 8px; PADDING-TOP: 8px"><A
href="http://www.17xie.com/" target=_blank>17xie</A> > <A
href="http://www.17xie.com/book.php?bid=303">C++ Builder 程序设计实用教程</A> > 7.4
SQL在数据库中的使用</DIV>
<DIV
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FLOAT: right; PADDING-BOTTOM: 0px; PADDING-TOP: 4px"><INPUT class=button-red8 onclick="window.location.href='/m/book/write.php?pid=5579'" type=button value=点击编辑本页></DIV></DIV>
<DIV id=read-mpage>
<DIV
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FLOAT: left; PADDING-BOTTOM: 8px; PADDING-TOP: 8px">背景：
<SPAN class=chcolor style="BACKGROUND-COLOR: #eeeeff"
onclick="chcolor('#eeeeff')"> </SPAN> <SPAN class=chcolor
style="BACKGROUND-COLOR: #ffeeee"
onclick="chcolor('#ffeeee')"> </SPAN> <SPAN class=chcolor
style="BACKGROUND-COLOR: #eeffee"
onclick="chcolor('#eeffee')"> </SPAN> <SPAN class=chcolor
style="BACKGROUND-COLOR: #ffffee"
onclick="chcolor('#ffffee')"> </SPAN> <SPAN class=chcolor
style="BACKGROUND-COLOR: #eeeeee"
onclick="chcolor('#eeeeee')"> </SPAN> <SPAN class=chcolor
style="BACKGROUND-COLOR: #ffffff"
onclick="chcolor('#ffffff')"> </SPAN> </DIV>
<DIV
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FLOAT: right; PADDING-BOTTOM: 0px; PADDING-TOP: 3px">
<TABLE>
<TBODY>
<TR>
<TD><NOBR><SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=1'">|<</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=72'">上一页</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=70'">70</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=71'">71</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=72'">72</SPAN>
<SPAN class=page-here
onclick="window.location.href='/read.php?bid=303&seq=73'">73</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=74'">74</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=75'">75</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=76'">76</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=74'">下一页</SPAN>
<SPAN class=page-nor
onclick="window.location.href='/read.php?bid=303&seq=105'">>|</SPAN></NOBR>.</TD>
<TD><INPUT class=input-text
onkeydown='if(window.event.keyCode==13)window.location.href="/read.php?bid=303&seq="+this.value'
style="WIDTH: 25px"></TD>
<TD style="PADDING-TOP: 2px">[共105页]</TD></TR></TBODY></TABLE></DIV></DIV>
<DIV id=read-conts style="BACKGROUND-COLOR: #ffffff"><SPAN
style="FONT-SIZE: 12px">本页字数：8801 最后更新：<NOBR>12天以前</NOBR>
<NOBR>[11-30 13:04]</NOBR> 由 <A onclick='$showu(1271,"张晋")'
href="javascript:void(0)">张晋</A> 编辑 <A class=aline
style="COLOR: red" href="http://www.17xie.com/m/user/inviter_reg.php"
target=_blank>注册17xie 一起来写书 实现您的出书梦想！</A></SPAN>
<HR>
<CENTER>
<DIV style="WIDTH: 547px; TEXT-ALIGN: left">
<DIV class=Section1 style="LAYOUT-GRID: 15.6pt none">
<H2 style="MARGIN-BOTTOM: 5pt"><A name=_Toc392384325></A><A
name=_Toc502915387></A><A name=_Toc392384321><SPAN
style="mso-bookmark: _Toc502915387"><SPAN
style="mso-bookmark: _Toc392384325"><SPAN lang=EN-US>7.4<SPAN
style="mso-spacerun: yes"> </SPAN>SQL</SPAN></SPAN></SPAN></A><SPAN
style="mso-bookmark: _Toc392384321"><SPAN
style="mso-bookmark: _Toc502915387"><SPAN
style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 楷体_GB2312; mso-ascii-font-family: 'Times New Roman'">在数据库中的使用</SPAN></SPAN></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc392384325"></SPAN></H2>
<P class=MsoNormalIndent><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">如果设计一个比较简单的数据库应用程序，利用</SPAN><SPAN
lang=EN-US>Table</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">控件就足够了，但是如果要求数据库的功能比较完善，比如在程序运行的过程中动态的显示数据库中各个域，那么就需要在数据库程序的设计过程中嵌入</SPAN><SPAN
lang=EN-US>SQL</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">语句了。</SPAN></SPAN></P>
<P class=MsoNormalIndent><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">在</SPAN><SPAN
lang=EN-US>CBuilder 5</SPAN></SPAN><SPAN
style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中，利用</SPAN><SPAN
lang=EN-US>Query</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">控件可以很方便的实现</SPAN><SPAN
lang=EN-US>SQL</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">语句与数据控件之间的连接操作，下面就以一个示例程序来说明在</SPAN><SPAN
lang=EN-US>CBuilder 5</SPAN></SPAN><SPAN
style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的数据库程序设计的过程中如何嵌入</SPAN><SPAN
lang=EN-US>SQL</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">语句，示例程序不但可以实现本章第二节示例中的全部功能，还可以在程序运行的过程中随时的编辑</SPAN><SPAN
lang=EN-US>SQL</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">语句，然后在程序中调用，程序设计的具体步骤如下所示。</SPAN></SPAN></P>
<H4><SPAN style="mso-bookmark: _Toc392384325"><SPAN
lang=EN-US>1</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 楷体_GB2312; mso-ascii-font-family: 'Times New Roman'">．开始工作</SPAN></SPAN></H4>
<P class=MsoNormalIndent><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">首先启动一个新的项目，选择菜单</SPAN><SPAN
lang=EN-US>File</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中的</SPAN><SPAN
lang=EN-US>New Application</SPAN></SPAN><SPAN
style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">项，在</SPAN><SPAN
lang=EN-US>CBuilder 5</SPAN></SPAN><SPAN
style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的集成开发环境中就会弹出一个新建的窗体，在控件工具栏上选择</SPAN><SPAN
lang=EN-US>System</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">选项后，在</SPAN><SPAN
lang=EN-US>Timer</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">控件的图标上双击鼠标的左键，这时空白的窗体上就会出现一个计时器控件，接着向窗体上添加</SPAN><SPAN
lang=EN-US>10</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">个</SPAN><SPAN
lang=EN-US>Button</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">控件、</SPAN><SPAN
lang=EN-US>1</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">个</SPAN><SPAN
lang=EN-US>DataSource</SPAN></SPAN><SPAN
style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">控件、</SPAN><SPAN
lang=EN-US>1</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">个</SPAN><SPAN
lang=EN-US>Query</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">控件、</SPAN><SPAN
lang=EN-US>1</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">个</SPAN><SPAN
lang=EN-US>DBGrid</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">控件和</SPAN><SPAN
lang=EN-US>1</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">个</SPAN><SPAN
lang=EN-US>Memo</SPAN></SPAN><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">控件，各个控件的功能将在后面分别的加以介绍，</SPAN></SPAN></P>
<P class=MsoNormalIndent><SPAN style="mso-bookmark: _Toc392384325"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">其中窗体以及窗体上各个控件的属性设置如下所示：</SPAN></SPAN></P>
<P class=a1><SPAN style="mso-bookmark: _Toc392384325"><SPAN lang=EN-US
style="FONT-FAMILY: 'Times New Roman'">object Form1:
TForm1<o:p></o:p></SPAN></SPAN></P>
<P class=a1><SPAN style="mso-bookmark: _Toc392384325"><SPAN lang=EN-US
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -