Examples of java.sql.ResultSet.updateDate()

java.sql.ResultSet.updateDate()
Updates a column specified by a column index with a java.sql.Date 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

        rs.updateString(2, null);
        rs.updateBigDecimal(3, null);
        rs.updateBoolean(4, false);
        rs.updateByte(5, (byte) 0);
        rs.updateBytes(6, null);
        rs.updateDate(7, null);
        rs.updateTime(8, null);
        rs.updateTimestamp(9, null);
        rs.updateDouble(10, 0.0);
        rs.updateFloat(11, (float) 0.0);
        rs.updateLong(12, 0L);

View Full Code Here

        rs.updateString("NAME", "+");
        rs.updateBigDecimal("DEC", new BigDecimal("1.2"));
        rs.updateBoolean("BOO", true);
        rs.updateByte("BYE", (byte) 0xff);
        rs.updateBytes("BIN", new byte[] { 0x00, (byte) 0xff });
        rs.updateDate("D", Date.valueOf("2005-09-21"));
        rs.updateTime("T", Time.valueOf("21:46:28"));
        rs.updateTimestamp("TS", Timestamp.valueOf("2005-09-21 21:47:09.567890123"));
        rs.updateDouble("DB", 1.725);
        rs.updateFloat("R", (float) 2.5);
        rs.updateLong("L", Long.MAX_VALUE);

View Full Code Here

                        continue;
                    }
                } else if (updateXXXName == 14) { 
                    //update column with updateDate methods
                    if (indexOrName == 1) //test by passing column position
                        rs.updateDate(sqlType,rs1.getDate(updateXXXName));
                    else //test by passing column name
                        rs.updateDate(ColumnNames[sqlType-1],
                                rs1.getDate(updateXXXName));
                } else if (updateXXXName == 15) { 
                    //update column with updateTime methods

View Full Code Here

                } else if (updateXXXName == 14) { 
                    //update column with updateDate methods
                    if (indexOrName == 1) //test by passing column position
                        rs.updateDate(sqlType,rs1.getDate(updateXXXName));
                    else //test by passing column name
                        rs.updateDate(ColumnNames[sqlType-1],
                                rs1.getDate(updateXXXName));
                } else if (updateXXXName == 15) { 
                    //update column with updateTime methods
                    if (indexOrName == 1) //test by passing column position
                        rs.updateTime(sqlType, rs1.getTime(updateXXXName));

View Full Code Here

                    localCal.get(Calendar.MINUTE), cal.get(Calendar.MINUTE));
            assertEquals("T.SECONDS",
                    localCal.get(Calendar.SECOND), cal.get(Calendar.SECOND));


            Date d1 = dates[i];
            rs.updateDate(3, d1);
            assertEquals("D (default calendar)",
                    stripTime(d1, localCal), rs.getDate(3));
            Date d2 = rs.getDate(3, cal);
            cal.clear();
            cal.setTime(d2);

View Full Code Here

                    t1.getMinutes(), cal.get(Calendar.MINUTE));
            assertEquals("T.SECONDS",
                    t1.getSeconds(), cal.get(Calendar.SECOND));


            Date d1 = dates[i];
            rs.updateDate(3, d1);
            assertEquals("D (default calendar)",
                    stripTime(d1, localCal), rs.getDate(3));
            Date d2 = rs.getDate(3, cal);
            cal.clear();
            cal.setTime(d2);

View Full Code Here

            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);
            rs.updateLong("F9", 99);

View Full Code Here


            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);
            rs.updateLong(9, 99);

View Full Code Here


    r.moveToInsertRow();


    r.updateString("name", name);
    r.updateString("surname", surname);
    r.updateDate("birthdate", birthDate);
    r.updateString("birthplace", birthPlace);
    r.updateString("nationality", nationality);
    r.updateString("maritalstatus", maritalStatus);
    r.updateString("username", username);    
    r.updateBytes("password", Utility.SHA1(password));

View Full Code Here


    r.moveToInsertRow();


    r.updateString("name", name);
    r.updateString("surname", surname);
    r.updateDate("birthdate", birthDate);
    r.updateString("birthplace", birthPlace);
    r.updateString("nationality", nationality);
    r.updateString("maritalstatus", maritalStatus);
    r.updateString("username", username);    
    r.updateBytes("password", Utility.SHA1(password));

View Full Code Here

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.