All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.clickntap.autoarchive.RowMover Maven / Gradle / Ivy

Go to download

Stripecube is an open source Java framework for Web Applications

There is a newer version: 1.30
Show newest version
package com.clickntap.autoarchive;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.jdbc.core.RowMapper;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class RowMover implements RowMapper {
    private JdbcTemplate jdbc;
    private String table;
    private boolean archive;

    public RowMover(JdbcTemplate jdbc, String table, boolean archive) {
        this.jdbc = jdbc;
        this.table = table;
        this.archive = archive;
    }

    public Object mapRow(ResultSet rs, int row) throws SQLException {
        String tablePre = "";
        if (archive) {
            tablePre = "autoarchive_";
        }
        Number id = null;
        final List params = new ArrayList();
        String sql = "insert into " + tablePre + table + " (";
        for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
            sql += "`" + rs.getMetaData().getColumnName(i) + "`";
            if (i != rs.getMetaData().getColumnCount()) {
                sql += ",";
            }
            params.add(rs.getObject(i));

            if (rs.getMetaData().getColumnName(i).equals("id")) {
                id = rs.getLong(i);
            }
        }
        sql += ") values (";
        for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
            sql += "?";
            if (i != rs.getMetaData().getColumnCount()) {
                sql += ",";
            }
        }
        sql += ")";
        jdbc.update(sql, new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                for (int i = 1; i <= params.size(); i++) {
                    ps.setObject(i, params.get(i - 1));
                }
            }
        });
        return id;
    }
}    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy