比较适合初学者,有几样东西值得学习,1.限制textbox数据输入的函数,2.数据插入和更新的函数。3.运用Eexcel报表输出-more suitable for beginners, there are several things worth learning, 1. Restrictions textbox data input function, 2. Inserting data and update functions. 3. Use Eexcel statements output
文 件 列 表
旅游酒店预定商务软件 Bin FORM HELP IMAGE TEMPLATE 报表 MSSCCPRJ.SCC README.TXT Tour.mdb TOUR.VBW unstall.html 山西旅游酒店预定商务软件.vbp 山西旅游酒店预定商务软件.exe 山西旅游酒店预定商务软件.vbw
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002416s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.097676s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002128s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001978s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.006634s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003578s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001803s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003153s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014146s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002531s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 127448 [ RunTime:0.001110s ]