This project is developed with android 2.0 framework and eclipse 3.0.
It contains one activity,which displays the two images.
when we click on the image it will do corresponding action ,which is defined in click event of imageview.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001830s ]
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.153258s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001615s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003083s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001778s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004511s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001092s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003294s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014558s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001461s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 100048 [ RunTime:0.001413s ]
