using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common;
using System.Data;
using System.Windows.Forms;
namespace DBAccess
{
class DBAccess : IDBAccess
{
//根据传入的SQL语句返回一个DataSet
public DataSet GetDataSet(string sql)
{
DataSet productsDataSet = null;
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sql);
productsDataSet = db.ExecuteDataSet(dbCommand);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return productsDataSet;
}
//根据传入的SQL语句返回一个整数结果
public int ExecuteSQL(string sql)
{
int i = 0;
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sql);
i = dbCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return i;
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common;
using System.Data;
using System.Windows.Forms;
namespace DBAccess
{
class DBAccess : IDBAccess
{
//根据传入的SQL语句返回一个DataSet
public DataSet GetDataSet(string sql)
{
DataSet productsDataSet = null;
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sql);
productsDataSet = db.ExecuteDataSet(dbCommand);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return productsDataSet;
}
//根据传入的SQL语句返回一个整数结果
public int ExecuteSQL(string sql)
{
int i = 0;
try
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(sql);
i = dbCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return i;
}
}
}