一个用J2ME实现的俄罗斯方块的例子,原本是下的别人的 后面我自己增加了一些逻辑处理,像是用RMS保存分数记录等。同时处理了一些BUG J2ME新手可以参考学习下-Implemented using a J2ME Tetris example, was originally under the back of someone else I added some logic processing, such as with the RMS to save scores of records. Also dealt with some BUG J2ME novice can refer to learn the next
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001578s ]
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.117870s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001525s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002507s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001254s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004594s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001186s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004437s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020116s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001531s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 231970 [ RunTime:0.001761s ]