代码如下：
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方法，还是会出这个错误，求高手指导~~~~~~~~
