This program is simple code that can control Sony TV. The control packages is divided by Wireshark. APP uses the java http client lib to send packages to Sony TV in lan. These are so many functions should be implement.
文 件 列 表
Dialog src res libs gen bin assets .classpath .project AndroidManifest.xml proguard-project.txt project.properties
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001088s ]
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.106593s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.022380s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.013266s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001541s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004509s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001071s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003932s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025367s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001471s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 97642 [ RunTime:0.015343s ]