数据库操作的样例脚本

db_connect("query1","DSN=test;uid=admin;pwd=");51Testing软件测试网tP@"Cf5Sl,W
        val=db_execute_query("query1","select * from school ",row_nb);
KTp,~7Dv"sM0       
QSrn8R qS8~2bS0        if (val==0) {
p'e#tlnBIoZ4L0            print(" query record num="&row_nb);
`-jes t9\}9F0            db_get_headers ("query1",field_num,headers);
x K7n0_3})f]D0                print("headers-count: "&field_num&"    headcontent  "&headers);51Testing软件测试网N#R E#C-Dke
               
Ttq$tx0}#\ b3R0                for (i=0;i<row_nb;i++){
H;r4v7^6@^+\0                db_get_row("query1",i,row_content);51Testing软件测试网#f!gUN^Z
                abc=db_get_field_value("query1","#"&i&"\"","#1");51Testing软件测试网T(h;m"@2R3Rk
                print(abc);
M)S&\v-we"B#j$zv0                obj_type("Edit",""&abc&"");                       51Testing软件测试网FU:FFP j8I
           }
-bu5|1N"t6Z v0        }
8d'YD3I,Aw$D0       
E Cqes)_ A3PQ:Iv0        ##读取当前数据表 第1行第2个字段的内容
e/?s;L ]zsGq2y+JjP0    aaa =db_get_field_value("query1","#0","#1");## #0实际上就是第一行记录51Testing软件测试网O3D a'}I-I"{
    print("DNAME="&aaa);51Testing软件测试网UH,[s0wT
        ##插入记录到数据库中51Testing软件测试网:_/G7B'_3N O
        db_execute_query("query1","insert into school values (66,'地质大学2','城府路3号')",i);