前一节,就是查询,下面看看添加表面层: protected void BTtrue_Click( object sender, EventArgs e) ...... ... { if (Page.IsValid == true) .........{ CXF.newstitle = tbtitle.Text;//在CXF类用定义的字符串名称 CXF.newsbody = FTBbody.Text; CXF.newsdate = DateTime.Now.ToString(); CXF.newsathor = tbauth.Text; CXF.ADDdata(tableID);//CXF类的添加方法 this.tbtitle.Text = ""; this.FTBbody.Text = ""; this.tbauth.Text = ""; Response.Write("<script language='javascript'>alert('添加成功!')</script>"); newsbind(); } } 业务层的添加方法: public static OleDbCommand ADDdata( string tableID) // 取的表名参数 ... { string stredit = ""; switch (tableID) ...{ case "hzhb": stredit = string.Format(@"SELECT MAX(hzhb_ID) AS [hzhb_id] FROM [hzhb]"); break; case "news": stredit = string.Format(@"SELECT MAX(news_ID) AS [news_id] FROM [news]"); break;//因为现在是新闻添加,在此跳出 case "guest": stredit = string.Format(@"SELECT MAX(guest_ID) AS [guest_id] FROM [guest]"); break; case "PEO": stredit = string.Format(@"SELECT MAX(PEO_ID) AS [PEO_id] FROM [PEO]"); break; case "user": stredit = string.Format(@"SELECT MAX(user_ID) AS [user_id] FROM [user]"); break; case "list": stredit = string.Format(@"SELECT MAX(list_ID) AS [list_id] FROM [list]"); break; case "product": stredit = string.Format(@"SELECT MAX(productID) AS [productid] FROM [product]"); break; } OleDbDataReader odr = DB.Get_Edit(stredit);//执行一个DB类查询最大ID号的方法, if (odr.Read()) ...{ addID = odr.GetInt32(0) + 1; } else addID = 1; string strdelete = ""; switch (tableID) ...{ case "hzhb": strdelete = string.Format(@"INSERT INTO [hzhb] VALUES('" + addID + "','" + hzhbname + "','" + hzhbbody + "','" + hzhbimage + "','" + DateTime.Now + "')"); break; case "PEO": strdelete = string.Format(@"INSERT INTO [PEO] VALUES('" + addID + "','" + PEOname + "','" + PEOcc + "','" + PEOabout + "','" + PEOimg + "')"); break; case "news": strdelete = string.Format(@"INSERT INTO [news] VALUES('" + addID + "','" + newstitle + "','" + newsbody + "','" + DateTime.Now + "','" + newsathor + "')"); break; case "shop": strdelete = string.Format(@"INSERT INTO [Product] VALUES('" + shopcategoryId + "','" + addID + "','" + shopProductName + "','" + shopPrice + "','" + shopImage + "','" + shopDetail + "')"); break; } OleDbCommand cmd = DB.Get_Delete(strdelete);//执行一个DB类添加数据的方法, return cmd; } 数据处理层 public static OleDbCommand Get_Delete( string strdelete) ... { using (OleDbConnection con = DB.con()) ...{ con.Open(); OleDbCommand cmd = new OleDbCommand(strdelete, con); cmd.ExecuteNonQuery(); return cmd; } } // 取的参数执行数据库 // 此方法功能强大,此系统中的删除/添加/更新都将用到此方法 public static OleDbDataReader Get_Edit( string stredit) ... { OleDbConnection con = DB.con(); con.Open(); OleDbCommand cmd = new OleDbCommand(stredit, con); OleDbDataReader odr = cmd.ExecuteReader(); return odr; }