hibernate 莫名的空指针

在使用union连接表查询时,query.list()的时候老报空指针,语句如下:

String sql = "(select count(distinct phone) from ts_user where createdate between to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and to_date(?,'yyyy-MM-dd hh24:mi:ss') and isvalid = '0') union all "+
//当日新增用户
"(select count(distinct phone) from ts_user where createdate between to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and to_date(?,'yyyy-MM-dd hh24:mi:ss') and (isvalid = '1' or isvalid = '2')) union all "+
//截止当日已退订的用户
" (select count(distinct phone) from ts_user where createdate < to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and isvalid = '0') union all "+
//载止当日已订购的用户
"(select count(distinct phone) from ts_user where createdate < to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and (isvalid = '1' or isvalid = '2')) union all "+
//当日暂停推送的用户
"(select count(distinct phone) from ts_user where createdate between to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and to_date(?,'yyyy-MM-dd hh24:mi:ss') and isvalid = '2') union all "+
//截止当日暂停推送的用户
"(select count(distinct phone) from ts_user where createdate < to_date(?,'yyyy-MM-dd hh24:mi:ss') and isvalid = '2')";


后面把每个语句的括号去掉就没报错了,哎不这道啥原因
修改成
String sql = "select count(distinct phone) from ts_user where createdate between to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and to_date(?,'yyyy-MM-dd hh24:mi:ss') and isvalid = '0' union all "+
//当日新增用户
"select count(distinct phone) from ts_user where createdate between to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and to_date(?,'yyyy-MM-dd hh24:mi:ss') and (isvalid = '1' or isvalid = '2') union all "+
//截止当日已退订的用户
" select count(distinct phone) from ts_user where createdate < to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and isvalid = '0' union all "+
//载止当日已订购的用户
"select count(distinct phone) from ts_user where createdate < to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and (isvalid = '1' or isvalid = '2') union all "+
//当日暂停推送的用户
"select count(distinct phone) from ts_user where createdate between to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and to_date(?,'yyyy-MM-dd hh24:mi:ss') and isvalid = '2' union all "+
//截止当日暂停推送的用户
"select count(distinct phone) from ts_user where createdate < to_date(?,'yyyy-MM-dd hh24:mi:ss')"+
" and isvalid = '2'";
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值