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再进一步转换一个默认值或异常值
Author Archive
attempted to return null from a method with a primitive return type (int)
2019-03-21 by Jinyang | No Comments | Filed in UncategorizedChaohai.com Bid History(15 Bidders:, 72 Bids)
2019-03-21 by Jinyang | No Comments | Filed in UncategorizedBidder 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 […]
TOKEN.CC Bid History(18 Bidders:, 43 Bids)
2019-03-17 by Jinyang | No Comments | Filed in UncategorizedBidder 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 […]
Bid history for bailie.com
2019-03-02 by Jinyang | No Comments | Filed in Uncategorized01-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 […]
用代码让世界变得更美好一些
2019-01-17 by Jinyang | No Comments | Filed in Uncategorized办理了税务变更 银行账号变更 都比较顺利 但是一天时间还是就这样消耗了 所以半夜起来加班写代码
查看linux系统中全部用户的crontab任务
2019-01-09 by Jinyang | No Comments | Filed in Uncategorized进入目录 /var/spool/cron/crontabs 查看编辑即可
定时重启php7.0-fpm
2019-01-09 by Jinyang | No Comments | Filed in Uncategorized每两小时重启一次： 0 */2 * * * service php7.0-fpm restart 开启crontab日志： sudo vim /etc/rsyslog.d/50-default.conf cron.* /var/log/cron.log #将cron前面的注释符去掉
证书链严格一致
2019-01-03 by Jinyang | No Comments | Filed in 技术相关发现中间证书错了， GeoTrust RSA CA 2018 搞成了 EV 证书 。
nginx tomcat springmvc上传文件报错
2019-01-01 by Jinyang | No Comments | Filed in 技术相关1. nginx 2. tomcat 3. springmvc <!– SpringMVC上传文件时，需要配置MultipartResolver处理器 –> <bean id=”multipartResolver” class=”org.springframework.web.multipart.commons. CommonsMultipartResolver”> <property name=”defaultEncoding” value=”UTF-8″/> <!– 指定所上传文件的总大小不能超过200KB。注意maxUploadSize属性的限制不是针对单个文件，而是所有文件的容量之和 –> <property name=”maxUploadSize” value=”200000″/> <!–resolveLazily属性启用是为了推迟文件解析，以便在UploadController 中捕获文件大小异常–> <property name=”resolveLazily” value=”true”/> </bean> maxUploadSize 调整为-1 ， 不限制
ShanPu.com Bid History(19 Bidders:, 58 Bids)
2018-12-29 by Jinyang | No Comments | Filed in 域名Bidder Bid Date Time first1 High Bid $2,138.00 Dec 28 12:50:35 ckrgksanrndghk $2,088.00 Dec 28 12:50:22 first1 $2,038.00 Dec 28 10:38:54 Doomain P $2,000.00 Dec 28 10:11:53 Doomain P $1,988.00 Dec 28 10:11:53 first1 $1,938.00 Dec 28 10:29:54 Doomain P $1,888.00 Dec 28 10:11:53 first1 $1,838.00 Dec 28 10:21:05 Doomain P $1,788.00 Dec 28 10:11:53 […]
