List of moveToInsertRow() Examples

Examples of moveToInsertRow()

com.alibaba.druid.proxy.jdbc.ResultSetProxy.moveToInsertRow()
com.sun.star.sdbc.XResultSetUpdate.moveToInsertRow()
java.sql.ResultSet.moveToInsertRow()
Moves the cursor position to the Insert row. The current position is remembered and the cursor is positioned at the Insert row. The columns in the Insert row should be filled in with the appropriate update methods, before calling insertRow to insert the new row into the database. @throws SQLException if a database error happens
javax.sql.rowset.FilteredRowSet.moveToInsertRow()
javax.sql.rowset.JdbcRowSet.moveToInsertRow()
javax.sql.rowset.WebRowSet.moveToInsertRow()
javax.sql.rowset.spi.SyncResolver.moveToInsertRow()
org.apache.harmony.sql.internal.rowset.SyncResolverImpl.moveToInsertRow()

Examples of com.alibaba.druid.proxy.jdbc.ResultSetProxy.moveToInsertRow()

        Statement stmt = conn.createStatement();
        ResultSetProxy rs = (ResultSetProxy) stmt.executeQuery(sql);


        rs.insertRow();
        rs.refreshRow();
        rs.moveToInsertRow();
        rs.moveToCurrentRow();
        rs.next();


        rs.updateRef(1, null);
        rs.updateArray(1, null);

View Full Code Here

Examples of com.sun.star.sdbc.XResultSetUpdate.moveToInsertRow()

            (XResultSetUpdate.class, set) ;


        XRowUpdate rowUpdt = (XRowUpdate) UnoRuntime.queryInterface
            (XRowUpdate.class, set) ;


        updt.moveToInsertRow() ;


        for (int i = 0; i < values.length; i++) {
            if (values[i] instanceof String) {
                rowUpdt.updateString(TST_STRING, (String) values[i]) ;
            } else

View Full Code Here

Examples of com.sun.star.sdbc.XResultSetUpdate.moveToInsertRow()


    /* ------------------------------------------------------------------ */
    private void moveToInsertRow() throws com.sun.star.uno.Exception, java.lang.Exception
    {
        XResultSetUpdate xResultSet = (XResultSetUpdate)UnoRuntime.queryInterface( XResultSetUpdate.class, m_masterForm );
        xResultSet.moveToInsertRow( );
    }


    /* ------------------------------------------------------------------ */
    private void moveToFirst() throws com.sun.star.uno.Exception, java.lang.Exception
    {

View Full Code Here

Examples of java.sql.ResultSet.moveToInsertRow()

            assertEquals("java.sql.Blob", meta.getColumnClassName(16));
        } else {
            assertEquals("java.io.Reader", meta.getColumnClassName(15));
            assertEquals("java.io.InputStream", meta.getColumnClassName(16));
        }
        rs.moveToInsertRow();
        rs.updateInt(1, 0);
        rs.updateNull(2);
        rs.updateNull("DEC");
        // 'not set' values are set to null
        rs.insertRow();

View Full Code Here

Examples of java.sql.ResultSet.moveToInsertRow()

        rs.updateNull(2);
        rs.updateNull("DEC");
        // 'not set' values are set to null
        rs.insertRow();


        rs.moveToInsertRow();
        rs.updateInt(1, 1);
        rs.updateString(2, null);
        rs.updateBigDecimal(3, null);
        rs.updateBoolean(4, false);
        rs.updateByte(5, (byte) 0);

View Full Code Here

Examples of java.sql.ResultSet.moveToInsertRow()

        rs.updateShort(14, (short) 0);
        rs.updateCharacterStream(15, new StringReader("test"), 0);
        rs.updateBinaryStream(16, new ByteArrayInputStream(new byte[] { (byte) 0xff, 0x00 }), 0);
        rs.insertRow();


        rs.moveToInsertRow();
        rs.updateInt("ID", 2);
        rs.updateString("NAME", "+");
        rs.updateBigDecimal("DEC", new BigDecimal("1.2"));
        rs.updateBoolean("BOO", true);
        rs.updateByte("BYE", (byte) 0xff);

View Full Code Here

Examples of java.sql.ResultSet.moveToInsertRow()

                rs.updateString(2, "Updated " + rs.getString(2));
                rs.updateRow();
            } else {
                rs.deleteRow();
            }
            rs.moveToInsertRow();
            rs.updateString(2, "Inserted " + j);
            rs.updateInt(1, j);
            j += 2;
            rs.insertRow();
        }

View Full Code Here

Examples of java.sql.ResultSet.moveToInsertRow()

        String result = "", error = "";
        try {
            if (op == 1) {
                boolean insert = row < 0;
                if (insert) {
                    rs.moveToInsertRow();
                } else {
                    rs.absolute(row);
                }
                for (int i = 0; i < rs.getMetaData().getColumnCount(); i++) {
                    String x = attributes.getProperty("r" + row + "c" + (i + 1));

View Full Code Here

Examples of java.sql.ResultSet.moveToInsertRow()

        
        rs.next();
        
        // Test that it is possible to move to next row from insertRow
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.next();
        assertEquals("CurrentPosition should be " + (currentPosition + 1), 
                rs.getRow(), currentPosition + 1);
        // should be able to delete the row

View Full Code Here

Examples of java.sql.ResultSet.moveToInsertRow()

        // should be able to delete the row
        rs.deleteRow();


        // Test that it is possible to move using relative from insertRow
        currentPosition = rs.getRow();
        rs.moveToInsertRow();
        rs.updateInt(1, currentPosition + 1000);
        rs.relative(2);
        assertEquals("CurrentPosition should be " + (currentPosition + 2), 
                rs.getRow(), currentPosition + 2);
        // should be able to delete the row

View Full Code Here

0 1 2 3 4 5

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.