Examples of java.sql.ResultSet.updateDouble()

java.sql.ResultSet.updateDouble()
Updates a column specified by a column index with a double value. @param columnIndex the index of the column to update @param x the new value for the specified column @throws SQLException if a database error happens

            "SELECT * FROM MultiTypeTable",
            ResultSet.TYPE_FORWARD_ONLY,
            ResultSet.CONCUR_UPDATABLE);
        rs = uSelect.executeQuery();
        rs.next();
        rs.updateDouble("F06", Float.MAX_VALUE * 10.0);
        rs.updateRow();


        rs = plainSelect.executeQuery();
        rs.next();

View Full Code Here

        // JDBC type -> float
        rs.close();


        rs = uSelect.executeQuery();
        rs.next();
        rs.updateDouble("F06", -Float.MAX_VALUE * 10.0);
        rs.updateRow();


        rs = plainSelect.executeQuery();
        rs.next();

View Full Code Here

            "select * from s1.wages");
        assertTrue(rs.isBeforeFirst());
        rs.moveToInsertRow();
        rs.updateInt("EMPLOYEEID", 666);
        rs.updateInt("CATEGORY", 667);
        rs.updateDouble("SALARY", 666.0);
        rs.updateString("NAME", "N.N.");
        rs.insertRow();
        rs.close();


        rs = cStmt.executeQuery(

View Full Code Here

        rs.close();


        rs = cStmt.executeQuery(
            "select * from s1.wages where name = 'N.N.'");
        rs.next();
        rs.updateDouble("SALARY", 666.1);
        rs.updateRow();
        rs.close();


        rs = cStmt.executeQuery(
            "select * from s1.wages where name = 'N.N.'");

View Full Code Here

        ResultSet rs = s.executeQuery(SELECT_STMT);
        
        rs.next();
      
        for (int i = 1; i <= COLUMNS; i++) {
            rs.updateDouble(i, 2.0);
            assertEquals("Expected rs.getDouble(" + i + 
                         ") to match updated value", 2, (int) rs.getDouble(i));
        }
        rs.updateRow();
        rs.close();

View Full Code Here

            rs.getAsciiStream("F13");
            rs.getCharacterStream("F14");
            rs.getObject("F15", new HashMap<String, Class<?>>());


            rs.updateFloat("F1", 2F);
            rs.updateDouble("F2", 2D);
            rs.updateDate("F4", new java.sql.Date(System.currentTimeMillis()));
            rs.updateTime("F5", new java.sql.Time(System.currentTimeMillis()));
            rs.updateByte("F6", (byte) 6);
            rs.updateShort("F7", (short) 77);
            rs.updateInt("F8", 77);

View Full Code Here

            rs.getObject(15, new HashMap<String, Class<?>>());


            rs.getHoldability();


            rs.updateFloat(1, 2F);
            rs.updateDouble(2, 2D);
            rs.updateDate(4, new java.sql.Date(System.currentTimeMillis()));
            rs.updateTime(5, new java.sql.Time(System.currentTimeMillis()));
            rs.updateByte(6, (byte) 6);
            rs.updateShort(7, (short) 77);
            rs.updateInt(8, 77);

View Full Code Here

0 1 2

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.