本文整理汇总了Java中java.sql.Types.OTHER属性的典型用法代码示例。如果您正苦于以下问题:Java Types.OTHER属性的具体用法?Java Types.OTHER怎么用?Java Types.OTHER使用的例子?那么恭喜您, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在类java.sql.Types
的用法示例。
在下文中一共展示了Types.OTHER属性的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getSqlType
/** This method returns a Type constant defined in java.sql.Types, based on the sqlType defined in the mapping file.
* This throws a runtime exception IllegalArgumentException, in case the typename is not supported.
* @param typeName The sqlType defined in the mapping file.
* @param engineType The engine type as defined in init.xml
* @return a Type constant defined in java.sql.Types.
*/
public static int getSqlType(String typeName, String engineType) {
// For "Boolean", get the default packing code, which is database dependent, and then use that to get the actual SqlType
if (typeName.equals(Defaults.BOOLEAN))
typeName = getDefaultPackingCodeForBoolean(engineType);
if (IStoredProcedure.CURSOR.equals(typeName)) {
if ("oracle".equalsIgnoreCase(engineType))
return getSqlTypeForOracleCursor();
else
return Types.OTHER;
} else {
Integer output = (Integer) SQL_TYPES.get(typeName);
if (output == null) {
String str = "Unsupported SqlType " + typeName;
log.error(str);
throw new IllegalArgumentException(str);
}
return output.intValue();
}
}
示例2: getJdbcType
/**
* Translates from the string representation of the type to the
* java.sql.Types value.
*
* @param jdbcTypeName
* the iBATIS String representation of a JDBC type
* @return a value from java.sql.Types
*/
public static int getJdbcType(String jdbcTypeName) {
Integer answer = nameToType.get(jdbcTypeName);
if (answer == null) {
answer = Types.OTHER;
}
return answer;
}
示例3: isBlob
/**
* Return if a given data type is blob type or not. Note: CLOB should really
* not be in this list, use isLob method for that.
*
* @param type the type from java.sql.Types return true if the give type is
* blob type; false otherwise
*/
static public boolean isBlob(int type) {
switch (type) {
case Types.BLOB:
case Types.CLOB:
case Types.BINARY:
case Types.VARBINARY:
case Types.LONGVARBINARY:
case Types.OTHER:
case Types.NCLOB:
return true;
}
return false;
}
示例4: createDefaultOutParameter
@Override
public SqlParameter createDefaultOutParameter(String parameterName, CallParameterMetaData meta) {
if (meta.getSqlType() == Types.OTHER && REF_CURSOR_NAME.equals(meta.getTypeName())) {
return new SqlOutParameter(parameterName, getRefCursorSqlType(), new ColumnMapRowMapper());
}
else {
return super.createDefaultOutParameter(parameterName, meta);
}
}
示例5: getParameterType
@Override
public int getParameterType(int param) throws SQLException
{
Integer type = statement.getParameterStore().getType(param);
if (type != null)
return type.intValue();
Object value = statement.getParameterStore().getParameter(param);
if (value == null)
{
return Types.OTHER;
}
else if (Boolean.class.isAssignableFrom(value.getClass()))
{
return Types.BOOLEAN;
}
else if (Byte.class.isAssignableFrom(value.getClass()))
{
return Types.TINYINT;
}
else if (Short.class.isAssignableFrom(value.getClass()))
{
return Types.SMALLINT;
}
else if (Integer.class.isAssignableFrom(value.getClass()))
{
return Types.INTEGER;
}
else if (Long.class.isAssignableFrom(value.getClass()))
{
return Types.BIGINT;
}
else if (Float.class.isAssignableFrom(value.getClass()))
{
return Types.FLOAT;
}
else if (Double.class.isAssignableFrom(value.getClass()))
{
return Types.DOUBLE;
}
else if (BigDecimal.class.isAssignableFrom(value.getClass()))
{
return Types.DECIMAL;
}
else if (Date.class.isAssignableFrom(value.getClass()))
{
return Types.DATE;
}
else if (Timestamp.class.isAssignableFrom(value.getClass()))
{
return Types.TIMESTAMP;
}
else if (Time.class.isAssignableFrom(value.getClass()))
{
return Types.TIME;
}
else if (String.class.isAssignableFrom(value.getClass()))
{
return Types.NVARCHAR;
}
else if (byte[].class.isAssignableFrom(value.getClass()))
{
return Types.BINARY;
}
else
{
return Types.OTHER;
}
}
示例6: getSQLType
/**
* Get the SQLType for the given java.sql.Type type.
*
* @param type the java.sql.Type type specifier
* @return SQLType.the SQLType for this java.sql.Type, or null if it's not recognized
*/
public static SQLType getSQLType(int type) {
switch (type) {
case Types.BIT: return SQLType.BIT;
case Types.TINYINT: return SQLType.TINYINT;
case Types.SMALLINT: return SQLType.SMALLINT;
case Types.INTEGER: return SQLType.INTEGER;
case Types.BIGINT: return SQLType.BIGINT;
case Types.FLOAT: return SQLType.FLOAT;
case Types.REAL: return SQLType.REAL;
case Types.DOUBLE: return SQLType.DOUBLE;
case Types.NUMERIC: return SQLType.NUMERIC;
case Types.DECIMAL: return SQLType.DECIMAL;
case Types.CHAR: return SQLType.CHAR;
case Types.VARCHAR: return SQLType.VARCHAR;
case Types.LONGVARCHAR: return SQLType.LONGVARCHAR;
case Types.DATE: return SQLType.DATE;
case Types.TIME: return SQLType.TIME;
case Types.TIMESTAMP: return SQLType.TIMESTAMP;
case Types.BINARY: return SQLType.BINARY;
case Types.VARBINARY: return SQLType.VARBINARY;
case Types.LONGVARBINARY: return SQLType.LONGVARBINARY;
case Types.NULL: return SQLType.NULL;
case Types.OTHER: return SQLType.OTHER;
case Types.JAVA_OBJECT: return SQLType.JAVA_OBJECT;
case Types.DISTINCT: return SQLType.DISTINCT;
case Types.STRUCT: return SQLType.STRUCT;
case Types.ARRAY: return SQLType.ARRAY;
case Types.BLOB: return SQLType.BLOB;
case Types.CLOB: return SQLType.CLOB;
case Types.REF: return SQLType.REF;
case Types.DATALINK: return SQLType.DATALINK;
case Types.BOOLEAN: return SQLType.BOOLEAN;
case Types.LONGNVARCHAR: return SQLType.LONGVARCHAR;
case Types.NCHAR: return SQLType.CHAR;
case Types.NCLOB: return SQLType.CLOB;
case Types.NVARCHAR: return SQLType.VARCHAR;
case Types.SQLXML: return SQLType.SQLXML;
case Types.ROWID: return SQLType.ROWID;
default:
Logger.getLogger(JDBCUtils.class.getName()).log(Level.WARNING, "Unknown JDBC column type: " + type + ". Returns null.");
return null;
}
}
示例7: sqlTypeString
public static String sqlTypeString(int sqlType) {
switch (sqlType) {
case Types.BIT:
return "BIT";
case Types.TINYINT:
return "TINYINT";
case Types.SMALLINT:
return "SMALLINT";
case Types.INTEGER:
return "INTEGER";
case Types.BIGINT:
return "BIGINT";
case Types.FLOAT:
return "FLOAT";
case Types.REAL:
return "REAL";
case Types.DOUBLE:
return "DOUBLE";
case Types.NUMERIC:
return "NUMERIC";
case Types.DECIMAL:
return "DECIMAL";
case Types.CHAR:
return "CHAR";
case Types.VARCHAR:
return "VARCHAR";
case Types.LONGVARCHAR:
return "LONGVARCHAR";
case Types.DATE:
return "DATE";
case Types.TIME:
return "TIME";
case Types.TIMESTAMP:
return "TIMESTAMP";
case Types.BINARY:
return "BINARY";
case Types.VARBINARY:
return "VARBINARY";
case Types.LONGVARBINARY:
return "LONGVARBINARY";
case Types.NULL:
return "NULL";
case Types.OTHER:
return "OTHER";
case Types.JAVA_OBJECT:
return "JAVA_OBJECT";
case Types.DISTINCT:
return "DISTINCT";
case Types.STRUCT:
return "STRUCT";
case Types.ARRAY:
return "ARRAY";
case Types.BLOB:
return "BLOB";
case Types.CLOB:
return "CLOB";
case Types.REF:
return "REF";
case Types.DATALINK:
return "DATALINK";
case Types.BOOLEAN:
return "BOOLEAN";
case Types.ROWID:
return "ROWID";
case Types.NCHAR:
return "NCHAR";
case Types.NVARCHAR:
return "NVARCHAR";
case Types.LONGNVARCHAR:
return "LONGNVARCHAR";
case Types.NCLOB:
return "NCLOB";
case Types.SQLXML:
return "SQLXML";
default:
return "<UNKNOWN>";
}
}
示例8: getSqlTypeString
/**
* Convert sql types to String for display
*
* @param sqlType the type number from java.sql.Types
* @return the type name
*/
static public String getSqlTypeString(int sqlType) {
switch (sqlType) {
case Types.BIGINT:
return "BIGINT"; //NOI18N
case Types.BINARY:
return "BINARY"; //NOI18N
case Types.BIT:
return "BIT"; //NOI18N
case Types.NCHAR:
return "NCHAR"; //NOI18N
case Types.CHAR:
return "CHAR"; //NOI18N
case Types.DATE:
return "DATE"; //NOI18N
case Types.DECIMAL:
return "DECIMAL"; //NOI18N
case Types.DOUBLE:
return "DOUBLE"; //NOI18N
case Types.FLOAT:
return "FLOAT"; //NOI18N
case Types.INTEGER:
return "INTEGER"; //NOI18N
case Types.LONGVARBINARY:
return "LONGVARBINARY"; //NOI18N
case Types.LONGNVARCHAR:
return "LONGNVARCHAR"; //NOI18N
case Types.LONGVARCHAR:
return "LONGVARCHAR"; //NOI18N
case Types.NULL:
return "NULL"; //NOI18N
case Types.NUMERIC:
return "NUMERIC"; //NOI18N
case Types.OTHER:
return "OTHER"; //NOI18N
case Types.REAL:
return "REAL"; //NOI18N
case Types.SMALLINT:
return "SMALLINT"; //NOI18N
case Types.TIME:
return "TIME"; //NOI18N
case Types.TIMESTAMP:
return "TIMESTAMP"; //NOI18N
case Types.TINYINT:
return "TINYINT"; //NOI18N
case Types.VARBINARY:
return "VARBINARY"; //NOI18N
case Types.NVARCHAR:
return "NVARCHAR";
case Types.VARCHAR:
return "VARCHAR"; //NOI18N
case Types.JAVA_OBJECT:
return "JAVA_OBJECT"; //NOI18N
case Types.DISTINCT:
return "DISTINCT"; //NOI18N
case Types.STRUCT:
return "STRUCT"; //NOI18N
case Types.ARRAY:
return "ARRAY"; //NOI18N
case Types.BLOB:
return "BLOB"; //NOI18N
case Types.NCLOB:
return "NCLOB";
case Types.CLOB:
return "CLOB"; //NOI18N
case Types.REF:
return "REF"; //NOI18N
default:
Logger.getLogger(SQLTypeUtil.class.getName()).log(Level.WARNING, "Unknown JDBC column type: {0}. Returns null.", sqlType);
return "UNKNOWN"; //NOI18N
}
}
示例9: DefaultValueArgument
private DefaultValueArgument(Value<?> value) {
this(value, Types.OTHER);
}
示例10: DefaultOptionArgument
private DefaultOptionArgument(Option<?> value) {
this(value, Types.OTHER);
}
示例11: getParameterJavaValue
static public Object getParameterJavaValue(int param_type, String value) throws UnsupportedEncodingException, MalformedURLException, SQLException {
if (value != null) {
switch (param_type) {
case Types.ARRAY:
return value.split(",");
case Types.BIGINT:
return Long.valueOf(value);
case Types.BINARY:
return String.valueOf(value).getBytes("UTF-8");
case Types.BIT:
return Boolean.valueOf(value);
case Types.BLOB:
return value;//connection.createBlob();//
case Types.BOOLEAN:
return Boolean.valueOf(value);
case Types.CHAR:
return String.valueOf(value);
case Types.CLOB:
return value;//connection.createClob();//
case Types.DATALINK:
return new java.net.URL(value);
case Types.DATE:
return java.sql.Date.valueOf(value);
case Types.DECIMAL:
return java.math.BigDecimal.valueOf(Double.valueOf(value));
case Types.DISTINCT:
return value;//Object.class;
case Types.DOUBLE:
return Double.valueOf(value);
case Types.FLOAT:
return Double.valueOf(value);
case Types.INTEGER:
return Integer.valueOf(value, 10);
case Types.JAVA_OBJECT:
return value;//Object.class;
case Types.LONGVARBINARY:
return String.valueOf(value).getBytes("UTF-8");
case Types.LONGVARCHAR:
return String.valueOf(value);
case Types.NCLOB:
return value;//connection.createNClob();//
case Types.NULL:
return null;//Object.class;
case Types.NUMERIC:
return java.math.BigDecimal.valueOf(Double.parseDouble(value));
case Types.NCHAR:
case Types.NVARCHAR:
case Types.LONGNVARCHAR:
return String.valueOf(value);
case Types.OTHER:
return value;//Object.class;
case Types.REAL:
return Float.parseFloat(value);
case Types.REF:
return value;//java.sql.Ref.class;
case Types.ROWID:
return value;//java.sql.RowId.class;
case Types.SMALLINT:
return Short.valueOf(value);
case Types.STRUCT:
return value;//connection.createStruct(typeName, attributes);//
case Types.SQLXML:
return value;//connection.createSQLXML();//
case Types.TIME:
return java.sql.Time.valueOf(value);
case Types.TIMESTAMP:
return java.sql.Timestamp.valueOf(value);
case Types.TINYINT:
return Byte.valueOf(value);
case Types.VARBINARY:
return String.valueOf(value).getBytes("UTF-8");
case Types.VARCHAR:
return String.valueOf(value);
default:
return value;
}
}
return null;
}
示例12: getParameterJavaClass
static public Class<?> getParameterJavaClass(int param_type) {
switch (param_type) {
case Types.ARRAY:
return Object[].class;
case Types.BIGINT:
return Long.class;
case Types.BINARY:
return byte[].class;
case Types.BIT:
return Boolean.class;
case Types.BLOB:
return java.sql.Blob.class;
case Types.BOOLEAN:
return Boolean.class;
case Types.CHAR:
return String.class;
case Types.CLOB:
return java.sql.Clob.class;
case Types.DATALINK:
return java.net.URL.class;
case Types.DATE:
return java.sql.Date.class;
case Types.DECIMAL:
return java.math.BigDecimal.class;
case Types.DISTINCT:
return Object.class;
case Types.DOUBLE:
return Double.class;
case Types.FLOAT:
return Double.class;
case Types.INTEGER:
return Integer.class;
case Types.JAVA_OBJECT:
return Object.class;
case Types.LONGVARBINARY:
return byte[].class;
case Types.LONGVARCHAR:
return String.class;
case Types.NCLOB:
return java.sql.NClob.class;
case Types.NULL:
return Object.class;
case Types.NUMERIC:
return java.math.BigDecimal.class;
case Types.NCHAR:
case Types.NVARCHAR:
case Types.LONGNVARCHAR:
return String.class;
case Types.OTHER:
return Object.class;
case Types.REAL:
return Float.class;
case Types.REF:
return java.sql.Ref.class;
case Types.ROWID:
return java.sql.RowId.class;
case Types.SMALLINT:
return Short.class;
case Types.STRUCT:
return java.sql.Struct.class;
case Types.SQLXML:
return java.sql.SQLXML.class;
case Types.TIME:
return java.sql.Time.class;
case Types.TIMESTAMP:
return java.sql.Timestamp.class;
case Types.TINYINT:
return Byte.class;
case Types.VARBINARY:
return byte[].class;
case Types.VARCHAR:
return String.class;
default:
return Object.class;
}
}
示例13: getRefCursorSqlType
@Override
public int getRefCursorSqlType() {
return Types.OTHER;
}
示例14: getSqlType
@Override
public int getSqlType() {
return Types.OTHER;
}
示例15: getSqlType
public int getSqlType() {
// ugh
return Types.OTHER;
}