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

C#语言编程设计

课程实验报告

实验：银行客户服务系统

1.实验目的

做一个三层结构的银行客户服务系统，实现客户的存款和取款的过程。

其中三层要求如下：

第一层：业务表现层，在用户界面上实现客户的存款取款过程。

第二层：业务逻辑层，验证用户的输入是否合法，比如用正则表达式验证用户的存款和取款的输入必须是数字。

第三层：数据访问层,当业务逻辑层完成数据的验证以后，使用数据访问层的类直接对数据库进行插入或者删除的操作。

2.设计代码

见附录。

3.实验结果

首页(index.aspx) 提示用户输入用户名和密码：

图1

若输入身份证号码错误，或者密码错误，弹出错误提示框，返回首页

图2

若用户名与密码正确则登陆到账户管理页面

图3

图4

若输入不是数字，或违法恶意输入，弹出提示框，返回用户管理页面

图5

若输入正确，弹出‘交易成功’提示框，返回用户管理页面，余额相应增加

图6

选择取款功能，进入取款界面

图7

若输入不是数字，或违法恶意输入，弹出提示框，返回用户管理页面

图7

若取款金额超出余额，弹出提示框，禁止取款，返回用户管理页面

若输入正确，提示交易成功，跳转到用户管理页面，金额相应减少

图8

若选择注销功能，消除Session值，跳转到登陆页面

图10

图11

4.说明体会

本人熟悉web开发，之前一直使用php在appache环境下做网站，数组库使用的是mysql，也在iis下做过asp，这次有机会使用https://www.360docs.net/doc/857485115.html,，让我感触很多。

首先，.net允许你使用多种不同编程语言的框架，你可以在你的网站中嵌入各种语言，然后，他还有出色的面向对象编程模型，强大的类库为用户带来了很多方便，还有，https://www.360docs.net/doc/857485115.html,起初运行于IIS，现在也可以运行于Apache，这将给.net的安全性带来不少改进。由于接触时间不长，在使用方面不是很熟悉。

通过这次实验我对.net有了进一步了解，以后会继续努力学习钻研！

5.附录

源代码：

//index.aspx

//登陆页面

<%@Page Language="C#"AutoEventWireup="true"CodeFile="index.aspx.cs"Inherits="index" %>

"https://www.360docs.net/doc/857485115.html,/TR/xhtml1/DTD/xhtml1-transitional.dtd">

valign="middle"> Style="font-size: 12px; z-index: 100; left: 228px; vertical-align: middle; font-family: 宋体; position: absolute; top: 143px; text-align: center"Text="用户名："Width="65px"> Style="z-index: 103; left: 313px; position: absolute; top: 142px"Width="119px" OnTextChanged="name_TextChanged"> Style="font-size: 12px; z-index: 102; left: 236px; position: absolute; top: 169px"Text="密码：" Width="57px"> Style="z-index: 104; left: 313px; position: absolute; top: 169px"TextMode="Password" Width="119px"> Style="z-index: 106; left: 319px; position: absolute; top: 201px"Text="重设"Width="40px" OnClick="Button2_Click"/>

//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();

https://www.360docs.net/doc/857485115.html,mandText = "select * from [user] where username='" +

name.Text.Trim().ToString() + "' and password='" + psw.Text.Trim().ToString() + "'";

// Response.Write(https://www.360docs.net/doc/857485115.html,mandText);

SqlDataReader thisReader = thisCommand.ExecuteReader();

if (thisReader.Read())

{

Session["username"] = name.Text.Trim().ToString();

Session["password"] = psw.Text.Trim().ToString();

Session["id"] = thisReader["id"].ToString();

Response.Redirect("zhanghu.aspx?id='" + Session["id"] + "'");

}

else

{

Response.Write("");

}

thisReader.Close();

conn.Close();

}

protected void TextBox2_TextChanged(object sender, EventArgs e)

{

}

protected void name_TextChanged(object sender, EventArgs e)

{

}

}

//zhanghu.aspx

//账户管理页面

<%@Page Language="C#"AutoEventWireup="true"CodeFile="zhanghu.aspx.cs"Inherits="zhanghu"%>

"https://www.360docs.net/doc/857485115.html,/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

style="border-right: thin solid; border-top: thin solid; border-left: thin solid; border-bottom: thin solid">

	OnTextChanged="count_TextChanged"ReadOnly="True">

//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 = https://www.360docs.net/doc/857485115.html,mandText = "select * from [user] where id='" + Session["id"] + "'";

SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);

DataSet dataSet = new DataSet();

dataAdapter.Fill(dataSet, "user");

String balance = dataSet.Tables["user"].Rows[0]["balance"].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='" + Session["id"] + "'");

}

protected void Button1_Click(object sender, EventArgs e)

{

//进入取款页面

Response.Redirect("qukuan.aspx?id='" + Session["id"] + "'");

}

protected void Button2_Click(object sender, EventArgs e)

{

//注销

Response.Redirect("index.aspx");

}

}

// cunkuan.aspx

//存款页面

<%@Page Language="C#"AutoEventWireup="true"CodeFile="cunkuan.aspx.cs"Inherits="cunkuan"%>

"https://www.360docs.net/doc/857485115.html,/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

style="border-right: thin solid; border-top: thin solid; border-left: thin solid; border-bottom: thin solid">

	OnTextChanged="count_TextChanged"ReadOnly="True"> OnTextChanged="SaveAmount_TextChanged">     Style="font-size: 12px; z-index: 109; left: 355px; position: absolute; top: 330px"Text="确定"Width="40px" OnClick="Button1_Click1"/>

//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 = https://www.360docs.net/doc/857485115.html,mandText = "select * from [user] where id='" + Session["id"] + "'";

SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);

DataSet dataSet = new DataSet();

dataAdapter.Fill(dataSet, "user");

String balance = dataSet.Tables["user"].Rows[0]["balance"].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+(\.\d{0,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 = https://www.360docs.net/doc/857485115.html,mandText = "update [user] set balance = '" + Convert.ToDouble(amount) + "'where id ='" + Session["id"] + "'";

command.ExecuteNonQuery();

conn.Close();

Response.Write("");

SaveAmount.Focus();

}

else

{

Response.Write(""); }

}

protected void SaveAmount_TextChanged(object sender, EventArgs e)

{

}

protected void count_TextChanged(object sender, EventArgs e)

{

}

protected void Button3_Click1(object sender, EventArgs e)

{

Response.Redirect("zhanghu.aspx?id='" + Session["id"] + "'");

}

}

//qukuan.aspx

//取款页面

<%@Page Language="C#"AutoEventWireup="true"CodeFile="qukuan.aspx.cs"Inherits="qunkuan" %>

"https://www.360docs.net/doc/857485115.html,/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

style="border-right: thin solid; border-top: thin solid; border-left: thin solid; border-bottom: thin solid">

	ReadOnly="True"> OnTextChanged="TakeAmount_TextChanged">     Style="font-size: 12px; z-index: 109; left: 488px; position: absolute; top: 330px"Text="返回"Width="40px" OnClick="Button1_Click1"/>

//qukuan.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 qukuan : 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 = https://www.360docs.net/doc/857485115.html,mandText = "select * from [user] where id='" + Session["id"] + "'";

SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);

DataSet dataSet = new DataSet();

dataAdapter.Fill(dataSet, "user");

String balance = dataSet.Tables["user"].Rows[0]["balance"].ToString();

amount = Convert.ToDouble(balance);

count.Text = balance.ToString();

}

protected void TakeAmount_TextChanged(object sender, EventArgs e)

{

}

protected void Button3_Click(object sender, EventArgs e)

{

string input = TakeAmount.Text;

TakeAmount.Text = "";

//使用正则表达式验证输入是否合法

Regex theReg = new Regex(@"^\d+(\.\d{0,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 = https://www.360docs.net/doc/857485115.html,mandText = "update [user] set balance = '" + Convert.ToDouble(amount) + "'where id ='" + Session["id"] + "'";

command.ExecuteNonQuery();

conn.Close();

Response.Write("");

Response.Redirect("zhanghu.aspx?id='" + Session["id"] + "'");

TakeAmount.Focus();

}

else

{

Response.Write(""); }

}

protected void Button1_Click1(object sender, EventArgs e)

{

Response.Redirect("zhanghu.aspx?id='" + Session["id"] + "'");

}

}