分类:
2008-06-27 09:18:22
create proc uition_test
@sid int,@byname varchar(50)
as
declare @uition int
if exists(select * from signUtil)
begin
select @uition=max(uition)+1 from signUtil
insert into signUtil(sid,byname,uition) values(@sid,@byname,@uition);
end
else
insert into signUtil(sid,byname,uition) values(@sid,@byname,100);
GO
//这里是方法
public boolean insersginUtil(int sid, String contex) throws SQLException {
CallableStatement proc = null;
boolean bool = false;
try {
conn = this.tranc.getConn();
proc = conn.prepareCall("{call uition_test(?, ?) }");
proc.setInt(1, sid);
proc.setString(2, contex);
System.out.println(sid + "" + contex);
bool = proc.execute();
} finally {
try {
proc.close();
} catch (SQLException e) {
}
}
System.out.println(bool);
return bool;
}