函数解析:
var sbiao,sitem:string; begin sbiao:='user_db'; sitem:='username'; //载入表名和需要查询的列名 fun_db.fundb.refreshcombox(sbiao,sitem,combobox1); end;
函数解析:
var sbiao,sitem:string; begin sbiao:='user_db'; sitem:='username'; //载入表名和需要查询的列名 fun_db.fundb.refreshcombox_trim(sbiao,sitem,combobox1); end;
函数解析:
var sbiao,sitemcheck:string; sitem1,sitem2,sitem3 begin sbiao:='user_db'; sitem1:='username'; sitem2:='='; sitem3:='admin'; sitemcheck:='username'; fun_db.fundb.refreshcombox_itemlist(sbiao,sitem1,sitem2,sitem3,sitemcheck,combobox1); end;
procedure Refreshdb_Combobox_itemlist_trim(var sbiao,sitem1,sitem2,sitem3,sitemcheck:string; var Tcom:TCombobox);
函数解析:
var sbiao:string; begin sbiao:='user_db'; //只需要载入表名 fun_db.fundb.refreshdb(sbiao); end;
var spatch:string;//定义一个变量用于储存linkfile.txt的路径 begin spatch:=slj+'linkfile.txt'; slinkstr:=fun_basic.funbasic.getstrfromfile(spatch); //showmessage(slinkstr) ; fun_db.fundb.AdoQuery1.ConnectionString:=slinkstr; //连接字符串赋值 fun_db.fundb.AdoQuery2.ConnectionString:=slinkstr; Form1.DBGrid1.DataSource := fun_db.fundb.DataSource1;//配置DBgird显示查询结果 end;
函数解析:
var sbiao,sdesc:string; begin sbiao:='user_db'; sdesc:='id' fun_db.fundb.refreshdb_desc(sbiao,sdesc); end;
函数解析:
var sbiao,sitem,sitemstr:string; begin sbiao:='user_db'; sitem:='username'; sitemstr:='admin'; fun_db.fundb.refreshdb_item(sbiao,sitem,sitemstr); end;
函数解析:
var sbiao,sitem,sitemstr,sdesc:string; begin sbiao:='user_db'; sitem:='username'; sitemstr:='admin'; sdesc:='id'; fun_db.fundb.refreshdb_item_desc(sbiao,sitem,sitemstr,sdesc); end;
函数解析:
var sbiao,sitem,sitemstr:string; tlist:TStringlist; begin sbiao:='user_db'; sitem:='username'; sitemstr:='admin'; tlist:=TStringlist.Create; tlist.Add('列名1'); tlist.Add('列名2'); tlist.Add('列名3'); tlist.Add('列名4'); fun_db.fundb.Refreshdb_item_strlist(sbiao,sitem,sitemstr,tlist); tlist.Free; end;
procedure Refreshdb_item_strlist_desc(var sbiao,sitem,sitemstr,sdesc:string ;var tlist:TStringlist);
var sbiao,sitem,sitemstr,sdesc:string; tlist:TStringlist; begin sbiao:='user_db'; sitem:='username'; sitemstr:='admin'; sdesc:='id'; tlist:=TStringlist.Create; tlist.Add('列名1'); tlist.Add('列名2'); tlist.Add('列名3'); tlist.Add('列名4'); fun_db.fundb.Refreshdb_item_strlist_desc(sbiao,sitem,sitemstr,sdesc,tlist); tlist.Free; end;
函数解析:
var sbiao,sitem,sitemstr:string; begin sbiao:='user_db'; sitem:='username'; sitemstr:='admin'; fun_db.fundb.deledbstr(sbiao,sitem,sitemstr); end;
函数解析:
var sbiao:string; begin sbiao:='user_db'; fun_db.fundb.deletable(sbiao); end;
函数解析:
var sbiao,sitem,sitemstr,ssetitem,ssetitemstr:string; begin sbiao:='user_db'; sitem:='username'; sitemstr:='liusen2'; ssetitem:='password'; ssetitemstr:='123'; fun_db.fundb.updatestr(sbiao,ssetitem,ssetitemstr,sitem,sitemstr); end;
函数解析:
var sbiao,sitem,sitemstr:string; sfilestr,sfilepatch:string; slj:string; begin fun_basic.funbasic.getpatch(slj);//函数已经被GetPath_p(var slj:string)替换更新。 sbiao:='upfiles'; sitem:='sitem'; sitemstr:='test_new'; sfilestr:='sitem_up'; sfilepatch:=slj+'abc.jpg' ; fun_db.fundb.upload_file_db_new(sbiao,sitem,sitemstr,sfilestr,sfilepatch); end;
函数解析:
var spach:string; begin spach:='C:\abc.mdb'; fun_db.fundb.CreateLocalmdb(spach); end;
函数解析:
var sbiao,sitem,sitemstr:string; sfilestr,sfilepatch:string; slj:string; begin fun_basic.funbasic.getpatch(slj); //getpatch 已经被 getpatch_p 代替
//或者使用 function getpatch 来获取返回结果。 sbiao:='upfiles'; sitem:='id'; sitemstr:='3'; sfilestr:='sitem_up'; sfilepatch:=slj+'abc.jpg'; fun_db.fundb.download_file_db_new(sbiao,sitem,sitemstr,sfilestr,sfilepatch); end;
函数解析:
var sbiao:string; tlist1,tlist2:TStringlist; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; //必须先创建实例 tlist1.Add('username'); tlist2.Add('liusen'); tlist1.Add('password'); tlist2.Add('123456'); tlist1.Add('slevel'); tlist2.Add('5'); fun_db.fundb.adddbinfo_strlist(sbiao,tlist1,tlist2); tlist1.Free; tlist2.Free; //最后要释放实例 end;
函数解析:
var sbiao:string; tlist1,tlist2:TStringlist; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; //必须先创建实例 tlist1.Add('id'); tlist2.Add('2'); tlist1.Add('id'); tlist2.Add('3'); tlist1.Add('id'); tlist2.Add('3'); fun_db.fundb.deldbinfo_strlist(sbiao,tlist1,tlist2); tlist1.Free; tlist2.Free; //最后要释放实例 end;
函数解析:
var sbiao:string; tlist1,tlist2,tlist3,tlist4:TStringlist; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; tlist4:=TStringlist.Create; //必须先创建实例 tlist1.Add('id'); tlist2.Add('4'); tlist3.Add('slevel'); tlist1.Add('id'); tlist2.Add('5'); tlist3.Add('slevel'); tlist1.Add('id'); tlist2.Add('6'); tlist3.Add('slevel'); fun_db.fundb.getdbstr_strlist(sbiao,tlist1,tlist2,tlist3,tlist4); tlist1.Free; tlist2.Free; tlist3.Free; tlist4.Free; //最后要释放实例 end;
函数解析:
var sbiao:string; tlist1,tlist2,tlist3,tlist4:TStringlist; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; tlist4:=TStringlist.Create; //必须先创建实例 tlist1.Add('id'); tlist2.Add('4'); tlist3.Add('slevel'); tlist1.Add('id'); tlist2.Add('5'); tlist3.Add('slevel'); tlist1.Add('id'); tlist2.Add('6'); tlist3.Add('slevel'); fun_db.fundb.getdbstr_strlist(sbiao,tlist1,tlist2,tlist3,tlist4); tlist1.Free; tlist2.Free; tlist3.Free; tlist4.Free; //最后要释放实例 end;
procedure Getdbstr_Strlist_trim(var sbiao:string;var arrdb,arrstr,arritem,arrcheck:Tstringlist);
函数解析:
var sbiao,sitem,sitemstr,sitemcheck:string; tlist:TStringlist; begin sbiao:='user'; sitem:='id'; sitemstr:='5'; sitemcheck:='password'; tlist:=TStringlist.Create; fun_db.fundb.Getdbstr_Item_Tolist(sbiao,sitem,sitemstr,sitemcheck,tlist); tlist.Free; end;
procedure Getdbstr_Item_Tolist_trim(var sbiao,sitem,sitemstr,sitemcheck:string;var tlist:TStringlist);
函数解析:
var sbiao:string; tlist1,tlist2,tlist3,tlist4:TStringlist; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; tlist4:=TStringlist.Create; //必须先创建实例 tlist1.Add('id'); tlist2.Add('4'); tlist3.Add('slevel'); tlist4.Add('10'); tlist1.Add('id'); tlist2.Add('5'); tlist3.Add('slevel'); tlist4.Add('10'); tlist1.Add('id'); tlist2.Add('6'); tlist3.Add('slevel'); tlist4.Add('10'); fun_db.fundb.updatestr_strlist(sbiao,tlist3,tlist4,tlist1,tlist2); tlist1.Free; tlist2.Free; tlist3.Free; tlist4.Free; //最后要释放实例 end;
函数解析:
var sbiao:string; tlist1,tlist2:TStringlist; s_tmp:string; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; //首先创建实例 if trim(edit1.Text) <> ''then begin tlist1.Add('username'); tlist2.Add(trim(edit1.Text)); end; if combobox1.ItemIndex <> -1 then begin tlist1.Add('slevel'); s_tmp:=combobox1.Items.Strings[combobox1.ItemIndex]; tlist2.Add(s_tmp); end; fun_db.fundb.querydb_strlist(sbiao,tlist1,tlist2); tlist1.Free; tlist2.Free; //释放实例 end;
begin combobox1.Clear; combobox1.Items.Add('1'); combobox1.Items.Add('5'); combobox1.Items.Add('10'); combobox1.ItemIndex:=-1; combobox1.Text:='下拉选择'; edit1.Clear; edit1.SetFocus; end;
if trim(edit1.Text) <> ''then begin tlist1.Add('username'); tlist2.Add(trim(edit1.Text)); end;
if combobox1.ItemIndex <> -1 then begin tlist1.Add('slevel'); s_tmp:=combobox1.Items.Strings[combobox1.ItemIndex]; tlist2.Add(s_tmp); end;2、 初始化的时候一定要先清空combobox的内容,并且设置combobox.itemindex的值,因为判断条件的时候是判断combobox.itemindex是否等于-1;
procedure Querydb_Strlist_desc(var sbiao,sdesc:string;var arrdb,arrstr:TStringlist);
函数解析:
var sbiao,sdesc:string; tlist1,tlist2,tlist3:TStringlist; s_tmp:string; begin sbiao:='user_db'; sdesc:='id'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; tlist1.Add('username'); tlist2.Add('liusen'); tlist3.Add('='); tlist1.Add('password'); tlist2.Add('123456'); tlist3.Add('<>'); fun_db.fundb.querydb_strlist_opera_or_desc(sbiao,sdesc,tlist1,tlist2,tlist3); //查询表 usernmae=liusen 并且 password=123456 //查询结果根据ID倒叙排列 tlist1.Free; tlist2.Free; tlist3.Free; //释放内存 end;
while not eof do begin s_tmp:=fieldByname(sitemcheck).asstring; tlist4.Add(s_tmp); next; end;
函数解析:
var sbiao,sdesc:string; tlist1,tlist2,tlist3:TStringlist; s_tmp:string; begin sbiao:='user_db'; sdesc:='id'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; //首先创建实例 tlist1.Add('username'); tlist2.Add('liusen'); tlist3.Add('='); // tlist1.Add('password'); tlist2.Add('123456'); tlist3.Add('<>'); fun_db.fundb.querydb_strlist_opera_or_desc(sbiao,sdesc,tlist1,tlist2,tlist3); tlist1.Free; tlist2.Free; tlist3.Free; //释放实例 end;
procedure Querydb_Strlist_Opera_or(var sbiao:string; var tlist1,tlist2,tlist3:TStringlist);
函数解析:
var sbiao,scheck:string; tlist1,tlist2,tlist3,tlist4:TStringlist; s_tmp:string; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; tlist4:=TStringlist.Create; //首先创建实例 tlist1.Add('username'); tlist2.Add('liusen'); tlist3.Add('='); // tlist1.Add('password'); tlist2.Add('123456'); tlist3.Add('='); scheck:='slevel'; fun_db.fundb.getdb_strlist_querydb_strlist_opera(sbiao,scheck,tlist1,tlist2,tlist3,tlist4); tlist1.Free; tlist2.Free; tlist3.Free; tlist4.Free; //释放实例 end;
procedure Getdb_Strlist_Querydb_Strlist_Opera_trim(var sbiao,sitemcheck:string;var tlist1,tlist2,tlist3,tlist4:TStringlist);
函数解析:
var sbiao,sdesc:string; tlist1,tlist2,tlist3:TStringlist; s_tmp:string; begin sbiao:='user_db'; sdesc:='id'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; //首先创建实例 tlist1.Add('username'); tlist2.Add('liusen'); // tlist1.Add('password'); tlist2.Add('123'); tlist3.Add('username'); tlist3.Add('password'); fun_db.fundb.querydb_strlist_item_desc(sbiao,sdesc,tlist1,tlist2,tlist3); tlist1.Free; tlist2.Free; tlist3.Free; //释放实例 end;
函数解析:
var sbiao:string; tlist1,tlist2:TStringlist; s_tmp:string; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; //首先创建实例 tlist1.Add('username'); tlist2.Add('liusen'); // tlist1.Add('password'); tlist2.Add('123'); fun_db.fundb.querydb_strlist_or(sbiao,tlist1,tlist2); tlist1.Free; tlist2.Free; //释放实例 end;
procedure Querydb_Strlist_or_desc(var sbiao,sdesc:string;var arrdb,arrstr:TStringlist);
函数解析:
var sbiao,sdesc:string; tlist1,tlist2,tlist3:TStringlist; s_tmp:string; begin sbiao:='user_db'; sdesc:='id'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; //首先创建实例 tlist1.Add('username'); tlist2.Add('liusen'); // tlist1.Add('password'); tlist2.Add('123'); tlist3.Add('username'); tlist3.Add('password'); fun_db.fundb.querydb_strlist_item_desc(sbiao,sdesc,tlist1,tlist2,tlist3); tlist1.Free; tlist2.Free; tlist3.Free; //释放实例 end;
procedure Querydb_Strlist_item(var sbiao:string;var arrdb,arrstr,sitem:TStringlist);
函数解析:
var sbiao,sdesc:string; tlist1,tlist2,tlist3:TStringlist; s_tmp:string; begin sbiao:='user_db'; sdesc:='id'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist3:=TStringlist.Create; //首先创建实例 tlist1.Add('username'); tlist2.Add('liusen'); // tlist1.Add('password'); tlist2.Add('123'); tlist3.Add('username'); tlist3.Add('password'); fun_db.fundb.querydb_strlist_item_desc(sbiao,sdesc,tlist1,tlist2,tlist3); tlist1.Free; tlist2.Free; tlist3.Free; //释放实例 end;
procedure Querydb_Strlist_item(var sbiao:string;var arrdb,arrstr,sitem:TStringlist);
函数解析:
var sbiao,sitem,sitemstr:string; begin sbiao:='user_db'; sitem:='username'; sitemstr:='liusen_add'; fun_db.fundb.addinfo_one(sbiao,sitem,sitemstr); end;
函数解析:
var sbiao:string; tlist:TStringlist; begin sbiao:='user_db'; tlist:=TStringlist.Create; tlist.Add('username'); tlist.Add('password'); fun_db.fundb.refreshdb_strlist(sbiao,tlist); tlist.Free; end;
procedure Refreshdb_Strlist_desc(var sbiao,sdesc:string;var tlist:TStringlist);
函数解析:
var sbiao,sitem:string; tlist:TStringlist; begin sbiao:='user_db'; sitem:='slevel'; tlist:=TStringlist.Create; fun_db.fundb.getdbinfo_strlist(sbiao,sitem,tlist); tlist.Free; end;
procedure Getdbinfo_Strlist_limit(var sbiao,sitem,slimit:string; var tlist:TStringlist);
函数解析:
var sbiao,sitem,sitemstr,slimit,scheck:string; tlist:TStringlist; begin sbiao:='user_db'; sitem:='username'; sitemstr:='liusen'; scheck:='srole'; slimit:='10'; tlist:=TStringlist.Create; fun_db.fundb.getdbinfo_item_strlist_limit(sbiao,sitem,sitemstr,scheck,slimit,tlist); tlist.Free; end;
procedure Getdbinfo_Item_Strlist_desc_limit(var sbiao,sdesc,sitem,sitemstr,scheck,slimit:string; var tlist:TStringlist);
函数解析:
var tlist:TStringlist; begin tlist:=TStringlist.Create; tlist.Add('ID'); tlist.Add('登录账户'); tlist.Add('登录密码'); tlist.Add('登录权限'); tlist.Add('所属项目'); fun_db.fundb.setdbgrid_caption(dbgrid1,tlist); tlist.Free; end;
函数解析:
var sbiao:string; begin sbiao:='user_db'; fun_db.fundb.drop_table(sbiao); end;
函数解析:
var sbiao,sitem,sitemstr,sitemcheck:string; tlist1:TStringlist; begin sbiao:='user'; sitemstr:='username'; tlist1:=TStringlist.Create; fun_db.fundb.Addstrtolist_Strlist(sbiao,sitem,tlist1) ; tlist1.Free; end;
procedure Addstrtolist_Strlist_trim(var sbiao,sitem:string; var tlist:TStringlist);
函数解析:
var sbiao,sitem,sitemstr:string; b:boolean; begin sbiao:='user_db'; sitem:='username'; sitemstr:='123456'; b:=fun_db.fundb.querydb_bool(sbiao,sitem,sitemstr); end;
function Querydb_Bool_Strlist(var sbiao:string;var tlist1,tlist2,tlist3:TStringlist):boolean;
函数解析:
var sbiao,sitem,sitemstr,sid:string; tlist1:TStringlist; begin sbiao:='user'; sitem:='username'; sitemstr:='admin'; sid:=fun_db.fundb.Querydb_Bool_Tostr(sbiao,sitem,sitemstr) ; end;
函数解析:
var sbiao,sitem,sitemstr,scheck:string; sresult:string; begin sbiao:='user_db'; sitem:='username'; sitemstr:='liusen'; scheck:='slevel'; sresult:=fun_db.fundb.getdbstr(sbiao,sitem,sitemstr,scheck); end;
function Getdbstr_Integer(var sbiao,sitem,sitemstr:string;var iitemstr:integer):string;
函数解析:
var sbiao,sitem_db,sitemstr_db,sitem,sitemstr:string; b:boolean; begin sbiao:='user_db'; sitem_db:='username'; sitemstr_db:='password'; sitem:=trim(edit1.Text); sitemstr:=trim(edit2.Text); b:=fun_db.fundb.checklogin_two_boolean(sbiao,sitem_db,sitemstr_db,sitem,sitemstr); if b=true then showmessage('t') else showmessage('f'); end;
函数解析:
var sbiao,sitem,sitemstr:string; b:boolean; begin sbiao:='user_db'; sitem:='username'; sitemstr:='liusen'; b:=fun_db.fundb.checkitem_empty(sbiao,sitem,sitemstr); if b=true then showmessage('t') else showmessage('f'); end;
函数解析:
var sbiao:string; i:integer; begin sbiao:='user_db'; i:=fun_db.fundb.sqlcount(sbiao); end;
函数解析:
var sbiao:string; b:boolean; begin sbiao:='user'; b:=fun_db.fundb.TestdbCon(sbiao); end;
函数解析:
var sbiao,sitem,sitemstr:string; i:integer; begin sbiao:='user_db'; sitem:='username'; sitemstr:='liusen'; i:=fun_db.fundb.gettotal_item(sbiao,sitem,sitemstr); end;
函数解析:
var sbiao:string; tlist1,tlist2:TStringlist; i:integer; begin sbiao:='user_db'; tlist1:=TStringlist.Create; tlist2:=TStringlist.Create; tlist1.Add('username'); tlist2.Add('liusen'); tlist1.Add('password'); tlist2.Add('1234'); i:=fun_db.fundb.gettotal_strlist_or(sbiao,tlist1,tlist2); tlist1.Free; tlist2.Free; end;
function Gettotal_Strlist_and(var sbiao:string;var tlist1,tlist2:TStringlist):integer;
函数解析:
var sbiao,sitem:string; i:integer; begin sbiao:='user_db'; sitem:='id'; i:=fun_db.fundb.querydb_sum_total(sbiao,sitem); showmessage(inttostr(i)); end;
function Querydb_Strlist_Opera_desc_count(var sbiao,sitem:string;var tlist1,tlist2,tlist3:TStringlist):integer;
function Querydb_Sum_total(var sbiao,sitem:string):integer;
function Querydb_Strlist_Opera_Getinfo_id(var sbiao,sitemcheck:string; var tlist1,tlist2,tlist3:TStringlist):integer;
function Querydb_Strlist_Opera_Getinfo_str(var sbiao,sitemcheck:string; var tlist1,tlist2,tlist3:TStringlist):string;
function Querydb_Strlist_Count(var sbiao:string;var arrdb,arrstr:TStringlist):integer;
function Querydb_Strlist_Opera_Sqlcount(var sbiao:string;var tlist1,tlist2,tlist3:TStringlist):integer;
function Querydb_Strlist_Opera_Sqlcount_or(var sbiao:string;var tlist1,tlist2,tlist3:TStringlist):integer;