用VC++链接SQLServer数据库,包括链接,查询,插入,更新,删除等函数,已经将相关函数封装在类里面,可以直接重用或者扩充。-With VC++ Link SQLServer database, including the link, query, insert, update, delete, etc. functions, has been encapsulated in the type of correlation function which can be directly reused or expanded.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001497s ]
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.092352s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000993s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001225s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000991s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003634s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000875s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003801s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016766s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001287s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 58045 [ RunTime:0.019565s ]