String sql = "{fn ABS(1)}";
CallableStatement stmt = conn.prepareCall(sql);
boolean hasResultSet = stmt.execute();
if(hasResultSet) {
ResultSet rs = stmt.getResultSet(); while (rs.next()) {
System.out.println("abs:" + rs.getInt(1));
}
}
CallableStatement stmt = conn.prepareCall(sql);
boolean hasResultSet = stmt.execute();
if(hasResultSet) {
ResultSet rs = stmt.getResultSet(); while (rs.next()) {
System.out.println("abs:" + rs.getInt(1));
}
}
换成
ResultSet rs = stmt.execute();
java.sql.SQLException: [GUOHP]第 1 行: '1' 附近有语法错误。why??????