java中調用預存程序

資料庫中的預存程序

CREATE PROCEDURE [dbo].[Proc_deleteStuByNo]
 -- Add the parameters for the stored procedure here
 @stuNo char(7),
 @result int output
AS
BEGIN
 SET NOCOUNT ON;
 delete from studinfo where StudNo=@stuNo
 set @result=@@rowcount
END

 

java中調用預存程序：

String stuno="a1";

int result=0;

Connection connection = ConnDB.getConection();
   CallableStatement callStm=null;
   try {
    callStm = connection.prepareCall("{call Proc_deleteStuByNo(?,?)}");
    callStm.setString("stuNo",stuno);//為CallableStatement對象添加輸入參數
    callStm.registerOutParameter("result",java.sql.Types.INTEGER);//為CallableStatement對象註冊輸出參數  

 } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   try {
    callStm.executeUpdate();
    result = callStm.getInt("result");//擷取輸出參數中的值
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }finally{
    try {
     callStm.close();
     connection.close();
    } catch (SQLException e) {
     // TODO Auto-generated catch block
     e.printStackTrace();
    }   
   }
   if(result>0){
    System.out.println("刪除成功");
   }else{

　　System.out.println("刪除失敗");
    }