数据库原理及应用课程设计报告Word文档下载推荐.docx
- 文档编号:6558121
- 上传时间:2023-05-06
- 格式:DOCX
- 页数:30
- 大小:186.68KB
数据库原理及应用课程设计报告Word文档下载推荐.docx
《数据库原理及应用课程设计报告Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《数据库原理及应用课程设计报告Word文档下载推荐.docx(30页珍藏版)》请在冰点文库上搜索。
系统需求分析与设计
数据流图
E-R图
数据结构描述
商品数据结构:
Shanid
Char
6
Shanname
8
Shancount
Smailint
2
Shanprice
Factorid
char
公司数据结构:
Factorname
varChar
24
Factoraddr
Factorphone
11
销售数据结构:
Salsecount
销售管理系统
软件设计流程图和功能模块图
程序模块汇总
商品信息录入;
商品信息查询;
公司信息录入;
公司信息查询;
销售信息录入;
销售信息查询;
源程序清单
主目录:
usingSystem;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
publicpartialclass_Default:
System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidButton1_Click(objectsender,EventArgse)
Response.Redirect("
~/Default2.aspx"
);
protectedvoidButton3_Click(objectsender,EventArgse)
~/Default3.aspx"
protectedvoidButton2_Click(objectsender,EventArgse)
~/Default4.aspx"
protectedvoidButton4_Click(objectsender,EventArgse)
~/Default6.aspx"
protectedvoidButton5_Click(objectsender,EventArgse)
protectedvoidButton6_Click(objectsender,EventArgse)
~/Default5.aspx"
protectedvoidButton7_Click(objectsender,EventArgse)
~/Default7.aspx"
}
○1商品信息录入;
usingSystem.Collections;
usingSystem.Data.SqlClient;
publicpartialclassDefault2:
System.Web.UI.Page
if((ShangID.Text.Trim()).Length<
1)
Response.Write("
<
script>
window.alert('
没有要删除的项!
'
)<
/script>
"
return;
SqlConnectioncon=newSqlConnection("
server=localhost;
userid=sa;
pwd=123456;
database=studb"
con.Open();
stringselect="
selectcount(*)astotalfromSwhereShanID="
+"
+ShangID.Text.Trim()+"
;
SqlCommandcmdsel=newSqlCommand(select,con);
SqlDataReaderdr=cmdsel.ExecuteReader();
if(dr.Read())
if(int.Parse(dr["
total"
].ToString())==0)
要删除的记录不存在!
dr.Close();
stringstr="
deletefromSwhereShanID="
+"
+ShangID.Text.Trim()+"
SqlCommandcmd=newSqlCommand(str,con);
cmd.ExecuteNonQuery();
con.Close();
protectedvoidExit_Click(objectsender,EventArgse)
Response.Redirect("
~/Default.aspx"
protectedvoidInsert_Click(objectsender,EventArgse)
uid=sa;
stringinsert="
insertintoS(ShanID,ShanName,ShanCount,ShanPrice,FactoryID)values("
"
+ShangName.Text.Trim()+
"
+ShangCount.Text.Trim()+"
+ShangPrice.Text.Trim()+
+ShangAddr.Text.Trim()+"
)"
Response.Write(insert);
SqlCommandcmd1=newSqlCommand(insert,con);
cmd1.ExecuteNonQuery();
○2商品信息查询;
publicpartialclassDefault3:
protectedvoidMoveToFirst_Click(objectsender,EventArgse)
selectShanIDfromSorderbyShanIDasc"
SqlDataReadersr=cmd.ExecuteReader();
if(sr.Read())
stringStudent=sr["
ShanID"
].ToString();
Refresh(Student);
sr.Close();
privatevoidRefresh(stringshangId)
select*fromSwhereShanID="
+shangId.ToString()+"
ShangID.Text=shangId.ToString();
ShangName.Text=sr["
ShanName"
ShangCount.Text=sr["
ShanCount"
ShangPrice.Text=sr["
ShanPrice"
ShangAddr.Text=sr["
FactoryID"
protectedvoidMoveToPre_Click(objectsender,EventArgse)
请选择一个当前项!
stringshangid="
shangid=sr["
if(shangid==ShangID.Text.Trim())
当前数据项已经是第一个了!
else
stringtempstr="
selectmax(ShanID)asmaxidfromSwhereShanID<
cmd.CommandText=tempstr;
SqlDataReaderdr=cmd.ExecuteReader();
stringshId=dr["
maxid"
Refresh(shId);
protectedvoidMoveToNext_Click(objectsender,EventArgse)
selectShanIDfromSorderbyShanIDdesc"
当前数据项已经是最后一个了!
selectmin(ShanID)asmaxidfromSwhereShanID>
protectedvoidMoveToLast_Click(objectsender,EventArgse)
stringShang=sr["
Refresh(Shang);
protectedvoidKeySelect_Click(objectsender,EventArgse)
boolfind=false;
stringcmdstr="
select*fromS"
SqlDataAdapterda=newSqlDataAdapter(cmdstr,con);
DataSetds=newDataSet();
da.Fill(ds);
for(inti=0;
i<
ds.Tables[0].Rows.Count;
i++)
for(intj=0;
j<
ds.Tables[0].Columns.Count;
j++)
stringdata=(ds.Tables[0].Rows[i][j].ToString()).Trim();
if(data==Select.Text.Trim())
ShangID.Text=ds.Tables[0].Rows[i]["
ShangName.Text=ds.Tables[0].Rows[i]["
ShangCount.Text=ds.Tables[0].Rows[i]["
ShangPrice.Text=ds.Tables[0].Rows[i]["
ShangAddr.Text=ds.Tables[0].Rows[i]["
find=true;
if(find==false)
没有相关记录!
protectedvoidExit_Click(objectsender,EventArgse)
○3公司信息录入;
publicpartialclassDefault4:
protectedvoidInsert_Click(objectsender,EventArgse)
insertintoFactory(FactorID,FactorName,FactorAddr,FactorPhone)values("
+FactoryID.Text.Trim()+"
+FactoryName.Text.Trim()+
+FactoryAddr.Text.Trim()+"
+FactoryPhone.Text.Trim()+
cmd1.ExecuteNonQuery
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 数据库 原理 应用 课程设计 报告
![提示](https://static.bingdoc.com/images/bang_tan.gif)