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
Ïà¹ØÎÊ´ð£º
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
ÄÇλ´óÏÀÄܸøÎÒÒ»¸öJavaͨÓõķÖÒ³¿Ø¼þ£¬ÎÒ½«·Ç³£¸Ð¼¤¡£
ÆäÖÐ×îºÃÄܰüº¬SQL Server2000£¬SQL Server2005£¬Oracle¡¢MySqlµÈºÜ³£ÓõÄһЩÊý¾Ý¿â·ÖҳʵÏÖ¡£
×îºÃÄܼÓÉÏһЩʵÀý£¬±ãÓÚÎÒʹÓá£
ÎÒµÄÓÊÏäÊÇgaolihua889 ......
ÔõôÔÚ¿ØÖÆÌ¨ÖÐÊäÈëÀàËÆÏÂÃæµÄÐÅÏ¢£º
s1234 50
s1235 80
s1234 90
s1234 40
s1236 90
ÿµ±»Ø³µÊ± ......