using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
namespace liajie
{
internal class MysqlConnection
{
public static object MysqlConnect(string sql, params MySqlParameter[] paras)
{
//mysql连接字符串
string conn = "server=127.0.0.1;port=3306;user=root;password=123456;database=ssm";
//连接mysql对象
MySqlConnection connection = new MySqlConnection(conn);
//查询操作
//string sel = "select * from user";
MySqlCommand cmd = new MySqlCommand(sql, connection);
if (paras != null)
{
cmd.Parameters.Clear();
cmd.Parameters.AddRange(paras);
}
//创建mysql命令对象
connection.Open();
object reader = cmd.ExecuteScalar();
return reader;
cmd.Dispose();
connection.Close();
}
public static DataTable MysqlConnectBySql(string sql, params MySqlParameter[] paras)
{
DataTable dt = new DataTable();
string conn = "server=127.0.0.1;port=3306;user=root;password=123456;database=ssm";
//连接mysql对象
MySqlConnection connection = new MySqlConnection(conn);
//查询操作
//string sel = "select * from user";
MySqlCommand cmd = new MySqlCommand(sql, connection);
if (paras != null)
{
cmd.Parameters.Clear();
cmd.Parameters.AddRange(paras);
}
//创建mysql命令对象
connection.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.SelectCommand = cmd;
adapter.Fill(dt);
return dt;
cmd.Dispose();
connection.Close();
}
}
}