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
Ïà¹ØÎÊ´ð£º
ÓÃRandomAccessFileдÈëTXTÎļþ²é¿´Ê±ÊÇÂÒÂ룬ÇëÎÊÓÐʲô·½·¨¿ÉÒÔд³É¿É¶ÁµÄÎļþ£¬²»ÊÇÓÃÆäËûµÄÎļþ²Ù×÷£¬¾ÍÊÇÖ»ÓÃRandomAccessFileµÄ·½·¨ÊÇ·ñ¿ÉÒÔʵÏÖ£¿
Java code:
import java.io.*;
public class RandomAcce ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
Ïë×öÒ»¸öjspµÄµç×ÓÉÌÎñÍøÕ¾£¬ÏëÕÒһЩԴ´úÂ룬ÇëÎÊÄǸöÍøÕ¾ÓкõÄ×ÊÔ´¡£Ð»Ð»£¡
ËÑË÷Ï塃 ¿ªÔ´µÄÒ²ÓÐ
csdn¾ÍÓÐÏàËƵÄÔ´Â룬¥Ö÷ËÑÒ»ÏÂ
java ¿ªÔ´´óÈ«
¸ÄÄ£°åºÃÂ鷳Ŷ£¬»¹²»Èç×Ô¼ºÐ´¸öÁËÄØ
jf
¶¥Ò» ......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......