一个较为复杂的数据同步程序,涉及到sql和oracal数据库的访问,多线程,MFC网络编程,消息队列等内容-A more complex data synchronization process, and oracal related to sql database access, multi-threaded, MFC network programming, message queues, etc.
文 件 列 表
备份9月16 sql数据库建立触发器sql语句 Server oracle数据库建表语句 Client Client.ini readme.txt Server.ini
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001142s ]
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.081970s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001110s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001956s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001380s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003450s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000945s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003834s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018654s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001206s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 206892 [ RunTime:0.011918s ]