如何将数据库连接串封装成类？

[jqryga1221]

RT

[fphuang]

using System;
using System.Collections;
using System.Data;
using System.Data.OleDb;

namespace issuebase
{/// <summary>
/// Db_Conn 的摘要说明。
/// OLE Db数据库相关操作
/// 最后修改日期：2005-03-03
/// 类库相关版本：Version 0.1
/// </summary>
public class Db_Conn
{
public OleDbConnection Conn;
//public DataSet myDataSet;
public Db_Conn()
{
Conn = new OleDbConnection();
//myDataSet = new DataSet ();
}
private string GetConnStr()
{
string strConnection = "";
string dbname = ".\\数据库路径\\数据库文件（*.mdb）";
strConnection = @"Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " + System.Web.HttpContext.Current.Server.MapPath (dbname) + ";";
return strConnection;
}

public void Conn_Open()
{
string ConnStr = GetConnStr();
Conn.ConnectionString = ConnStr;
Conn.Open();
}
public void Conn_Close()
{
if(Conn != null)
Conn.Close();
}
}
}

[teacher1998]

public class DataBasseDB
{
public static string ConnectionString=ConfigurationSettings.Appsetting["SQLCONN"];
}

[renyu732]

you can write it in web.config
<appSettings>
<add key="Conn" value="Server=localhost;uid=sa;pwd=;database=database" />
</appSettings>

.vb

Dim conn as new sqlconnection(ConfigurationSettings.AppSettings("Conn"))

[zeusvenus]

看看大家有多少种方法,mark

[luck0235]

using System;
using System.Web;
using System.Data;
using System.Data.OleDb;

namespace jssl
{
public class Conn
{
public Conn()
{
connstr=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+HttpContext.Current.Server.MapPath("~/xx/xx/xx.mdb");
}
private string connstr;
private OleDbConnection conn;
public OleDbConnection GetConnection()
{
if(conn==null)
{
conn=new OleDbConnection(connstr);
return conn;
}
else
return conn;
}

public void open()
{
if (conn==null)
{
conn=new OleDbConnection(connstr);
conn.Open();
}
else
{
conn.Open();
}
}

public void close()
{
if (conn!=null)
{
conn.Close();
}
}
}
}

[junglewhut]

teacher1998() 的做法好一些，将数据库连接字符串写在web.config中，如果写在类中，每次修改连接字符串都要重新编译那个类，很不方便

[upshania]

你可以动态的转入一些参数来达到这个类的使用目的。。。

比如SQL 你知道要填的项有 user pass ip 等