Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

java mysql ºº×Ö´æÈëʱÂÒÂë


´ÓÍøÂçÕª³­µ½µÄ½â¾ö·½·¨——
½â¾ö·½·¨¶þ£º
      Á¬½Ómysqlʱ(ÎÞÂÛÔÚ´Ómysql¶Á»¹ÊÇÈ¡Êý¾ÝµÄÇé¿ö)£¬Ö¸¶¨Ê¹ÓõıàÂ뷽ʽΪutf-8£¬¾ßÌå´úÂëÈçÏÂ
      //×°ÔØmysql-jdbcÇý¶¯
       Class.forName("com.mysql.jdbc.Driver").newInstance();
      //Á¬½ÓÊý¾Ý¿â
      Connection sqlCon = DriverManager.getConnection( "jdbc:mysql://localhost:3306/javatest?user=root&password=admin&useUnicode=true&characterEncoding=utf-8 " );
      ÎÒÊÇÓÃÕâ¸ö·½·¨½â¾öµÄ¡£
ÔÚÅäÖÃÎļþÖиÄΪ
url="jdbc:mysql://127.0.0.1/elearning?useUnicode=true&characterEncoding=utf-8"
³ö´í£¬ºó¸ÄΪurl="jdbc:mysql://127.0.0.1/elearning?useUnicode=true&characterEncoding=utf-8"
³É¹¦


Ïà¹ØÎĵµ£º

Mysql Error #2002: Can't connect to local

ÔÚSentOS 5ÖУº
>>yum install mysql
°²×°Íê±Ïºó£¬
>>mysql
error:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)";
½ñÌì·þÎñÆ÷Óöµ½ÁËÒ»¸öºÜÊìϤµÄÎÊÌâ
ÊäÈë
#mysql -u root -p
 
ERROR 2002 (HY000):Can't connect to local MySQL server
 
  ......

mysql×Ó²éѯ exists,not exists


(1)ʵÏÖÈýá¹û¼¯A-½á¹û¼¯B£º--ÀûÓÃnot
exists£¬ºÏ²¢Ôò¿ÉÓÃunion
exists,not
exists£ºÓÃÓÚÅжÏÇÒ»ñÈ¡½á¹û¼¯AÊÇ·ñ´æÔڵؽá¹û¼¯BÖÐ!
==========½á¹û¼¯A£º
SELECT
d.Device_ID,d.Device_Name,a.App_ID,a.App_Name
               from
T_ ......

MySQL²é¿´ºÍµ¼Èëµ¼³öÃüÁî

1¡¢ÏÔʾÊý¾Ý¿âÁÐ±í£º
   show databases;
   ¸Õ¿ªÊ¼Ê±²ÅÁ½¸öÊý¾Ý¿â£ºmysqlºÍtest¡£mysql¿âºÜÖØÒªËüÀïÃæÓÐMYSQLµÄϵͳÐÅÏ¢£¬ÎÒÃǸÄÃÜÂëºÍÐÂÔöÓû§£¬Êµ¼ÊÉϾÍÊÇÓÃÕâ¸ö¿â½øÐвÙ×÷¡£
2¡¢ÏÔʾ¿âÖеÄÊý¾Ý±í£º
   use mysql£» //´ò¿ª¿â
   show tables;
3¡¢ÏÔʾÊý¾Ý±íµÄ½á¹¹£ ......

ASP.NETÓëMySqlµÄÁ¬½Ó

1.Êý¾ÝÁ¬½Ó·½Ê½
ASP.NET±¾ÉíµÄÊý¾Ý·ÃÎÊADO.NET²»Ö§³Ö¶ÔÓÚMySqlµÄÁ¬½ÓºÍ²éѯ£¬µ«ÊÇMySQL¹ÙÍøÉϾùÌṩÁ˶àÖÖASP.NETÁ¬½Óµ½MySQLµÄ·½Ê½£º
£¨1£©ODBCÇý¶¯µÄ·ÃÎÊ·½Ê½£ºmysql-connector-odbc-5.1.5-win32.msi£¬ODBC
£¨2£©ADO.NET¶ÔÓÚMySQLµÄ·ÃÎÊ·½Ê½£ºmysql-connector-net-6.2.2.zip
¸öÈËÑ¡ÓõÄÊǵڶþÖÖ£¬¸Ð¾õ·½±ã£¬ºÍ.NET¶ÔS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ