zhfb set zhfb.vacancy=zhfb.vacancy+(select moneys from inserted)
where account='8888' and (select clinch from inserted)=1
update zhfb set zhfb.vacancy=zhfb.vacancy-(select moneys from inserted)
where account=(select account from users where yfname=(select yhname from inserted)) and (select clinch from inserted)=1
end
go
2.9.3当删除订单时删除所有订单子项
create trigger dele_dian1
on diandan1
for delete
as
delete from diandan2
where diandan2.ddid=(select ddid from deleted)
go
2.9.4当删除商品时删除商品评论
create trigger xanapan_dele
on xangpian
for delete
as
delete from xppl where xppl.xpid=(select xpid from deleted)
go
2.9.5当订单付款时超市账号加订单金额(0:没有付款,1:已经付款)
create trigger up_dian1_clinch
on diandan1
for update
as
if update(clinch)
update zhfb set zhfb.vacancy=zhfb.vacancy+(select moneys from inserted)
where account='8888' and (select clinch from inserted)=1
update zhfb set zhfb.vacancy=zhfb.vacancy-(select moneys from inserted)
where account=(select account from users where yfname=(select yhname from inserted)) and (select clinch from inserted)=1
go
2.9.6当超市进购商品时超市账号减去进货款
create trigger insert_xangpian
on xangpian
for insert
as
update zhfb set zhfb.vacancy=zhfb.vacancy-((select jg from inserted)*(select numer from inserted))
where account='8888'
go
2.9.7 数据库关系表:
第三章.系统设计及功能实现
3.1设计说明
总体规划:网上购物系统是一个复杂、综合的系统,因此必须运用软件工程的方法,首先对系统进行总体的规划和设计,否则会导致开发进度缓慢,系统不符合要求等。网上购物系统由前端网页界面、处理程序和SQL server 2000后台数据库系统组成。网页主要展示各类商品的名称、图片、价格和详细介绍等。
处理程序负责对顾客的操作和表单提交进行响应和处理,后台数据库主要存储商品数据、顾客数据、订据和销售数据等。
系统的主要功能包括前端管理和后台管理。前端管理为顾客提供新用户注册、账户登录、购物车、中心、商品搜索、在线购物、在线结算、提交订单、查询订单、修改订单、取消订单和顾客留言等功能;
后台为商家提供商品管理、顾客信息管理、订单管理和评论管理等功能。
运行平台和开发工具:
网上购物系统运行平台为windows操作系统,web服务器软APMServ5.2.6。系统开发工具:前端使用PHP,后台数据库使用SQL server 2000,网页设计工具为EditPlus3和Macromedia Dreamweaver 8。
3.2后台管理
3.2.1数据库连接关键代码:
$server="CHINA-981007323"; //服务器名
$user="sa"; //用户名
$password=""; //密码
$database="shop"; //要连接的数据库
$conn=mssql_connect($server,$user,$password); //连接服务器
mssql_select_db($database,$conn); //打开数据库
//mysql_query("SET NAMES gb2312"); //设置字符集
?>
3.3用户管理模块
3.3.1查看用户关键代码部分:
require("function.php");
$sql="select * from users";
$result=mssql_query($sql);
echo("
");
echo("
");
echo("
");echo(" | ");
echo("
");echo("
"); echo("
"); echo("
"); echo("
"); echo("用户名 ");echo(" ");echo(" | "); echo("
"); echo("
"); echo("用户密码");echo(" ");echo(" | "); echo("
"); echo("
"); echo("支付宝账号");echo(" ");echo(" | "); echo("
"); echo("
"); echo("E-mail");echo(" ");echo(" | "); echo("
"); echo("
"); echo("QQ号");echo(" ");echo(" | "); echo("
"); echo("
"); echo("手机号");echo(" ");echo(" | "); echo("
"); echo("
"); echo("操作");echo(" ");echo(" | ");echo(" "); while($row=mssql_fetch_row($result)) { echo("
"); echo("
");echo("
"); echo($row[0]); echo(" ");echo(" | "); echo("
");echo("
"); echo($row[1]); echo(" ");echo(" | "); echo("
"); echo("
");echo($row[2]); echo(" ");echo(" | "); echo("
");echo("
");echo($row[3]); echo(" ");echo(" | "); echo("
");echo("
");echo($row[4]); echo(" ");echo(" | "); echo("
");echo("
");echo($row[5]); echo(" ");echo(" | "); echo("
"); echo("");echo("");echo("[编辑]");echo(""); echo("");echo("");echo("[删除]");echo(""); echo("
"); echo(" | "); echo(" "); } echo(" ");?> 3.3.2修改用户关键代码部分: $yfname=$_POST["yfname"]; $yfpass=$_POST["yfpass"]; $account=$_POST["zhfb"]; $email=$_POST["email"]; $qq=$_POST["qq"]; $sjnumer=$_POST["sjnumer"]; $select_yf=$_POST["yfname1"]; $sub=$_POST[Submit]; $b=false; require("function.php"); $sql="select * from users where yfname='jkjkjkjk'"; if($sub=="修改用户") {$sql="update users set yfname='$yfname', yfpass='$yfpass', account='$account', email='$email', qq='$qq', sjnumer='$sjnumer' where yfname='$yfname'"; $b=false; } if($sub=="查找") { $sql="select * from users where yfname='$select_yf'"; $b=true; } $result=mssql_query($sql); if($b) { while($row=mssql_fetch_row($result)) { $a1=$row[0]; $a2=$row[1]; $a3=$row[2]; $a4=$row[3]; $a5=$row[4]; $a6=$row[5]; $a7=$row[6]; $a8=$row[7]; } }?> 3.3.3删除用户代码部分: $yfname=$_POST["yfname"]; $yfpass=$_POST["yfpass"]; $account=$_POST["zhfb"]; $email=$_POST["email"]; $qq=$_POST["qq"]; $sjnumer=$_POST["sjnumer"]; $select_yf=$_POST["yfname1"]; $sub=$_POST[Submit]; $b=false; require("function.php"); $sql="select * from users where yfname='klhkk'"; if($sub=="删除用户") {$sql="delete from users where yfname='$yfname'"; $b=false;} if($sub=="查找") { $sql="select * from users where yfname='$select_yf'"; $b=true; } $result=mssql_query($sql); if($b) {while($row=mssql_fetch_row($result)) { $a1=$row[0]; $a2=$row[1]; $a3=$row[2]; $a4=$row[3]; $a5=$row[4]; $a6=$row[5]; $a7=$row[6]; $a8=$row[7];}}?> 3.4商品管理模块 3.4.1查看商品关键代码部分: require("function.php"); $sql="select * from xangpian"; $result=mssql_query($sql); echo("
"); echo("
"); echo("
");echo(" | "); echo("
");echo("
"); echo("
"); echo("
");echo("
");echo("商品id ");echo(" ");echo(" | "); echo("
");echo("
");echo("商品名");echo(" ");echo(" | "); echo("
");echo("
");echo("商品类型");echo(" ");echo(" | "); echo("
");echo("
");echo("单价");echo(" ");echo(" | "); echo("
");echo("
");echo("数量");echo(" ");echo(" | "); echo("
");echo("
" | | |
上一篇:
PHP网站毕业设计论文
下一篇:
网上购物系统毕业设计论文