提问 问题标签用户 string格式转化出错，求高手指导

[zhuhl2011]

代码如下：
public class TEST implements Extractable {

private String getSqlStr() {

StringBuffer buf = new StringBuffer();
buf.append(" SELECT nvl(ROUND(J.AMOUNT),’0’) AS SHIHARAIKIN1, ");

buf.append(" FROM T_WL_TAX_PRINCIPAL J ");

return buf.toString();
}

private List<Map> execQuery() {

PreparedStatement ps = null;
ResultSet rs = null;
DBean db = new DBean();
List<Map> resultList = new LinkedList<Map>();
Connection con = null;
try {
db.connect();
con = db.getConnection();
ps = con.prepareStatement(getSqlStr());
rs = ps.executeQuery();
int i = 0;
while (rs.next()) {
Map<String, String> mapData = new HashMap<String, String>();
int ShiHaRaiKin = Integer.valueOf(rs.get("SHIHARAIKIN1"));
}
}
} catch (Exception e) {

resultList.add(mapData);
} finally {
DBean.closeAll(null, ps, db);
}
return resultList;
}
}

在执行 int ShiHaRaiKin = Integer.valueOf(rs.get("SHIHARAIKIN1")); 语句的时候报出下面错误：
For input string at java.lang.NumberFormatException.forInputString(Unknown Source)

我试过在rs.get("SHIHARAIKIN1")后面加个trim方法，还是会出这个错误，求高手指导~~~~~~~~

[zhuhl2011]

引用 1 楼 fudongrifdr 的回复:

用ResultSetMetaData.getColumnName(int column)看一下列名对不

列名是对的 ，里面也有数值：4478998

[末日哥]

用ResultSetMetaData.getColumnName(int column)看一下列名对不