前期准备
安装MySql.Data 包
配置外部文件
<connectionStrings>
<add name="connStr"
connectionString="server=localhost;database=mysql_student;uid=root;pwd=123456"
providerName="MySql.Data.MySqlClient"/>
</connectionStrings>
一、MysqlCommand 不带参数
MySqlCommand cmd = connect.CreateCommand();
cmd.CommandText = sql;
cmd.Connection = connect;
internal class Program
{
static void Main(string[] args)
{
//获取外部文件字符串
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (MySqlConnection connect = new MySqlConnection(connStr))
{
connect.Open();
string sql = "show databases;";
//MysqlCommand 命令创建 不带参数
MySqlCommand cmd = connect.CreateCommand();
cmd.CommandText = sql;
cmd.Connection = connect;
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader[0]);
}
reader.Close();
//connect.Close(); //自动关闭
}
Console.WriteLine("Hello World!");
}
}
二、MysqlCommand 带一个参数
MySqlCommand cmd = new MySqlCommand(sql);
cmd.Connection = connect;
internal class Program
{
static void Main(string[] args)
{
//获取外部文件字符串
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (MySqlConnection connect = new MySqlConnection(connStr))
{
connect.Open();
string sql = "show databases;";
//MysqlCommand 命令创建 带一个参数
MySqlCommand cmd = new MySqlCommand(sql);
cmd.Connection = connect;
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader[0]);
}
reader.Close();
//connect.Close(); //自动关闭
}
Console.WriteLine("Hello World!");
}
}
三、MysqlCommand 带两个参数 (推荐)
MySqlCommand cmd = new MySqlCommand(sql, connect);
internal class Program
{
static void Main(string[] args)
{
//获取外部文件字符串
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (MySqlConnection connect = new MySqlConnection(connStr))
{
connect.Open();
string sql = "show databases;";
//MysqlCommand 命令创建 带两个参数 (推荐)
MySqlCommand cmd = new MySqlCommand(sql, connect);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader[0]);
}
reader.Close();
//connect.Close(); //自动关闭
}
Console.WriteLine("Hello World!");
}
}