首先,安装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;
}
}
}
}
}
}