Question

下面SQL语句使用JDBC方式如何查询出结果集合，并显示在页面上？求大神帮帮忙！

select * from ((select count(*) from ft_subject where (logintime>='2016-08-18 00:00:00' and logintime<='2016-08-18 23:59:59')) as tmp1),((select count(distinct(userid)) from ft_subject where (logintime>='2016-08-18 00:00:00' and logintime<='2016-08-18 23:59:59')) as tmp2),((select count(*) from ft_freewatchaccount where (login_time>='2016-08-18 00:00:00' and login_time<='2016-08-18 23:59:59')) as tmp3),((select count(distinct(userid)) from ft_freewatchaccount where (login_time>='2016-08-18 00:00:00' and login_time<='2016-08-18 23:59:59')) as tmp4),((select count(pvid),t2.entrancename from lt_pvlog t1,ft_entrancesigns t2 where t1.signid=t2.signid and (t1.createtime>='2016-08-18 00:00:00' and t1. createtime<='2016-08-18 23:59:59')) as tmp5);





Answer 1

你这SQL也太差了吧。

1、没有格式化

2、6个相互独立的、简单的统计 -- 为何不用UNION?

3、时间条件有漏洞：

23:59:59 ~~00:00:00之间的数据漏掉了。应该：

WHERE loginTime >= '2016-10-18 00:00:00'
AND loginTime < '2016-10-19 00:00:00'