1、系统输入数据第一层数据流图用户存款信息用户取款信息(6)数据字典:数据流名称:储户信息数据结构:账号(ZH)银行(YH)密码(MM)姓名(XM)身份证号(SFZH)性别(XB)年龄(NL)地址(DZ)存款余额(CKYE)银行存款存款单号(CKDH)日期(RQ)存款方式(CKFS)存款金额(JE)银行取款取款单号(CKDH)取款方式(CKFS)金额(JE)2.概念结构设计(1)系统E-R图 1 1 N NN3.逻辑结构设计储户(账号、银行、密码、姓名、身份证号、性别、年龄、地址、存款余额)存款单(存款单号、账号、日期、存款方式、金额)取款单(取款单号、账号、日期、取款方式、金额)(注:“”表示主
2、键,“”表示主键+外键,“”表示外键)储户字段名数据类型长度说明描述ZHChar15账号主键YHVarchar50银行MM6密码XM8姓名SFZH18身份证号XB2性别NLSmallint年龄DZ地址CKYEFloat20存款余额存款单CKDH16存款单号主键(年月日+序号)外键RQDatatime日期JE金额CUFS存款方式取款单QUDHCharr取款单号QKFS取款方式银行存取款系统用户的增删改一、增加用户信息:代码:using System;using System.Collections.Generic;using System.ComponentModel;using System.
3、Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace 银行存取款系统数据库设计 public partial class Form1 : Form public Form1() InitializeComponent(); private void 确定_Click(object sender, EventArgs e) /连接字符串 string Strcnn = Data Source=127
4、.0.0.1;Initial Catalog=银行存取款系统数据库设计;Integrated Security=True; /实例化连接对象 SqlConnection sqlcnn = new SqlConnection(Strcnn); /打开连接通道 sqlcnn.Open(); /建立SQL语句 string SQLstr = insert into 用户 values( + txtno.Text.Trim() + , + txtname.Text.Trim() + + txtsex.Text.Trim() + , + txtage.Text.Trim() + + txtid.Text
5、.Trim() + ) /建立SQLcommand对象 SqlCommand sqlcmm = new SqlCommand(SQLstr, sqlcnn); /执行查询命令 int result = sqlcmm.ExecuteNonQuery(); /判断执行是否成功 if (result 0) MessageBox.Show(插入用户信息成功!); else插入用户信息失败! /关闭连接通道 sqlcnn.Close(); private void 重置_Click(object sender, EventArgs e) /清除文本框的内容 txtno.Clear(); txtname.
6、Clear(); txtsex.Clear(); txtage.Clear(); txtid.Clear(); private void 退出_Click(object sender, EventArgs e) this.Close(); private void txtid_TextChanged(object sender, EventArgs e) private void label6_Click(object sender, EventArgs e) private void txtage_TextChanged(object sender, EventArgs e) private
7、 void label5_Click(object sender, EventArgs e) private void txtsex_TextChanged(object sender, EventArgs e) private void label4_Click(object sender, EventArgs e) private void txtname_TextChanged(object sender, EventArgs e) private void label3_Click(object sender, EventArgs e) private void txtno_TextC
8、hanged(object sender, EventArgs e) private void label2_Click(object sender, EventArgs e) private void label1_Click(object sender, EventArgs e)截图:二、查询修改用户信息:usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Wi
9、ndows.Forms;usingSystem.Data.SqlClient;public partial class Form2 :public Form2()InitializeComponent(); private void 查询_Click(object sender, EventArgs e)SqlConnectionsqlcnn = new SqlConnection(Strcnn);sqlcnn.Open();select * from 用户 where no= + cmbno.SelectedItem.ToString() + SqlCommandsqlcmm = new S
10、qlCommand(SQLstr, sqlcnn); /执行查询命令, 结果填充到SqlDataReader数据中SqlDataReadersqlrd = sqlcmm.ExecuteReader();while (sqlrd.Read()txtname.Text = sqlrdname.ToString();txtsex.Text = sqlrdsextxtage.Text = sqlrdagetxtid.Text = sqlrdidsqlcnn.Close();private void Form2data_Load(object sender, EventArgs e) private v
11、oid 保存_Click(object sender, EventArgs e)update 用户 set name=,sex=,age=,id= where no=int result = sqlcmm.ExecuteNonQuery();if (result MessageBox.Show(修改用户信息成功!else修改用户信息失败!this.Close();private void Form2_Load(object sender, EventArgs e)select * from 用户 /通过循环一个一个读取学号填入组合中cmbno.Items.Add(sqlrdno);三、删除用户
12、信息public partial class Form3 :public Form3() private void 删除_Click(object sender, EventArgs e) / 从listbox列表框中选择的一行用户信息,提取用户的账号stringSelectno = lstStu.SelectedItem.ToString().Substring(0, 19);delete from 用户 where no=+Selectno+删除用户信息成功!删除用户信息失败! /从当前的listbox列表框中,把选择删除的内容移去。lstStu.Items.Remove(lstStu.SelectedItem);private void Form3_Load(object sender, EventArgs e) /通过循环一个一个读取账号填入组合中stringitmno = sqlrdstringitmname = sqlrdstringitmsex = sqlrdstringitmage = sqlrdstringitmid = sqlrdstringitmStr = itmno + + itmname + + itmsex + + itmage + + itmid;lstStu.Items.Add(itmStr);