调用存储过程时浏览器几秒后假死,尝试很多次都是这样……
打印输出结果发现有很长一段空白字符,使用trim()之后就可以正常显示了
Connection con=DB.getConnection();
CallableStatement oracleCallableStatement=con.prepareCall("begin ZXTAGL_SP_GETNEWCONSULTEDCST(?,?,?);end;");
oracleCallableStatement.setString(1,consulter);
oracleCallableStatement.registerOutParameter(2,OracleTypes.CURSOR);
oracleCallableStatement.registerOutParameter(3,OracleTypes.CHAR);
oracleCallableStatement.execute();
..........
String temp=oracleCallableStatement.getString(2);
改成
Connection con=DB.getConnection();
CallableStatement oracleCallableStatement=con.prepareCall("begin ZXTAGL_SP_GETNEWCONSULTEDCST(?,?,?);end;");
oracleCallableStatement.setString(1,consulter);
oracleCallableStatement.registerOutParameter(2,OracleTypes.CURSOR);
oracleCallableStatement.registerOutParameter(3,OracleTypes.CHAR);
oracleCallableStatement.execute();
..........
String temp=oracleCallableStatement.getString(2).trim();
只需添加trim方法,其他都不变