.net三层

来源：互联网发布：天正软件那里有卖编辑：程序博客网时间：2024/05/16 15:42

webconfig连接路径

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

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累方法执行增，删，改

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