一个简单的基于.NET平台和XML数据源的同学录,本系统对XML增、删、改、查等操作都有,并有详细注释,超级管理员登陆账号和密码都是xml !
-Based on a simple. NET platform and XML data sources of Classmates, the system of XML by adding, changing, checking and other operations are, and have detailed notes, the super administrator account login and password are the xml!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001382s ]
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.080858s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000980s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001136s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000968s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003100s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000843s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003639s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015248s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001245s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 148338 [ RunTime:0.013205s ]