ÔÚoracleÖÐÓÃjdbcÀ´Á¬½ÓÊý¾Ý¿â£¬ÎªÊ²Ã´ResultsetÀïÃæÇ¶Ì×ResultSet,µ½Ñ»·µÄµÚ¶þ´Î¾Í±¨¿ÕÖ¸Õ룬ÄÄλ֪µÀÊÇÔõô»ØÊÂÂð£¿
´úÂ룺Java code:
while(prors.next()){
System.out.println(prors.getRow());
Date startime = prors.getTime("starttime");
String st = sf.format(startime);
String ft = sf.format(prors.getTime("finishtime"));
int rt = (int) (sf.parse(ft).getTime()-sf.parse(st).getTime())/1000;
int ssid = prors.getInt("seresscriptid"); //ÕÒµ½ÏµÁеÄid
String ssql = "select * from seriescript where id ="+ssid;
ResultSet srs = stmt.executeQuery(ssql);
srs.absolute(1);
System.out.println(srs.getString("name"));//»ñÈ¡½Å±¾ÏµÁеÄÃû×Ö
srs.beforeFirst();
}
±¨´íÈçÏ£º
Java code:
Exception in thread "main" java.lang.NullPointerException
at oracle.jdbc.driver.ScrollableResultSet.cacheRowAt(ScrollableResultSet.java:1588)
at oracle.jdbc.driver.ScrollableResultSet.isValidRow(ScrollableResultSet.java:1571)
at oracle.jdbc.driver.ScrollableResultSet.next(ScrollableResultSet.java:301)
at test.main(test.java:49)
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......