使用存储过程、事务、webpage实现转账。

最新推荐文章于 2020-12-19 18:31:34 发布

liu_111111

最新推荐文章于 2020-12-19 18:31:34 发布

阅读量991

点赞数

分类专栏：程序

本文链接：https://blog.csdn.net/liu_111111/article/details/8176010

版权

程序专栏收录该内容

121 篇文章 0 订阅

订阅专栏

--思路1要有存储过程，存储过程中包含事务。参数应该有3个（转入账号，转出账号，金额）
/*
update bank set ammonut=amonut-金额 where id=转出账号
update bank set ammonut=amonut+金额 where id=转入账号

create table Bank(id int identity,amonut float)
insert into Bank values(100)
insert into Bank values (1000)
select * from Bank

alter table Bank
add constraint CH_amonut check (amonut>=10)

------------------------------------------------------------

Sql Server存储过程：

create proc usp_Bank_trans
@outputNumber int,
@inputNumber int,
@moneyNumber money
as
begin
begin tran
begin try
declare @errorsum int=0
update Bank set amonut=amonut-@moneyNumber where id=@outputNumber
set @errorSum=@errorSum+@@error
update Bank set amonut=amonut+@moneyNumber where id=@inputNumber
set @errorSum=@errorSum+@@error
commit
print '提交！！'
end try
begin catch
rollback
print '回滚！'
end catch
end

--------------------------------------------------------------------------------------------------

aspx前台：

app.configer:

---------------------------------------------------------------------------------------------

后台代码：

string Constr = ConfigurationManager.ConnectionStrings["MySchoolconStr"].ConnectionString;

protected void btnZhiXing_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(Constr))
{
conn.Open();
string sp_name = "usp_Bank_trans";
using (SqlCommand cmd = new SqlCommand(sp_name, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@outputNumber", txtoutputNumber.Text));
cmd.Parameters.Add(new SqlParameter("@inputNumber", txtinputNumber.Text));
cmd.Parameters.Add(new SqlParameter("@moneyNumber", txtmoneyNumber.Text));
int r = cmd.ExecuteNonQuery();
if (r > 0)
{
Label1.Text = "转入成功！";
}
else
{
Label1.Text = "转入失败！";
}
}
}
}