在 Delphi 开发中，我们有时要打印一些复杂的报表。这个时候，或许你会选择一些第三方报表组件来集成你应用程序的报表功能。虽然能快速开发报表功能，但对于一些报表功能要求不高的小程序，你又不愿意花额外的钱去购买第三方组件。这时候你可以考虑一下下面我讲的这个实现方法？-In the Delphi development, we sometimes want to print a number of complex statements. This time, perhaps you will choose a number of third-party component statements to integrate your application
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000909s ]
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.080346s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000969s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001206s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001010s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003129s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000876s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003727s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.018334s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001743s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 120418 [ RunTime:0.024618s ]
