String name = rs.getString(2);
String age = rs.getString(3);
System.out.println(id + " " + name + " " + age);
}
// 调用第 2 个存储过程
cs = con.prepareCall(callSQL2);
cs.setString(1, "2");
cs.registerOutParameter(2, Types.CHAR);
cs.registerOutParameter(3, Types.INTEGER);
cs.execute();
String name = cs.getString(2);
int age = cs.getInt(3);
System.out.println("第二个存储过程调用结果");
System.out.println("This student's name is " + name
+ " and age is " + age);
// 调用函数
cs = con.prepareCall(callSQL3);
cs.registerOutParameter(1, Types.INTEGER);
cs.execute();
age = cs.getInt(1);
System.out.println("函数调用结果");
System.out.println("This student's name is " + age + ".");
cs.close();
con.close();
} catch (NamingException ex) {
System.err.println("Name Not Bound : " + ex.getMessage());
} catch (SQLException ex) {
System.err.println("SQLException : " + ex.getMessage());
}
System.out.println("调用结束!");
}
}
摘自 Java教程