Lines Matching refs:sql
28 import java.sql.*;
29 import javax.sql.*;
35 import javax.sql.rowset.*;
36 import javax.sql.rowset.spi.*;
37 import javax.sql.rowset.serial.*;
420 * env.put(javax.sql.rowset.spi.SyncFactory.ROWSET_PROVIDER_NAME,
466 javax.sql.rowset.spi.SyncFactory.ROWSET_SYNC_PROVIDER);
681 } else if (obj instanceof java.sql.Array) {
683 obj = new SerialArray((java.sql.Array)obj, map);
685 obj = new SerialArray((java.sql.Array)obj);
751 * value for scale. javax.sql.rowset.RowSetMetaDataImpl will throw an exception
788 * @see java.sql.Connection
864 * @see #acceptChanges(java.sql.Connection)
865 * @see javax.sql.RowSetWriter
866 * @see javax.sql.rowset.spi.SyncProvider
936 * @see javax.sql.RowSetWriter
937 * @see javax.sql.rowset.spi.SyncFactory
938 * @see javax.sql.rowset.spi.SyncProvider
956 * @see javax.sql.RowSetListener#rowSetChanged
988 * @see javax.sql.RowSetListener#rowSetChanged
1072 * @see java.sql.ResultSet#cancelRowUpdates
1102 * @see javax.sql.RowSetEvent
1103 * @see javax.sql.RowSetListener
1153 * @see javax.sql.RowSetEvent
1154 * @see javax.sql.RowSetListener
1211 * @see javax.sql.RowSetEvent
1212 * @see javax.sql.RowSetListener
1246 * @see javax.sql.RowSetEvent
1247 * @see javax.sql.RowSetListener
2106 * <code>java.sql.Date</code> object.
2111 * @return the column value as a <code>java.sql.Data</code> object; if
2117 public java.sql.Date getDate(int columnIndex) throws SQLException {
2142 case java.sql.Types.DATE: {
2143 long sec = ((java.sql.Date)value).getTime();
2144 return new java.sql.Date(sec);
2146 case java.sql.Types.TIMESTAMP: {
2147 long sec = ((java.sql.Timestamp)value).getTime();
2148 return new java.sql.Date(sec);
2150 case java.sql.Types.CHAR:
2151 case java.sql.Types.VARCHAR:
2152 case java.sql.Types.LONGVARCHAR: {
2155 return ((java.sql.Date)(df.parse(value.toString())));
2171 * <code>java.sql.Time</code> object.
2181 public java.sql.Time getTime(int columnIndex) throws SQLException {
2206 case java.sql.Types.TIME: {
2207 return (java.sql.Time)value;
2209 case java.sql.Types.TIMESTAMP: {
2210 long sec = ((java.sql.Timestamp)value).getTime();
2211 return new java.sql.Time(sec);
2213 case java.sql.Types.CHAR:
2214 case java.sql.Types.VARCHAR:
2215 case java.sql.Types.LONGVARCHAR: {
2218 return ((java.sql.Time)(tf.parse(value.toString())));
2234 * <code>java.sql.Timestamp</code> object.
2244 public java.sql.Timestamp getTimestamp(int columnIndex) throws SQLException {
2269 case java.sql.Types.TIMESTAMP: {
2270 return (java.sql.Timestamp)value;
2272 case java.sql.Types.TIME: {
2273 long sec = ((java.sql.Time)value).getTime();
2274 return new java.sql.Timestamp(sec);
2276 case java.sql.Types.DATE: {
2277 long sec = ((java.sql.Date)value).getTime();
2278 return new java.sql.Timestamp(sec);
2280 case java.sql.Types.CHAR:
2281 case java.sql.Types.VARCHAR:
2282 case java.sql.Types.LONGVARCHAR: {
2285 return ((java.sql.Timestamp)(tf.parse(value.toString())));
2676 * of the current row as a <code>java.sql.Date</code> object.
2688 public java.sql.Date getDate(String columnName) throws SQLException {
2694 * of the current row as a <code>java.sql.Time</code> object.
2704 public java.sql.Time getTime(String columnName) throws SQLException {
2710 * of the current row as a <code>java.sql.Timestamp</code> object.
2720 public java.sql.Timestamp getTimestamp(String columnName) throws SQLException {
2901 * @see javax.sql.RowSetMetaData
3865 * @param type one of the constants from <code>java.sql.Types</code>
3874 case java.sql.Types.NUMERIC:
3875 case java.sql.Types.DECIMAL:
3876 case java.sql.Types.BIT:
3877 case java.sql.Types.TINYINT:
3878 case java.sql.Types.SMALLINT:
3879 case java.sql.Types.INTEGER:
3880 case java.sql.Types.BIGINT:
3881 case java.sql.Types.REAL:
3882 case java.sql.Types.DOUBLE:
3883 case java.sql.Types.FLOAT:
3893 * @param type one of the constants from <code>java.sql.Types</code>
3900 case java.sql.Types.CHAR:
3901 case java.sql.Types.VARCHAR:
3902 case java.sql.Types.LONGVARCHAR:
3912 * @param type one of the constants from <code>java.sql.Types</code>
3919 case java.sql.Types.BINARY:
3920 case java.sql.Types.VARBINARY:
3921 case java.sql.Types.LONGVARBINARY:
3933 * @param type one of the constants from <code>java.sql.Types</code>
3940 case java.sql.Types.DATE:
3941 case java.sql.Types.TIME:
3942 case java.sql.Types.TIMESTAMP:
3954 * @param type one of the constants from <code>java.sql.Types</code>
3961 case java.sql.Types.BIT:
3962 case java.sql.Types.BOOLEAN:
3981 * <code>java.sql.Types</code>
3984 * <code>java.sql.Types</code>: <code>NUMERIC</code>,
3992 * numeric types in <code>java.sql.Types</code>
4007 case java.sql.Types.BIT:
4012 case java.sql.Types.TINYINT:
4014 case java.sql.Types.SMALLINT:
4016 case java.sql.Types.INTEGER:
4018 case java.sql.Types.BIGINT:
4020 case java.sql.Types.NUMERIC:
4021 case java.sql.Types.DECIMAL:
4023 case java.sql.Types.REAL:
4024 case java.sql.Types.FLOAT:
4026 case java.sql.Types.DOUBLE:
4028 case java.sql.Types.CHAR:
4029 case java.sql.Types.VARCHAR:
4030 case java.sql.Types.LONGVARCHAR:
4056 * <TD><code>java.sql.Date</code>
4061 * <TD><code>java.sql.Time</code>
4066 * <TD><code>java.sql.Timestamp</code>
4082 * <code>java.sql.Types</code>
4085 * <code>java.sql.Types</code>: <code>DATE</code>,
4091 * temporal types in <code>java.sql.Types</code>
4107 case java.sql.Types.DATE:
4108 if (srcType == java.sql.Types.TIMESTAMP) {
4109 return new java.sql.Date(((java.sql.Timestamp)srcObj).getTime());
4113 case java.sql.Types.TIMESTAMP:
4114 if (srcType == java.sql.Types.TIME) {
4115 return new Timestamp(((java.sql.Time)srcObj).getTime());
4117 return new Timestamp(((java.sql.Date)srcObj).getTime());
4119 case java.sql.Types.TIME:
4120 if (srcType == java.sql.Types.TIMESTAMP) {
4121 return new Time(((java.sql.Timestamp)srcObj).getTime());
4125 case java.sql.Types.CHAR:
4126 case java.sql.Types.VARCHAR:
4127 case java.sql.Types.LONGVARCHAR:
4149 * <code>java.sql.Types</code>
4152 * <code>java.sql.Types</code>: <code>BIT</code>,
4157 * types in <code>java.sql.Types</code>
4174 case java.sql.Types.BIT:
4179 case java.sql.Types.BOOLEAN:
4255 java.sql.Types.BIT,
4291 java.sql.Types.TINYINT,
4327 java.sql.Types.SMALLINT,
4362 java.sql.Types.INTEGER,
4398 java.sql.Types.BIGINT,
4435 java.sql.Types.REAL,
4470 java.sql.Types.DOUBLE,
4506 java.sql.Types.NUMERIC,
4607 public void updateDate(int columnIndex, java.sql.Date x) throws SQLException {
4614 java.sql.Types.DATE,
4644 public void updateTime(int columnIndex, java.sql.Time x) throws SQLException {
4651 java.sql.Types.TIME,
4682 public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws SQLException {
4689 java.sql.Types.TIMESTAMP,
5228 public void updateDate(String columnName, java.sql.Date x) throws SQLException {
5256 public void updateTime(String columnName, java.sql.Time x) throws SQLException {
5287 public void updateTimestamp(String columnName, java.sql.Timestamp x) throws SQLException {
5760 if (RowSetMD.getColumnType(columnIndex) != java.sql.Types.REF) {
5799 if (RowSetMD.getColumnType(columnIndex) != java.sql.Types.BLOB) {
5839 if (RowSetMD.getColumnType(columnIndex) != java.sql.Types.CLOB) {
5873 java.sql.Array value;
5880 if (RowSetMD.getColumnType(columnIndex) != java.sql.Types.ARRAY) {
5885 value = (java.sql.Array)(getCurrentRow().getColumnObject(columnIndex));
5995 * of this <code>CachedRowSetImpl</code> object as a <code>java.sql.Date</code>
6012 public java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException {
6031 java.sql.Types.DATE);
6051 return new java.sql.Date(cal.getTime().getTime());
6056 * of this <code>CachedRowSetImpl</code> object as a <code>java.sql.Date</code>
6072 public java.sql.Date getDate(String columnName, Calendar cal) throws SQLException {
6078 * of this <code>CachedRowSetImpl</code> object as a <code>java.sql.Time</code>
6095 public java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException {
6114 java.sql.Types.TIME);
6130 return new java.sql.Time(cal.getTime().getTime());
6135 * of this <code>CachedRowSetImpl</code> object as a <code>java.sql.Time</code>
6151 public java.sql.Time getTime(String columnName, Calendar cal) throws SQLException {
6157 * of this <code>CachedRowSetImpl</code> object as a <code>java.sql.Timestamp</code>
6174 public java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException {
6193 java.sql.Types.TIMESTAMP);
6212 return new java.sql.Timestamp(cal.getTime().getTime());
6218 * <code>java.sql.Timestamp</code> object, using the given
6234 public java.sql.Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException {
6492 * @param ref the new column <code>java.sql.Ref</code> value
6498 public void updateRef(int columnIndex, java.sql.Ref ref) throws SQLException {
6526 * @param ref the new column <code>java.sql.Ref</code> value
6532 public void updateRef(String columnName, java.sql.Ref ref) throws SQLException {
6606 * <code>java.sql.Blob</code> value.
6647 * <code>java.sql.Blob </code> value.
6673 * <code>java.sql.Array</code> values.
6708 * <code>java.sql.Array</code> value.
6755 if (RowSetMD.getColumnType(columnIndex) != java.sql.Types.DATALINK) {
6882 * @see java.sql.Connection#commit
6892 * @see java.sql.Connection#rollback
6902 * @see java.sql.Connection#rollback(Savepoint)
7368 } else if (obj instanceof java.sql.Array) {
7369 obj = new SerialArray((java.sql.Array)obj, map);
7729 * <code>ResultSet</code> object as a java.sql.RowId object in the Java
7744 * <code>ResultSet</code> object as a java.sql.RowId object in the Java
7837 * to <code>java.sql.Types.NCLOB</code>
7849 * to <code>java.sql.Types.NCLOB</code>
7890 public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException {
7900 * Sets the designated parameter to the given <code>java.sql.SQLXML</code> object. The driver converts this to an
7912 * Sets the designated parameter to the given <code>java.sql.SQLXML</code> object. The driver converts this to an
7925 * Sets the designated parameter to the given <code>java.sql.RowId</code> object. The
7941 * Sets the designated parameter to the given <code>java.sql.RowId</code> object. The
7983 * Sets the designated parameter to a <code>java.sql.NClob</code> object. The object
7984 * implements the <code>java.sql.NClob</code> interface. This <code>NClob</code>
8039 * Updates the designated column with a <code>java.sql.SQLXML</code> value.
8055 * Updates the designated column with a <code>java.sql.SQLXML</code> value.
9051 * Sets the designated parameter to a <code>java.sql.NClob</code> object. The driver converts this to
9166 * Sets the designated parameter to the given <code>java.sql.Timestamp</code> value,
9186 public void setTimestamp(String parameterName, java.sql.Timestamp x, Calendar cal)
9219 * Sets the designated parameter to the given <code>java.sql.Clob</code> object.
9263 * Sets the designated parameter to the given <code>java.sql.Date</code> value
9278 public void setDate(String parameterName, java.sql.Date x)
9285 * Sets the designated parameter to the given <code>java.sql.Date</code> value,
9305 public void setDate(String parameterName, java.sql.Date x, Calendar cal)
9312 * Sets the designated parameter to the given <code>java.sql.Time</code> value.
9325 public void setTime(String parameterName, java.sql.Time x)
9332 * Sets the designated parameter to the given <code>java.sql.Time</code> value,
9352 public void setTime(String parameterName, java.sql.Time x, Calendar cal)
9501 * Sets the designated parameter to the given <code>java.sql.Blob</code> object.
9567 * @param targetSqlType the SQL type (as defined in java.sql.Types) to be
9569 * @param scale for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types,
9599 * @param targetSqlType the SQL type (as defined in java.sql.Types) to be
9896 * Sets the designated parameter to the given <code>java.sql.Timestamp</code> value.
9910 public void setTimestamp(String parameterName, java.sql.Timestamp x)
9921 * @param sqlType the SQL type code defined in <code>java.sql.Types</code>
9955 * @param sqlType a value from <code>java.sql.Types</code>