当前位置：文档之家 › 3层架构代码

3层架构代码

  • 格式：docx
  • 大小：22.32 KB
  • 文档页数：6

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);}}}。

合集下载

java三层架构实例 -回复

java三层架构实例 -回复

java三层架构实例-回复Java三层架构实例在软件开发中，通常使用三层架构将软件系统划分为三个层次：表示层、业务逻辑层和数据访问层。

Java作为一种广泛应用于业界的编程语言，也可以利用其强大的特性来实现这种架构。

本文将以Java三层架构实例为主题，逐步解释这个过程。

第一步：设计表示层在Java三层架构中，表示层负责对外部系统和用户的交互，通常以用户界面的形式展示数据和接收用户输入。

我们可以使用Java Swing或JavaFX等图形界面框架来实现表示层。

这部分的代码仅涉及用户界面的操作，不涉及具体的业务逻辑。

示例代码如下：javaimport javax.swing.*;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;public class PresentationLayer {private JFrame frame;private JButton button;private JLabel label;public PresentationLayer() {frame = new JFrame("Java三层架构示例");button = new JButton("查询");label = new JLabel();button.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {String result = BusinessLayer.queryData();label.setText(result);}});frame.add(button);frame.add(label);frame.setLayout(new FlowLayout());frame.setSize(300, 200);frame.setLocationRelativeTo(null);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.setVisible(true);}}第二步：设计业务逻辑层在Java三层架构中，业务逻辑层负责处理表示层传递过来的数据，进行相应的数据处理和业务逻辑操作。

三层架构简易实例详解

三层架构简易实例详解

三层架构简易实例详解何为三层架构？通常意义上的三层架构就是将整个业务应用划分为：表现层（UI）、业务逻辑层（BLL）、数据访问层（DAL）。

区分层次的目的即为了“高内聚，低耦合”的思想。

1.表现层（UI）：即展现给用户的界面；2.业务逻辑层（BLL）：针对具体问题的操作，也可以说是对数据层的操作，对数据业务逻辑处理；3.数据访问层（DAL）：该层所做事务直接操作数据库，针对数据的增添、删除、修改、查找等。

下面通过通过一个简单的例子来描述三层架构:需求1.实现一个客户信息管理界面（包括增加、修改、删除）操作；2.用户sql—server作为数据库以下是成型界面，至于UI设计是否合理，望各位大神拍砖UI层设计设计器代码：<Grid><DockPanel><ToolBar DockPanel.Dock="Top" Height="30"><Button Name="BtnAdd" Click="BtnAdd_Click" ToolTip="新增"><Image Source="Image\add.ico"></Image></Button><Button Name="BtnEdit" Click="BtnEdit_Click" ToolTip="编辑"><Image Source="Image\edit.ico"></Image></Button><Button Name="BtnDel" Click="BtnDel_Click" ToolTip="删除"><Image Source="Image\delete.ico"></Image></Button></ToolBar><DataGrid Name="DataGrid1" DockPanel.Dock="Top" IsReadOnly="True" AutoGenerateColumns="False"><DataGrid.Columns><DataGridTextColumn Header="姓名" Binding="{Binding Name}"></DataGridTextColumn><DataGridTextColumn Header="生日" Binding="{Binding BirthDay}"></DataGridTextColumn><DataGridTextColumn Header="电话" Binding="{Binding TelNum}"></DataGridTextColumn><DataGridTextColumn Header="地址" Binding="{Binding Address}"></DataGridTextColumn><DataGridTextColumn Header="等级" Binding="{BindingCustlevel}"></DataGridTextColumn></DataGrid.Columns></DataGrid></DockPanel></Grid>主要是通过设计器后台代码，DataGrid控件绑定数据，代码如下：/// <summary>/// 初始化加载数据/// </summary>private void LoadData(){DataGrid1.ItemsSource = CustomDAL.GetAll();}数据业务逻辑代码如下：/// <summary>/// 新增/// </summary>/// <param name="sender"></param>/// <param name="e"></param>private void BtnAdd_Click(object sender, RoutedEventArgs e){CustomEditUI editUI = new CustomEditUI();editUI.isInsert = true;if (editUI.ShowDialog() == true){LoadData();}}/// <summary>/// 编辑/// </summary>/// <param name="sender"></param>/// <param name="e"></param>private void BtnEdit_Click(object sender, RoutedEventArgs e){Custom customer = (Custom)DataGrid1.SelectedItem;if (customer == null){MessageBox.Show("请选择要编辑的行！");return;}CustomEditUI editUI = new CustomEditUI();//添加标识便于区分是编辑保存还是新增保存editUI.isInsert = false;editUI.editId = customer.Id;if (editUI.ShowDialog() == true){LoadData();}}/// <summary>/// 删除/// </summary>/// <param name="sender"></param>/// <param name="e"></param>private void BtnDel_Click(object sender, RoutedEventArgs e){if (MessageBox.Show("确认删除此条数据？", "提醒", MessageBoxButton.YesNo) == MessageBoxResult.Yes){Custom custom = DataGrid1.SelectedItem as Custom;if (custom != null){if ((MessageBox.Show("确认要删除此调数据", "提醒") == MessageBoxResult.OK)){CustomDAL.Delete(custom.Id);LoadData();}}else{MessageBox.Show("请选择要删除的数据", "提醒");return;}}}数据访问层（DAL），代码如下：public class CustomDAL{/// <summary>/// 查询数据总条数/// </summary>/// <returns></returns>public static int GetCount(){return (int)SqlHelper.ExecuteScalar("select * from T_Custom");}/// <summary>///根据ID查询数据/// </summary>/// <param name="id"></param>/// <returns></returns>public static Custom GetByid(long id){DataTable table = SqlHelper.ExecuteDataTable("select * from T_custom where id=@id", new SqlParameter("@id", id));return ToCustom(table.Rows[0]); ;}/// <summary>/// 根据id删除数据/// </summary>/// <param name="id"></param>public static void Delete(long id){SqlHelper.ExecuteNonQuery("delete from T_custom where id=@id", new SqlParameter("@id", id));}/// <summary>/// 插入空值处理/// </summary>/// <param name="value"></param>/// <returns></returns>public static object FromDBNull(object value){if (value == null){return DBNull.Value;}else{return value;}}/// <summary>/// 查询空值处理/// </summary>/// <param name="value"></param>/// <returns></returns>public static object ToDBNull(object value){if (DBNull.Value == null){return null;}else{return value;}}/// <summary>/// 新增数据/// </summary>/// <param name="custom"></param>public static void InSert(Custom custom){SqlHelper.ExecuteNonQuery(@"insert into T_Custom(Name,Birthday,Address,Telnum,Custlevel)values(@Name,@Birthday,@Address,@Teln um,@Custlevel)",new SqlParameter("@Name", ),new SqlParameter("@Birthday", FromDBNull(custom.BirthDay)),new SqlParameter("@Address", custom.Address),new SqlParameter("@Telnum", custom.TelNum),new SqlParameter("@Custlevel", custom.Custlevel));}/// <summary>/// 更新数据/// </summary>/// <param name="custom"></param>public static void UpDate(Custom custom){SqlHelper.ExecuteNonQuery(@"update T_Custom set Name=@Name,Birthday=@Birthday,Address=@Address,Telnum=@Telnum,Custlevel=@Custlevel where id=@id",new SqlParameter("@Name", ),new SqlParameter("@Birthday", FromDBNull(custom.BirthDay)),new SqlParameter("@Address", custom.Address),new SqlParameter("@TelNum", custom.TelNum),new SqlParameter("@Custlevel", custom.Custlevel),new SqlParameter("@Id", custom.Id));}/// <summary>/// 查询所有数据/// </summary>/// <returns></returns>public static List<Custom> GetAll(){DataTable table = SqlHelper.ExecuteDataTable("select * from T_custom");List<Custom> lst = new List<Custom>();for (int i = 0; i < table.Rows.Count; i++){lst.Add(ToCustom(table.Rows[i]));}return lst;}/// <summary>/// 影射关系赋值/// </summary>/// <param name="row"></param>/// <returns></returns>public static Custom ToCustom(DataRow row){Custom custom = new Custom(); = row["Name"].ToString();custom.Address = row["Address"].ToString();custom.BirthDay = (DateTime?)ToDBNull(row["BirthDay"]);custom.TelNum = row["TelNum"].ToString();custom.Custlevel = (int)row["CUstlevel"];custom.Id = (long)row["id"];return custom;}}public class SqlHelper{private static string connstr = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;/// <summary>/// 查询数据/// </summary>/// <param name="sql"></param>/// <param name="parameters"></param>/// <returns></returns>public static Object ExecuteScalar(string sql, params SqlParameter[] parameters){using (SqlConnection cnn = new SqlConnection(connstr)){cnn.Open();using (SqlCommand cmd = cnn.CreateCommand()){mandText = sql;cmd.Parameters.AddRange(parameters);return cmd.ExecuteScalar();}}}/// <summary>/// 增、删、改操作/// </summary>/// <param name="sql"></param>/// <param name="parameters"></param>public static void ExecuteNonQuery(string sql, params SqlParameter[] parameters){using (SqlConnection cnn = new SqlConnection(connstr)){cnn.Open();using (SqlCommand cmd = cnn.CreateCommand()){mandText = sql;cmd.Parameters.AddRange(parameters);cmd.ExecuteNonQuery();}}}/// <summary>/// 单个查询结果返回/// </summary>/// <param name="sql"></param>/// <param name="parameters"></param>/// <returns></returns>public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters){using (SqlConnection cnn = new SqlConnection(connstr)){cnn.Open();using (SqlCommand cmd = cnn.CreateCommand()){mandText = sql;cmd.Parameters.AddRange(parameters);SqlDataAdapter apter = new SqlDataAdapter(cmd);DataSet dataset = new DataSet();apter.Fill(dataset);return dataset.Tables[0];}}}}业务模型层public class Custom{public long Id { set; get; }public string Name { set; get; }public DateTime? BirthDay { set; get; }public string Address { set; get; }public string TelNum { set; get; }public int Custlevel { set; get; }}业务模型层public class Custom{public long Id { set; get; }public string Name { set; get; }public DateTime? BirthDay { set; get; }public string Address { set; get; }public string TelNum { set; get; }public int Custlevel { set; get; } }上述用思想,图形表示如下：。

java三层架构实例

java三层架构实例

java三层架构实例摘要：1.三层架构概述2.Java三层架构实例详解3.三层架构的优缺点4.总结正文：一、三层架构概述三层架构（3-Tier Architecture）是一种常见的软件架构模式，它将系统分为三个层次：显示层、业务逻辑层和数据层。

这种架构模式使得系统具有高内聚、低耦合的特点，提高了程序的可重用性和可移植性。

在Java开发中，显示层通常使用HTML、CSS和JavaScript等技术，业务逻辑层使用JavaBean、Servlet等技术，数据层则使用JDBC等数据库操作技术。

二、Java三层架构实例详解1.显示层（View）：编写注册界面，用户可以通过界面输入用户名、密码和邮箱等信息。

2.业务逻辑层（Controller）：编写CustomerServlet.java，接收请求参数并封装，保证用户名的唯一性，调用Service层将用户信息添加到数据库。

3.数据层（Model）：编写User实体类，表示用户的信息。

4.数据库（Database）：使用JDBC技术，实现用户信息的增删查改。

三、三层架构的优缺点优点：1.高内聚、低耦合：每个层次职责明确，相互独立，便于维护和扩展。

2.可重用性和可移植性：各层次可以根据需求独立更换，提高系统的灵活性。

缺点：1.系统性能稍低：由于分层处理，可能导致请求处理的效率降低。

2.级联修改：当某个层次发生变化时，可能需要修改其他层次，增加了维护难度。

四、总结Java三层架构是一种理想的软件开发模式，它使得系统具有更好的可维护性、可扩展性和灵活性。

通过具体的实例，我们可以更深入地理解三层架构的实现方式和注意事项。

三层架构(CURD)通用方法

三层架构(CURD)通用方法

三层架构增、删、改、查通用方法命名规则要求：比如：Student 解决方案名称三层创建：UI层：Web网站E:\Student\Web.BLL层：类库Student.BLL 类命名：对象名+ManagerDAL层：类库Student.DAL 类命名：对象名+ServiceModels层：类库Student。

Models。

类命名：以数据库表同名（对于复数名词改成单数形式）。

数据访问层操作方法：（DBHelper帮助类）以用户对象为例子：备注：下面参数为”参数列表的我们都是使用DBHelper.CreateParamer(“@ProName”,SqlDbType.Varchar,”值”)”方式。

1.添加(两行代码实现)：public bool AddUser(User user){string sql=”插入语句”;return DBHelper.GetExecuteNonquery(sql,参数列表)>0;}2.修改（行代码实现）:public bool UpdateUser(User user){string sql=”修改语句”;return DBHelper.GetExecuteNonquery(sql,参数列表)>0;}3.删除（两行代码实现）：public bool DeleteUserById(string id){string sql=”删除语句”;return DBHelper.GetExecuteNonquery(sql,参数列表)>0;}4.单个查询：public User GetUserById(string id){string sql=”查询语句”;User user = new User();SqlDataReader dr=DBHelper.GetDataReader(sql,参数列表);if(dr.reader()){user.Id=(int)dr[“Id”];//……………..同样方式给对象赋值。