C# ODBC·ÃÎÊMySQLÊý¾Ý¿â
·Ï»°²»ËµÁË£¬Ö±½Ó½øÈëÖ÷Ì⣬C# ODBC·ÃÎÊMySQLÊý¾Ý¿â£º
1.°²×°Microsoft ODBC.net£ºÎÒ°²×°µÄÊÇmysql-connector-odbc-3.51.22-win32.msi
2.°²×°MDAC 2.7»òÕ߸ü¸ß°æ±¾£ºÎÒ°²×°µÄÊÇmdac_typ.exe 2.7¼òÌåÖÐÎİæ
3.°²×°MySQLµÄODBCÇý¶¯³ÌÐò£ºÎÒ°²×°µÄÊÇ odbc_net.msi
4.¹ÜÀí¹¤¾ß -> Êý¾ÝÔ´ODBC –>ÅäÖÃDSN…
5.½â¾ö·½°¸¹ÜÀíÖÐÌí¼ÓÒýÓà Microsoft.Data.Odbc.dll(1.0.3300)
6.C# ODBC·ÃÎÊMySQLÊý¾Ý¿â´úÂëÖÐÔö¼ÓÒýÓà using Microsoft.Data.Odbc;
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Drawing;
usingSystem.Linq;//vs2005ºÃÏñûÓÐÕâ¸öÃüÃû¿Õ¼ä£¬ÔÚc#2008ϲâÊÔ×Ô¶¯Éú³ÉµÄ
usingSystem.Text;
usingSystem.Windows.Forms;
usingMicrosoft.Data.Odbc;
namespacemysql{
publicpartialclassForm1:Form{
publicForm1(){
InitializeComponent();
}
privatevoidForm1_Load(objectsender,EventArgse){
stringMyConString
=
"DRIVER={MySQLODBC3.51Driver};"
+
"
SERVER
=
localhost
;"+
"
DATABASE
=
inv
;"+
"
UID
=
root
;"+
"
PASSWORD
=
831025
;"+
"
OPTION
=
3
";
OdbcConnectionMyConnection
=
newOdbcConnection
(MyConString);
MyConnection.Open();
Console.WriteLine("\nsuccess,connectedsuccessfully!\n");
stringquery
=
"insertintotestvalues('hello','lucas','liu')"
;
OdbcCommandcmd
=
newOdbcCommand
(query,MyConnection);
//´¦ÀíÒì³££º²åÈëÖØ¸´¼Ç¼ÓÐÒì³£
try{
cmd.ExecuteNonQuery();
}
catch(Exceptionex){
Console.WriteLine("recordduplicate.");
}
finally{
cmd.Dispose();
}
stringtmp1
=
null
;
stringtmp2
=
null
;
stringtmp3
=
null
;
query
=
"select*fromtest"
;
OdbcCommandcmd2
=
newOdbcCommand
(query,MyConnection);
OdbcDataReaderreader
=
cmd
Ïà¹ØÎĵµ£º
GRASPģʽ:General Responsibility Assignment Software Patterns£ºÍ¨ÓÃÔðÈηÖÅäÈí¼þģʽ
ÀïÃæÖØÒªµÄ¸ÅÄîÊÇÔðÈΣ¬ÔðÈÎÊÇÀà¼äµÄÒ»ÖÖºÏÔ¼»òÊÇÒåÎñ£¬¿ÉÒÔϸ·ÖΪÁ½²¿·Ö£¬Óù«Ê½±íʾÈçÏ£º
ÔðÈÎ = ÖªµÀÔðÈÎ + ÐÐΪÔðÈΣ¨ÕâÀïÃæËÆºõ´æÔÚ¸ÅÄîµÄÑ»·¶¨Ò壩
×¢£ºÓÃͨË׵ϰÀ´½²£¬ÔðÈξÍÊÇÒ»¸öÀàÖªµÀÒª×öʲô£¬²¢ÇÒÄܹ»×öʲô¡£
· ......
¹ÜÀí½Úµã:192.168.50.211 Êý¾Ý½Úµã: 192.168.50.214 Êý¾Ý½Úµã: 192.168.50.215 SQL½Úµã: 192.168.50.212 SQL½Úµã: 192.168.50.213 ²Ù×÷ϵͳ:Red Hat Enterprise Linux AS release 5 ------------------------------------------°²×°Ç°±Ø¶Á---------------------------------------- µ±Ç°ÎĵµµÄ°æ±¾Îªmysql-cluster- ......
ϵͳ»·¾³£ºrhel5 (×îС»¯°²×°£¬Ö»°²×°vi¹¤¾ß) Äںˣº2.6.18-8.el5 1¡¢ ÏÂÔØ±àÒë°²×° #cd /usr/local/src/tarbag #wget http://mysql.byungsoo.net/Downloads/MySQL-5.1/mysql-5.1.38.tar.gz //ÏÂÔØ5.1.38 #tar xzvf mysql-5.1.38.tar.gz -C ../software/ #cd ../software/mysql-5.1.38 #./configure --prefix=/usr ......
OracleÓëMySQLÖГ¿É´®Ðл¯”µÄ¶Ô±È²âÊÔ
Thomas Kyte ÔÚ“Oracle 9i&10g±à³ÌÒÕÊõ”Ò»ÊéÖÐΪÁË˵Ã÷ÊÂÎñµÄ¸ôÀë¼¶±ð£¬ÌṩÁËһЩÀý×Ó¡£ÕâÀïÎÒÃÇÀ´¿´¿´“¿É´®Ðл¯”¼¶±ðϵıíÏÖ¡£
ÒÔÆÕͨÓû§µÇ¼ϵͳ£¬²¢´´½¨²âÊÔÓÃµÄ±í¡£
idle> connect scott/tiger
......