一个较为复杂的数据同步程序，涉及到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.002769s ]
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.091058s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001863s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001984s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002239s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003581s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001913s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003316s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014536s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002333s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 206892 [ RunTime:0.001135s ]
