本文为【连接MYSQL数据库的方法及示例】的汉字拼音对照版显示拼音
连lian接jiemysql数shu据ju库ku的de方fang法fa及ji示shi例li
方fang法fa一yi:
使shi用yongMYSQL推tui出chu的deMySQL Connector/Net is an ADO.NET driver for MySQL
该gai组zu件jian为weiMYSQL为weiADO.NET访fang问wenMYSQL数shu据ju库ku设she计ji的de.NET访fang问wen组zu件jian。
安an装zhuang完wan成cheng该gai组zu件jian后hou,引yin用yong命ming名ming空kong间jianMySql.Data.MySqlClient;
使shi用yong命ming令ling行xing编bian译yi时shi:csc /r:MySql.Data.dll test.cs
方fang法fa二er:
通tong过guoODBC访fang问wenMYSQL数shu据ju库ku
访fang问wen前qian要yao先xian下xia载zai两liang个ge组zu件jian:odbc.net和heMYSQL的deODBC驱qu动dong(MySQL Connector/ODBC (MyODBC) driver)目mu前qian为wei3.51版ban
安an装zhuang完wan成cheng后hou,即ji可ke通tong过guoODBC访fang问wenMYSQL数shu据ju库ku
方fang法fa三san:
使shi用yongCoreLab推tui出chu的deMYSQL访fang问wen组zu件jian,面mian向xiang.NET
安an装zhuang完wan成cheng后hou,引yin用yong命ming名ming空kong间jian:CoreLab.MySql;
使shi用yong命ming令ling编bian译yi时shi:csc /r:CoreLab.MySql.dll test.cs以yi下xia为wei访fang问wenMYSQL数shu据ju库ku实shi例li编bian译yi指zhi令ling:csc /r:CoreLab.MySql.dll /r:MySql.Data.dll test.csusing System;
using System.Net;
using System.Text;
using CoreLab.MySql;
using System.Data.Odbc;
using MySql.Data.MySqlClient;class ConnectMySql
{
public void Connect_CoreLab()
{
string constr = "User Id=root;Host=localhost;Database=qing;passWord=qing";
MySqlConnection mycn = new MySqlConnection(constr);
mycn.Open();
MySqlCommand mycm = new MySqlCommand("select * from shop",mycn);
MySqlDataReader msdr = mycm.ExecuteReader();
while(msdr.Read())
{
if (msdr.HasRows)
{
Console.WriteLine(msdr.GetString(0));
}
}
msdr.Close();
mycn.Close();
}
public void Connect_Odbc()
{
//string MyConString ="DSN=MySQL;UID=root;PWD=qing";
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=localhost;" +
"DATABASE=test;" +
"UID=root;" +
"PASSWORD=qing;" +
"OPTION=3";
OdbcConnection MyConn = new OdbcConnection(MyConString);
MyConn.Open();
OdbcCommand mycm = new OdbcCommand("select * from hello",MyConn);
OdbcDataReader msdr = mycm.ExecuteReader();
while(msdr.Read())
{
if (msdr.HasRows)
{
Console.WriteLine(msdr.GetString(0));
}
}
msdr.Close();
MyConn.Close();
}
public void Connect_Net()
{
string myConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=qing";
MySqlConnection mycn = new MySqlConnection(myConnectionString);
mycn.Open();
MySqlCommand mycm = new MySqlCommand("select * from hello",mycn);
MySqlDataReader msdr = mycm.ExecuteReader();
while(msdr.Read())
{
if (msdr.HasRows)
{
Console.WriteLine(msdr.GetString(0));
}
}
msdr.Close();
mycn.Close();
}
public static void Main()
{
ConnectMySql ms = new ConnectMySql();
ms.Connect_CoreLab();
ms.Connect_Odbc();
Connect_Net();
}
}
【原文】