.Net连接MySQL 

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Configuration;
 4 using System.Data;
 5 using System.Data.SqlClient;
 6 using System.Linq;
 7 using System.Text;
 8 using System.Threading.Tasks;
 9 using MySql;
10 using MySql.Data;
11 using MySql.Data.MySqlClient;
12 
13 namespace ConsoleApp1
14 {
15     class Hlpe
16     {
17         private static MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
18         //非查询
19         public static int ExecuteNonQuery(string sql, params SqlParameter[] sqlParameter)
20         {
21             try
22             {
23                 conn.Open();
24                 Console.WriteLine("连接成功");
25                 MySqlCommand cmd = conn.CreateCommand();
26                 cmd.CommandText = sql;
27                 cmd.Parameters.AddRange(sqlParameter);
28                 return cmd.ExecuteNonQuery();
29             }
30             catch (Exception ex)
31             {
32                 return -1;
33                 throw;
34             }
35             finally
36             {
37                 conn.Close();
38             }
39         }
40 
41         //查询单值
42         public static Object ExecuteScalar(string sql, params SqlParameter[] sqlParameter)
43         {
44             try
45             {
46                 conn.Open();
47                 MySqlCommand cmd = conn.CreateCommand();
48                 cmd.CommandText = sql;
49                 cmd.Parameters.AddRange(sqlParameter);
50                 return cmd.ExecuteScalar();
51             }
52             catch (Exception ex)
53             {
54                 return null;
55                 throw;
56             }
57             finally
58             {
59                 conn.Close();
60             }
61         }
62 
63         //离线查询
64         public static DataTable ExecuteQuery(string sql, params SqlParameter[] sqlParameter)
65         {
66             try
67             {
68                 conn.Open();
69                 MySqlCommand cmd = conn.CreateCommand();
70                 cmd.CommandText = sql;
71                 cmd.Parameters.AddRange(sqlParameter);
72                 DataSet set = new DataSet();
73                 MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
74                 adapter.Fill(set);
75                 return set.Tables[0];
76             }
77             catch (Exception ex)
78             {
79                 return null;
80                 throw;
81             }
82             finally
83             {
84                 conn.Close();
85             }
86         }
87 
88     }
89 }
在Web.config下</configuration>中添加下列语句
<connectionStrings>
    <add connectionString="Server=127.0.0.1;DataBase=test;Uid=root;Pwd=123" providerName="System.Data.SqlClient" name="conn"/>
  </connectionStrings>

MySql.Data.dll需要引入这个程序集

posted @ 2019-03-01 09:33  SkyWorldTY  阅读(21)  评论(0)    收藏  举报