wpf连Mysql

200 阅读 0 评论 132 点赞

我是靠谱客的博主现实水蜜桃，这篇文章主要介绍wpf连Mysql，现在分享给大家，希望可以做个参考。

首先，安装MySql包

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace one.Service
{
    public class Mysql_Server
    {
        public static string connectStr = "datasource=localhost;username=root;password=20021227pp;port=3306;database=c_sharp";
        public static int conect_flag = 0;
        private static MySqlConnection conn = null;

//连接方法
        public static bool Connect_sql()
        {
            using (conn = new MySqlConnection(connectStr))
            {                                            //执行完自动关闭
                try
                {
                    conn.Open();

                    if (conn.State == ConnectionState.Open)
                    {
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                    //MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM c_sharp.watertest", conn)

                }
                catch (Exception ex)
                {
                    return false;
                }
            }
        }

//事务执行
        public static DataSet ExecSqls(string sql)
        {
            var mycom = conn.CreateCommand();
            mycom.CommandText = sql;
            MySqlDataAdapter adap = new MySqlDataAdapter(mycom);
            DataSet ds = new DataSet();
            adap.Fill(ds);
            return ds;
        }

//事务执行
        public static bool ExecSql(string sqlStr, params MySqlParameter[] para)
        {
            using (MySqlConnection conn = new MySqlConnection(connectStr))
            {                                            //执行完自动关闭
                using (MySqlCommand command = new MySqlCommand(sqlStr, conn))
                {
                    try
                    {
                        conn.Open();
                        if (para != null)
                        {
                            foreach (MySqlParameter p in para) //遍历
                            {
                                command.Parameters.AddWithValue(p.ParameterName, p.Value);
                            }
                        }

                        return command.ExecuteNonQuery() > 0;
                    }
                    catch (Exception ex)
                    {
                        return false;
                    }
                }
            }
        }

//查询方法

        public static DataSet ExecSqlquery(string sqlStr, params MySqlParameter[] para)
        {
            using (MySqlConnection conn = new MySqlConnection(connectStr))
            {                                            //执行完自动关闭
                using (MySqlCommand command = new MySqlCommand(sqlStr, conn))
                {
                    DataSet ds = new DataSet();
                    try
                    {
                        conn.Open();
                        if (para != null)
                        {
                            foreach (MySqlParameter p in para) //遍历
                            {
                                command.Parameters.AddWithValue(p.ParameterName, p.Value);
                            }
                        }
                        MySqlDataAdapter adap = new MySqlDataAdapter(command);

                        adap.Fill(ds);
                        return ds;
                        // return command.ExecuteNonQuery() > 0;
                    }
                    catch (Exception ex)
                    {
                        return ds;
                    }
                }
            }
        }
    }
}