007-MySqlHelper(MySQL帮助类)

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;

namespace MySQL
{
    public static class SqlHelper
    {
        private static string connStr = "datasource=192.168.0.1;port=3306;Database=mysql;user=username;pwd=123456;charset=utf8;";
        public static DataTable GetTable(string sql, params MySqlParameter[] ps)
        {
            using (MySqlConnection conn = new MySqlConnection(connStr))
            {
                MySqlDataAdapter msda = new MySqlDataAdapter(sql, conn);
                msda.SelectCommand.Parameters.AddRange(ps);
                DataSet ds = new DataSet();
                msda.Fill(ds);
                return ds.Tables[0];
            }
        }
        public static int ExecuteNonQuery(string sql, params MySqlParameter[] ps)
        {
            using (MySqlConnection conn = new MySqlConnection(connStr))
            {
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.Parameters.AddRange(ps);
                conn.Open();
                return cmd.ExecuteNonQuery();
            }
        }
        public static object ExecuteScalar(string sql, MySqlParameter[] ps)
        {
            using (MySqlConnection conn = new MySqlConnection(connStr))
            {
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.Parameters.AddRange(ps);
                conn.Open();
                return cmd.ExecuteScalar();
            }
        }
    }
}