EAS调用SQLServer数据库存储过程

原文：

参考资料1：registerOutParameter 方法 (java.lang.String, int) | Microsoft Docs

参考资料2：33、Connection.prepareCall方法——调用数据库存储过程_DarrenMJ的博客-优快云博客_preparecall方法

没有参数查询存储过程数据

import java.sql.*;

......

      String className = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
      String url = "接口路径";
      String name = "数据库名";
      String password = "数据库密码";
      //存储过程名：sp_审批中流程查询
      String sql ="{call sp_审批中流程查询()}";
	      Connection conn = null;
	      CallableStatement call = null;
	      ResultSet rs = null;
	         StringBuffer sb = new StringBuffer();
	         StringBuffer sb2 = new StringBuffer();
	          try {
	        	Class.forName(className);
				conn = DriverManager.getConnection(url, name, password);
				call = conn.prepareCall(sql);
		        rs = call.executeQuery();
		        while (rs.next()) {
		        	 sb.append(rs.getString("单号")+",");
		        	 sb2.append(rs.getString("业务单号")+",");
		        	
		          }
				
			} catch (SQLException e1) {
				e1.printStackTrace();
			} catch (ClassNotFoundException e1) {
				e1.printStackTrace();
			}
			
			 System.out.println("单号："+sb.toString());
			 System.out.println("业务单号:"+sb2.toString());

输出结果