asp.net 初级入门学习之ATM
来源：互联网 发布：java哪个的视频好 编辑：程序博客网 时间：2024/05/16 15:02
这不， 看到这个14：00， 就想起昨晚整到凌晨才把这个ATM写完， 提笔的有点晚，不过， 基本上还是完成了。
本次博文的目的是把刚学的asp.net基础知识再巩固下。若有雷同，纯属偶合~~~
开发环境：VS2013， 开发平台：windows8.1， 使用数据库版本：Access 2010
ATM的效果图：
界面做的简单了点儿， 但是基本上是实现了ATM的基本功能的
但是笔者 指出一点： 笔者并没有做的像ATM那样，每次取钱或这存钱均为100的整数倍， 当时在做的时候， 想到，不过是加上限制条件，不过笔者有点困，就没做啦~~~~
login.aspx.cs 登陆界面的代码：
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.OleDb;namespace HR{ public partial class login : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void loginBtn_Click(object sender, EventArgs e) { string selectStr = "select * from login where 账户 = '"+AccountBox.Text+"' and 密码 = '"+KeyBox.Text+"'"; DataSet ds = AccessHelper.dataSet(selectStr); if (ds.Tables[0].Rows.Count > 0) { ///---session 保存登录信息 Session["userName"] = AccountBox.Text; Session["key"] = KeyBox.Text; Response.Redirect("index.aspx"); } else { Response.Write("<script>alert('用户名或者密码错误')</script>"); AccountBox.Text = ""; KeyBox.Text = ""; } } }}index.aspx.cs 主界面代码：
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.OleDb;using System.Data;namespace HR{ public partial class index : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { ///---先判断是否登录账户 if (Session["userName"] != null && Session["key"] != null) { Account_CountLabel.Visible = false; } else { ///--跳转到 登录界面 Response.Redirect("login.aspx"); } } /// <summary> /// ---注销， 直接返回到登录界面, 清空： session 内的 内容 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void logOffBtn_Click(object sender, EventArgs e) { Session["userName"] = ""; Session["key"] = ""; Response.Redirect("login.aspx"); } /// <summary> /// ---_取钱按钮消息事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GetBtn_Click(object sender, EventArgs e) { Response.Redirect("GetMoney.aspx"); } /// <summary> /// ----显示余额按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Account_CountBtn_Click(object sender, EventArgs e) { DataSet ds = AccessHelper.dataSet("select * from Account"); Account_Label.Text += ds.Tables[0].Rows[0][0].ToString(); AccountName_Label.Text += ds.Tables[0].Rows[0][1].ToString(); Account_CountLabel.Text += ds.Tables[0].Rows[0][2].ToString(); Account_CountLabel.Visible = true; ///--禁用按钮 ： 显示余额 Account_CountBtn.Enabled = false; } /// <summary> /// --存钱按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void saveBtn_Click(object sender, EventArgs e) { Response.Redirect("saveMoney.aspx"); } }}取钱页面：
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.OleDb;using System.Data;namespace HR{ public partial class GetMoney : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Session["userName"] != null && Session["key"] != null) { DataSet ds = AccessHelper.dataSet("select * from Account"); ///--显示余额 Label1.Text += ds.Tables[0].Rows[0][2]; } else { ///--跳转到 登录界面 Response.Redirect("login.aspx"); } } protected void sureBtn_Click(object sender, EventArgs e) { if (money_NumBox.Text == "") { Response.Write("<script>alert('取款数不能为空')</script>"); } else { //获取输入的取钱数目， float tempF = float.Parse(money_NumBox.Text); DataSet ds = AccessHelper.dataSet("select * from Account"); float allStr = float.Parse(ds.Tables[0].Rows[0][2].ToString()); // 所有额 ///---取钱数<= 余额 if (tempF < allStr && tempF > 0) { ///---计算余额 float restStr = allStr - tempF; ///----更新数据库操作 string upDateStr = "update Account set 账户 = '" + Session["userName"] + "' , 户主 = '" + ds.Tables[0].Rows[0][1].ToString() + "' , 余额 = '" + restStr.ToString() + "' "; AccessHelper.excuteSql(upDateStr); ///---提示：取走现金 Response.Write("<script>alert('请取走您的现金， 注意财产安全')</script>"); DataSet ds1 = AccessHelper.dataSet("select * from Account"); Label1.Text = "您的余额：" + ds1.Tables[0].Rows[0][2].ToString(); ///---清空输入框内的数据 money_NumBox.Text = ""; } else { ///--取款失败 Response.Write("<script>alert('取款失败，输入的数据非法')</script>"); ///---清空输入框 money_NumBox.Text = ""; } } } /// <summary> /// -返回到主页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BackBtn_Click(object sender, EventArgs e) { Response.Redirect("index.aspx"); } }}存款界面的代码：
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.OleDb;namespace HR{ public partial class saveMoney : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Session["userName"] != null && Session["key"] != null) { ///--加载余额 DataSet ds = AccessHelper.dataSet("select * from Account"); Label1.Text += ds.Tables[0].Rows[0][2].ToString(); } else { ///--跳转到 登录界面 Response.Redirect("login.aspx"); } } /// <summary> /// ---返回到主页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BackBtn_Click(object sender, EventArgs e) { Response.Redirect("index.aspx"); } /// <summary> /// ---确定存钱按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void saveBtn_Click(object sender, EventArgs e) { if (saveMoneyBox.Text == "" || float.Parse(saveMoneyBox.Text) < 0) { ///---提示存钱失败 Response.Write("<script>alert('存钱失败，存钱数不正确')</script>"); } else { ///---输入的存款数为正数 //获取输入的取钱数目， float tempF = float.Parse(saveMoneyBox.Text); DataSet ds = AccessHelper.dataSet("select * from Account"); float allStr = float.Parse(ds.Tables[0].Rows[0][2].ToString()); // 所有额 ///---取钱数<= 余额 if (tempF > 0) { ///---计算余额 float restStr = allStr + tempF; ///----更新数据库操作 string upDateStr = "update Account set 账户 = '" + Session["userName"] + "' , 户主 = '" + ds.Tables[0].Rows[0][1].ToString() + "' , 余额 = '" + restStr.ToString() + "' "; AccessHelper.excuteSql(upDateStr); ///---提示：取走现金 Response.Write("<script>alert('存款成功')</script>"); ///---更新金额提示label DataSet ds1 = AccessHelper.dataSet("select * from Account"); Label1.Text = "您的余额：" + ds1.Tables[0].Rows[0][2].ToString(); ///---清空输入框内的数据 saveMoneyBox.Text = ""; } else { ///--取款失败 Response.Write("<script>alert('取款失败，输入的数据非法')</script>"); ///---清空输入框 saveMoneyBox.Text = ""; } } } }}提示：
笔者代码里面使用一个名为AccessHelper的类， 这里面封装了数据库的一些常用操作。稍加修改， 这个类可以适用于SQL。之前的博文也说到过这个AccessHelper类，
这里，我把这个类的代码还是贴出来。
============================ AccessHelper 类 源码======================================
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.OleDb;using System.Web; public class AccessHelper { protected static OleDbConnection conn = new OleDbConnection(); protected static OleDbCommand comm = new OleDbCommand(); public AccessHelper() { // // TODO: 在此处添加构造函数逻辑 // } /// <summary> /// 打开数据库 /// </summary> private static void openConnection() { if (conn.State == ConnectionState.Closed) { conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + HttpContext.Current.Server.MapPath("1.accdb") + " "; comm.Connection = conn; try { conn.Open(); } catch (Exception e) { throw new Exception(e.Message); } } } /// <summary> /// 关闭数据库 /// </summary> private static void closeConnection() { if (conn.State == ConnectionState.Open) { conn.Close(); conn.Dispose(); comm.Dispose(); } } /// <summary> /// 执行sql语句 /// </summary> /// <param name="sqlstr"></param> public static void excuteSql(string sqlstr) { try { openConnection(); comm.CommandType = CommandType.Text; comm.CommandText = sqlstr; comm.ExecuteNonQuery(); } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } } /// <summary> /// 返回指定sql语句的OleDbDataReader对象，使用时请注意关闭这个对象。 /// </summary> /// <param name="sqlstr"></param> /// <returns></returns> public static OleDbDataReader dataReader(string sqlstr) { OleDbDataReader dr = null; try { openConnection(); comm.CommandText = sqlstr; comm.CommandType = CommandType.Text; dr = comm.ExecuteReader(CommandBehavior.CloseConnection); } catch { try { dr.Close(); closeConnection(); } catch { } } return dr; } /// <summary> /// 返回指定sql语句的OleDbDataReader对象,使用时请注意关闭 /// </summary> /// <param name="sqlstr"></param> /// <param name="dr"></param> public static void dataReader(string sqlstr, ref OleDbDataReader dr) { try { openConnection(); comm.CommandText = sqlstr; comm.CommandType = CommandType.Text; dr = comm.ExecuteReader(CommandBehavior.CloseConnection); } catch { try { if (dr != null && !dr.IsClosed) dr.Close(); } catch { } finally { closeConnection(); } } } /// <summary> /// 返回指定sql语句的dataset /// </summary> /// <param name="sqlstr"></param> /// <returns></returns> public static DataSet dataSet(string sqlstr) { DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(); try { openConnection(); comm.CommandType = CommandType.Text; comm.CommandText = sqlstr; da.SelectCommand = comm; da.Fill(ds); } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } return ds; } /// <summary> /// 返回指定sql语句的dataset /// </summary> /// <param name="sqlstr"></param> /// <param name="ds"></param> public static void dataSet(string sqlstr, ref DataSet ds) { OleDbDataAdapter da = new OleDbDataAdapter(); try { openConnection(); comm.CommandType = CommandType.Text; comm.CommandText = sqlstr; da.SelectCommand = comm; da.Fill(ds); } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } } /// <summary> /// 返回指定sql语句的datatable /// </summary> /// <param name="sqlstr"></param> /// <returns></returns> public static DataTable dataTable(string sqlstr) { DataTable dt = new DataTable(); OleDbDataAdapter da = new OleDbDataAdapter(); try { openConnection(); comm.CommandType = CommandType.Text; comm.CommandText = sqlstr; da.SelectCommand = comm; da.Fill(dt); } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } return dt; } /// <summary> /// 返回指定sql语句的datatable /// </summary> /// <param name="sqlstr"></param> /// <param name="dt"></param> public static void dataTable(string sqlstr, ref DataTable dt) { OleDbDataAdapter da = new OleDbDataAdapter(); try { openConnection(); comm.CommandType = CommandType.Text; comm.CommandText = sqlstr; da.SelectCommand = comm; da.Fill(dt); } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } } /// <summary> /// 返回指定sql语句的dataview /// </summary> /// <param name="sqlstr"></param> /// <returns></returns> public static DataView dataView(string sqlstr) { OleDbDataAdapter da = new OleDbDataAdapter(); DataView dv = new DataView(); DataSet ds = new DataSet(); try { openConnection(); comm.CommandType = CommandType.Text; comm.CommandText = sqlstr; da.SelectCommand = comm; da.Fill(ds); dv = ds.Tables[0].DefaultView; } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } return dv; } }=====================AccessHelper 类代码 至此 ======================
这不，代码都贴出来了，相信，消化它，剩下的就是时间问题啦~~~~~~
这里 是本次练手源码下载地址~~~~~~~
0 0
- asp.net 初级入门学习之ATM
- Asp.net WebService的初级入门
- Ajax之ASP.NET初级练习
- Ajax之ASP.NET初级练习
- asp.net入门学习
- ASP.NET入门学习
- Asp.NET之入门
- ASP.NET学习入门网站
- ASP.NET学习路线图(入门)
- Asp组件初级入门与精通系列之二
- Asp组件初级入门与精通系列之三
- Asp组件初级入门与精通系列之四
- Asp组件初级入门与精通系列之五
- Asp组件初级入门与精通系列之六
- Asp组件初级入门与精通系列之七
- Asp组件初级入门与精通系列之八
- Asp组件初级入门与精通系列之二
- Asp组件初级入门与精通系列之三
- 如何在Scope中利用keyword来使自己的Scope在聚合Scope中展示自己
- hdoj 1408 盐水的故事 【double精度问题】
- oracle建立dblink以及建立定时任务
- 读书笔记：编写可维护的javascript
- 【Unity】Unity数据加密
- asp.net 初级入门学习之ATM
- 技术面前，一切商业模式都是纸老虎
- Android APP崩溃上传日志到服务器并且重启！
- Git .gitignore 设置为全局global
- Ibatis学习笔记
- 无需人工交互的命令行安装SQL Server
- [笔记][html][ios]点击元素有闪烁的解决办法
- java String类有关静态变量，常量池，引用对象的问题
- java控制台版扫雷
