Java程序调用存储过程应用举例

Java程序调用存储过程验证用户登录
package com.yzy.jdbc.dao;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import oracle.jdbc.OracleTypes;
public class LoginDao {
 public boolean loginValidate(String username, String password) {
  boolean isValid = false;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
   Connection conn = DriverManager.getConnection(url, "scott", "yzy");
   CallableStatement cstmt = null;
   ResultSet rs = null;
   String sql = "{ call p_validate(?,?,?) }";
   cstmt = conn.prepareCall(sql);
   cstmt.setString(1, username);
   cstmt.setString(2, password);
   cstmt.registerOutParameter(3, OracleTypes.NUMBER);
   cstmt.execute();
   long num = cstmt.getLong(3);
   if (num > 0) {
    isValid = true;
   }
  } catch (Exception e) {
   e.printStackTrace();
  }
  return isValid;
 }
}
Java程序调用存储过程查询并返回结果集
package com.yzy.jdbc.dao;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import oracle.jdbc.OracleTypes;
public class Demo2Dao {
 public void query() {
  boolean isValid = false;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
   Connection conn = DriverManager.getConnection(url, "scott", "yzy");
   CallableStatement cstmt = null;
   ResultSet rs = null;
   String sql = "{ call  pack_res.p_g