XlsResultSet.java

/*
 * Copyright 2012 pcal.net
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software 
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package net.pcal.sqlsheet;

import org.apache.poi.ss.usermodel.*;

import java.io.InputStream;
import java.io.Reader;
import java.math.BigDecimal;
import java.net.URL;
import java.sql.*;
import java.sql.Date;
import java.util.*;

/**
 * SqlSheet implementation of java.sql.ResultSet.
 *
 * @author <a href='http://www.pcal.net'>pcal</a>
 * @author <a href='http://code.google.com/p/sqlsheet'>sqlsheet</a>
 */
public class XlsResultSet implements ResultSet {

    private static final double BAD_DOUBLE = 0;
    protected Statement statement;
    private Workbook workbook;
    private Sheet sheet;
    private XlsResultSetMetaData metadata;
    private int firstSheetRowOffset = 0;
    private int cursorSheetRow;
    private CellStyle dateStyle = null;
    private DataFormatter formatter;

    public XlsResultSet(Workbook wb, Sheet s, int firstSheetRowOffset) throws SQLException {
        if (s == null){
            throw new IllegalArgumentException("null sheet");
        }
        if (wb == null){
            throw new IllegalArgumentException("null workbook");
        }
        formatter = new DataFormatter();
        workbook = wb;
        sheet = s;
        this.firstSheetRowOffset = firstSheetRowOffset;
        cursorSheetRow = this.firstSheetRowOffset - 1;
        metadata = new XlsResultSetMetaData(s, this, firstSheetRowOffset);
        // set the default date cell format
        dateStyle = workbook.createCellStyle();
        dateStyle.setDataFormat(workbook.createDataFormat().getFormat("yyyy-mm-dd"));
    }



    private static SQLException wrapped(Throwable t) {
        SQLException out = new SQLException(t.getMessage());
        out.initCause(t);
        return out;
    }


    public ResultSetMetaData getMetaData() throws SQLException {
        return metadata;
    }

    public boolean getBoolean(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell != null && cell.getBooleanCellValue();
    }

    public boolean getBoolean(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell != null && cell.getBooleanCellValue();
    }

    public double getDouble(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell == null ? 0 : cell.getNumericCellValue();
    }

    public double getDouble(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell == null ? 0 : cell.getNumericCellValue();
    }

    public byte getByte(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (byte) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public byte getByte(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (byte) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public float getFloat(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (float) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public float getFloat(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (float) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public int getInt(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (int) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public int getInt(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (int) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public long getLong(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (long) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public long getLong(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (long) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public Object getObject(String jdbcColumn) throws SQLException {
        return getObject(jdbcColumn);
    }

    public Object getObject(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        int columnType = metadata.getColumnType(jdbcColumn);
        try {
            if (cell == null){
                return null;
            }
            switch (cell.getCellType()) {

                case Cell.CELL_TYPE_BOOLEAN:
                    if (columnType == Types.VARCHAR) {
                        return cell.getBooleanCellValue();
                    } else {
                        throw new RuntimeException("The cell ("+getCurrentRow()+","+jdbcColumn+") is a boolean and cannot be cast to ("+XlsResultSetMetaData.columnTypeNameMap.get(columnType)+".");
                    }
                case Cell.CELL_TYPE_STRING:
                    if (columnType == Types.VARCHAR) {
                        return cell.getStringCellValue();
                    } else {
                        throw new RuntimeException("The cell ("+getCurrentRow()+","+jdbcColumn+") is a string cell and cannot be cast to ("+XlsResultSetMetaData.columnTypeNameMap.get(columnType)+".");
                    }
                case Cell.CELL_TYPE_NUMERIC:
                    if (columnType == Types.VARCHAR) {
                        return String.valueOf(cell.getNumericCellValue());
                    } else if (columnType == Types.DOUBLE) {
                        return cell.getNumericCellValue();
                    } else if (columnType == Types.DATE) {
                        if (DateUtil.isCellDateFormatted(cell)) {
                            java.util.Date value = cell.getDateCellValue();
                            return new java.sql.Date(value.getTime());
                        }
                    } else {
                        throw new RuntimeException("The cell ("+getCurrentRow()+","+jdbcColumn+") is a numeric cell and cannot be cast to ("+XlsResultSetMetaData.columnTypeNameMap.get(columnType)+".");
                    }


                default:
                    return null;
            }
        } catch (Exception e) {
            throw wrapped(e);
        }
    }

    public <T> T getObject(int jdbcColumn, Class<T> type) throws SQLException {
        return (T) getObject(jdbcColumn);
    }

    public <T> T getObject(String columnName, Class<T> type) throws SQLException {
        return (T) getObject(columnName);
    }

//    Object getNextRowObject(int jdbcColumn) throws SQLException {
//        if (sheet.getRow(cursorSheetRow + 1) != null) {
//            Cell cell = sheet.getRow(cursorSheetRow + 1).getCell((short) (jdbcColumn - 1));
//            return getObject(cell);
//        }
//        return getObject(jdbcColumn);
//    }

    public Timestamp getTimestamp(int jdbcColumn) throws SQLException {
        return new Timestamp(((java.util.Date) getObject(jdbcColumn)).getTime());
    }

    public Timestamp getTimestamp(String jdbcColumn) throws SQLException {
        return new Timestamp(((java.util.Date) getObject(jdbcColumn)).getTime());
    }

    public Timestamp getTimestamp(int jdbcColumn, Calendar cal)
            throws SQLException {
        throw nyi();
    }

    public Timestamp getTimestamp(String jdbcColumn, Calendar cal)
            throws SQLException {
        throw nyi();
    }

    public short getShort(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (short) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public short getShort(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return (short) (cell == null ? 0 : cell.getNumericCellValue());
    }

    public String getString(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell == null ? null : formatter.formatCellValue(cell);
    }

    public String getString(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell == null ? null : formatter.formatCellValue(cell);
    }

    public void updateBoolean(int jdbcColumn, boolean x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateBoolean(String jdbcColumn, boolean x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateByte(int jdbcColumn, byte x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateByte(String jdbcColumn, byte x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateDouble(int jdbcColumn, double x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateDouble(String jdbcColumn, double x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateFloat(int jdbcColumn, float x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateFloat(String jdbcColumn, float x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateInt(int jdbcColumn, int x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateInt(String jdbcColumn, int x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateLong(int jdbcColumn, long x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateLong(String jdbcColumn, long x) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateNull(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue((String) null); // REVIEW
        }
    }

    public void updateNull(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue((String) null); // REVIEW
        }
    }

    public void updateObject(int jdbcColumn, Object x) throws SQLException {
        updateObject(findOrCreateCell(jdbcColumn), x);
    }

    public void updateObject(String jdbcColumn, Object x) throws SQLException {
        updateObject(findOrCreateCell(jdbcColumn), x);
    }

    public void updateShort(int jdbcColumn, short x) throws SQLException {
        Cell cell = findOrCreateCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateShort(String jdbcColumn, short x) throws SQLException {
        Cell cell = findOrCreateCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateString(int jdbcColumn, String x) throws SQLException {
        Cell cell = findOrCreateCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    public void updateString(String jdbcColumn, String x) throws SQLException {
        Cell cell = findOrCreateCell(jdbcColumn);
        if (cell != null) {
            cell.setCellValue(x);
        }
    }

    // ResultSet implementation - everything else

    public boolean absolute(int row) throws SQLException {
        cursorSheetRow = (row - 1) + firstSheetRowOffset;
        return true;
    }

    public void afterLast() throws SQLException {
        cursorSheetRow = sheet.getLastRowNum() + 1;
    }

    public void beforeFirst() throws SQLException {
        cursorSheetRow = firstSheetRowOffset - 1;
    }

    public boolean first() throws SQLException {
        cursorSheetRow = firstSheetRowOffset;
        return true;
    }

    public int getFetchDirection() throws SQLException {
        return FETCH_UNKNOWN;
    }

    public void setFetchDirection(int direction) throws SQLException {
        throw nyi();
    }

    public int getFetchSize() throws SQLException {
        return 0;
    }

    public void setFetchSize(int rows) throws SQLException {
        // better just ignore it if configuration is not supported
        //throw nyi();
    }

    public int getRow() throws SQLException {
        return cursorSheetRow - firstSheetRowOffset + 1;
    }

    public int getType() throws SQLException {
        return TYPE_SCROLL_INSENSITIVE;
    }

    public boolean isAfterLast() throws SQLException {
        return cursorSheetRow > sheet.getLastRowNum();
    }

    public boolean isBeforeFirst() throws SQLException {
        return cursorSheetRow < firstSheetRowOffset;
    }

    public boolean isFirst() throws SQLException {
        return cursorSheetRow == firstSheetRowOffset;
    }

    public boolean isLast() throws SQLException {
        return cursorSheetRow == sheet.getLastRowNum();
    }

    public boolean last() throws SQLException {
        cursorSheetRow = sheet.getLastRowNum();
        return true;
    }

    public boolean next() throws SQLException {
        if (isAfterLast()) {
            return false;
        }
        cursorSheetRow++;
        return !isAfterLast() && (sheet.getRow(cursorSheetRow) != null);
    }

    public boolean previous() throws SQLException {
        if (isBeforeFirst()) {
            return false;
        }
        cursorSheetRow--;
        return isBeforeFirst();
    }

    public void moveToInsertRow() throws SQLException {
        for (; true; cursorSheetRow++) {
            Row row = sheet.getRow(cursorSheetRow);
            if (row == null || (row.getCell((short) 0) == null)) {
                sheet.createRow(cursorSheetRow);
                return;
            }
        }
    }

    public void insertRow() throws SQLException {
        cursorSheetRow++;
    }

    private void updateObject(Cell cell, Object x) throws SQLException {
        if (x instanceof String) {
            cell.setCellValue((String) x);
        } else if (x instanceof char[]) {
            cell.setCellValue(new String((char[]) x));
        } else if (x instanceof Double) {
            if (x.equals(Double.NEGATIVE_INFINITY)
                    || x.equals(Double.POSITIVE_INFINITY) || x.equals(Double.NaN)) {
                cell.setCellValue(BAD_DOUBLE);
            } else {
                cell.setCellValue((Double) x);
            }
        } else if (x instanceof Number) {
            cell.setCellValue(((Number) x).doubleValue());
            // } else if (x instanceof java.sql.Date) {
            // cell.setCellValue(new java.util.Date(((java.sql.Date)x).getTime()));
            // if (dateStyle != null) cell.setCellStyle(dateStyle);
        } else if (x instanceof java.util.Date) {
            cell.setCellValue(DateUtil.getExcelDate((java.util.Date) x));
            if (dateStyle != null) cell.setCellStyle(dateStyle);
        } else if (x instanceof Boolean) {
            cell.setCellValue((Boolean) x);
        } else if (x == null) {
            cell.setCellValue((String) null);
        } else {
            throw new SQLException(
                    "Unknown value type for ExcelResultSet.updateObject: " + x + " ("
                            + x.getClass().getName() + ")");
        }
    }

    private Row getCurrentRow() {
        if (sheet.getRow(cursorSheetRow) == null) {
            sheet.createRow(cursorSheetRow);
        }
        return sheet.getRow(cursorSheetRow);
    }

    private Cell findOrCreateCell(int jdbcColumn) {
        Cell cell = getCell(jdbcColumn);
        if (cell == null) {
            cell = getCurrentRow().createCell((short) (jdbcColumn - 1));
        }
        return cell;
    }

    private Cell findOrCreateCell(String jdbcColumn) {
        int col = getSheetColumnNamed(jdbcColumn);
        return findOrCreateCell(col);
    }

    /**
     * Protected becasue used also in the resultset metadata to scan the column type
     * @param jdbcColumn - index of the column
     * @return the Cell
     */
    protected Cell getCell(int jdbcColumn) {
        return sheet.getRow(cursorSheetRow).getCell((short) (jdbcColumn - 1));
    }

    private Cell getCell(String named) {
        return sheet.getRow(cursorSheetRow).getCell(getSheetColumnNamed(named));
    }

    private short getSheetColumnNamed(String name) {
        int count = metadata.getColumnCount();
        for (short i = 0; i < count; i++) {
            String col = metadata.getColumnName(i + 1);
            if (col.equalsIgnoreCase(name)){
                return i;
            }
        }
        return -1;
    }

    private IllegalStateException nyi() {
        return new IllegalStateException("NYI");
    }

    public void cancelRowUpdates() throws SQLException {
        throw nyi();
    }

    public void clearWarnings() throws SQLException {
        throw nyi();
    }

    public void close() throws SQLException {
    }

    public void deleteRow() throws SQLException {
        throw nyi();
    }

    public int findColumn(String jdbcColumn) throws SQLException {
        throw nyi();
    }

    public Array getArray(int i) throws SQLException {
        throw nyi();
    }

    public Array getArray(String colName) throws SQLException {
        throw nyi();
    }

    public InputStream getAsciiStream(int jdbcColumn) throws SQLException {
        throw nyi();
    }

    public InputStream getAsciiStream(String jdbcColumn) throws SQLException {
        throw nyi();
    }

    public BigDecimal getBigDecimal(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell == null ? null : BigDecimal.valueOf(cell.getNumericCellValue());
    }

    public BigDecimal getBigDecimal(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell == null ? null : BigDecimal.valueOf(cell.getNumericCellValue());
    }

    public BigDecimal getBigDecimal(int jdbcColumn, int scale) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell == null) {
            return null;
        } else {
            BigDecimal bigDecimal = BigDecimal.valueOf(cell.getNumericCellValue());
            return bigDecimal.setScale(scale, BigDecimal.ROUND_HALF_UP);
        }
    }

    public BigDecimal getBigDecimal(String jdbcColumn, int scale) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell == null) {
            return null;
        } else {
            BigDecimal bigDecimal = BigDecimal.valueOf(cell.getNumericCellValue());
            return bigDecimal.setScale(scale, BigDecimal.ROUND_HALF_UP);
        }
    }

    public InputStream getBinaryStream(int jdbcColumn) throws SQLException {
        throw nyi();
    }

    public InputStream getBinaryStream(String jdbcColumn) throws SQLException {
        throw nyi();
    }

    public Blob getBlob(int i) throws SQLException {
        throw nyi();
    }

    public Blob getBlob(String colName) throws SQLException {
        throw nyi();
    }

    public byte[] getBytes(int jdbcColumn) throws SQLException {
        throw nyi();
    }

    public byte[] getBytes(String jdbcColumn) throws SQLException {
        throw nyi();
    }

    public Reader getCharacterStream(int jdbcColumn) throws SQLException {
        throw nyi();
    }

    public Reader getCharacterStream(String jdbcColumn) throws SQLException {
        throw nyi();
    }

    public Clob getClob(int i) throws SQLException {
        throw nyi();
    }

    public Clob getClob(String colName) throws SQLException {
        throw nyi();
    }

    public int getConcurrency() throws SQLException {
        throw nyi();
    }

    public String getCursorName() throws SQLException {
        throw nyi();
    }

    public Date getDate(int jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell == null ? null : new Date(cell.getDateCellValue().getTime());
    }

    public Date getDate(String jdbcColumn) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        return cell == null ? null : new Date(cell.getDateCellValue().getTime());
    }

    public Date getDate(int jdbcColumn, Calendar cal) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell == null) {
            return null;
        } else {
            Calendar calendar = Calendar.getInstance();
            calendar.setTime(cell.getDateCellValue());
            calendar.set(Calendar.HOUR_OF_DAY, cal.get(Calendar.HOUR_OF_DAY));
            calendar.set(Calendar.MINUTE, cal.get(Calendar.MINUTE));
            calendar.set(Calendar.SECOND, cal.get(Calendar.SECOND));
            calendar.set(Calendar.MILLISECOND, cal.get(Calendar.MILLISECOND));
            return new Date(calendar.getTime().getTime());
        }
    }

    public Date getDate(String jdbcColumn, Calendar cal) throws SQLException {
        Cell cell = getCell(jdbcColumn);
        if (cell == null) {
            return null;
        } else {
            Calendar calendar = Calendar.getInstance();
            calendar.setTime(cell.getDateCellValue());
            calendar.set(Calendar.HOUR_OF_DAY, cal.get(Calendar.HOUR_OF_DAY));
            calendar.set(Calendar.MINUTE, cal.get(Calendar.MINUTE));
            calendar.set(Calendar.SECOND, cal.get(Calendar.SECOND));
            calendar.set(Calendar.MILLISECOND, cal.get(Calendar.MILLISECOND));
            return new Date(calendar.getTime().getTime());
        }
    }

    public Object getObject(int i, Map<String, Class<?>> map)
            throws SQLException {
        throw nyi();
    }

    public Object getObject(String colName, Map<String, Class<?>> map)
            throws SQLException {
        throw nyi();
    }

    public Ref getRef(int i) throws SQLException {
        throw nyi();
    }

    public Ref getRef(String colName) throws SQLException {
        throw nyi();
    }

    public Statement getStatement() throws SQLException {
        return statement;
    }

    public Time getTime(int jdbcColumn) throws SQLException {
        throw nyi();
    }

    public Time getTime(String jdbcColumn) throws SQLException {
        throw nyi();
    }

    public Time getTime(int jdbcColumn, Calendar cal) throws SQLException {
        throw nyi();
    }

    public Time getTime(String jdbcColumn, Calendar cal) throws SQLException {
        throw nyi();
    }

    public URL getURL(int jdbcColumn) throws SQLException {
        throw nyi();
    }

    public URL getURL(String jdbcColumn) throws SQLException {
        throw nyi();
    }

    public InputStream getUnicodeStream(int jdbcColumn) throws SQLException {
        throw nyi();
    }

    public InputStream getUnicodeStream(String jdbcColumn) throws SQLException {
        throw nyi();
    }

    public SQLWarning getWarnings() throws SQLException {
        throw nyi();
    }

    public void moveToCurrentRow() throws SQLException {
        throw nyi();
    }

    public void refreshRow() throws SQLException {
        throw nyi();
    }

    public boolean relative(int rows) throws SQLException {
        throw nyi();
    }

    public boolean rowDeleted() throws SQLException {
        throw nyi();
    }

    public boolean rowInserted() throws SQLException {
        throw nyi();
    }

    public boolean rowUpdated() throws SQLException {
        throw nyi();
    }

    public void updateArray(int jdbcColumn, Array x) throws SQLException {
        throw nyi();
    }

    public void updateArray(String jdbcColumn, Array x) throws SQLException {
        throw nyi();
    }

    public RowId getRowId(int columnIndex) throws SQLException {
        throw nyi();
    }

    public RowId getRowId(String columnLabel) throws SQLException {
        throw nyi();
    }

    public void updateRowId(int columnIndex, RowId x) throws SQLException {
        throw nyi();
    }

    public void updateRowId(String columnLabel, RowId x) throws SQLException {
        throw nyi();
    }

    public int getHoldability() throws SQLException {
        throw nyi();
    }

    public boolean isClosed() throws SQLException {
        throw nyi();
    }

    public void updateNString(int columnIndex, String nString) throws SQLException {
        throw nyi();
    }

    public void updateNString(String columnLabel, String nString) throws SQLException {
        throw nyi();
    }

    public void updateNClob(int columnIndex, NClob nClob) throws SQLException {
        throw nyi();
    }

    public void updateNClob(String columnLabel, NClob nClob) throws SQLException {
        throw nyi();
    }

    public NClob getNClob(int columnIndex) throws SQLException {
        throw nyi();
    }

    public NClob getNClob(String columnLabel) throws SQLException {
        throw nyi();
    }

    public SQLXML getSQLXML(int columnIndex) throws SQLException {
        throw nyi();
    }

    public SQLXML getSQLXML(String columnLabel) throws SQLException {
        throw nyi();
    }

    public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException {
        throw nyi();
    }

    public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException {
        throw nyi();
    }

    public String getNString(int columnIndex) throws SQLException {
        throw nyi();
    }

    public String getNString(String columnLabel) throws SQLException {
        throw nyi();
    }

    public Reader getNCharacterStream(int columnIndex) throws SQLException {
        throw nyi();
    }

    public Reader getNCharacterStream(String columnLabel) throws SQLException {
        throw nyi();
    }

    public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException {
        throw nyi();
    }

    public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException {
        throw nyi();
    }

    public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException {
        throw nyi();
    }

    public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException {
        throw nyi();
    }

    public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException {
        throw nyi();
    }

    public void updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException {
        throw nyi();
    }

    public void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException {
        throw nyi();
    }

    public void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException {
        throw nyi();
    }

    public void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException {
        throw nyi();
    }

    public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException {
        throw nyi();
    }

    public void updateClob(int columnIndex, Reader reader, long length) throws SQLException {
        throw nyi();
    }

    public void updateClob(String columnLabel, Reader reader, long length) throws SQLException {
        throw nyi();
    }

    public void updateNClob(int columnIndex, Reader reader, long length) throws SQLException {
        throw nyi();
    }

    public void updateNClob(String columnLabel, Reader reader, long length) throws SQLException {
        throw nyi();
    }

    public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException {
        throw nyi();
    }

    public void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException {
        throw nyi();
    }

    public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException {
        throw nyi();
    }

    public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException {
        throw nyi();
    }

    public void updateCharacterStream(int columnIndex, Reader x) throws SQLException {
        throw nyi();
    }

    public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException {
        throw nyi();
    }

    public void updateBinaryStream(String columnLabel, InputStream x) throws SQLException {
        throw nyi();
    }

    public void updateCharacterStream(String columnLabel, Reader reader) throws SQLException {
        throw nyi();
    }

    public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException {
        throw nyi();
    }

    public void updateBlob(String columnLabel, InputStream inputStream) throws SQLException {
        throw nyi();
    }

    public void updateClob(int columnIndex, Reader reader) throws SQLException {
        throw nyi();
    }

    public void updateClob(String columnLabel, Reader reader) throws SQLException {
        throw nyi();
    }

    public void updateNClob(int columnIndex, Reader reader) throws SQLException {
        throw nyi();
    }

    public void updateNClob(String columnLabel, Reader reader) throws SQLException {
        throw nyi();
    }

    public void updateAsciiStream(int jdbcColumn, InputStream x, int length)
            throws SQLException {
        throw nyi();
    }

    public void updateAsciiStream(String jdbcColumn, InputStream x, int length)
            throws SQLException {
        throw nyi();
    }

    public void updateBigDecimal(int jdbcColumn, BigDecimal x)
            throws SQLException {
        throw nyi();
    }

    public void updateBigDecimal(String jdbcColumn, BigDecimal x)
            throws SQLException {
        throw nyi();
    }

    public void updateBinaryStream(int jdbcColumn, InputStream x, int length)
            throws SQLException {
        throw nyi();
    }

    public void updateBinaryStream(String jdbcColumn, InputStream x, int length)
            throws SQLException {
        throw nyi();
    }

    public void updateBlob(int jdbcColumn, Blob x) throws SQLException {
        throw nyi();
    }

    public void updateBlob(String jdbcColumn, Blob x) throws SQLException {
        throw nyi();
    }

    public void updateBytes(int jdbcColumn, byte[] x) throws SQLException {
        throw nyi();
    }

    public void updateBytes(String jdbcColumn, byte[] x) throws SQLException {
        throw nyi();
    }

    public void updateCharacterStream(int jdbcColumn, Reader x, int length)
            throws SQLException {
        throw nyi();
    }

    public void updateCharacterStream(String jdbcColumn, Reader reader,
                                      int length) throws SQLException {
        throw nyi();
    }

    public void updateClob(int jdbcColumn, Clob x) throws SQLException {
        throw nyi();
    }

    public void updateClob(String jdbcColumn, Clob x) throws SQLException {
        throw nyi();
    }

    public void updateDate(int jdbcColumn, Date x) throws SQLException {
        throw nyi();
    }

    public void updateDate(String jdbcColumn, Date x) throws SQLException {
        throw nyi();
    }

    public void updateObject(int jdbcColumn, Object x, int scale)
            throws SQLException {
        throw nyi();
    }

    public void updateObject(String jdbcColumn, Object x, int scale)
            throws SQLException {
        throw nyi();
    }

    public void updateRef(int jdbcColumn, Ref x) throws SQLException {
        throw nyi();
    }

    public void updateRef(String jdbcColumn, Ref x) throws SQLException {
        throw nyi();
    }

    public void updateRow() throws SQLException {
        throw nyi();
    }

    public void updateTime(int jdbcColumn, Time x) throws SQLException {
        throw nyi();
    }

    public void updateTime(String jdbcColumn, Time x) throws SQLException {
        throw nyi();
    }

    public void updateTimestamp(int jdbcColumn, Timestamp x)
            throws SQLException {
        throw nyi();
    }

    public void updateTimestamp(String jdbcColumn, Timestamp x)
            throws SQLException {
        throw nyi();
    }

    public boolean wasNull() throws SQLException {
        throw nyi();
    }

    public <T> T unwrap(Class<T> iface) throws SQLException {
        throw nyi();
    }

    public boolean isWrapperFor(Class<?> iface) throws SQLException {
        throw nyi();
    }
}