mysql封装类c#_C# Mysql封装操作类

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