在编辑界面创建所需的控件,并于Properties中将ID,Caption按表填好,给复选和编辑框控件连接变量,对消息处理函数加入指定代码。-In the editing interface to create the necessary controls and Properties Lieutenant ID, Caption completed table to check and edit the control box to connect variables, on the message processing function by adding the specified code.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002216s ]
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.105260s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.003290s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002079s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002484s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003855s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002116s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003364s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016486s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002245s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 211996 [ RunTime:0.001470s ]