//調(diào)用存儲(chǔ)過程帶參
CallableStatement ca = conn.prepareCall("{call Login (?,?)}");
ca.setString(1,username);
ca.setString(2,password);
ca.execute();
//調(diào)用存儲(chǔ)過程帶返回參數(shù)的
CallableStatement ca = conn.prepareCall("{call Login (?,?,?)}");
ca.setString(1,username);
ca.setString(2,password);
ca.registerOutParameter(3,java.sql.Types.INTEGER);
ca.execute();
int returnOut = ca.getInt(3);
//調(diào)用存儲(chǔ)過程帶返回值的return
CallableStatement ca = conn.prepareCall("{?=call Login (?,?,?)}");
ca.setString(2,username);
ca.setString(3,password);
ca.registerOutParameter(1,java.sql.Types.INTEGER);
ca.execute();
int returnOut = ca.getInt(1);
//調(diào)用存儲(chǔ)過程返回兩個(gè)結(jié)果集
CallableStatement ca = conn.prepareCall("{call Login (?,?,?)}");
ca.setString(1,username);
ca.setString(2,password);
ca.execute();
ResultSet rs = ca.getResultSet();
while(rs.next())
{
System.out.println(rs.getInt(1)+rs.getString(2));
}
if(ca.getMoreResults())
{
rs = ca.getResultSet();
while (rs.next()) {
System.out.println(rs.getInt(1) + rs.getString(2));
}