C#语言编程设计--课程实验报告(实验银行客户服务系统).doc

C#语言编程设计课程实验报告实验：银行客户服务系统1. 实验目的 做一个三层结构的银行客户服务系统，实现客户的存款和取款的过程。其中三层要求如下：第一层：业务表现层，在用户界面上实现客户的存款取款过程。第二层：业务逻辑层，验证用户的输入是否合法，比如用正则表达式验证用户的存款和取款的输入必须是数字。第三层：数据访问层,当业务逻辑层完成数据的验证以后，使用数据访问层的类直接对数据库进行插入或者删除的操作。2. 设计代码见附录。3. 实验结果首页(index.aspx) 提示用户输入用户名和密码：图1若输入身份证号码错误，或者密码错误，弹出错误提示框，返回首页图2若用户名与密码正确则登陆到账户管理页面图3选择存款功能，进入存款页面图4若输入不是数字，或违法恶意输入，弹出提示框，返回用户管理页面图5 若输入正确，弹出交易成功提示框，返回用户管理页面，余额相应增加图6选择取款功能，进入取款界面图7若输入不是数字，或违法恶意输入，弹出提示框，返回用户管理页面图7若取款金额超出余额，弹出提示框，禁止取款，返回用户管理页面若输入正确，提示交易成功，跳转到用户管理页面，金额相应减少图8若选择注销功能，消除Session值，跳转到登陆页面图10数据库样例：图114. 说明体会本人熟悉web开发，之前一直使用php在appache环境下做网站，数组库使用的是mysql，也在iis下做过asp，这次有机会使用ASP.NET，让我感触很多。首先，.net允许你使用多种不同编程语言的框架，你可以在你的网站中嵌入各种语言，然后，他还有出色的面向对象编程模型，强大的类库为用户带来了很多方便，还有，ASP.NET起初运行于IIS，现在也可以运行于Apache，这将给.net的安全性带来不少改进。由于接触时间不长，在使用方面不是很熟悉。通过这次实验我对.net有了进一步了解，以后会继续努力学习钻研！5. 附录源代码：/index.aspx/登陆页面 网上银行 /index.aspx.cs/登陆页面using System;using System.Data;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class index : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button2_Click(object sender, EventArgs e) Response.Redirect(index.aspx); protected void submit_Click(object sender, EventArgs e) /连接数据库，查询数据库 string conString = server=school-913254b1; + Trusted_Connection=yes; database=bank; SqlConnection conn = new SqlConnection(conString); conn.Open(); SqlCommand thisCommand = conn.CreateCommand(); thisCommand.CommandText = select * from user where username= + name.Text.Trim().ToString() + and password= + psw.Text.Trim().ToString() + ; / Response.Write(thisCommand.CommandText); SqlDataReader thisReader = thisCommand.ExecuteReader(); if (thisReader.Read() Sessionusername = name.Text.Trim().ToString(); Sessionpassword = psw.Text.Trim().ToString(); Sessionid = thisReaderid.ToString(); Response.Redirect(zhanghu.aspx?id= + Sessionid + ); else Response.Write(alert(输入有误，请重新输入!); thisReader.Close(); conn.Close(); protected void TextBox2_TextChanged(object sender, EventArgs e) protected void name_TextChanged(object sender, EventArgs e) /zhanghu.aspx/账户管理页面 网上银行/              /zhanghu.aspx.cs/账户管理页面using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class zhanghu : System.Web.UI.Page string balance = ; /int check = 0; protected void Page_Load(object sender, EventArgs e)/连接数据库，查询数据库 string connect = server=school-913254b1; + Trusted_Connection=yes; database=bank; SqlConnection conn = new SqlConnection(connect); conn.Open(); SqlCommand command = conn.CreateCommand(); string sql = command.CommandText = select * from user where id= + Sessionid + ; SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn); DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet, user); String balance = dataSet.Tablesuser.Rows0balance.ToString(); / check = Convert.ToInt32(balance); count.Text = balance.ToString(); protected void count_TextChanged(object sender, EventArgs e) protected void Button3_Click(object sender, EventArgs e) /进入存款页面 Response.Redirect(cunkuan.aspx?id= + Sessionid + ); protected void Button1_Click(object sender, EventArgs e)/进入取款页面 Response.Redirect(qukuan.aspx?id= + Sessionid + ); protected void Button2_Click(object sender, EventArgs e)/注销 Response.Redirect(index.aspx); / cunkuan.aspx/存款页面 网上银行/          /cunkuan.aspx.cs/存款页面using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;using System.Text.RegularExpressions;public partial class cunkuan : System.Web.UI.Page string balance = ; private double amount = 0; string connect = server=school-913254b1; + Trusted_Connection=yes; database=bank; protected void Page_Load(object sender, EventArgs e) /连接数据库，查询余额 SqlConnection conn = new SqlConnection(connect); conn.Open(); SqlCommand command = conn.CreateCommand(); string sql = command.CommandText = select * from user where id= + Sessionid + ; SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn); DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet, user); String balance = dataSet.Tablesuser.Rows0balance.ToString(); amount = Convert.ToDouble(balance); count.Text = balance.ToString(); protected void TextBox1_TextChanged(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) protected void Button2_Click(object sender, EventArgs e) protected void Button1_Click1(object sender, EventArgs e) string input = SaveAmount.Text; SaveAmount.Text = ;/使用正则表达式验证输入是否合法 Regex theReg = new Regex(d+(.d0,2)?$); if (theReg.IsMatch(input) /输入合法，连接数据库，修改数据 double money = Convert.ToDouble(input); amount += money; SqlConnection conn = new SqlConnection(connect); conn.Open(); SqlCommand command = conn.CreateCommand(); string sql = command.CommandText = update user set balance = + Convert.ToDouble(amount) + where id = + Sessionid + ; comman