Examples of java.sql.ResultSet.findColumn()

java.sql.ResultSet.findColumn()
Gets the index number for a column in the ResultSet from the provided Column Name. @param columnName the column name @return the index of the column in the ResultSet for the column name @throws SQLException if a database error happens

                        DatabaseMetaData dbmd = theConnection.getMetaData();
                        rs = dbmd.getColumns(null,schema,table,null);


                        int[] displayColumns = new int[] {
                                rs.findColumn("TABLE_SCHEM"),
                                rs.findColumn("TABLE_NAME"),
                                rs.findColumn("COLUMN_NAME"),
                                rs.findColumn("TYPE_NAME"),
                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),

View Full Code Here

                        rs = dbmd.getColumns(null,schema,table,null);


                        int[] displayColumns = new int[] {
                                rs.findColumn("TABLE_SCHEM"),
                                rs.findColumn("TABLE_NAME"),
                                rs.findColumn("COLUMN_NAME"),
                                rs.findColumn("TYPE_NAME"),
                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),
                                rs.findColumn("COLUMN_DEF"),

View Full Code Here


                        int[] displayColumns = new int[] {
                                rs.findColumn("TABLE_SCHEM"),
                                rs.findColumn("TABLE_NAME"),
                                rs.findColumn("COLUMN_NAME"),
                                rs.findColumn("TYPE_NAME"),
                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),
                                rs.findColumn("COLUMN_DEF"),
                                rs.findColumn("CHAR_OCTET_LENGTH"),

View Full Code Here

                        int[] displayColumns = new int[] {
                                rs.findColumn("TABLE_SCHEM"),
                                rs.findColumn("TABLE_NAME"),
                                rs.findColumn("COLUMN_NAME"),
                                rs.findColumn("TYPE_NAME"),
                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),
                                rs.findColumn("COLUMN_DEF"),
                                rs.findColumn("CHAR_OCTET_LENGTH"),
                                rs.findColumn("IS_NULLABLE"),

View Full Code Here

                                rs.findColumn("TABLE_SCHEM"),
                                rs.findColumn("TABLE_NAME"),
                                rs.findColumn("COLUMN_NAME"),
                                rs.findColumn("TYPE_NAME"),
                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),
                                rs.findColumn("COLUMN_DEF"),
                                rs.findColumn("CHAR_OCTET_LENGTH"),
                                rs.findColumn("IS_NULLABLE"),
                        };

View Full Code Here

                                rs.findColumn("TABLE_NAME"),
                                rs.findColumn("COLUMN_NAME"),
                                rs.findColumn("TYPE_NAME"),
                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),
                                rs.findColumn("COLUMN_DEF"),
                                rs.findColumn("CHAR_OCTET_LENGTH"),
                                rs.findColumn("IS_NULLABLE"),
                        };
                        int[] columnWidths = new int[] {

View Full Code Here

                                rs.findColumn("COLUMN_NAME"),
                                rs.findColumn("TYPE_NAME"),
                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),
                                rs.findColumn("COLUMN_DEF"),
                                rs.findColumn("CHAR_OCTET_LENGTH"),
                                rs.findColumn("IS_NULLABLE"),
                        };
                        int[] columnWidths = new int[] {
                                20,

View Full Code Here

                                rs.findColumn("TYPE_NAME"),
                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),
                                rs.findColumn("COLUMN_DEF"),
                                rs.findColumn("CHAR_OCTET_LENGTH"),
                                rs.findColumn("IS_NULLABLE"),
                        };
                        int[] columnWidths = new int[] {
                                20,
                                20,

View Full Code Here

                                rs.findColumn("DECIMAL_DIGITS"),
                                rs.findColumn("NUM_PREC_RADIX"),
                                rs.findColumn("COLUMN_SIZE"),
                                rs.findColumn("COLUMN_DEF"),
                                rs.findColumn("CHAR_OCTET_LENGTH"),
                                rs.findColumn("IS_NULLABLE"),
                        };
                        int[] columnWidths = new int[] {
                                20,
                                20,
                                20,

View Full Code Here


    public void testCaseInsensitiveFindColumn() throws SQLException
    {
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT id, id AS \"ID2\" FROM testrs");
        assertEquals(1, rs.findColumn("id"));
        assertEquals(1, rs.findColumn("ID"));
        assertEquals(1, rs.findColumn("Id"));
        assertEquals(2, rs.findColumn("id2"));
        assertEquals(2, rs.findColumn("ID2"));
        assertEquals(2, rs.findColumn("Id2"));

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.