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

    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"));
        try

View Full Code Here

    {
        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"));
        try
        {

View Full Code Here

        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"));
        try
        {
            rs.findColumn("id3");

View Full Code Here

        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"));
        try
        {
            rs.findColumn("id3");
            fail("There isn't an id3 column in the ResultSet.");

View Full Code Here

        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"));
        try
        {
            rs.findColumn("id3");
            fail("There isn't an id3 column in the ResultSet.");
        }

View Full Code Here

        assertEquals(2, rs.findColumn("id2"));
        assertEquals(2, rs.findColumn("ID2"));
        assertEquals(2, rs.findColumn("Id2"));
        try
        {
            rs.findColumn("id3");
            fail("There isn't an id3 column in the ResultSet.");
        }
        catch (SQLException sqle)
        {
        }

View Full Code Here

        + "(column1,column2,column3) values (3031,11,'binlijin3031');");
    ResultSet rs = stat
        .executeQuery("SELECT column1,column2,column3 FROM test where column1=3031 and column3='binlijin3031'");
    // assertEquals(1, rs.findColumn("COLUMN1"));
    // assertEquals(2, rs.findColumn("COLUMN2"));
    assertEquals(1, rs.findColumn("column1"));
    assertEquals(2, rs.findColumn("column2"));
    // assertEquals(1, rs.findColumn("Column1"));
    // assertEquals(2, rs.findColumn("Column2"));
  }

View Full Code Here

    ResultSet rs = stat
        .executeQuery("SELECT column1,column2,column3 FROM test where column1=3031 and column3='binlijin3031'");
    // assertEquals(1, rs.findColumn("COLUMN1"));
    // assertEquals(2, rs.findColumn("COLUMN2"));
    assertEquals(1, rs.findColumn("column1"));
    assertEquals(2, rs.findColumn("column2"));
    // assertEquals(1, rs.findColumn("Column1"));
    // assertEquals(2, rs.findColumn("Column2"));
  }


  @Test

View Full Code Here


    // MySQL compatibility (is this required?)
    rs = stat
        .executeQuery("SELECT column1,column2,column3 FROM test where column3='testInt' ORDER BY column1");
    // MySQL compatibility
    assertEquals(1, rs.findColumn("column1"));
    assertEquals(2, rs.findColumn("column2"));


    ResultSetMetaData meta = rs.getMetaData();
    assertEquals(3, meta.getColumnCount());

View Full Code Here

    // MySQL compatibility (is this required?)
    rs = stat
        .executeQuery("SELECT column1,column2,column3 FROM test where column3='testInt' ORDER BY column1");
    // MySQL compatibility
    assertEquals(1, rs.findColumn("column1"));
    assertEquals(2, rs.findColumn("column2"));


    ResultSetMetaData meta = rs.getMetaData();
    assertEquals(3, meta.getColumnCount());


    assertTrue(rs.getRow() == 0);

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.