public class DataBase
{
public OleDbConnection dataConnection = new OleDbConnection();
public OleDbDataAdapter dataAdapter;
public DataSet dataSet = new DataSet();
public OleDbCommand command;
string connstr = @"Provider=Microsoft.ACE.Oledb.12.0;" + @"Data Source=..\dormMIS.mdb";
public DataSet GetDataFromDB(string sqlStr)//公共查询方法
{
try
{
dataConnection.ConnectionString = connstr;
dataAdapter = new OleDbDataAdapter(sqlStr, dataConnection);
dataSet.Clear();
dataAdapter.Fill(dataSet);
dataConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dataConnection.Close();
}
if (dataSet.Tables[0].Rows.Count != 0)
{
return dataSet;
}
else
{
return null;
}
}
public bool UpdataDB(string sqlStr)//公共数据操作方法UpdataDB成功返回TRUE,否则返回FALSE;
{
try
{
dataConnection.ConnectionString = connstr;
dataConnection.Open();
command = dataConnection.CreateCommand();
command.CommandText = sqlStr;
command.ExecuteNonQuery();
dataConnection.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
}
{
public OleDbConnection dataConnection = new OleDbConnection();
public OleDbDataAdapter dataAdapter;
public DataSet dataSet = new DataSet();
public OleDbCommand command;
string connstr = @"Provider=Microsoft.ACE.Oledb.12.0;" + @"Data Source=..\dormMIS.mdb";
public DataSet GetDataFromDB(string sqlStr)//公共查询方法
{
try
{
dataConnection.ConnectionString = connstr;
dataAdapter = new OleDbDataAdapter(sqlStr, dataConnection);
dataSet.Clear();
dataAdapter.Fill(dataSet);
dataConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
dataConnection.Close();
}
if (dataSet.Tables[0].Rows.Count != 0)
{
return dataSet;
}
else
{
return null;
}
}
public bool UpdataDB(string sqlStr)//公共数据操作方法UpdataDB成功返回TRUE,否则返回FALSE;
{
try
{
dataConnection.ConnectionString = connstr;
dataConnection.Open();
command = dataConnection.CreateCommand();
command.CommandText = sqlStr;
command.ExecuteNonQuery();
dataConnection.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
}