using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Configuration;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
using System.Xml;
using MySql.Data;
/*
* Author: Lee
* Time: 2015-04-08
* Info: 数据库封装操作类
*/
namespace Common
{
public class DbManager
{
//连接用的字符串
private string connStr;
public string ConnStr
{
get { return this.connStr; }
set { this.connStr = value; }
}
private DbManager() { }
//DbManager单实例
private static DbManager _instance = null;
public static DbManager Ins
{
get { if (_instance == null) { _instance = new DbManager(); } return _instance; }
}
///
/// 需要获得多个结果集的时候用该方法,返回DataSet对象。
///
///
///
public DataSet ExecuteDataSet(string sql, params MySqlParameter[] paras)
{
using (MySqlConnection con = new MySqlConnection(ConnStr))
{
//数据适配器
MySq