3层架构代码

Default.aspx.cs(表示层)using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using BLL;public partial class_Default : System.Web.UI.Page{studentBLL stubll = new studentBLL();private void databind(){GridView1.DataSource=stubll.GetAllStudent();GridView1.DataBind();}protected void Page_Load(object sender, EventArgs e){if(!IsPostBack){databind();}}protected void Button1_Click(object sender, EventArgs e){int no = int.Parse(TxtSno.Text);string name = TxtSname.Text;string sex = TxtSsex.Text;int age = int.Parse(TxtSage.Text);string dept = TxtSdept.Text;int n = stubll.InsertStudent(no,name,sex,age,dept);databind();}protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {GridView1.EditIndex = -1;databind();}protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e){int no = int.Parse(e.Keys[0].ToString());int n = stubll.DeleteStudent(no);databind();}protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e){GridView1.EditIndex = e.NewEditIndex;databind();}protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e){int no = int.Parse(e.NewValues[0].ToString());string name = e.NewValues[1].ToString();string sex = e.NewValues[2].ToString();int age = int.Parse(e.NewValues[3].ToString());string dept = e.NewValues[4].ToString();int n = stubll.UpdateStudent(no, name, sex, age, dept);GridView1.EditIndex = -1;databind();}}SQLHelper.cs类（封装层）using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;using System.Configuration;namespace DBUtility{public class SQLHepler{private static string connstr =ConfigurationManager.ConnectionStrings["StudentConStr"].ConnectionString;public static SqlDataReader ExecuteReader(string sqlstr,params SqlParameter[] parameters) {SqlConnection conn = new SqlConnection(connstr);SqlCommand cmd = new SqlCommand(sqlstr, conn);SqlDataReader dr = null;foreach (SqlParameter pa in parameters){cmd.Parameters.Add(pa);}try{conn.Open();dr = cmd.ExecuteReader(mandBehavior.CloseConnection);cmd.Parameters.Clear();}catch{conn.Close();}return dr;}public static int ExecuteNonQuery(string sqlstr, params SqlParameter[] parameters){SqlConnection conn = new SqlConnection(connstr);SqlCommand cmd = new SqlCommand(sqlstr, conn);foreach (SqlParameter pa in parameters){cmd.Parameters.Add(pa);}try{conn.Open();int i = cmd.ExecuteNonQuery();cmd.Parameters.Clear();return i;}finally{conn.Close();}}}}StudentModel.cs（实体层）using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace MODEL{public class studentMODEL{private int s_no;private string s_name;private string s_sex;private int s_age;private string s_dept;public int sno{get{return s_no;}set{s_no = value;}}public string sname{get{return s_name;}set{s_name = value;}}public string ssex{get{return s_sex;}set{s_sex = value;}}public int sage{get{return s_age;}set{s_age = value;}}public string sdept{get{return s_dept;}set{s_dept = value;}}}}StudentDAL.cs（数据访问层）using System;using System.Collections.Generic;using System.Linq;using System.Text;using DBUtility;using MODEL;using System.Data;using System.Data.SqlClient;namespace DAL{public class studentDAL{public List<studentMODEL> GetAllStudent(){string sqlstr = "select sno,sname,ssex,sage,sdept from student";List <studentMODEL> stuList= new List<studentMODEL>();SqlDataReader dr = null;try{dr = SQLHepler.ExecuteReader(sqlstr);while (dr.Read()){studentMODEL s = new studentMODEL();s.sno = dr.GetInt32(0);s.sname = dr.GetString(1);s.ssex = dr.GetString(2);s.sage = dr.GetInt32(3);s.sdept = dr.GetString(4);stuList.Add(s);}return stuList;}catch{dr.Close();return null;}}public int InsertStudent(int no, string name, string sex, int age, string dept){SqlParameter[] sps = new SqlParameter[]{new SqlParameter("@sno",no),new SqlParameter("@sname",name),new SqlParameter("@ssex",sex),new SqlParameter("@sage",age),new SqlParameter("@sdept",dept)};string sqlstr = "insert student (sno,sname,ssex,sage,sdept) values(@sno,@sname,@ssex,@sage,@sdept)";return SQLHepler.ExecuteNonQuery(sqlstr, sps);}public int UpdateStudent(int no, string name, string sex, int age, string dept){SqlParameter[] sps = new SqlParameter[]{new SqlParameter("@sno",no),new SqlParameter("@sname",name),new SqlParameter("@ssex",sex),new SqlParameter("@sage",age),new SqlParameter("@sdept",dept)};string sqlstr = "update student set sname=@sname,ssex=@ssex,sage=@sage,sdept=@sdept where sno=@sno";return SQLHepler.ExecuteNonQuery(sqlstr, sps);}public int DeleteStudent(int no){SqlParameter[] sps = new SqlParameter[]{new SqlParameter("@sno",no)};string sqlstr = "delete from student where sno=@sno";return SQLHepler.ExecuteNonQuery(sqlstr, sps);}}}StudentBLL.cs（业务逻辑层）using System;using System.Collections.Generic;using System.Linq;using System.Text;using MODEL;using DAL;namespace BLL{public class studentBLL{studentDAL studal = new studentDAL();public List<studentMODEL> GetAllStudent(){return studal.GetAllStudent();}public int InsertStudent(int no, string name, string sex, int age, string dept){return studal.InsertStudent(no, name, sex, age, dept);}public int UpdateStudent(int no, string name, string sex, int age, string dept){return studal.UpdateStudent(no, name, sex, age, dept);}public int DeleteStudent(int no){return studal.DeleteStudent(no);}}}。