public class OleConn
{
private static OleDbConnection conn;
private OleConn()
{
}
public static OleDbConnection getConn()
{
string db = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
string str = @"E:\C#\addressBook\addressBook\DataBase\MyBook.mdb";
conn = new OleDbConnection(db+str);
return conn;
}
}
这样的单例oleconn 连接类
//执行sql 带参数的数组
public static bool ExecSQLParamters(OleDbParameter[] par, string sql)
{
try
{
using (OleDbCommand comm = new OleDbCommand(sql, OleConn.getConn()))
{
foreach (OleDbParameter pars in par)
{
comm.Parameters.Add(pars);
}
OleConn.getConn().Open();
comm.ExecuteNonQuery();
return true;
}
}
catch
{
