J#-储存

/**
* alter procedure myproc @bookId int
as
delete from books where book_id=@bookId
go
*/

CallableStatement cs = conn.prepareCall("exec myproc 9") ;
int row = cs.executeUpdate();

1,J#-存储过程

use pubs
go

create table user_info
(
    name varchar(20) primary key,
    gender char(2) check(gender='男' or gender='女'),
    age int
)
go


--创建存储过程实现增、删、改、查
--添加
create proc insertp
(
    @name varchar(20),
    @gender char(2),
    @age int
)
as
begin
    insert into user_info values (@name,@gender,@age)
end

--调用存储过程insertp
exec insertp '麦克','男',18

--查询,无参数
create proc selectp
as
begin
select * from user_info
end
drop proc selectp
--执行
exec selectp

--修改,按照名字来修改
create proc updatep
(
    @name varchar(20),
    @gender char(2),
    @age int
)
as
begin
    update user_info set gender=@gender,age=@age where name=@name
end

--执行
exec updatep '麦克','男','20'

--删除
create proc deletep
(
    @name varchar(20)
)
as
begin
    delete from user_info where name=@name
end

--执行
exec deletep '麦克'

2,J#-存储过程

--存储过程
use pubs
go

create table user_info
(
    name varchar(20) primary key,
    password varchar(20) not null,
    gender char(2) check(gender='男' or gender='女')
)
go

--帖子表
create table bbs_info
(
    id int primary key identity(1,1),
    title varchar(200) not null,
    content varchar(4000) not null,
    author varchar(20) references user_info(name)
)
go

insert into bbs_info values('标题','内容','麦克')

--添加的存储过程
create proc insertp
(
    @name varchar(20),
    @pwd varchar(20),
    @gender char(2)
)
as
begin
    insert into user_info values(@name,@pwd,@gender)
end
return

--执行存储过程
exec insertp '麦克','123456','男'

select * from user_info
select * from bbs_info



--删除的存储过程
create proc deletep
(
    @name varchar(20)
)
as 
begin
    declare @n int
    delete from bbs_info where author=@name
    set @n=@@rowcount
    if @n=1
    begin
        delete from  user_info where name=@name
    end
end
return

exec deletep '麦克'