java调用MySql存储过程

[sherry521]

java调用MySql存储过程，怎样在存储过程中返回刚插入数据的自增长ID呢？

[sherry521]

这是MYSQL的存储过程语法吗？我问MYSQL，不是问的MS SQLServer

[不姓贾_请叫我甄先生]

Mysql的存储过程？

[生活]

关注下。。。。

[小李子]

如果你用Hibernate之类的，存储对象后对象会获得id，否则就再查一下

[so185582]

CREATE PROCEDURE [insert_employee_1]
@name_1 [varchar](50),
@age_2 [varchar](50),
@address_3 [varchar](50),
@id int out


AS
INSERT INTO dbo.h_sms_PublicUserMo_tb(UserID,ProductID,FeatureStr,CreateTime)
VALUES (@name_1,@age_2,@address_3,getdate())
--select @@identity
set @id=@@identity
return

GO

public   int   getId(){   
            
          int   id   =   0;   
  Connection   conn   =   null;   
                  Statement   stmt   =   null;   
    
  try   {   
                  conn   =   this.db.getConnection();   
                          stmt   =   conn.createStatement();   
  String   sql   =   "{call   dbo.insert_employee_1(?,?,?,?)}";   
  CallableStatement   st   =   conn.prepareCall(sql);   
  st.setString(1,"13811217419");   
          st.setString(2,"fdasfdsa");   
          st.setString(3,"fdasfdsafads");   
  st.registerOutParameter(4,   Types.INTEGER);   
  st.execute();   
  id   =   st.getInt(4);   
  st.close();   
  }   catch   (Exception   e)   {   
  logger.debug(e.toString());   
  }   finally   {   
  try   {   
  if(conn!=null)   
  conn.close();   
  }   catch   (SQLException   e)   {   
  logger.debug("getContent   "+e.toString());   
  }   
  }   
  return   id;   
          }

[operatezhang]

好像是这个样子的把!

[wwwtyb]

[Quote=引用 3 楼 so185582 的回复:]

CREATE PROCEDURE [insert_employee_1]
@name_1 [varchar](50),
@age_2 [varchar](50),
@address_3 [varchar](50),
@id int out


AS
INSERT INTO dbo.h_sms_PublicUserMo_tb(UserID,P……
[/Quote]

结构是正确的，但是存储过程需要修改：
CREATE PROCEDURE [insert_employee_1]
@name_1 [varchar](50),
@age_2 [varchar](50),
@address_3 [varchar](50),
@id int out


AS
INSERT INTO dbo.h_sms_PublicUserMo_tb(UserID,ProductID,FeatureStr,CreateTime)
VALUES (@name_1,@age_2,@address_3,getdate())
select @id=last_insert_id();

return @id

GO

[ladybirds2008]

[Quote=引用 5 楼 wwwtyb 的回复:]

引用 3 楼 so185582 的回复:

CREATE PROCEDURE [insert_employee_1]
@name_1 [varchar](50),
@age_2 [varchar](50),
@address_3 [varchar](50),
@id int out


AS
INSERT INTO dbo.h_sms_……
[/Quote]有那么点意思。。。呵呵。。。

[智鹿软件]

应该和SQL Server中的系统变量一样吧！

[krudy2005]

#3是对的