CREATE PROCEDURE yh_insert
@yhm varchar(50),@kl varchar(50)
AS
begin
set nocount on
 insert into test(yhm,kl) values(@yhm,@kl)
set nocount off
select newid=@@identity
end
GO

解決辦法：

在查詢分析器中執(zhí)行sp的方法

declare @id int
exec sp_yh_insert 'tetstst','111111',@id output
select @id

修改sp如下：使用輸出參數(shù)來(lái)存儲(chǔ)得到的新的Id

CREATE PROCEDURE sp_yh_insert
@yhm varchar(50),@kl varchar(50),@id int output
AS
begin
set nocount on
 insert into test(yhm,kl) values(@yhm,@kl)
set nocount off
--select newid=@@identity
select @id=@@identity --關(guān)鍵
end
GO

java程序如下：

public String call_sp_insert_jh(String yhm,String kl)throws Exception
{
  String strFlag = "";
  String strString = "";
  Connection conn = null;
  try
   {
    conn = db.getConnection();
    //CallableStatement proc = conn.prepareCall(strSql);
    CallableStatement  proc=conn.prepareCall("{call sp_yh_insert(?,?,?)}");
    proc.setString(1, "往往外餓餓餓額"); //給第一個(gè)輸入?yún)?shù)賦值
    proc.setString(2, "1111111"); //給第2個(gè)輸入?yún)?shù)賦值
    proc.registerOutParameter(3,Types.INTEGER); //處理輸出參數(shù)
    proc.execute(); //執(zhí)行sp
    int id = proc.getInt(3);//得到返回值的值
    strString=Integer.toString(id);
    strFlag=strString ;
   }
  catch (SQLException e)
   {
     System.out.println("proc execute error"+strString);
    }
  finally
   {
     //關(guān)閉數(shù)據(jù)庫(kù)聯(lián)接
     try
      {
      conn.close();
      }
     catch(Exception sqle)
      {
      //產(chǎn)生新 異常，則拋出新 程序異常
      //throw new Exception("[DBBean.executeQuery(sql,tname)]","10");
      System.out.println("出錯(cuò)了");
      }
    }
  return strFlag;
}

希望本文所述對(duì)大家Java程序設(shè)計(jì)有所幫助。

您可能感興趣的文章: