J#-存储器的调用

//利用存储器来调用
create proc insert_news
(
@title varchar(20),
@content varchar(200),
@uname varchar(10)
)
as
insert into news values(@title, @content,default,@uname)
update users set score = score + 5
where uname = @uname

exec insert_news '报道', 'haha来报道' , 'haha'

csmt = con.prepareCall("{call insert_news(? , ? , ?)}");
csmt.setString(1, title);
csmt.setString(2, content);
csmt.setString(3, uname);
int l = csmt.executeUpdate();

delete from users where uname = 'hehe'
delete from news where uname = 'hehe'

create proc del_user
(
@uname varchar(10)
)
as
delete from news where uname = @uname
delete from users where uname = @uname

exec del_user 'haha'

csmt = con.prepareCall("{call del_user (?)}");
csmt.setString(1, uname);

int l = csmt.executeUpdate();