| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> delphi >> yong Delphi kai fa shu ju ku cheng xu jing yan san ze

yong Delphi kai fa shu ju ku cheng xu jing yan san ze

2008-06-01 01:59:02 编辑來源:互联网 评论
 
 
 
本文为【用Delphi 开发数据库程序经验三则】的拼音翻译版
  1. jian li lin shi biao
  shu ju shu ru shi kai fa shu ju ku cheng xu de bi ran huan jie 。 zai Client/Server jie gou zhong , ke hu duan ke neng yao shu ru yi pi shu ju hou , zai xiang fu wu qi de hou tai shu ju ku ti jiao , zhe jiu xu yao zai ben di ( ke hu duan ) jian li lin shi shu ju biao lai cun chu yong hu shu ru de shu ju , dai ti jiao hou , qing chu ben di biao shu ju 。
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  zhe zhong fang fa de hao chu shi : ti gao shu ru xiao lv , jian xiao wang luo fu dan 。
  you yu yong hu yi ci shu ru de shu ju liang yi ban qing kuang xia jiao xiao ( bu hui chao guo ji bai tiao ji lu ), suo yi lin shi biao ke yi jian li zai nei cun zhong , zhe yang chu li su du jiao kuai 。
  fang fa 1: shi yong cha xun kong jian (TQuery)
  di 1 bu : zai chuang ti shang fang shang cha xun kong jian (TQuery), she zhi hao suo lian jie de shu ju biao 。
  di 2 bu : shi TQuery. CachedUpdates=True;
  TQuery. RequestLive=True
  di 3 bu : zai yuan you de SQL yu ju hou jia ru yi tiao Where zi yu ju , yao qiu jia ru zhe tiao Where zi yu ju hou SQL cha xun jie guo wei kong 。
  li ru :
  SELECT Biolife.″Species No″, Category, Common_Name, Biolife.″Species Name″, Biolife.″Length (cm)″, Length_In, Notes, Graphic
  FROM ″biolife.db″ Biolife
  where Biolife.Category=′A′ and Biolife.Category=′B′
  zhe yang lin shi biao jiu jian li wan cheng le 。
  fang fa 2: shi yong dai ma chuang jian lin shi biao
  dai ma ru xia :
  function CreateTableInMemory(const AFieldDefs:TFieldDefs):TDataSet;
  var
  TempTable:TClientDataSet;
  begin
  TempTable:=nil;
  Result:=nil;
  if AFieldDefs$#@60;$#@62;nil then
  begin
  try
  TempTable:=TClientDataSet.Create(application);
  TempTable.FieldDefs.Assign(AFieldDefs);
  TempTable.CreateDataSet;
  Result:=(TempTable as TDataSet);
  Except
  if TempTable$#@60;$#@62;nil then
  TempTable.Free;
  Result:=nil;
  raise;
   end
  end
  end;
  zai cheng xu zhong an ru xia fang fa shi yong :
  PRocedure TForm1.Button1Click(Sender: TObject);
  var
  ADataSet:TDataSet;
  begin
  ADataSet:=TDataSet.Create(Self);
  with ADataSet.FieldDefs do
  begin
  Add(′Name′,ftString,30,False);
  Add(′ ue′,ftInteger,0,False);
  end;
  with DataSource1 do
  begin
  DataSet:=CreateTableInMemory(ADataSet.FieldDefs);
  DataSet.Open;
  end;
  ADataSet.Free;
  end;
  lin shi biao chuang jian wan cheng 。
  fang fa 1 shi yong jian dan , dan you yu li yong cha xun kong jian , qing kong shu ju shi xu yao cha xun fu wu qi hou tai shu ju ku , suo yi su du shao man , er qie bu shi yong yu lin shi biao zhong ge ge zi duan you shu ge shu ju biao de zi duan pin cou er cheng de qing kuang 。 fang fa 2 shi yong fan wei guang 、 su du kuai , dan xu yao bian xie dai ma 。( dai ma zhong TFieldDefs de shi yong fang fa shi fen jian dan , jian Delphi de lian ji bang zhu )。
  2. pei zhi shu ju yin qing (BDE、SQL Link)
  you guan shu ju ku cheng xu fen fa shi , xu yao xie dai shu ju yin qing (BDE、SQL Link), bing qie zai ke hu duan an zhuang wan cheng xu hou huan xu yao pei zhi shu ju yin qing , ru yong hu ming (username)、 mi ma (PassWord) deng deng 。 jia ru shou gong pei zhi de hua , gong zuo liang bi jiao da ( gen ju ke hu ji shu liang er ding )。
  
   er InstallShield For Delphi you si hu mei you zhe fang mian de xuan xiang , qi shi InstallShield For Delphi ke yi zuo dao , zai sheng cheng an zhuang cheng xu de mu lu li you yi ge *.iwz de wen ben wen jian , zhi yao zai [IDAPI Alias] pian duan zhong shou gong jia ru ji ke 。 li ru :
  [IDAPI Alias]
  usesname=SYSDBA
  password=masterkey
  an zhuang cheng xu hou shu ju yin qing zi dong pei zhi wan bi 。
  3. zai InterBase shu ju ku zhong shi yong han shu
  cheng xu yuan ke neng zai yong InterBase zuo wei hou tai shu ju ku shi , hui wei qi ti gong de han shu guo shao er gan dao bu fang bian ( zhi you si ge ), wu fa fang bian di bian xie chu fu duo de cun chu guo cheng 。InterBase ben shen wu fa bian xie han shu , dan ta ke yi shi yong wai bu han shu ( tiao yong DLL zhong de han shu )。 xia li zhong shuo ming ru he zai InterBase zhong sheng ming SUBSTR han shu 。
  DECLARE EXTERNAL FUNCTION SUBSTR
  CSTRING(80), SMALLINT, SMALLINT
  RETURNS CSTRING(80)
  ENTRY_POINT ″IB_UDF_substr″ MODULE_NAME ″ib_udf″
  qi zhong :MODULE_NAME wei DLL de ming cheng ,ENTRY_POINT wei han shu ming 。
  sheng ming hou bian ke yi shi yong , li ru :
  select SUBSTR(country)
  from country
  ben li shi yong de shi Delphi an zhuang shi zi dai de IBLocal shu ju ku 。 yong hu ye ke yi zi ji bian xie han shu lai kuo chong InterBase。
用Delphi 开发数据库程序经验三则
geng duo nei rong qing kan shu ju ku xiang guan wen zhang zhuan ti , huo【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
  1. jian li lin shi biao    shu ju shu ru shi kai fa shu ju ku cheng xu de bi ran huan jie 。 zai Client/Server jie gou zhong , ke hu duan ke neng yao shu ru yi pi shu ju hou , zai xiang fu wu qi de hou tai shu ju ku ti jiao , zhe jiu xu yao zai ben di ( ke hu duan ) jian li lin shi shu ju biao lai cun chu yong hu shu ru de shu ju , dai ti jiao hou , qing chu ben di biao shu ju 。 zhe zhong fang fa de hao chu shi : ti gao shu ru xiao lv , jian xiao wang luo fu dan 。    you yu yong hu yi ci shu ru de shu ju liang yi ban qing kuang xia jiao xiao ( bu hui chao guo ji bai tiao ji lu ), suo yi lin shi biao ke yi jian li zai nei cun zhong , zhe yang chu li su du jiao kuai 。    fang fa 1: shi yong cha xun kong jian (TQuery)    di 1 bu : zai chuang ti shang fang shang cha xun kong jian (TQuery), she zhi hao suo lian jie de shu ju biao 。    di 2 bu : shi TQuery. CachedUpdates=True;    TQuery. RequestLive=True    di 3 bu : zai yuan you de SQL yu ju hou jia ru yi tiao Where zi yu ju , yao qiu jia ru zhe tiao Where zi yu ju hou SQL cha xun jie guo wei kong 。    li ru :   SELECT Biolife.″Species No″, Category, Common_Name, Biolife.″Species Name″, Biolife.″Length (cm)″, Length_In, Notes, Graphic    FROM ″biolife.db″ Biolife   where Biolife.Category=′A′ and Biolife.Category=′B′    zhe yang lin shi biao jiu jian li wan cheng le 。    fang fa 2: shi yong dai ma chuang jian lin shi biao    dai ma ru xia :   function CreateTableInMemory(const AFieldDefs:TFieldDefs):TDataSet;   var TempTable:TClientDataSet;   begin    TempTable:=nil;    Result:=nil;    if AFieldDefs$#@60;$#@62;nil then    begin    try    TempTable:=TClientDataSet.Create(application);    TempTable.FieldDefs.Assign(AFieldDefs);    TempTable.CreateDataSet;    Result:=(TempTable as TDataSet);    Except    if TempTable$#@60;$#@62;nil then TempTable.Free;   Result:=nil;    raise;     end end  end;    zai cheng xu zhong an ru xia fang fa shi yong :   PRocedure TForm1.Button1Click(Sender: TObject);   var ADataSet:TDataSet;   begin    ADataSet:=TDataSet.Create(Self);    with ADataSet.FieldDefs do    begin    Add(′Name′,ftString,30,False);    Add(′ ue′,ftInteger,0,False);    end;    with DataSource1 do    begin    DataSet:=CreateTableInMemory(ADataSet.FieldDefs);    DataSet.Open;    end;    ADataSet.Free;   end;    lin shi biao chuang jian wan cheng 。    fang fa 1 shi yong jian dan , dan you yu li yong cha xun kong jian , qing kong shu ju shi xu yao cha xun fu wu qi hou tai shu ju ku , suo yi su du shao man , er qie bu shi yong yu lin shi biao zhong ge ge zi duan you shu ge shu ju biao de zi duan pin cou er cheng de qing kuang 。 fang fa 2 shi yong fan wei guang 、 su du kuai , dan xu yao bian xie dai ma 。( dai ma zhong TFieldDefs de shi yong fang fa shi fen jian dan , jian Delphi de lian ji bang zhu )。 2. pei zhi shu ju yin qing (BDE、SQL Link)    you guan shu ju ku cheng xu fen fa shi , xu yao xie dai shu ju yin qing (BDE、SQL Link), bing qie zai ke hu duan an zhuang wan cheng xu hou huan xu yao pei zhi shu ju yin qing , ru yong hu ming (username)、 mi ma (PassWord) deng deng 。 jia ru shou gong pei zhi de hua , gong zuo liang bi jiao da ( gen ju ke hu ji shu liang er ding )。 er InstallShield For Delphi you si hu mei you zhe fang mian de xuan xiang , qi shi InstallShield For Delphi ke yi zuo dao , zai sheng cheng an zhuang cheng xu de mu lu li you yi ge *.iwz de wen ben wen jian , zhi yao zai [IDAPI Alias] pian duan zhong shou gong jia ru ji ke 。 li ru :    [IDAPI Alias]    usesname=SYSDBA    password=masterkey    an zhuang cheng xu hou shu ju yin qing zi dong pei zhi wan bi 。 3. zai InterBase shu ju ku zhong shi yong han shu    cheng xu yuan ke neng zai yong InterBase zuo wei hou tai shu ju ku shi , hui wei qi ti gong de han shu guo shao er gan dao bu fang bian ( zhi you si ge ), wu fa fang bian di bian xie chu fu duo de cun chu guo cheng 。InterBase ben shen wu fa bian xie han shu , dan ta ke yi shi yong wai bu han shu ( tiao yong DLL zhong de han shu )。 xia li zhong shuo ming ru he zai InterBase zhong sheng ming SUBSTR han shu 。   DECLARE EXTERNAL FUNCTION SUBSTR    CSTRING(80), SMALLINT, SMALLINT    RETURNS CSTRING(80)    ENTRY_POINT ″IB_UDF_substr″ MODULE_NAME ″ib_udf″    qi zhong :MODULE_NAME wei DLL de ming cheng ,ENTRY_POINT wei han shu ming 。    sheng ming hou bian ke yi shi yong , li ru :   select SUBSTR(country)    from country    ben li shi yong de shi Delphi an zhuang shi zi dai de IBLocal shu ju ku 。 yong hu ye ke yi zi ji bian xie han shu lai kuo chong InterBase。 [url=http://www.wangchao.net.cn/bbs/pydetail_1785128.html][img]http://image.wangchao.net.cn/it/1323424631136.gif[/img][/url] geng duo nei rong qing kan shu ju ku xiang guan wen zhang zhuan ti , huo
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
桌球宝贝_性感在蔓延(3)
桌球宝贝_性感在蔓延(2)
银杏树下清纯女孩(9)
银杏树下清纯女孩(8)
痞子的甘南日记
疑是银河落九天
雪域坝上四——纯美色
冬日恋歌——西城杨柳弄轻柔
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有