一个非常经典的XML读写代码,利用三种方法来实现,一种是利用微软的DCOM来读写,另外两种是普通实现-a very classic read and write XML code, using three methods to achieve, one is using Microsoft"s DCOM to read and write, and the other two are ordinary achievement
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001561s ]
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.107918s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001678s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002092s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001871s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004428s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001330s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004077s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017049s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001613s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 238502 [ RunTime:0.001515s ]