子查询然后给个别名就好了

NiLiao.com Bid History(13 Bidders:, 56 Bids) Bidder Bid Date Time jiuzheHigh Bid P $1,749.00 Mar 24 13:11:54 Alibackorders $1,699.00 Mar 24 13:11:54 jiuzheP $1,602.00 Mar 24 13:08:55 Alibackorders $1,552.00 Mar 24 13:07:37 jiuzheP $1,550.00 Mar 24 13:07:37 jiuzheP $1,452.00 Mar 24 13:06:16 Alibackorders $1,402.00 Mar 24 13:06:16 jiuzheP $1,301.00 Mar 24 13:04:04 AlibackordersP $1,251.00 Mar 24 13:04:04 AlibackordersP $1,250.00 […]

WFH 在家处理突发工作； 在家更愉快的写代码

org.apache.ibatis.binding.BindingException: Mapper method ‘cn.Mapper.findCouponIdListByFacadeid attempted to return null from a method with a primitive return type (int). select 语句应该返回一个int字段，但是返回了一个空的结果集，所以代码就报错了，修正方法修改sql语句保证任何时候都返回一个int☞ifnull(sum(字段),0) as 字段 sum函数保证了肯定有一行记录，但是可能是nullifnull再进一步转换一个默认值或异常值

Bidder Bid Date Time first1High Bid $3,001.00 Mar 20 13:02:42 jackiesjkP $3,000.00 Mar 20 13:02:42 jackiesjkP $2,951.00 Mar 20 12:58:43 first1 $2,901.00 Mar 20 12:58:43 jackiesjkP $2,851.00 Mar 20 12:57:40 first1 $2,801.00 Mar 20 12:57:40 jackiesjkP $2,751.00 Mar 20 12:57:06 first1 $2,701.00 Mar 20 12:57:06 jackiesjkP $2,651.00 Mar 20 12:56:02 first1 $2,601.00 Mar 20 12:56:02 […]

Bidder Bid Date Time dcnbusHigh Bid $1,551.00 Mar 16 13:20:07 jiuzheP $1,501.00 Mar 16 13:15:24 dcnbus $1,451.00 Mar 16 13:15:24 jiuzhe $1,401.00 Mar 16 13:10:37 dcnbus $1,351.00 Mar 16 13:07:06 jiuzhe $1,301.00 Mar 16 13:02:29 encgtheltgP $1,251.00 Mar 16 13:00:02 jiuzhe $1,250.00 Mar 16 13:00:02 encgtheltgP $1,200.00 Mar 16 12:59:51 jiuzhe $1,150.00 Mar 16 12:59:51 […]

01-Mar-2019 15:23 PST Bidder Date Bid Amount Comment 9ten 01-Mar-2019 14:12 PST $1,772.00 Completed 9ten 01-Mar-2019 12:17 PST $1,772.00 Bid Placed nj–thelion 01-Mar-2019 12:14 PST $1,722.00 Bid Placed dribble 01-Mar-2019 12:14 PST $1,710.00 Bid Placed dribble 01-Mar-2019 12:12 PST $1,661.00 Bid Placed 9ten 01-Mar-2019 12:09 PST $1,611.00 Bid Placed istu 01-Mar-2019 12:09 PST $1,600.00 Bid […]