| | |
| | | if (null!=user){ |
| | | ExamPayment examPayment = new ExamPayment(); |
| | | examPayment.setWorkerId(user.getId().toString()); |
| | | examPayment.setPaymentStatus(1); |
| | | examPayment.setCertificateUrl(urls); |
| | | examPayment.setType(1); |
| | | examPayment.setPaymentTime(new Date()); |
| | |
| | | |
| | | //数据推送 |
| | | String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examPayment.getPaymentTime()); |
| | | String s = "insert into sys_apply(id,type,payment_time,worker_id,apply_code,certificate_url) " + |
| | | String s = "insert into sys_exam_payment(id,type,payment_time,worker_id,payment_status,certificate_url) " + |
| | | "values(" + "'" + examPayment.getId() + "'" + |
| | | "," + "'" + examPayment.getType() + "'" + |
| | | "," + "'" + formatStr + "'" + |
| | | "," + "'" + examPayment.getWorkerId() + "'" + |
| | | "," + "'" + examPayment.getApplyCode() + "'" + |
| | | "," + "'" + examPayment.getPaymentStatus() + "'" + |
| | | "," +"'" + examPayment.getCertificateUrl() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s); |
| | | |