<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta name="generator" content="pdf2htmlEX">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css">
<link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css">
<link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/6269d9d60990925c04673862/raw.css">
<script src="https://static.pudn.com/base/js/compatibility.min.js"></script>
<script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script>
<script>
try{
pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});
}catch(e){}
</script>
<title></title>
</head>
<body>
<div id="sidebar" style="display: none">
<div id="outline">
</div>
</div>
<div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/6269d9d60990925c04673862/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">第<span class="ff2">4</span>章<span class="ff2"> <span class="_ _0"></span> </span>销售<span class="_ _0"></span>管理信息系统</div><div class="t m0 x2 h4 y3 ff3 fs1 fc0 sc0 ls0 ws0">PowerB<span class="_ _0"></span>uilder<span class="_ _0"></span><span class="ff1">是</span>Sybase<span class="ff1">公<span class="_ _0"></span>司推出的<span class="_ _0"></span>一套强大<span class="_ _0"></span>的数据库应<span class="_ _0"></span>用系统开<span class="_ _0"></span>发工具，<span class="_ _0"></span>它具有完<span class="_ _0"></span>整的</span></div><div class="t m0 x3 h4 y4 ff1 fs1 fc0 sc0 ls0 ws0">客户<span class="ff3">/</span>服<span class="_ _0"></span>务器体系结<span class="_ _0"></span>构、面向<span class="_ _0"></span>对象的应用<span class="_ _0"></span>程序开发<span class="_ _0"></span>方法以及可<span class="_ _0"></span>视化的开<span class="_ _0"></span>发环境<span class="_ _0"></span>，因而成<span class="_ _0"></span>为近</div><div class="t m0 x3 h4 y5 ff1 fs1 fc0 sc0 ls0 ws0">几年流<span class="_ _0"></span>行的数据库<span class="_ _0"></span>前端开发<span class="_ _0"></span>工具。目<span class="_ _0"></span>前，<span class="ff3">Power<span class="_ _0"></span>Builder<span class="_ _0"></span></span>已经广泛地<span class="_ _0"></span>应用于银<span class="_ _0"></span>行、电信、<span class="_ _0"></span>医疗</div><div class="t m0 x3 h4 y6 ff1 fs1 fc0 sc0 ls0 ws0">保健、<span class="_ _0"></span>保险等行业<span class="_ _0"></span>中，为这<span class="_ _0"></span>些行业的数<span class="_ _0"></span>据库应用<span class="_ _0"></span>提供了强大<span class="_ _0"></span>的开发功<span class="_ _0"></span>能。</div><div class="t m0 x2 h4 y7 ff1 fs1 fc0 sc0 ls0 ws0">销售管<span class="_ _0"></span>理信息系<span class="_ _0"></span>统作为信息<span class="_ _0"></span>管理系统<span class="_ _0"></span>的一个分支<span class="_ _0"></span>，已逐渐<span class="_ _0"></span>成为企业信<span class="_ _0"></span>息化建设<span class="_ _0"></span>的重要</div><div class="t m0 x3 h4 y8 ff1 fs1 fc0 sc0 ls0 ws0">组成部<span class="_ _0"></span>分。为企<span class="_ _0"></span>业管理分布<span class="_ _0"></span>在全国的<span class="_ _0"></span>销售网点提<span class="_ _0"></span>供了一个<span class="_ _0"></span>功能强大、<span class="_ _0"></span>安装部署<span class="_ _0"></span>方便、使用<span class="_ _0"></span>成</div><div class="t m0 x3 h4 y9 ff1 fs1 fc0 sc0 ls0 ws0">本低廉<span class="_ _0"></span>、操作简捷<span class="_ _0"></span>的实时销<span class="_ _0"></span>售管理系统<span class="_ _0"></span>。不仅能<span class="_ _0"></span>够促进销售<span class="_ _0"></span>业务的拓<span class="_ _0"></span>展，提高销<span class="_ _0"></span>售运作的<span class="_ _0"></span>效</div><div class="t m0 x3 h4 ya ff1 fs1 fc0 sc0 ls0 ws0">益，也<span class="_ _0"></span>为最终实现<span class="_ _0"></span>有效的“<span class="_ _0"></span>供应链管<span class="_ _0"></span>理”和更<span class="_ _0"></span>加广泛的<span class="_ _0"></span>“电子商<span class="_ _0"></span>务”奠定<span class="_ _0"></span>了基础。本<span class="_ _0"></span>章将以典<span class="_ _0"></span>型</div><div class="t m0 x3 h4 yb ff1 fs1 fc0 sc0 ls0 ws0">的销售<span class="_ _0"></span>管理信息系<span class="_ _0"></span>统为例，<span class="_ _0"></span>向读者详细<span class="_ _0"></span>讲述如何<span class="_ _0"></span>使用<span class="ff3">Po<span class="_ _0"></span>werBuilde<span class="_ _0"></span>r</span>开发企业<span class="_ _0"></span>销售管理<span class="_ _0"></span>信息系</div><div class="t m0 x3 h4 yc ff1 fs1 fc0 sc0 ls0 ws0">统。<span class="ff3"> </span></div><div class="t m0 x4 h5 yd ff4 fs2 fc0 sc0 ls0 ws0">4.1 P<span class="_ _0"></span>owerBuilde<span class="_ _0"></span>r<span class="ff1 sc1">对数据<span class="_ _0"></span>库开发的支<span class="_ _0"></span>持</span></div><div class="t m0 x2 h4 ye ff3 fs1 fc0 sc0 ls0 ws0">PowerB<span class="_ _0"></span>uilder<span class="_ _0"></span><span class="ff1">作为专业<span class="_ _0"></span>的数据库开<span class="_ _0"></span>发工具，以<span class="_ _0"></span>其开放的<span class="_ _0"></span>体系结构、<span class="_ _0"></span>简洁高效<span class="_ _0"></span>的集成开发</span></div><div class="t m0 x3 h4 yf ff1 fs1 fc0 sc0 ls0 ws0">环境、<span class="_ _0"></span>强大的数据<span class="_ _0"></span>窗口技术<span class="_ _0"></span>、良好的数<span class="_ _0"></span>据库访问<span class="_ _0"></span>能力和友好<span class="_ _0"></span>的用户界<span class="_ _0"></span>面，日益成<span class="_ _0"></span>为数据库<span class="_ _0"></span>开</div><div class="t m0 x3 h4 y10 ff1 fs1 fc0 sc0 ls0 ws0">发人员<span class="_ _0"></span>的得力助手<span class="_ _0"></span>。</div><div class="t m0 x2 h4 y11 ff3 fs1 fc0 sc0 ls0 ws0">PowerB<span class="_ _0"></span>uilder<span class="_ _0"></span><span class="ff1">支持各种<span class="_ _0"></span>常见的数据<span class="_ _0"></span>库，提供了<span class="_ _0"></span>多种数据<span class="_ _0"></span>库接口。<span class="_ _0"></span></span>PowerBui<span class="_ _0"></span>lder<span class="ff1">与数<span class="_ _0"></span>据库</span></div><div class="t m0 x3 h4 y12 ff1 fs1 fc0 sc0 ls0 ws0">的连接<span class="_ _0"></span>是建立在驱<span class="_ _0"></span>动程序之<span class="_ _0"></span>上的，可以<span class="_ _0"></span>通过<span class="ff3">ODB<span class="_ _0"></span>C</span>或<span class="ff3">JDBC<span class="_ _0"></span></span>接口来存储<span class="_ _0"></span>数据，也<span class="_ _0"></span>可以通过像</div><div class="t m0 x3 h4 y13 ff1 fs1 fc0 sc0 ls0 ws0">专用的<span class="_ _0"></span>数据库接口<span class="_ _0"></span>直接连接<span class="_ _0"></span>数据库。</div><div class="t m0 x2 h4 y14 ff1 fs1 fc0 sc0 ls0 ws0">数<span class="_ _1"></span>据<span class="_ _1"></span>窗<span class="_ _1"></span>口<span class="_ _2"></span><span class="ff3">(<span class="_ _1"></span>D<span class="_ _1"></span>a<span class="_ _0"></span>t<span class="_ _1"></span>a<span class="_ _1"></span>W<span class="_ _1"></span>i<span class="_ _1"></span>n<span class="_ _1"></span>d<span class="_ _1"></span>o<span class="_ _1"></span>w<span class="_ _0"></span>)<span class="_ _3"></span><span class="ff1">是<span class="_ _1"></span><span class="ff3">P<span class="_ _1"></span>o<span class="_ _1"></span>w<span class="_ _0"></span>e<span class="_ _1"></span>r<span class="_ _1"></span>B<span class="_ _1"></span>u<span class="_ _1"></span>i<span class="_ _1"></span>l<span class="_ _1"></span>d<span class="_ _0"></span>e<span class="_ _2"></span>r<span class="_ _4"></span><span class="ff1">中<span class="_ _1"></span>一<span class="_ _1"></span>个<span class="_ _1"></span>独<span class="_ _1"></span>特<span class="_ _1"></span>的<span class="_ _1"></span>对<span class="_ _1"></span>象<span class="_ _1"></span>，<span class="_ _1"></span>是<span class="_ _5"></span><span class="ff3">S<span class="_ _1"></span>y<span class="_ _1"></span>b<span class="_ _0"></span>a<span class="_ _1"></span>s<span class="_ _1"></span>e<span class="_ _6"></span><span class="ff1">的<span class="_ _1"></span>专<span class="_ _1"></span>利<span class="_ _1"></span>技<span class="_ _1"></span>术<span class="_ _1"></span>，</span></span></span></span></span></span></div><div class="t m0 x3 h4 y15 ff3 fs1 fc0 sc0 ls0 ws0">PowerBu<span class="_ _0"></span>ilder<span class="ff1">的<span class="_ _0"></span>成功在很大<span class="_ _0"></span>程度上归<span class="_ _0"></span>功于它。数<span class="_ _0"></span>据窗口的<span class="_ _0"></span>功能非常强<span class="_ _0"></span>大，它可<span class="_ _0"></span>以方便而快<span class="_ _0"></span>速</span></div><div class="t m0 x3 h4 y16 ff1 fs1 fc0 sc0 ls0 ws0">地处理<span class="_ _0"></span>数据。通过<span class="_ _0"></span>数据窗口<span class="_ _0"></span>，无需编写<span class="_ _0"></span>复杂的<span class="_ _0"></span><span class="ff3">SQL</span>语句，<span class="_ _0"></span>就可以实<span class="_ _0"></span>现对数据库<span class="_ _0"></span>的读写操<span class="_ _0"></span>作。</div><div class="t m0 x2 h4 y17 ff1 fs1 fc0 sc0 ls0 ws0">本节将<span class="_ _0"></span>对<span class="ff3">PowerB<span class="_ _0"></span>uilder<span class="_ _0"></span></span>与<span class="ff3">Access</span>数<span class="_ _0"></span>据库的连<span class="_ _0"></span>接，以及数<span class="_ _0"></span>据窗口技<span class="_ _0"></span>术的相关知<span class="_ _0"></span>识进行<span class="_ _0"></span><span class="ff3"> </span>介绍</div><div class="t m0 x3 h6 y18 ff2 fs3 fc0 sc0 ls0 ws0">4.1.1 <span class="_ _0"></span><span class="ff1">实现</span>Po<span class="_ _0"></span>werBuilder<span class="_ _0"></span><span class="ff1">访问</span>Acc<span class="_ _0"></span>ess<span class="ff1">数据库</span></div><div class="t m0 x2 h4 y19 ff3 fs1 fc0 sc0 ls0 ws0">PowerB<span class="_ _0"></span>uilder<span class="_ _0"></span><span class="ff1">与</span>Access<span class="_ _0"></span><span class="ff1">的连接方法<span class="_ _0"></span>可以通过<span class="_ _0"></span></span>ODBC<span class="ff1">调用<span class="_ _0"></span>软件来实<span class="_ _0"></span>现。下面将<span class="_ _0"></span>介绍如何<span class="_ _0"></span>实</span></div><div class="t m0 x3 h4 y1a ff1 fs1 fc0 sc0 ls0 ws0">现<span class="ff3">Power<span class="_ _0"></span>Builder<span class="_ _0"></span></span>访问<span class="ff3">Acc<span class="_ _0"></span>ess</span>中的“<span class="_ _0"></span>联系人管<span class="_ _0"></span>理”数据库。</div><div class="t m0 x2 h4 y1b ff1 fs1 fc0 sc0 ls0 ws0">因为是<span class="_ _0"></span>通过<span class="ff3">ODBC<span class="_ _0"></span></span>连接<span class="ff3">Acces<span class="_ _0"></span>s</span>数据库<span class="_ _0"></span>，则需要定<span class="_ _0"></span>义<span class="ff3">ODBC<span class="_ _0"></span></span>数据源，具<span class="_ _0"></span>体方法可<span class="_ _0"></span>参阅<span class="ff3">2.8.1</span></div><div class="t m0 x3 h4 y1c ff1 fs1 fc0 sc0 ls0 ws0">节内容<span class="_ _0"></span>，也可以通<span class="_ _0"></span>过<span class="ff3">Power<span class="_ _0"></span>Builder</span>自<span class="_ _0"></span>带的工具<span class="_ _0"></span>定义<span class="ff3">ODBC<span class="_ _0"></span></span>数据源。</div><div class="t m0 x2 h4 y1d ff3 fs1 fc0 sc0 ls0 ws0">(1) <span class="ff1">为<span class="_ _0"></span>“联系人<span class="_ _0"></span>管理”数<span class="_ _0"></span>据库注册<span class="_ _0"></span></span>ODBC<span class="ff1">数据源<span class="_ _0"></span>“联系人<span class="_ _0"></span>管理”，但<span class="_ _0"></span>只定义数<span class="_ _0"></span>据源是不够<span class="_ _0"></span>的，</span></div></div></div><div class="pi" data-data='{"ctm":[1.860806,0.000000,0.000000,1.860806,0.000000,0.000000]}'></div></div>
</body>
</html>
<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/6269d9d60990925c04673862/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x5 h7 y1e ff3 fs4 fc0 sc0 ls0 ws0">Access<span class="_ _7"> </span><span class="ff1">数据库项目案例<span class="ff5">导航</span></span></div><div class="t m0 x3 h8 y1f ff5 fs1 fc0 sc0 ls0 ws0">还<span class="ff1">要建<span class="_ _0"></span>立<span class="ff3">PowerBu<span class="_ _0"></span>ilder</span>的<span class="_ _0"></span>数据库</span>配置<span class="_ _0"></span>文<span class="ff1">件<span class="ff3">(P<span class="_ _0"></span>rofile)<span class="_ _0"></span></span>。</span></div><div class="t m0 x2 h8 y20 ff5 fs1 fc0 sc0 ls0 ws0">单击<span class="ff3">P<span class="_ _0"></span>owerBar<span class="ff1">上<span class="_ _0"></span>的</span>DB Pro<span class="_ _0"></span>file<span class="ff1">工具<span class="_ _0"></span></span></span>按钮<span class="_ _8"> </span><span class="ff1">，</span>打<span class="ff1">开<span class="_ _0"></span>如</span>图<span class="ff3">4-1</span>所<span class="_ _0"></span>示<span class="ff1">的对</span>话框<span class="_ _0"></span><span class="ff1">。在</span>树状<span class="_ _0"></span><span class="ff1">视</span>图列<span class="ff1">出</span></div><div class="t m0 x3 h8 y21 ff1 fs1 fc0 sc0 ls0 ws0">的数据<span class="_ _0"></span>库接口驱动<span class="_ _0"></span>程序中<span class="ff5">选<span class="_ _0"></span>择所</span>要连<span class="_ _0"></span>接的数据<span class="_ _0"></span>库<span class="ff5">类<span class="ff3">ODB O<span class="_ _0"></span>DBC</span></span>，<span class="ff5">右击<span class="_ _0"></span></span>，在<span class="ff5">弹</span>出<span class="_ _0"></span>的快捷<span class="ff5">菜<span class="_ _0"></span>单</span></div><div class="t m0 x3 h8 y22 ff1 fs1 fc0 sc0 ls0 ws0">中<span class="ff5">选择<span class="_ _0"></span><span class="ff3">New Profi<span class="_ _0"></span>le</span>命令<span class="_ _0"></span></span>。</div><div class="t m0 x6 h7 y23 ff5 fs4 fc0 sc0 ls0 ws0">图<span class="ff3">4-1 <span class="_ _0"></span>Database <span class="_ _0"></span>Porfile<span class="_ _0"></span><span class="ff1">对</span></span>话框</div><div class="t m0 x2 h8 y24 ff3 fs1 fc0 sc0 ls0 ws0">(2<span class="_ _0"></span>) <span class="ff5">打<span class="_ _0"></span><span class="ff1">开<span class="_ _0"></span></span></span>Da<span class="_ _0"></span>tab<span class="_ _0"></span>a<span class="_ _0"></span>se <span class="_ _0"></span>Pr<span class="_ _0"></span>of<span class="_ _0"></span>ile<span class="_ _0"></span> S<span class="_ _0"></span>et<span class="_ _0"></span>up<span class="_ _9"></span><span class="ff1">对<span class="ff5">话<span class="_ _0"></span>框<span class="_ _0"></span></span>，这<span class="_ _0"></span><span class="ff5">里</span>只<span class="_ _0"></span>有<span class="_ _0"></span><span class="ff3">C<span class="_ _0"></span>on<span class="_ _0"></span>ne<span class="_ _0"></span>ct<span class="_ _0"></span>ion<span class="_ _a"></span><span class="ff5">选<span class="_ _0"></span><span class="ff1">项</span>卡<span class="_ _0"></span><span class="ff1">中的<span class="_ _0"></span><span class="ff3">P<span class="_ _0"></span>ro<span class="_ _0"></span>fi<span class="_ _0"></span>le<span class="_ _0"></span> N<span class="_ _0"></span>ame<span class="_ _a"></span><span class="ff1">和</span></span></span></span></span></span></div><div class="t m0 x3 h8 y25 ff3 fs1 fc0 sc0 ls0 ws0">Data S<span class="_ _0"></span>ource<span class="ff5">两<span class="ff1">项<span class="_ _0"></span>参数是</span>必<span class="_ _0"></span>须<span class="ff1">要</span>指<span class="ff1">定<span class="_ _0"></span>的。</span></span>Profi<span class="_ _0"></span>le Name <span class="_ _0"></span><span class="ff5">指<span class="ff1">定</span>配置<span class="_ _0"></span>文<span class="ff1">件的</span>名<span class="_ _0"></span>称<span class="ff1">，这</span>里<span class="_ _0"></span>指<span class="ff1">定为“<span class="_ _0"></span>联系</span></span></div><div class="t m0 x3 h8 y26 ff1 fs1 fc0 sc0 ls0 ws0">人管理<span class="_ _0"></span>”<span class="ff5">；<span class="ff3">Data<span class="_ _0"></span> Source</span>指<span class="_ _0"></span></span>定对应的<span class="_ _0"></span><span class="ff3">ODBC</span>数据<span class="_ _0"></span>源，这<span class="ff5">里<span class="_ _0"></span>选择</span>前面定<span class="_ _0"></span>义好的<span class="ff3">ODB<span class="_ _0"></span>C</span>数据源“<span class="_ _0"></span>联系</div><div class="t m0 x3 h8 y27 ff1 fs1 fc0 sc0 ls0 ws0">人管理<span class="_ _0"></span>”<span class="ff5">；<span class="ff3">UserI<span class="_ _0"></span>d</span></span>和<span class="ff3">Passw<span class="_ _0"></span>ord</span>分<span class="ff5">别</span>用<span class="_ _0"></span>于<span class="ff5">指</span>定连<span class="_ _0"></span>接数据源<span class="_ _0"></span>的<span class="ff5">账</span>户<span class="ff5">名<span class="_ _0"></span></span>和口<span class="ff5">令</span>，它<span class="_ _0"></span><span class="ff5">们</span>是可<span class="ff5">选<span class="_ _0"></span></span>的，如<span class="ff5">图</span></div><div class="t m0 x3 h8 y28 ff3 fs1 fc0 sc0 ls0 ws0">4-2<span class="ff5">所示<span class="_ _0"></span><span class="ff1">。</span></span></div><div class="t m0 x2 h8 y29 ff3 fs1 fc0 sc0 ls0 ws0">(3) <span class="ff5">选<span class="_ _0"></span>择</span>Previe<span class="_ _0"></span>w<span class="ff5">选<span class="ff1">项</span>卡<span class="_ _0"></span><span class="ff1">，</span>测试<span class="ff1">连<span class="_ _0"></span>接是</span>否<span class="ff1">成功<span class="_ _0"></span>。设</span>置<span class="ff1">完<span class="_ _0"></span></span>毕后<span class="ff1">，</span>单<span class="_ _0"></span>击</span>OK<span class="ff5">按钮<span class="ff1">，<span class="_ _0"></span>数据库</span>配<span class="_ _0"></span>置</span></div><div class="t m0 x3 h8 y2a ff5 fs1 fc0 sc0 ls0 ws0">文<span class="_ _0"></span><span class="ff1">件<span class="_ _0"></span>的<span class="_ _0"></span>参<span class="_ _0"></span>数<span class="_ _0"></span>将<span class="_ _0"></span>存<span class="_ _0"></span>放<span class="_ _0"></span></span>到<span class="_ _1"></span><span class="ff3">W<span class="_ _0"></span>i<span class="_ _0"></span>n<span class="_ _0"></span>d<span class="_ _0"></span>ow<span class="_ _0"></span>s<span class="_ _b"></span><span class="ff1">的<span class="_ _0"></span>注<span class="_ _0"></span>册<span class="_ _0"></span><span class="ff5">表<span class="_ _0"></span></span>中<span class="_ _0"></span>，<span class="_ _0"></span><span class="ff5">同<span class="_ _0"></span></span>时<span class="_ _0"></span>，<span class="_ _0"></span><span class="ff5">配<span class="_ _0"></span>置<span class="_ _0"></span>文<span class="_ _1"></span></span>件<span class="_ _0"></span>的<span class="_ _0"></span><span class="ff5">名<span class="_ _0"></span>称<span class="_ _0"></span></span>也<span class="_ _0"></span><span class="ff5">会<span class="_ _0"></span></span>出<span class="_ _0"></span>现<span class="_ _0"></span>在<span class="_ _0"></span>数<span class="_ _0"></span>据<span class="_ _0"></span>库<span class="_ _0"></span><span class="ff5">类</span></span></span></div><div class="t m0 x3 h8 y2b ff3 fs1 fc0 sc0 ls0 ws0">ODB <span class="_ _0"></span>ODBC<span class="ff1">的目<span class="_ _0"></span><span class="ff5">录</span>中<span class="_ _0"></span>。<span class="ff5">然后<span class="_ _0"></span>右击该<span class="_ _0"></span>配置文<span class="_ _0"></span></span>件，在<span class="_ _0"></span><span class="ff5">弹</span>出<span class="_ _0"></span>的快捷<span class="_ _0"></span><span class="ff5">菜单</span>中<span class="_ _0"></span><span class="ff5">选择<span class="_ _2"></span></span></span>C<span class="_ _0"></span>onnec<span class="_ _0"></span>tion<span class="ff5">命令<span class="_ _0"></span><span class="ff1">，</span></span></div><div class="t m0 x3 h8 y2c ff3 fs1 fc0 sc0 ls0 ws0">PowerBu<span class="_ _0"></span>ilder<span class="ff1">将<span class="_ _0"></span>完成对“<span class="_ _0"></span>联系人管理<span class="_ _0"></span>”数据库<span class="_ _0"></span>的连接，如<span class="_ _0"></span><span class="ff5">图</span></span>4-3<span class="ff5">所<span class="_ _0"></span>示<span class="ff1">。</span></span></div><div class="t m0 x2 h8 y2d ff1 fs1 fc0 sc0 ls0 ws0">连接成<span class="_ _0"></span>功<span class="ff5">后</span>，就<span class="_ _0"></span>可以在<span class="ff3">Pow<span class="_ _0"></span>erBuilde<span class="_ _0"></span>r</span>的开发<span class="_ _0"></span>环境中访<span class="_ _0"></span>问“联系人<span class="_ _0"></span>管理”数据<span class="_ _0"></span>库了。如<span class="_ _0"></span><span class="ff5">果</span>要</div><div class="t m0 x3 h8 y2e ff1 fs1 fc0 sc0 ls0 ws0">在应用<span class="_ _0"></span>程序中连接<span class="_ _0"></span><span class="ff3">Access</span>数<span class="_ _0"></span>据库，可<span class="_ _0"></span>以直接在程<span class="_ _0"></span>序中编写<span class="_ _0"></span><span class="ff5">脚</span>本。<span class="ff5">同<span class="_ _0"></span>样</span>，可以<span class="_ _0"></span>使用<span class="ff3">ODBC<span class="_ _0"></span></span>接口</div><div class="t m0 x3 h8 y2f ff1 fs1 fc0 sc0 ls0 ws0">的语法<span class="_ _0"></span>，<span class="ff5">根</span>据上<span class="_ _0"></span>面<span class="ff5">所填</span>写的<span class="_ _0"></span><span class="ff5">配置</span>参数<span class="_ _0"></span>，在<span class="ff3">Appl<span class="_ _0"></span>ication<span class="_ _0"></span></span>的<span class="ff3">Open<span class="ff5">事</span></span>件<span class="_ _0"></span>中加<span class="ff5">入代<span class="_ _0"></span>码</span>。</div><div class="t m0 x2 h8 y30 ff5 fs1 fc0 sc0 ls0 ws0">若<span class="ff1">使用<span class="_ _0"></span><span class="ff3">ODBC</span>接口<span class="_ _0"></span>的语法连<span class="_ _0"></span>接数据库，<span class="_ _0"></span></span>代码<span class="ff1">如下<span class="_ _0"></span></span>：</div><div class="t m0 x7 h9 y31 ff3 fs4 fc0 sc0 ls0 ws0">// Prof<span class="_ _0"></span>ile <span class="ff1">联系<span class="_ _0"></span>人管理</span></div><div class="t m0 x7 ha y32 ff3 fs4 fc0 sc0 ls0 ws0">SQLCA.D<span class="_ _0"></span>BMS = "OD<span class="_ _0"></span>BC"</div><div class="t m0 x7 ha y33 ff3 fs4 fc0 sc0 ls0 ws0">SQLCA.A<span class="_ _0"></span>utoCommi<span class="_ _0"></span>t = Fals<span class="_ _0"></span>e</div><div class="t m0 x7 h9 y34 ff3 fs4 fc0 sc0 ls0 ws0">SQLCA.D<span class="_ _0"></span>BParm = <span class="_ _0"></span>"ConnectS<span class="_ _0"></span>tring='DSN<span class="_ _0"></span>=<span class="ff1">联系<span class="_ _0"></span>人管理</span>;<span class="_ _0"></span>UID=;PWD<span class="_ _0"></span>='"</div><div class="t m0 x7 h9 y35 ff3 fs4 fc0 sc0 ls0 ws0">//<span class="ff1">连接<span class="_ _0"></span>数据库</span></div><div class="t m0 x7 ha y36 ff3 fs4 fc0 sc0 ls0 ws0">Connec<span class="_ _0"></span>t;</div><div class="t m0 x7 ha y37 ff3 fs4 fc0 sc0 ls0 ws0">If sqlc<span class="_ _0"></span>a.sqlcode<<span class="_ _0"></span>>0 then</div></div><div class="t m0 x8 ha y38 ff3 fs4 fc0 sc0 ls0 ws0">• 1<span class="_ _c"></span>10 •</div></div><div class="pi" data-data='{"ctm":[1.860806,0.000000,0.000000,1.860806,0.000000,0.000000]}'></div></div>
<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/6269d9d60990925c04673862/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x9 h9 y39 ff1 fs4 fc0 sc0 ls0 ws0">第<span class="_ _7"> </span><span class="ff3">4<span class="_ _7"> </span></span>章<span class="ff3"> </span>销售管理信息系统</div><div class="t m0 x7 h7 y3a ff3 fs4 fc0 sc0 ls0 ws0"> Me<span class="_ _0"></span>ssagebox(<span class="_ _0"></span>'<span class="ff1">连接数据<span class="_ _0"></span>库<span class="ff5">失败</span></span>'<span class="_ _0"></span>,sqlca.sq<span class="_ _0"></span>lerrtext)</div><div class="t m0 x7 ha y3b ff3 fs4 fc0 sc0 ls0 ws0"> Ha<span class="_ _0"></span>lt Close</div><div class="t m0 x7 ha y3c ff3 fs4 fc0 sc0 ls0 ws0">Else</div><div class="t m0 x7 h7 y3d ff3 fs4 fc0 sc0 ls0 ws0"> Me<span class="_ _0"></span>ssagebox(<span class="_ _0"></span>'<span class="ff1">提<span class="ff5">示</span>信息<span class="_ _0"></span></span>', '<span class="ff1">连接<span class="_ _0"></span>数据库成<span class="_ _0"></span>功</span>')</div><div class="t m0 x7 h7 y3e ff3 fs4 fc0 sc0 ls0 ws0"> //<span class="_ _0"></span><span class="ff1">其<span class="ff5">他</span>操作，<span class="_ _0"></span>如<span class="ff5">打</span>开<span class="ff5">登<span class="_ _0"></span>录</span>窗口等</span></div><div class="t m0 x7 ha y3f ff3 fs4 fc0 sc0 ls0 ws0"> //Op<span class="_ _0"></span>en(w_log<span class="_ _0"></span>in)</div><div class="t m0 x7 ha y40 ff3 fs4 fc0 sc0 ls0 ws0">End if </div><div class="t m0 xa hb y41 ff3 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 xb h7 y42 ff5 fs4 fc0 sc0 ls0 ws0">图<span class="ff3">4-2<span class="_ _0"></span> Databa<span class="_ _0"></span>se Profil<span class="_ _0"></span>e Setup <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span></span>图<span class="_ _0"></span><span class="ff3">4-3 Data<span class="_ _0"></span>base Prof<span class="_ _0"></span>ile</span></div><div class="t m0 x3 h6 y43 ff2 fs3 fc0 sc0 ls0 ws0">4.1.2 <span class="_ _0"></span>PowerBuilde<span class="_ _0"></span>r<span class="ff1">的<span class="_ _0"></span>数据窗口技术</span></div><div class="t m0 x2 h4 y44 ff1 fs1 fc0 sc0 ls0 ws0">数据窗<span class="_ _0"></span>口<span class="ff3">(DataW<span class="_ _0"></span>indow)</span>是<span class="_ _0"></span><span class="ff3">PowerBu<span class="_ _0"></span>ilder</span>开<span class="_ _0"></span>发数据库应<span class="_ _0"></span>用程序最<span class="_ _0"></span>强有力的工<span class="_ _0"></span>具。数据<span class="_ _0"></span>窗口</div><div class="t m0 x3 h8 y2f ff1 fs1 fc0 sc0 ls0 ws0">对象是<span class="_ _0"></span><span class="ff3">PowerBuild<span class="_ _0"></span>er</span>数据<span class="_ _0"></span>窗口技术的<span class="_ _0"></span><span class="ff5">核心</span>内容<span class="_ _0"></span>，为<span class="ff5">检索<span class="_ _0"></span></span>、<span class="ff5">表</span>现和<span class="_ _0"></span>操作相关数<span class="_ _0"></span>据库或其<span class="_ _0"></span><span class="ff5">他</span>数据</div><div class="t m0 x3 h8 y45 ff1 fs1 fc0 sc0 ls0 ws0">源中的<span class="_ _0"></span>数据提供了<span class="_ _0"></span>非常方便<span class="_ _0"></span>的手<span class="ff5">段</span>。<span class="_ _0"></span>开发人员<span class="_ _0"></span>可以通过定<span class="_ _0"></span>义数据窗<span class="_ _0"></span>口对象来<span class="_ _0"></span><span class="ff5">指</span>定数据<span class="_ _0"></span>的<span class="ff5">显示</span></div><div class="t m0 x3 h8 y46 ff5 fs1 fc0 sc0 ls0 ws0">格式<span class="ff1">、<span class="_ _0"></span></span>表<span class="ff1">现</span>风格<span class="_ _0"></span><span class="ff1">以及其</span>他<span class="ff1">数<span class="_ _0"></span>据</span>属性<span class="ff1">，<span class="_ _0"></span>提高效</span>率<span class="_ _0"></span>并<span class="ff1">开发出<span class="_ _0"></span>高</span>质量<span class="ff1">的应<span class="_ _0"></span>用系统。</span></div><div class="t m0 x2 h4 y47 ff2 fs1 fc0 sc0 ls0 ws0">1. <span class="ff1">数据<span class="_ _0"></span>窗口对象</span></div><div class="t m0 x2 h8 y48 ff3 fs1 fc0 sc0 ls0 ws0">PowerB<span class="_ _0"></span>uilder<span class="_ _0"></span><span class="ff1">中的数据<span class="_ _0"></span>窗口对象<span class="ff5">主<span class="_ _0"></span></span>要完成<span class="ff5">两<span class="_ _0"></span></span>个方面的<span class="_ _0"></span>工作<span class="ff5">：</span>一<span class="_ _0"></span>方面，它处<span class="_ _0"></span>理应用程<span class="_ _0"></span>序<span class="ff5">所</span></span></div><div class="t m0 x3 h8 y49 ff1 fs1 fc0 sc0 ls0 ws0">需的<span class="ff5">底<span class="_ _0"></span>层</span>数据源<span class="_ _0"></span>，使开发人<span class="_ _0"></span>员能够方<span class="_ _0"></span>便地操作各<span class="_ _0"></span>种<span class="ff5">类</span>型<span class="_ _0"></span>的数据源，<span class="_ _0"></span>而不<span class="ff5">必</span>关<span class="_ _0"></span><span class="ff5">心</span>这些数<span class="_ _0"></span>据源的</div><div class="t m0 x3 h8 y4a ff5 fs1 fc0 sc0 ls0 ws0">底层<span class="ff1">调<span class="_ _0"></span>用，如数据<span class="_ _0"></span>源接口<span class="ff3">A<span class="_ _0"></span>PI</span>，</span>甚至<span class="_ _0"></span>较<span class="ff1">为高</span>级<span class="_ _0"></span><span class="ff1">的<span class="ff3">SQL</span>语句<span class="_ _0"></span>也可以</span>由<span class="_ _0"></span><span class="ff1">数据窗口<span class="_ _0"></span>对象自动<span class="_ _0"></span></span>生<span class="ff1">成</span>；</div><div class="t m0 x3 h8 y4b ff5 fs1 fc0 sc0 ls0 ws0">另<span class="ff1">一方<span class="_ _0"></span>面，数据窗<span class="_ _0"></span>口对象</span>控<span class="_ _0"></span>制着从<span class="ff1">数<span class="_ _0"></span>据源得</span>到<span class="_ _0"></span><span class="ff1">的结</span>果<span class="ff1">集<span class="_ _0"></span>的</span>显示<span class="ff1">，</span>负<span class="_ _0"></span>责<span class="ff1">和应用<span class="_ _0"></span>程序的用<span class="_ _0"></span>户之</span>间</div><div class="t m0 x3 h8 y4c ff1 fs1 fc0 sc0 ls0 ws0">的<span class="ff5">交互<span class="_ _0"></span></span>，使开发<span class="_ _0"></span>人员不<span class="ff5">必再<span class="_ _0"></span></span>在高<span class="ff5">水平<span class="_ _0"></span></span>的<span class="ff5">图形</span>界<span class="_ _0"></span>面设<span class="ff5">计</span>上<span class="_ _0"></span><span class="ff5">花费精</span>力。</div></div><div class="t m0 xc ha y38 ff3 fs4 fc0 sc0 ls0 ws0">• 1<span class="_ _c"></span>1<span class="_ _c"></span>1 •</div></div><div class="pi" data-data='{"ctm":[1.860806,0.000000,0.000000,1.860806,0.000000,0.000000]}'></div></div>
<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/6269d9d60990925c04673862/bg4.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x5 h7 y1e ff3 fs4 fc0 sc0 ls0 ws0">Access<span class="_ _7"> </span><span class="ff1">数据库项目案例<span class="ff5">导航</span></span></div><div class="t m0 x2 h8 y1f ff1 fs1 fc0 sc0 ls0 ws0">下面将<span class="_ _0"></span>使用<span class="ff3">Power<span class="_ _0"></span>Builder<span class="_ _0"></span></span>的数据窗口<span class="_ _0"></span><span class="ff5">创</span>建向<span class="ff5">导<span class="_ _0"></span></span>来<span class="ff5">创</span>建一<span class="_ _0"></span>个简<span class="ff5">单</span>的<span class="_ _0"></span>数据窗口对<span class="_ _0"></span>象。</div><div class="t m0 x2 h8 y4d ff3 fs1 fc0 sc0 ls0 ws0">(1) <span class="ff5">选<span class="_ _0"></span>择显示风<span class="_ _0"></span>格</span></div><div class="t m0 x2 h8 y21 ff5 fs1 fc0 sc0 ls0 ws0">由<span class="ff1">于数<span class="_ _0"></span>据窗口对象<span class="_ _0"></span></span>显示<span class="ff1">的是<span class="_ _0"></span>数据库</span>表<span class="_ _0"></span><span class="ff1">中的信息<span class="_ _0"></span>，在</span>创<span class="ff1">建<span class="_ _0"></span>数据窗口前<span class="_ _0"></span>对象，<span class="ff3">P<span class="_ _0"></span>owerBuider</span></span></div><div class="t m0 x3 h8 y22 ff1 fs1 fc0 sc0 ls0 ws0">要<span class="ff5">求</span>连<span class="_ _0"></span>接数据库。<span class="_ _0"></span><span class="ff5">假</span>设已经<span class="_ _0"></span>成功连接<span class="_ _0"></span>了数据库“<span class="_ _0"></span>联系人管<span class="_ _0"></span>理”<span class="ff3">(</span>注<span class="_ _0"></span><span class="ff5">意：</span>因为<span class="ff3">P<span class="_ _0"></span>owerBuile<span class="_ _0"></span>r</span>不支持</div><div class="t m0 x3 h8 y4e ff1 fs1 fc0 sc0 ls0 ws0">中<span class="ff5">文字<span class="_ _0"></span>段</span>，这<span class="ff5">里<span class="_ _0"></span></span>在数据库中<span class="_ _0"></span><span class="ff5">增添</span>了<span class="ff3">F<span class="_ _0"></span>riendInfo<span class="_ _0"></span><span class="ff5">表</span></span>，在下<span class="_ _0"></span>面的<span class="ff5">示</span>例<span class="_ _0"></span>中将使用<span class="ff5">该<span class="_ _0"></span>表</span>进行<span class="ff5">演<span class="_ _0"></span>示<span class="ff3">)</span></span>，接</div><div class="t m0 x3 h8 y4f ff1 fs1 fc0 sc0 ls0 ws0">下来为<span class="_ _0"></span>数据窗口对<span class="_ _0"></span>象<span class="ff5">选择所<span class="_ _0"></span></span>需的<span class="ff5">显示<span class="_ _0"></span>风格<span class="ff3">(Pre<span class="_ _0"></span>sentation <span class="_ _0"></span>Style)<span class="_ _0"></span></span></span>。</div><div class="t m0 x2 h8 y4 ff5 fs1 fc0 sc0 ls0 ws0">选择<span class="ff3">F<span class="_ _0"></span>ile | New<span class="_ _0"></span></span>命令<span class="ff1">，</span>弹<span class="_ _0"></span><span class="ff1">出<span class="ff3">New</span>对</span>话<span class="_ _0"></span>框<span class="ff1">，</span>选择<span class="_ _0"></span><span class="ff3">DataWindo<span class="_ _0"></span>w</span>选<span class="ff1">项</span>卡<span class="_ _0"></span><span class="ff1">，如</span>图<span class="ff3">4-4<span class="_ _0"></span></span>所示<span class="ff1">。</span></div><div class="t m0 xd h7 y50 ff5 fs4 fc0 sc0 ls0 ws0">图<span class="ff3">4-4<span class="_ _0"></span> </span>选择<span class="ff1">数<span class="_ _0"></span>据窗口的<span class="_ _0"></span></span>显示风格</div><div class="t m0 x2 h8 y28 ff1 fs1 fc0 sc0 ls0 ws0">在<span class="ff3">Pow<span class="_ _0"></span>erBuilder<span class="_ _0"></span></span>中，<span class="ff5">显<span class="_ _0"></span>示风格决</span>定<span class="_ _0"></span>了以<span class="ff5">什么<span class="_ _0"></span>样</span>的<span class="ff5">格式<span class="_ _0"></span>显示</span>数据<span class="_ _0"></span>窗口中的数<span class="_ _0"></span>据。<span class="ff5">图<span class="ff3">1<span class="_ _0"></span>-32</span>列</span></div><div class="t m0 x3 h8 y29 ff1 fs1 fc0 sc0 ls0 ws0">出了数<span class="_ _0"></span>据窗口对象<span class="_ _0"></span>可用的<span class="_ _0"></span><span class="ff3">1<span class="_ _0"></span>1</span>种<span class="ff5">显示风<span class="_ _0"></span>格：<span class="_ _0"></span><span class="ff3">Composit<span class="_ _0"></span>e</span></span>，<span class="ff3">Cros<span class="_ _0"></span>stab</span>，<span class="ff3">F<span class="_ _0"></span>reeform<span class="_ _0"></span></span>，<span class="ff3">Graph</span>，<span class="_ _0"></span><span class="ff3">Grid</span>，</div><div class="t m0 x3 h4 y2a ff3 fs1 fc0 sc0 ls0 ws0">Group<span class="_ _0"></span><span class="ff1">，</span>Label<span class="ff1">，<span class="_ _0"></span></span>N-Up<span class="ff1">，</span>O<span class="_ _0"></span>LE2.0<span class="ff1">，</span>Ri<span class="_ _0"></span>ch Text<span class="ff1">和<span class="_ _0"></span></span>Tabular<span class="_ _0"></span><span class="ff1">，具体介绍<span class="_ _0"></span>可参阅</span>P<span class="_ _0"></span>owerBuil<span class="_ _0"></span>der<span class="ff1">用户<span class="_ _0"></span>手册</span></div><div class="t m0 x3 h4 y2b ff1 fs1 fc0 sc0 ls0 ws0">中的相<span class="_ _0"></span>关内容。</div><div class="t m0 x2 h8 y2c ff1 fs1 fc0 sc0 ls0 ws0">这<span class="ff5">里选<span class="_ _0"></span>择<span class="ff3">Freeform<span class="_ _0"></span></span>样式<span class="ff3">(</span></span>因<span class="_ _0"></span>为这种<span class="ff5">风<span class="_ _0"></span>格</span>应用最为<span class="_ _0"></span><span class="ff5">普遍</span>。它<span class="_ _0"></span><span class="ff5">允许</span>设<span class="ff5">计<span class="_ _0"></span></span>者在数据<span class="_ _0"></span>窗口<span class="ff5">画板<span class="_ _0"></span></span>中</div><div class="t m0 x3 h8 y2d ff1 fs1 fc0 sc0 ls0 ws0">自<span class="ff5">由</span>地<span class="_ _0"></span>调整和<span class="ff5">移<span class="_ _0"></span></span>动<span class="ff5">字段</span>对象<span class="_ _0"></span>和<span class="ff5">字段标<span class="_ _0"></span>签</span>对象<span class="ff3">)</span>，<span class="_ _0"></span><span class="ff5">然后单击<span class="_ _0"></span><span class="ff3">OK</span>按钮</span>。<span class="_ _0"></span><span class="ff5">值</span>得注<span class="ff5">意<span class="_ _0"></span></span>的是，如<span class="ff5">果<span class="_ _0"></span>没</span>有</div><div class="t m0 x3 h8 y2e ff1 fs1 fc0 sc0 ls0 ws0">建<span class="_ _1"></span>立<span class="_ _5"></span><span class="ff5">并<span class="_ _1"></span>打<span class="_ _5"></span></span>开<span class="_ _1"></span><span class="ff5">任<span class="_ _5"></span></span>何<span class="_ _1"></span>一<span class="_ _5"></span>个<span class="_ _1"></span>工<span class="_ _2"></span>作<span class="_ _2"></span><span class="ff5">区<span class="_ _5"> </span><span class="ff3">(<span class="_ _2"> </span>W<span class="_ _2"></span>o<span class="_ _2"></span>r<span class="_ _1"></span>k<span class="_ _2"> </span>s<span class="_ _2"> </span>p<span class="_ _2"></span>a<span class="_ _2"></span>c<span class="_ _2"></span>e<span class="_ _2"></span>)<span class="_ _d"></span><span class="ff1">，<span class="_ _1"></span>或<span class="_ _5"></span>者<span class="_ _1"></span>工<span class="_ _2"></span>作<span class="_ _2"></span><span class="ff5">区<span class="_ _5"></span></span>中<span class="_ _1"></span><span class="ff5">没<span class="_ _5"></span></span>有<span class="_ _1"></span><span class="ff5">任<span class="_ _5"></span></span>何<span class="_ _1"></span>容<span class="_ _5"></span><span class="ff5">纳<span class="_ _1"></span>该<span class="_ _5"></span></span>数<span class="_ _1"></span>据<span class="_ _5"></span>窗<span class="_ _1"></span>口<span class="_ _5"></span>的</span></span></span></div><div class="t m0 x3 h8 y2f ff3 fs1 fc0 sc0 ls0 ws0">PowerBu<span class="_ _0"></span>ilder<span class="ff1">库<span class="_ _0"></span>，<span class="ff5">那么该<span class="_ _0"></span>按钮</span>是不可<span class="_ _0"></span>用的。</span></div><div class="t m0 x2 h8 y30 ff3 fs1 fc0 sc0 ls0 ws0">(2) <span class="ff5">选<span class="_ _0"></span>择<span class="ff1">数据源</span></span></div><div class="t m0 x2 h8 y46 ff1 fs1 fc0 sc0 ls0 ws0">接下来<span class="_ _0"></span><span class="ff3">PowerBu<span class="_ _0"></span>ilder<span class="ff5">会<span class="_ _0"></span>弹</span></span>出<span class="ff3">Choos<span class="_ _0"></span>e Data Sou<span class="_ _0"></span>rce for Fr<span class="_ _0"></span>eeform Da<span class="_ _0"></span>taWindow<span class="_ _0"></span></span>对<span class="_ _0"></span><span class="ff5">话框</span>，其中<span class="_ _0"></span><span class="ff5">列</span></div><div class="t m0 x3 h8 y51 ff1 fs1 fc0 sc0 ls0 ws0">出<span class="_ _5"> </span>了<span class="_ _7"> </span><span class="ff3">5<span class="_ _5"> </span></span>种<span class="_ _5"> </span><span class="ff5">类<span class="_ _7"> </span></span>型<span class="_ _5"></span>的<span class="_ _5"> </span>数<span class="_ _7"> </span>据<span class="_ _5"></span>源<span class="_ _5"> </span>，<span class="_ _7"> </span>分<span class="_ _5"> </span><span class="ff5">别<span class="_ _7"> </span></span>是<span class="_ _7"> </span><span class="ff3">Q<span class="_ _5"> </span>u<span class="_ _5"> </span>i<span class="_ _7"> </span>c<span class="_ _2"> </span>k<span class="_ _7"> </span> <span class="_ _2"> </span>S<span class="_ _7"> </span>e<span class="_ _2"> </span>l<span class="_ _7"> </span>e<span class="_ _2"></span>c<span class="_ _7"> </span>t<span class="_ _e"></span><span class="ff1">，<span class="_ _5"> </span><span class="ff3">S<span class="_ _7"> </span>Q<span class="_ _2"></span>L<span class="_ _7"> </span> <span class="_ _2"></span>S<span class="_ _f"> </span>e<span class="_ _5"> </span>l<span class="_ _f"> </span>e<span class="_ _5"> </span>c<span class="_ _f"> </span>t<span class="_ _10"></span><span class="ff1">，<span class="_ _5"> </span><span class="ff3">Q<span class="_ _f"> </span>u<span class="_ _5"> </span>e<span class="_ _f"> </span>r<span class="_ _5"> </span>y<span class="_ _11"></span><span class="ff1">，<span class="_ _5"> </span><span class="ff3">E<span class="_ _f"> </span>x<span class="_ _5"> </span>t<span class="_ _f"> </span>e<span class="_ _5"> </span>r<span class="_ _f"> </span>n<span class="_ _5"> </span>a<span class="_ _f"> </span>l<span class="_ _d"></span><span class="ff1">，<span class="_ _f"> </span><span class="ff3">S<span class="_ _5"> </span>t<span class="_ _f"> </span>o<span class="_ _5"> </span>r<span class="_ _f"> </span>e<span class="_ _5"> </span>d</span></span></span></span></span></span></span></span></span></div><div class="t m0 x3 h8 y52 ff3 fs1 fc0 sc0 ls0 ws0">Procedu<span class="_ _0"></span>re<span class="ff1">，如<span class="ff5">图<span class="_ _0"></span></span></span>4-5<span class="ff5">所示<span class="ff1">。</span></span></div></div><div class="t m0 x8 ha y38 ff3 fs4 fc0 sc0 ls0 ws0">• 1<span class="_ _c"></span>12 •</div></div><div class="pi" data-data='{"ctm":[1.860806,0.000000,0.000000,1.860806,0.000000,0.000000]}'></div></div>
<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/6269d9d60990925c04673862/bg5.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x9 h9 y39 ff1 fs4 fc0 sc0 ls0 ws0">第<span class="_ _f"> </span><span class="ff3">4<span class="_"> </span></span>章<span class="ff3"> <span class="_ _c"></span> <span class="ff1">销售管理信息系统</span></span></div><div class="t m0 xe h7 y53 ff5 fs4 fc0 sc0 ls0 ws0">图<span class="ff3">4-5 <span class="_ _0"></span></span>选择<span class="ff1">数据<span class="_ _0"></span>窗口的数据<span class="_ _0"></span>源</span></div><div class="t m0 x2 h8 y54 ff5 fs1 fc0 sc0 ls0 ws0">选择<span class="ff3">Q<span class="_ _0"></span>uick Sele<span class="_ _0"></span>ct</span>类<span class="ff1">型<span class="_ _0"></span>的数据源。<span class="_ _0"></span><span class="ff3">Quick S<span class="_ _0"></span>elect</span>数据<span class="_ _0"></span>源是最简<span class="_ _0"></span></span>单<span class="ff1">、也是<span class="_ _0"></span>最常用的数<span class="_ _0"></span>据源，</span></div><div class="t m0 x3 h8 y55 ff5 fs1 fc0 sc0 ls0 ws0">该<span class="_ _0"></span><span class="ff1">数<span class="_ _0"></span>据源<span class="_ _0"></span></span>所<span class="_ _0"></span><span class="ff1">对<span class="_ _0"></span>应<span class="_ _0"></span>的<span class="_ _0"></span><span class="ff3">S<span class="_ _0"></span>QL<span class="_ _0"></span> <span class="_ _0"></span>Se<span class="_ _0"></span>l<span class="_ _0"></span>ec<span class="_ _0"></span>t<span class="_ _b"></span><span class="ff1">语<span class="_ _0"></span>句完<span class="_ _0"></span>全<span class="_ _0"></span>是<span class="_ _0"></span><span class="ff5">由<span class="_ _0"></span><span class="ff3">P<span class="_ _0"></span>o<span class="_ _0"></span>we<span class="_ _0"></span>r<span class="_ _0"></span>Bu<span class="_ _0"></span>i<span class="_ _0"></span>ld<span class="_ _0"></span>e<span class="_ _0"></span>r<span class="_ _6"></span><span class="ff1">自<span class="_ _0"></span>动<span class="_ _0"></span>、<span class="_ _0"></span>快速<span class="_ _0"></span><span class="ff5">生<span class="_ _0"></span></span>成<span class="_ _0"></span>的<span class="_ _0"></span>。<span class="_ _0"></span><span class="ff3">Q<span class="_ _0"></span>u<span class="_ _0"></span>ic<span class="_ _0"></span>k<span class="_ _0"></span> S<span class="_ _0"></span>e<span class="_ _0"></span>le<span class="_ _0"></span>c<span class="_ _0"></span>t</span></span></span></span></span></span></span></div><div class="t m0 x3 h8 y56 ff1 fs1 fc0 sc0 ls0 ws0">数据源<span class="_ _0"></span>中的数据可<span class="_ _0"></span>以来自一<span class="_ _0"></span>个数据<span class="ff5">表<span class="_ _0"></span></span>，或通过<span class="_ _0"></span><span class="ff5">外</span>部关<span class="ff5">键<span class="_ _0"></span>字</span>关联的多<span class="_ _0"></span>个数据<span class="ff5">表<span class="_ _0"></span></span>。</div><div class="t m0 x2 h8 y57 ff1 fs1 fc0 sc0 ls0 ws0">如<span class="ff5">果想<span class="_ _0"></span></span>在<span class="ff5">预览</span>数<span class="_ _0"></span>据窗口对象<span class="_ _0"></span>或<span class="ff5">打</span>开<span class="ff5">预<span class="_ _0"></span>览</span>视<span class="ff5">图</span>时<span class="_ _0"></span>，<span class="ff5">让</span>数据<span class="_ _0"></span>窗口对象自<span class="_ _0"></span>动<span class="ff5">从</span>数据<span class="_ _0"></span>源中重<span class="ff5">新</span></div><div class="t m0 x3 h8 y58 ff5 fs1 fc0 sc0 ls0 ws0">获取<span class="ff1">数<span class="_ _0"></span>据，可以<span class="_ _0"></span></span>选<span class="ff1">中<span class="ff3">Retr<span class="_ _0"></span>ieve on Pre<span class="_ _0"></span>view</span>复<span class="_ _0"></span></span>选框<span class="ff1">。</span></div><div class="t m0 x2 h8 y59 ff3 fs1 fc0 sc0 ls0 ws0">(3) <span class="ff5">选<span class="_ _0"></span>择并<span class="ff1">设</span>计<span class="_ _0"></span><span class="ff1">数据库</span>表<span class="_ _0"></span><span class="ff1">中的</span>字段</span></div><div class="t m0 x2 h8 y5a ff5 fs1 fc0 sc0 ls0 ws0">选<span class="ff1">中<span class="ff3">Qu<span class="_ _0"></span>ick Select<span class="_ _0"></span></span></span>后<span class="ff1">，</span>单<span class="_ _0"></span>击<span class="ff3">Next</span>按钮<span class="_ _0"></span><span class="ff1">，<span class="ff3">Powe<span class="_ _0"></span>rBuilder<span class="_ _0"></span></span></span>会弹<span class="ff1">出<span class="ff3">Qu<span class="_ _0"></span>ick Select<span class="_ _0"></span></span>对</span>话框<span class="_ _0"></span><span class="ff1">，如</span>图<span class="ff3">4-<span class="_ _0"></span>6</span></div><div class="t m0 x3 h8 y5b ff5 fs1 fc0 sc0 ls0 ws0">所示<span class="ff1">。<span class="_ _0"></span>在这</span>里<span class="ff1">，<span class="_ _0"></span><span class="ff3">PowerBuilde<span class="_ _0"></span>r</span></span>会指导<span class="_ _0"></span><span class="ff1">开发者</span>选<span class="_ _0"></span>择并<span class="ff1">设</span>计<span class="_ _0"></span><span class="ff1">数据库</span>表<span class="_ _0"></span><span class="ff1">中的</span>字段<span class="ff1">。</span></div><div class="t m0 xf h7 y5c ff5 fs4 fc0 sc0 ls0 ws0">图<span class="ff3">4-6<span class="_ _0"></span> </span>选择并<span class="_ _0"></span><span class="ff1">设</span>计<span class="ff1">数据库<span class="_ _0"></span></span>表<span class="ff1">中的</span>字<span class="_ _0"></span>段</div><div class="t m0 x2 h8 y5d ff1 fs1 fc0 sc0 ls0 ws0">在对<span class="ff5">话<span class="_ _0"></span>框左</span>上<span class="ff5">侧<span class="_ _0"></span></span>的<span class="ff3">Table<span class="_ _0"></span><span class="ff5">列表</span></span>中，<span class="_ _0"></span><span class="ff5">列</span>出了<span class="ff5">所</span>连<span class="_ _0"></span>接上的数<span class="_ _0"></span>据库“联系<span class="_ _0"></span>人管理”中<span class="_ _0"></span>的<span class="ff5">表</span>。而<span class="_ _0"></span><span class="ff5">右</span>上</div><div class="t m0 x3 h8 y5e ff5 fs1 fc0 sc0 ls0 ws0">侧<span class="ff1">的<span class="ff3">C<span class="_ _0"></span>olumns</span></span>列<span class="_ _0"></span>表<span class="ff1">用于</span>显示<span class="_ _0"></span>所选<span class="ff1">中的<span class="_ _0"></span>数据库</span>表<span class="_ _0"></span><span class="ff1">中的</span>字段<span class="_ _0"></span><span class="ff1">。这</span>里选<span class="ff1">中<span class="_ _0"></span>数据</span>表<span class="_ _2"></span><span class="ff3">Frie<span class="_ _0"></span>ndInfo<span class="ff1">，<span class="_ _0"></span></span></span>单击</div><div class="t m0 x3 h8 y5f ff3 fs1 fc0 sc0 ls0 ws0">Add Al<span class="_ _0"></span>l<span class="ff5">按钮<span class="ff1">，<span class="_ _0"></span>将</span>表<span class="ff1">中</span>所<span class="ff1">有<span class="_ _0"></span>的</span>字段添<span class="_ _0"></span><span class="ff1">加</span>到<span class="ff1">对</span>话<span class="_ _0"></span>框底<span class="ff1">部的<span class="_ _0"></span></span>列表<span class="ff1">中。在<span class="_ _0"></span></span>该列表<span class="ff1">中<span class="_ _0"></span>，可以定<span class="_ _0"></span>义</span>字段</span></div><div class="t m0 x3 h8 y60 ff1 fs1 fc0 sc0 ls0 ws0">的<span class="ff5">排</span>序<span class="_ _0"></span>和<span class="ff5">选择条<span class="_ _0"></span></span>件。</div></div><div class="t m0 xc ha y38 ff3 fs4 fc0 sc0 ls0 ws0">• 1<span class="_ _c"></span>13 •</div></div><div class="pi" data-data='{"ctm":[1.860806,0.000000,0.000000,1.860806,0.000000,0.000000]}'></div></div>
chap04 销售管理信息系统
