数据库:MySQL
框架:控制台console
语言:c#
第一步 连接数据库
mysql,sqlserver的连接语法不同,这里的mysql
MySqlConnection conn = new MySqlConnection("Data Source=localhost;Initial Catalog=test;Persist Security Info=True;User ID=sa;Password=sa;");//创建连接字符串,提供连接数据库的必要信息
MySqlCommand sqlcom = new MySqlCommand();
conn.Open();//连接数据库
sqlcom.Connection = conn;
Console.WriteLine("连接MySQL数据库成功");
第二步 编写mysql语句
sqlcom.CommandText = "select * from ship_followinfo";
MySqlDataReader read = sqlcom.ExecuteReader();
while (read.Read())
{
string a = read.GetValue(0).ToString();
string a1 = read.GetValue(