Question

java中调用存储过程有什么作用

Answer 1

ResultSet rs = stmt.executeQuery("{call dbo.ProcedureName}");
调用带参数存储程必须结合 SQLServerConnection 类 prepareCall 使用 call SQL 转义序列
CallableStatement cstmt = con.prepareCall("{call dbo.ProcedureName(?, ?)}");
cstmt.setInt(1, java.sql.Types.INTEGER);
cstmt.registerOutParameter(2, java.sql.Types.VARCHAR);
cstmt.execute();
System.out.println("MANAGER ID: " + cstmt.getInt(1));
System.out.println("MANAGER NAME: " + cstmt.getInt(2));
3 SAF NTSD overspd 运行期间电梯 1LS/2LS 实际速度超相应 NTSD 设定值 SHUTDOWN 电梯预定减速度减速停止复位