1.类似于DBHelper
public class ImportDAL
{
//成员字段
OleDbConnection m_con = null;
public OleDbConnection Connection
{
get { return m_con; }
}
OleDbCommand cmd = null;
OleDbDataAdapter dad = null;
//单例模式
private ImportDAL(string filepath)
{
//连接每个方法都要用。先实例化
string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + filepath + "';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
m_con = new OleDbConnection(SourceConstr);
}
private static ImportDAL selfObj;
public static ImportDAL GetInstance(string filepath)
{
if