Java SQL ResultSet copyInt(ResultSet rs, int sourcePos, PreparedStatement stmt, int destPos)

Description

copy Int

License

Open Source License

Declaration

public static void copyInt(ResultSet rs, int sourcePos, PreparedStatement stmt, int destPos)
            throws SQLException 

Method Source Code

//package com.java2s;
/*//from   www .  j  av a 2  s.c om
 * Copyright (C) 2008 Patrick Valsecchi
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  U
 */

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

public class Main {
    public static void copyInt(ResultSet rs, int sourcePos, PreparedStatement stmt, int destPos)
            throws SQLException {
        final int value = rs.getInt(sourcePos);
        if (rs.wasNull())
            stmt.setNull(destPos, Types.INTEGER);
        else
            stmt.setInt(destPos, value);
    }
}

Related

1. cleanupAfterQuery(final ResultSet rs, final Statement stmt)
2. cleanupConnection(ResultSet rs, Statement stmt, Connection conn)
3. cleanupJDBCResouce(ResultSet rs, Statement stmt, String oldCatalog, Connection conn)
4. consume(ResultSet rs)
5. consume2(ResultSet rs)
6. createLargeResultSetPreparedStatement(Connection conn, String sql)
7. createLargeResultSetStatement(Connection conn)
8. createTable(ResultSet rs)
9. createUid(final String[] keys, final ResultSet rs, final String keySeparator)