java 里 存储过程的使用

package poceduretest;

import java.sql.*;

class MainTest
{
  public static void main(String[] args)
  {
    java.sql.Connection con = ConnectionManager.getConnection();  //先获得连接
    /**
     * 基本存储过程调用
     */
    try
    {
      java.sql.CallableStatement cs = con.prepareCall("{call sp_num}");  //传入的参数是call 和 存储过程名
      cs.execute();
      if(cs.execute())
      {
      
      }else
      {
         java.sql.ResultSet r = cs.getResultSet();
      // 输出记录集里的数据
          while (r.next())
          {
             System.out.print(r.getString(1));
             System.out.print("\t" + r.getString(2));
             System.out.print("\t" + r.getInt(3));
             System.out.println("\t" + r.getInt(4));
          }
      }
    }
    catch (SQLException ex)
    {
    }



    /**
     * 调用有参数的存储过程1
     */
    try
    {
      int x = 15;
      java.sql.CallableStatement cs = con.prepareCall("{call sp_num1(?)}"); //此内的？与存储过程里的输出和输入参数一致
      cs.setInt(1, x);

      // 执行存储过程
      cs.execute();

      java.sql.ResultSet r = cs.getResultSet();
      // 输出记录集里的数据
      while (r.next())
      {
        System.out.print(r.getString(1));
        System.out.println("\t" + r.getString(2));
      }
    }
    catch (SQLException ex)
    {
    }

    /**
     * 调用有参数的存储过程2
     */




    try
    {
      String name = "business";
      java.sql.CallableStatement cs = con.prepareCall("{call sp_num2(?)}");
      cs.setString(1, name);

      // 执行存储过程
      cs.execute();

      java.sql.ResultSet r = cs.getResultSet();
      // 输出记录集里的数据
      while (r.next())
      {
        System.out.print(r.getString(1));
        System.out.println("\t" + r.getString(2));
      }
    }
    catch (SQLException ex)
    {
    }



    /**
     * 带有输出参数的存储过程
     */
    try
    {
      String name = "business";
      java.sql.CallableStatement cs = con.prepareCall("{call sp_num5(?,?)}");

      cs.registerOutParameter(1, java.sql.Types.INTEGER);
      cs.setInt(2, 5);


      cs.execute();


      System.out.println(cs.getInt(1));
    }
    catch (SQLException ex)
    {
    }

    /**
     * 返回多个结果集的存储过程
     */




    try
    {
      java.sql.CallableStatement cs = con.prepareCall("{call sp_num6}");
      cs.execute();

      do
      {
        java.sql.ResultSet t = cs.getResultSet();
        while (t.next())
        {
          System.out.print(t.getString(1));
          System.out.println("\t" +t.getString(2));
        }

      }while(cs.getMoreResults());
    }
    catch (SQLException ex)
    {
    }
  }
}