using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
namespace mysql1
{
class Program
{
static void Main(string[] args)
{
// 连接数据库
string connectStr = "server = 127.0.0.1; port = 3306; user = root; password = root1;database = mysql; SslMode = none;";
MySqlConnection conn = new MySqlConnection(connectStr);
try
{
conn.Open();
Console.WriteLine("已建立连接");
}
catch(MySqlException e)
{
Console.WriteLine(e.ToString());
}
// 查询数据库
string sql = "select * from help_category ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
Console.WriteLine(reader.GetInt32("help_category_id")+ "\t" + reader.GetString("name") + "\t"
+ "\t" + reader.GetInt32("parent_category_id"));//"userid"是数据库对应的列名,推荐这种方式
}
reader.Close();
Console.WriteLine("\n");
// 查询条件不固定
string sql1 = "select * from help_category " +
"where help_category_id =@para";
cmd.CommandText = sql1;
cmd.Parameters.AddWithValue("para", 3);
MySqlDataReader reader1 = cmd.ExecuteReader();
while (reader1.Read())
{
Console.WriteLine(reader1.GetInt32("help_category_id") + "\t" + reader1.GetString("name") + "\t"
+ "\t" + reader1.GetInt32("parent_category_id"));//"userid"是数据库对应的列名,推荐这种方式
}
reader1.Close();
// 增加记录
// string addStr = "insert into help_category(help_category_id, name, parent_category_id)" +
// "values(43, 'zhange', 50)";
//
// cmd.CommandText = addStr;
// int result = cmd.ExecuteNonQuery();
// Console.WriteLine(result);
// 删除记录
// string delete = "delete from help_category where help_category_id = 42";
//
// cmd.CommandText = delete;
// int result1 = cmd.ExecuteNonQuery();
// Console.WriteLine(result1);
string update = "update help_category set name = 'wangyao' where help_category_id = 43";
cmd.CommandText = update;
int result2 = cmd.ExecuteNonQuery();
Console.WriteLine(result2);
}
}
}