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,±¾Ò³Ã滹¿ÉÒÔÈ¡³öÖµÀ´.
µ«ÊÇһˢÐÂ,»òÕß´ò¿ªÐµÄÒ³Ãæ¾ÍÈ¡²»³öÖµÀ´ÁË.
Ææ¹ÖµÄÊÇ,ÎÒ²âÊÔÁíÒ»¸ö³ÌÐòʱºò
ÔÚjspÒ³Ãæ´æÉÏÒ»¸ösession,±¾Ò³Ãæ¿ÉÒÔÈ¡³öÖµÀ´,ˢлò´ò¿ªÐÂÒ³ÃæÖµÄÜÈ¡³öÀ´ÁË.
......
ÎҵĿª·¢µÄƽ̨ÊÇMyeclipes6.0 + tomcat5.x + mysql
ÎÒËùÓеıàÂ뷽ʽ¶¼ÊÇÓõÄUTF-8
ÎÒÖ»ÓÃÁËStrtus¿ò¼Ü
ÔÚÒ»¸öformÖÐÈçÏÂÓõÄÊÇpostµÄÌá½»·½Ê½£º
<form class="form" action=&quo ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó 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 ......