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

ÔõôÁ¬½ÓÊý¾Ý¿â°¡£¿mysqlµÄ

ÎÒÊÇÕâô²Ù×÷µÄ£¬ÎÒÒ²²»ÖªµÀ¶Ô²»¶Ô.ÐÂÊÖ£¬¸Õ¿ªÊ¼ÅªÊý¾Ý¿â¡£
ÔÚϵͳÖÐÔö¼Óclasspath »·¾³±äÁ¿£¬°ÑD:\driver\mysql-connector-java-5.0.8-bin.jarд½øÈ¥
È»ºóµ÷ÓÃClass.forName("com.mysql.jdbc.Driver");
¾ÍÔÚÕâÀï³ö´íÁË¡£¡£¡£
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at test.main(test.java:11)
Çý¶¯°ü·ÅÔÚÕâÀïÊÔÊÔ£ºjdk1.6.0_06\jre\lib\ext\mysql-connector-java-5.0.8-bin.jar

¾ÍÊÇÓÃmysql¿ÉÒÔ²»¸Ä»·¾³±äÁ¿µÄÊ×ÏÈÄãÒªÓÐmysqlµÄÇý¶¯°ü ¾ÍÏóһ¥˵µÄÄÇÑù È»ºóÔÚÁ¬½ÓÊý¾Ý¿âʱ¾Í°ÑÁ¬½ÓдÉϾÍÐÐÁË

ÒýÓÃ
Çý¶¯°ü·ÅÔÚÕâÀïÊÔÊÔ£ºjdk1.6.0_06\jre\lib\ext\mysql-connector-java-5.0.8-bin.jar


·Å½øÈ¥ÁË£¬»¹ÊDz»ÐÐ

»¹ÓÐÕâÀïÂjre1.6.0_06\lib\ext

²»ÖªµÀÄãÊÇÔÚÄÄÀï²Ù×÷µÄ£¬Èç¹ûÊÇÔÚTomcatÀïÃæ²Ù×÷µÄ»°£¬ÇëÈ·ÈÏ£¬½«Çý¶¯°ü·ÅÔÚÁËWeb-inf/libĿ¼Ï¡££¨Ò²¿ÉÒÔ·ÅÔÚTomcatµÄlibĿ¼Ï£©
ÎÒ¸Õ¿ªÊ¼ÅäÕâ¸ö¶«Î÷£¬±àÒëÔç³É¹¦ÁË£¬¾ÍÁ¬²»ÉÏ£¬¸ãÁ˽ӽü


Ïà¹ØÎÊ´ð£º

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

mysql ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......

mysqlÉÏÏÞÎÊÌâ

  ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ