本程序作用是在程序中引入变量和交互,让程序从外部输入读取数据;增加程序安全性;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Data;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string connStr = "server=localhost;user=root;database=world;port=3306;password=1234;";
MySqlConnection conn = new MySqlConnection(connStr);
try
{
Console.WriteLine("Connecting to MySQL...");
conn.Open();
//这里引入了变量;用@表示,在程序的作用是留下一个空,留着后来填;
string sql = "SELECT Name,HeadOfState FROM Country WHERE Continent=@Continent";
MySqlCommand cmd = new MySqlCommand(sql, conn);
Console.WriteLine("Enter a continent e.g. 'North America', 'Europe': ");
string user_input = Console.ReadLine();
//这里是添加变量,给变量赋值;
cmd.Parameters.AddWithValue("@Continent", user_input);
//多行数据读入;
MySqlDataReader rdr = cmd.ExecuteReader();
//这里的Read函数是一行一行的读;其中有自增的,返回的是True或False;
while(rdr.Read())
{
Console.WriteLine(rdr["Name"] + "------" + rdr["HeadOfState"]);
}
rdr.Close(); //这里注意要关闭这个reader;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
conn.Close();
Console.WriteLine("Done.");
Console.ReadKey();
}
}
}
执行结果如下