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
Ïà¹ØÎÊ´ð£º
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÄÇλ´óÏÀÄܸøÎÒÒ»¸öJavaͨÓõķÖÒ³¿Ø¼þ£¬ÎÒ½«·Ç³£¸Ð¼¤¡£
ÆäÖÐ×îºÃÄܰüº¬SQL Server2000£¬SQL Server2005£¬Oracle¡¢MySqlµÈºÜ³£ÓõÄһЩÊý¾Ý¿â·ÖҳʵÏÖ¡£
×îºÃÄܼÓÉÏһЩʵÀý£¬±ãÓÚÎÒʹÓá£
ÎÒµÄÓÊÏäÊÇgaolihua889 ......