Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

windows7 and oracleÊý¾Ý¿â


ΪʲôÔÚwindows7ÉÏ×°²»ÉÏoracleÊý¾Ý¿â£¿£¿£¿
ÒòΪ²»Ö§³Ö

¿ÉÒÔ°²×°Êý¾Ý°¡£¬ ÄãÓõÄÄǸö°æ±¾µÄWindows 7°¡£¬Ä¿Ç°7600µÄ¼æÈÝÐÔÓкܴóÌáÉýÁË£¬£¬ÎÒÊÇÓÃSQL Sever 2005£¬¾ÍûÓÐÎÊÌ⣬oracleÓ¦¸ÃÒ²¿ÉÒԵģ¬Èç¹û²» ......

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

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

SQL code:

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

ÕâÎÊÌâÎʵÄ

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