/**
* Get the designated column's name.
*
* @param column the first column is 1, the second is 2, ...
* @return column name
* @exception SQLException if a database access error occurs
*/
String getColumnName(int column) throws SQLException;
/**
* Get the designated column's table's schema.
*
* @param column the first column is 1, the second is 2, ...
* @return schema name or "" if not applicable
* @exception SQLException if a database access error occurs
*/
String getSchemaName(int column) throws SQLException;
实现
/**
* Return the column descriptor given a column index.
*
* @param column The column index (from 1 .. n).
* @return The column descriptor as a <code>ColInfo<code>.
* @throws SQLException
*/
ColInfo getColumn(int column) throws SQLException {
if (column < 1 || column > columnCount) {
throw new SQLException(
Messages.get("error.resultset.colindex",
Integer.toString(column)), "07009");
}
return columns[column - 1];
}
我本来是写的从1开始的,后面写webapi我自己都纳闷,额,我怎么给写成1了,怎么这么低级的错误,我就把哪个地方改成了0 ,把<=count 改成count,然后切换为jdbc模式的时候出错了,坑爹,坑爹,必须记录下来,搞得我改过来改过去
while (resultSet.next()) {
ResultSetMetaData rsMetaData = resultSet.getMetaData();
//检索列名列表
LinkedHashMap<String, Object> hashMap = new LinkedHashMap<>();
int count = rsMetaData.getColumnCount();
keymaploop:
for (int i = 1; i <= count; i++) {// getColumn 从1 开始
String columnName = rsMetaData.getColumnName(i);
int columnType = rsMetaData.getColumnType(i);
Object object = null;
if (columnType == Types.VARBINARY) {
object = resultSet.getBinaryStream(columnName);
} else if (columnType == Types.CLOB) {
Clob clob = resultSet.getClob(columnName);
object = ClobToString(clob);
} else if (columnType == Types.BLOB) {
Blob blob = resultSet.getBlob(columnName);
if (blob != null) {
object = blob.getBinaryStream();
}
} else {
object = resultSet.getObject(columnName);
}
if (onlyOneColumn) {
String result = String.valueOf(object == null ? "" : object);
if (!TextUtils.isEmpty(result)) {
list.add(result);
}
break keymaploop;//只查询一列作为list
} else {
if (object instanceof InputStream) {
hashMap.put(columnName, new JDBCWrapper.InputStreamWrap((InputStream) object, columnName));
} else if (object instanceof Array) {
hashMap.put(columnName, object);
} else {
hashMap.put(columnName, String.valueOf(object == null ? "" : object));
}
}
}
if (!onlyOneColumn) {
list.add(hashMap);//否则返回一个字符串list
}
}
除此之外,注册输出函数第一个index=1是返回值,也是从1开始的,就问奇葩不奇葩。
标签:index,jdbc,String,columnName,坑爹,object,resultSet,column,SQLException From: https://blog.51cto.com/u_15458814/5883445