JAVA2（J2ME）实用编程的150个范例，在JDK中调试成功，因此一般可在其他开发工具中使用。注意有些实例只提供了部分模块，因此运行时需要添加其他代码。
-JAVA2 (J2ME) programming utility 150 examples of the successful commissioning of the JDK, so the general can be used in other development tools. Note that some examples of only some modules, run-time, therefore need to add other code.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001169s ]
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.082719s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001057s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001847s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001084s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003580s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000926s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003148s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014242s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001168s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 48641 [ RunTime:0.003544s ]
