.net三层

webconfig连接路径

 

<connectionStrings>
  <add name="ConnString" connectionString="/Web_HL/App_Data/M_db.mdb"/>
 </connectionStrings>

---------------------------------------------------------------------------------------------------------------------

DataBase.cs 类连接路径

 

using System;
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.OleDb;

/// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase
{
 public DataBase()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    private OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString));

    public OleDbConnection MyConn
    {
        get { return conn; }
     
      
    }
}

--------------------------------------------------------------------------------------------------------------------

 

 

 

DataCom.cs累方法 执行增，删，改

 

 

 

using System;
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.OleDb;

/// <summary>
/// DataCom 的摘要说明
/// </summary>
public class DataCom:DataBase
{
 public DataCom()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    public DataTable ExeDT(OleDbCommand cmd) {
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        return dt;
    }
    public DataSet ExeDST(OleDbCommand cmd)
    {
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        DataSet dt = new DataSet();
        da.Fill(dt);
        return dt;
    }
    public int ExeNo(OleDbCommand cmd) {
        MyConn.Open();
        int i = cmd.ExecuteNonQuery();
        MyConn.Close();
        return i;
    }
    public int ExeScr(OleDbCommand cmd)
    {
       
        cmd.Connection = MyConn;
        MyConn.Open();
        int i = Convert.ToInt32(cmd.ExecuteScalar());
        MyConn.Close();
        return i;

    }
}

 

---------------------------------------------------------------------------------------------------------------

 

User_table.cs 累  写方法

 

 

 

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.OleDb;

/// <summary>
///User_table 的摘要说明
/// </summary>
public class User_table:DataCom
{
 public User_table()
 {
  //
  //TODO: 在此处添加构造函数逻辑
  //
 }
    public DataTable List(string U_name, string U_pwd) {
        string strsql = "select * from User_table where U_name =@U_name and U_pwd=@U_pwd";
        OleDbCommand cmd = new OleDbCommand(strsql, MyConn);
        cmd.Parameters.Add("@U_name", OleDbType.VarChar).Value = U_name;
        cmd.Parameters.Add("@U_pwd", OleDbType.VarChar).Value = U_pwd;
        return ExeDT(cmd);
    }
    public DataTable List() {
        string strsql = "select * from User_table";
        OleDbCommand cmd = new OleDbCommand(strsql, MyConn);
        return ExeDT(cmd);
    }
    public int Up(string U_name, string U_pwd, int id) {
        string strsql = "update User_table set U_name=@U_name,U_pwd=@U_pwd where id =@id";
        OleDbCommand cmd = new OleDbCommand(strsql, MyConn);
        cmd.Parameters.Add("@U_name", OleDbType.VarChar).Value = U_name;
        cmd.Parameters.Add("@U_pwd", OleDbType.VarChar).Value = U_pwd;
        cmd.Parameters.Add("@id", OleDbType.Integer).Value = id;
        return ExeNo(cmd);
    }
    public int Del(int id) {
        string strsql = "delete from User_table where id =@id";
        OleDbCommand cmd = new OleDbCommand(strsql, MyConn);
        cmd.Parameters.Add("@id", OleDbType.Integer).Value = id;
        return ExeNo(cmd);

    }
    public int Add(string U_name, string U_pwd) {
        string strsql = "insert into User_table(U_name,U_pwd)values(@U_name,@U_pwd)";
        OleDbCommand cmd = new OleDbCommand(strsql, MyConn);
        cmd.Parameters.Add("@U_name", OleDbType.VarChar).Value = U_name;
        cmd.Parameters.Add("@U_pwd", OleDbType.VarChar).Value = U_pwd;
        return ExeNo(cmd);
    }
}