Connection con = DriverManager.getConnection(url,user,pass);
//testproc 为数据库的存储过程带一个in 参数
CallableStatement stmt = con.prepareCall("{call testproc(?)}");
//给参数赋值
stmt.setString(1,"2");
stmt.execute();
ResultSet rs = stmt.getResultSet();
if(!rs.next()) System.out.println("无结果集");
rs.setFetchDirection(ResultSet.FETCH_FORWARD);
System.out.println("Received results:"+rs.getString(1));
......
//testproc 为数据库的存储过程带一个in 参数
CallableStatement stmt = con.prepareCall("{call testproc(?)}");
//给参数赋值
stmt.setString(1,"2");
stmt.execute();
ResultSet rs = stmt.getResultSet();
if(!rs.next()) System.out.println("无结果集");
rs.setFetchDirection(ResultSet.FETCH_FORWARD);
System.out.println("Received results:"+rs.getString(1));
......
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货