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

JAVAºÍMYSQL´ïÈËÇë½ø°¡£¬Ð¡µÜÓÃeclipse³öÎÊÌâÁË

СµÜ¸ÕѧjavaÁ¬½ÓÊý¾Ý¿â²¿·Ö£¬Ñ¡ÔñÁËÊìϤµÄMYSQL,´ò¿ªeclipse3.3´óÉñ£¬ÏÂÁËmysql-connector-java-5.1.9-bin.jar£¬°²×°ÁËMYSQL5.1£¬²¢°Ñmysql-connector-java-5.1.9-bin.jar·¾¶¼ÓÈëÁËCLASSPATH£¬ÔÚeclipseÖеÄwindow->preferences->java->installed jars Àï±à¼­Ä¬ÈÏJREÀï¼ÓÈëÁËmysql-connector-java-5.1.9-bin.jarÕâ¸ö°ü£¬È»ºó¿ªÊ¼²âÊÔ´úÂë 

´úÂëÈçÏ£ºimport java.sql.*;
import java.io.*;
import com.mysql.jdbc.Driver;
public class Connect {

public static void main(String[] args) {

try {

Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/test";

Connection conn = DriverManager.getConnection(url, "root","admin");
Statement stat = conn.createStatement();
ResultSet result = stat.executeQuery("SELETE * from GREETINGS");
while(result.next())
System.out.println(result.getString(1));
result.close();

} catch (Exception e) {
System.out.print(e);

}
}
}

×îºóÈ´Å׳öÁ˸ö£ºcom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELETE * from GREETINGS' at line 1
µÄÒì³£ Êý¾Ý¿âÀïȷʵÓжÔÓ¦µÄ±íºÍÊý¾Ý ÉÏÍø²éÁ˺öà×ÊÁ϶¼ËµÊÇSQLÓï¾äд´íÁË£¬µ«


Ïà¹ØÎÊ´ð£º

jspÒ³Ãæ»ñÈ¡sessionµÄÎÊÌâ - Java / Java EE

ÎÒÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......

jsp ÖÐÂÒÂëµÄ - Java / Web ¿ª·¢

ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8 
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
 <form class="form" action=&quo ......

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µÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ