Examples of java.sql.ResultSet.beforeFirst()

java.sql.ResultSet.beforeFirst()
Moves the Cursor to the start of the ResultSet, before the first row. @throws SQLException if a database error happens

        rs.relative(1);
        rs.absolute(3);
        rs.relative(-1);
        rs.first();
        rs.last();
        rs.beforeFirst();
        rs.afterLast();
        
        // close result set and statement
        rs.close();
        s.close();

View Full Code Here


    result.last();


    Object[][] rows = new Object[result.getRow()][6];


    result.beforeFirst();


    while(result.next())
    {
      int row = result.getRow() - 1;

View Full Code Here

            String select = "SELECT * FROM test";
            PreparedStatement stmt = c.prepareStatement(select,
                ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
            ResultSet rs = stmt.executeQuery();


            rs.beforeFirst();


            while (rs.next()) {
                int num = rs.getInt("num");


                if ((num % 7) == 0) {

View Full Code Here


      PreparedStatement stmt = connection.prepareStatement(String.format(
          SQL_SELECT_STATEMENT1, "msgbox", msgBoxId, String.format(
              "%s.%s", "msgbox", "id")));
      ResultSet resultSet = stmt.executeQuery();
      resultSet.beforeFirst();


      while (resultSet.next()) {
        InputStream in = resultSet.getAsciiStream("xml");
        ObjectInputStream s = new ObjectInputStream(in);
        String xmlString = (String) s.readObject();

View Full Code Here

                int am_of_resources = resourceIds.getRow();             
                r_matrix = new ResourcePrimitive[am_of_resources];
                int i = 0; //index of matrix
                
                //Compute matrix
                resourceIds.beforeFirst();
                while(resourceIds.next()){                 
                    int f2r2 = 0;
                    String content_hash = resourceIds.getNString(1);
                    ResourcePrimitive resInf = new ResourcePrimitive(content_hash, k);
                    res_tags_STMT.setNString(1, content_hash);

View Full Code Here

            s.executeQuery("select * from t1");
        
        rs.last();
        lastRow = rs.getRow();
        
        rs.beforeFirst();
        
        rs.next();
        
        // Test that it is possible to move to next row from insertRow
        currentPosition = rs.getRow();

View Full Code Here

        rs.relative(1);
        rs.absolute(3);
        rs.relative(-1);
        rs.first();
        rs.last();
        rs.beforeFirst();
        rs.afterLast();
        
        // close result set and statement
        rs.close();
        s.close();

View Full Code Here


        // Test that it is possible to move beforeFirst from insertRow
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.beforeFirst();
        assertTrue("isBeforeFirst() should return true", rs.isBeforeFirst());
        rs.next();
        assertEquals("CurrentPosition should be 1", rs.getRow(), 1);
        assertTrue("isFirst() should return true", rs.isFirst());

View Full Code Here

        rs.next();
        rs.moveToInsertRow();
        checkDetectabilityCallsOutsideRow(rs, "on insertRow");
        rs.moveToCurrentRow(); // needed until to DERBY-1322 is fixed


        rs.beforeFirst();
        checkDetectabilityCallsOutsideRow(rs, "on beforeFirst row");


        rs.afterLast();
        checkDetectabilityCallsOutsideRow(rs, "on afterLast row");

View Full Code Here

          Result.setCurrentPage("1");
        } else
          Result.setCurrentPage(String.valueOf(Page));
        Offset = (Page - 1) * rowsPerPage;
        if (Offset == 0) {
          Rs.beforeFirst();
        } else {
          Rs.absolute(Offset);
        }


        // 初始化参数变量

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.