springmvc 的 jdbcTemplate 插入返回主键

爱被打了一巴掌 2022-03-01 04:20 211阅读 0赞

public int saveReportsUpload(ReportsUpload reportsUpload) {
            String sql = " INSERT INTO reports_version (ID, FILENAME, URLCONTENT, FILEPATH, QBTYPE, uuid, UPLOADDATE," +
                    "UPLOADUSER, VERSION, ABSTCONTENT, UPLOADUSERNAME, PDFFILEPATH, VERSIONID ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            KeyHolder keyHolder = new GeneratedKeyHolder();
            jdbcTemplate.update(new PreparedStatementCreator() {
                @Override
                public PreparedStatement createPreparedStatement(Connection conn) throws SQLException {
                    PreparedStatement ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
                    ps.setString(1, reportsUpload.getId());
                    ps.setString(2,  reportsUpload.getFileName());
                    ps.setString(3, reportsUpload.getUrlcontent());
                    ps.setString(4, reportsUpload.getFilepath());
                    ps.setString(5, reportsUpload.getQbType());
                    ps.setString(6, reportsUpload.getUuid());
                    Date data = reportsUpload.getUploadDate();
                    if(data == null) {
                        data = new Date();
                    }
                    ps.setDate(7, new java.sql.Date(data.getTime()));
                    ps.setString(8, reportsUpload.getUploadUser());
                    ps.setInt(9, reportsUpload.getVersion());
                    ps.setString(10, reportsUpload.getAbstContent());
                    ps.setString(11, reportsUpload.getUploadUserName());
                    ps.setString(12, reportsUpload.getPdfFilePath());
                    ps.setString(13, reportsUpload.getVersionId());
                    return ps;
                }
            }, keyHolder);
            return keyHolder.getKey().intValue();
        }