@Override public void set(PreparedStatement prep, int parameterIndex) throws SQLException { prep.setNull(parameterIndex, DataType.convertTypeToSQLType(NULL)); }
/** * Returns the data type of a column. * See also java.sql.Type. * * @param column the column index (1,2,...) * @return the data type * @throws SQLException if the result set is closed or invalid */ @Override public int getColumnType(int column) throws SQLException { try { debugCodeCall("getColumnType", column); checkColumnIndex(column); int type = result.getColumnType(--column); return DataType.convertTypeToSQLType(type); } catch (Exception e) { throw logAndConvert(e); } }
public ResultSet getResultSet() { SimpleResultSet rs = new SimpleResultSet(); rs.setAutoClose(false); rs.addColumn("X", DataType.convertTypeToSQLType(getType()), MathUtils.convertLongToInt(getPrecision()), getScale()); rs.addRow(getObject()); return rs; }
public static ColumnDefinition getColumn(ResultInterface result, int i) { ColumnDefinition columnPacket = new ColumnDefinition(); columnPacket.catalog = "def"; columnPacket.org_name = result.getColumnName(i); columnPacket.name = result.getAlias(i); columnPacket.org_table = result.getTableName(i); columnPacket.table = result.getTableName(i); columnPacket.schema = result.getSchemaName(i); columnPacket.flags = toFlag(result, i); columnPacket.columnLength = result.getDisplaySize(i); columnPacket.decimals = result.getColumnScale(i); int sqlType = DataType.convertTypeToSQLType(result.getColumnType(i)); int javaType = MysqlDefs.javaTypeDetect(sqlType, (int) columnPacket.decimals); columnPacket.type = (byte) (MysqlDefs.javaTypeMysql(javaType) & 0xff); return columnPacket; }
private static SimpleResultSet getSimpleResultSet(ResultInterface rs, int maxrows) { int columnCount = rs.getVisibleColumnCount(); SimpleResultSet simple = new SimpleResultSet(); simple.setAutoClose(false); for (int i = 0; i < columnCount; i++) { String name = rs.getColumnName(i); int sqlType = DataType.convertTypeToSQLType(rs.getColumnType(i)); int precision = MathUtils.convertLongToInt(rs.getColumnPrecision(i)); int scale = rs.getColumnScale(i); simple.addColumn(name, sqlType, precision, scale); } rs.reset(); for (int i = 0; i < maxrows && rs.next(); i++) { Object[] list = new Object[columnCount]; for (int j = 0; j < columnCount; j++) { list[j] = rs.currentRow()[j].getObject(); } simple.addRow(list); } return simple; }
"" + DataType.convertTypeToSQLType(c.getType()),