在myeclipse下JDBC连接sqlserver2000的的驱动架包,使用直接把里面的.jar 拷贝到classes下的lib里-JDBC connection in SQL Server 2000 under myeclipse of the driver frame packet, the use of directly to the inside. Jar are copied to the classes under lib ri
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001438s ]
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.093228s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001460s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002056s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001193s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003626s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001119s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003312s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014819s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001405s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 112081 [ RunTime:0.001313s ]