eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:720)
at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5624)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5544)
ÎÒÓÃeclipseÁ¬½ÓmysqlÊý¾Ý¿â
±¾µØÓÐmysqlÊý¾Ý¿â
ÒѾ¼ÓÔØÇý¶¯¡£
´úÂëÈçÏ ºÜ¼òµ¥
package test;
import java.sql.*;
public class Conn {
public static void main(String[] args) {
String username = "root";
String password = "root";
String url = "jdbc:mysql://127.0.0.1:3306/mysql";
try {
String driver = "com.mysql.jdbc.Driver";
Class.forName(driver);
java.sql.Connection cn = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException cnfex) {
System.out.println("×°ÔØJDBC/ODBC Çý¶¯³ÌÐòʧ°Ü");
cnfex.printStackTrace();
} catch (SQLException sqlex) {
System.out.println("ÎÞ·¨Áª½ÓÊý¾Ý¿â");
sqlex.printStackTrace();
} catch (Exception ex) {
System.out.println("NoClassDefException");
ex.printStackTrac
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÏëÎÒjavaÕâÒ»·½Ãæ·¢Õ¹£¬ÓÐÄÄһλ¸ßÊÖ¿ÉÒÔ¸æËßÎÒ£¬Ïë³ÉΪһÃûJAVA±à³Ì¸ßÊÖ£¬Ëû±ØÐëҪѧϰµÄ֪ʶÂ𣿱ÈÈç˵ÎÒѧÍêÁËJAVAµÄ»ù´¡ÖªÊ¶Ö®ºóÎҸðÑÄ¿¹â·ÅÔÚÄÄÒ»·½Ã棬½ÓÏÂÀ´ÎÒÔÚѧϰÓйØJAVAµÄʲô֪ʶ£¿ÅóÓÑà ......
ÎÊÌâÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öÎļþnagiv.jsp ÁíÒ»¸öÎļþfailure.jsp°üº¬Ëû£¬Í¬Ê±nagivÎļþÖÐÓÐÒ»¸ö¿ÉÒÔÌø×ªµ½yy.jspµÄcommandButton£¬µ«ÊÇÎÒ½«failureÖеã»÷nagivÖеÄÄĸöcommandButton£¬Ò²Ãæ²»»áÌø×ª ......
ÎÒÐèÒªÔÚÒ»¸öforÑ»·ÀïÃæÃ¿Ñ»·Ò»´Îºó,ÔÝÍ£nÃëÖÓ,ÔÙÖ´ÐÐÏÂÒ»´ÎÑ»·.ÎÒ²»ÏëÓÃThread.sleep(n);Õâ¸ö·½·¨,ÇëÎÊ»¹ÓÐÆäËûµÄ·½·¨¿ÉÒÔʵÏÖÕâ¸ö¼òµ¥ÒªÇóÂð?Óмòµ¥´úÂë¸üºÃ,лл!
ÆÚ´ýºÃµÄ·½·¨£¡
ÎÒÖªµÀµÄÒ²¾ÍÊÇÕâ¸öÁË
......