C#学习笔记----C#连接MySQL数据库
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace ConnectMySQL
{
internal class Program
{
static void Main(string[] args)
{
Console.WriteLine("输入学号:");
SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
scsb.DataSource = "127.0.0.1";
scsb.UserID = "bigEric";
scsb.Password = "123456";
scsb.InitialCatalog = "table1";
SqlConnection sqlCon = new SqlConnection(scsb.ToString());
if (sqlCon.State==ConnectionState.Closed)
{
sqlCon.Open();
}
string stu_no = Console.ReadLine();
string sqlStr = "SELECT * FROM students WHERE 学号= '" + stu_no + "'";
SqlCommand sqlCommand =new SqlCommand(sqlStr,sqlCon);
SqlDataReader sdr = null;
try
{
sdr = sqlCommand.ExecuteReader();
while (sdr.Read())
{
Console.WriteLine("姓名:" + sdr["姓名"].ToString());
Console.WriteLine("班级:" + sdr["班级"].ToString());
Console.WriteLine("性别:" + sdr["性别"].ToString());
Console.WriteLine("年龄:" + sdr["年龄"].ToString());
Console.WriteLine("----------------");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
finally
{
sqlCon.Close();
}
}
}
}