大家好,又见面了,我是你们的朋友全栈君。
class Program
{
static void Main(string[] args)
{
//连接数据库
using( MySqlConnection conn = new MySqlConnection("Server=localhost; Database=study; uid=root; pwd=root; Charset=utf8;") )
//创建数据库对象
using (MySqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM t_customers";
using (MySqlDataReader read = cmd.ExecuteReader())
{
while (read.Read())//读取每行数据
{
//获取字段信息
int id = read.GetInt32("Id");
string name = read.GetString("Name");
string age = read.GetString("Age");
Console.WriteLine(id + name + age);
}
}
}
Console.ReadKey();
}
}
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/151487.html原文链接:https://javaforall.cn