Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleÖÐresultset´íÎó

ÔÚ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)



Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

Oracle 9i Ò»¶Ô¶àµÄ¹ØÏµ²éѯ

Ò»¶Ô¶à¹ØÏµ²éѯ

±í:
ea,eb,ga,gb
±í¹ØÏµÈçÏÂ
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33


ÊÂÀýÊý¾Ý¼°¹ØÏµÈçÏÂ:
SQL code:

SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (S ......

oracleÀïд¸ö´æ´¢¹ý³ÌÑ­»·²åÈë10ÍòÌõ¼Ç¼

¸ßÊÖ¸ø¸ö´æ´¢¹ý³Ì£¬ÄÜÑ­»·²åÈë10ÍòÌõ¼Ç¼£»ÔÚÏߵȡ£¡£¡£
Ñ­»·²åÈë10ÍòÌõ¼Ç¼£¿ÄܾßÌåµãÂð
ûÃ÷°×

SQL code:

--Á½±íÈç¹ûÒ»ÖÂʱ£º
insert into tableA as select * from tableB;

ÕâÎÊÌâÎʵÄ

ÎÞÃûÀÏ× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ