com.mysql.jdbc.JDBC42UpdatableResultSet Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of mysql-connector-java
Show all versions of mysql-connector-java
MySQL JDBC Type 4 driver
/*
Copyright (c) 2015, 2017, Oracle and/or its affiliates. All rights reserved.
The MySQL Connector/J is licensed under the terms of the GPLv2
, like most MySQL Connectors.
There are special exceptions to the terms and conditions of the GPLv2 as it is applied to
this software, see the FOSS License Exception
.
This program is free software; you can redistribute it and/or modify it under the terms
of the GNU General Public License as published by the Free Software Foundation; version 2
of the License.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this
program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth
Floor, Boston, MA 02110-1301 USA
*/
package com.mysql.jdbc;
import java.sql.Date;
import java.sql.SQLException;
import java.sql.SQLType;
import java.sql.Struct;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.time.OffsetDateTime;
import java.time.OffsetTime;
import java.time.format.DateTimeParseException;
import com.mysql.jdbc.Field;
import com.mysql.jdbc.RowData;
import com.mysql.jdbc.SQLError;
public class JDBC42UpdatableResultSet extends JDBC4UpdatableResultSet {
public JDBC42UpdatableResultSet(String catalog, Field[] fields, RowData tuples, MySQLConnection conn, StatementImpl creatorStmt) throws SQLException {
super(catalog, fields, tuples, conn, creatorStmt);
}
/*
* Helper methods.
*/
private int translateAndCheckSqlType(SQLType sqlType) throws SQLException {
return JDBC42Helper.translateAndCheckSqlType(sqlType, getExceptionInterceptor());
}
/**
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnIndex
* @param type
* @return
* @throws SQLException
*/
public T getObject(int columnIndex, Class type) throws SQLException {
synchronized (checkClosed().getConnectionMutex()) {
if (type == null) {
throw SQLError.createSQLException("Type parameter can not be null", SQLError.SQL_STATE_ILLEGAL_ARGUMENT, getExceptionInterceptor());
}
if (type.equals(LocalDate.class)) {
return type.cast(getDate(columnIndex).toLocalDate());
} else if (type.equals(LocalDateTime.class)) {
return type.cast(getTimestamp(columnIndex).toLocalDateTime());
} else if (type.equals(LocalTime.class)) {
return type.cast(getTime(columnIndex).toLocalTime());
} else if (type.equals(OffsetDateTime.class)) {
try {
return type.cast(OffsetDateTime.parse(getString(columnIndex)));
} catch (DateTimeParseException e) {
// Let it continue and try by object deserialization.
}
} else if (type.equals(OffsetTime.class)) {
try {
return type.cast(OffsetTime.parse(getString(columnIndex)));
} catch (DateTimeParseException e) {
// Let it continue and try by object deserialization.
}
}
return super.getObject(columnIndex, type);
}
}
/**
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnIndex
* @param x
* @throws SQLException
*/
@Override
public void updateObject(int columnIndex, Object x) throws SQLException {
super.updateObject(columnIndex, JDBC42Helper.convertJavaTimeToJavaSql(x));
}
/**
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnIndex
* @param x
* @param scaleOrLength
* @throws SQLException
*/
@Override
public void updateObject(int columnIndex, Object x, int scaleOrLength) throws SQLException {
super.updateObject(columnIndex, JDBC42Helper.convertJavaTimeToJavaSql(x), scaleOrLength);
}
/**
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnLabel
* @param x
* @throws SQLException
*/
@Override
public void updateObject(String columnLabel, Object x) throws SQLException {
super.updateObject(columnLabel, JDBC42Helper.convertJavaTimeToJavaSql(x));
}
/**
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnLabel
* @param x
* @param scaleOrLength
* @throws SQLException
*/
@Override
public void updateObject(String columnLabel, Object x, int scaleOrLength) throws SQLException {
super.updateObject(columnLabel, JDBC42Helper.convertJavaTimeToJavaSql(x), scaleOrLength);
}
/**
* Support for java.sql.JDBCType/java.sql.SQLType.
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnIndex
* @param x
* @param targetSqlType
* @throws SQLException
*/
public void updateObject(int columnIndex, Object x, SQLType targetSqlType) throws SQLException {
super.updateObjectInternal(columnIndex, JDBC42Helper.convertJavaTimeToJavaSql(x), translateAndCheckSqlType(targetSqlType), 0);
}
/**
* Support for java.sql.JDBCType/java.sql.SQLType.
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnIndex
* @param x
* @param targetSqlType
* @param scaleOrLength
* @throws SQLException
*/
public void updateObject(int columnIndex, Object x, SQLType targetSqlType, int scaleOrLength) throws SQLException {
super.updateObjectInternal(columnIndex, JDBC42Helper.convertJavaTimeToJavaSql(x), translateAndCheckSqlType(targetSqlType), scaleOrLength);
}
/**
* Support for java.sql.JDBCType/java.sql.SQLType.
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnLabel
* @param x
* @param targetSqlType
* @throws SQLException
*/
public void updateObject(String columnLabel, Object x, SQLType targetSqlType) throws SQLException {
super.updateObjectInternal(findColumn(columnLabel), JDBC42Helper.convertJavaTimeToJavaSql(x), translateAndCheckSqlType(targetSqlType), 0);
}
/**
* Support for java.sql.JDBCType/java.sql.SQLType.
* Support for java.time.LocalDate, java.time.LocalTime, java.time.LocalDateTime, java.time.OffsetTime and java.time.OffsetDateTime.
*
* @param columnLabel
* @param x
* @param targetSqlType
* @param scaleOrLength
* @throws SQLException
*/
public void updateObject(String columnLabel, Object x, SQLType targetSqlType, int scaleOrLength) throws SQLException {
super.updateObjectInternal(findColumn(columnLabel), JDBC42Helper.convertJavaTimeToJavaSql(x), translateAndCheckSqlType(targetSqlType), scaleOrLength);
}
}