java JDBC ResultSetÏê½â(javaÊý¾Ý¿â²Ù×÷)
	
    
    
	ÕâÆªÎÄÕ²¢Ã»Óиø³öÈçºÎʹÓÃResultSetµÄ¾ßÌåÀý×Ó£¬Ö»ÊÇ´ÓResultSetµÄ¹¦ÄÜÐÔÉϽøÐÐÁËÏêϸµÄ½²Êö¡£Ï£ÍûÕâÆªÎÄÕ¶Դó¼ÒÀí½âResultSetÄܹ»ÓÐËù°ïÖú¡£ÏÂÃæ¾ÍÊÇÕâÆªÎÄÕµľßÌåÄÚÈÝ¡£ 
½á¹û¼¯(ResultSet)ÊÇÊý¾ÝÖвéѯ½á¹û·µ»ØµÄÒ»ÖÖ¶ÔÏ󣬿ÉÒÔ˵½á¹û¼¯ÊÇÒ»¸ö´æ´¢²éѯ½á¹ûµÄ¶ÔÏ󣬵«Êǽá¹û¼¯²¢²»½ö½ö¾ßÓд洢µÄ¹¦ÄÜ£¬Ëûͬʱ»¹¾ßÓвÙ×ÝÊý¾ÝµÄ¹¦ÄÜ£¬¿ÉÄÜÍê³É¶ÔÊý¾ÝµÄ¸üеȡ£ 
½á¹û¼¯¶ÁÈ¡Êý¾ÝµÄ·½·¨Ö÷ÒªÊÇgetXXX()£¬ËûµÄ²ÎÊý¿ÉÒÔʹÕûÐͱíʾµÚ¼¸ÁУ¨ÊÇ´Ó1¿ªÊ¼µÄ£©£¬»¹¿ÉÒÔÊÇÁÐÃû¡£·µ»ØµÄÊǶÔÓ¦µÄXXXÀàÐ͵ÄÖµ¡£Èç¹û¶ÔÓ¦ÄÇÁÐʱ¿ÕÖµ£¬XXXÊǶÔÏóµÄ»°·µ»ØXXXÐ͵ĿÕÖµ£¬Èç¹ûXXXÊÇÊý×ÖÀàÐÍ£¬ÈçFloatµÈÔò·µ»Ø0£¬boolean·µ»Øfalse¡£Ê¹ÓÃgetString()¿ÉÒÔ·µ»ØËùÓеÄÁеÄÖµ£¬²»¹ý·µ»ØµÄ¶¼ÊÇ×Ö·û´®ÀàÐ͵ġ£XXX¿ÉÒÔ´ú±íµÄÀàÐÍÓУº»ù±¾µÄÊý¾ÝÀàÐÍÈçÕûÐÍ(int)£¬²¼¶ûÐÍ(Boolean)£¬¸¡µãÐÍ(Float,Double)µÈ£¬±ÈÌØÐÍ£¨byte£©£¬»¹°üÀ¨Ò»Ð©ÌØÊâµÄÀàÐÍ£¬È磺ÈÕÆÚÀàÐÍ£¨java.sql.Date£©£¬Ê±¼äÀàÐÍ(java.sql.Time)£¬Ê±¼ä´ÁÀàÐÍ(java.sql.Timestamp)£¬´óÊýÐÍ(BigDecimalºÍBigIntegerµÈ)µÈ¡£»¹¿ÉÒÔʹÓÃgetArray(int colindex/String columnname)£¬Í¨¹ýÕâ¸ö·½·¨»ñµÃµ±Ç°ÐÐÖУ¬colindexËùÔÚÁеÄÔªËØ×é³ÉµÄ¶ÔÏóµÄÊý×顣ʹÓÃgetAsciiStream(int colindex/String colname)¿ÉÒÔ»ñµÃ¸ÃÁжÔÓ¦µÄµ±Ç°ÐеÄasciiÁ÷¡£Ò²¾ÍÊÇ˵ËùÓеÄgetXXX·½·¨¶¼ÊǶԵ±Ç°ÐнøÐвÙ×÷¡£ 
½á¹û¼¯´ÓÆäʹÓõÄÌØµãÉÏ¿ÉÒÔ·ÖΪËÄÀ࣬ÕâËÄÀàµÄ½á¹û¼¯µÄËù¾ß±¸µÄÌØµã¶¼ÊǺÍStatementÓï¾äµÄ´´½¨Óйأ¬ÒòΪ½á¹û¼¯ÊÇͨ¹ýStatementÓï¾äÖ´Ðкó²úÉúµÄ£¬ËùÒÔ¿ÉÒÔ˵£¬½á¹û¼¯¾ß±¸ºÎÖÖÌØµã£¬ÍêÈ«¾ö¶¨ÓÚStatement£¬µ±È»ÎÒÊÇ˵ÏÂÃæÒª½«µÄËĸöÌØµã£¬ÔÚStatement´´½¨Ê±°üÀ¨ÈýÖÖÀàÐÍ¡£Ê×ÏÈÊÇÎÞ²ÎÊýÀàÐ͵ģ¬Ëû¶ÔÓ¦µÄ¾ÍÊÇÏÂÃæÒª½éÉܵĻù±¾µÄResultSet¶ÔÓ¦µÄStatement¡£ÏÂÃæµÄ´úÂëÖÐÓõ½µÄConnection²¢Ã»ÓÐ¶ÔÆä³õʼ»¯£¬±äÁ¿conn´ú±íµÄ¾ÍÊÇConnection¶ÔÓ¦µÄ¶ÔÏó¡£SqlStr´ú±íµÄÊÇÏìÓ¦µÄSQLÓï¾ä¡£ 
1.×î»ù±¾µÄResultSet¡£ 
Ö®ËùÒÔ˵ÊÇ×î»ù±¾µÄResultSetÊÇÒòΪ£¬Õâ¸öResultSetËûÆðµ½µÄ×÷ÓþÍÊÇÍê³ÉÁ˲éѯ½á¹ûµÄ´æ´¢¹¦ÄÜ£¬¶øÇÒÖ»ÄܶÁÈ¥Ò»´Î£¬²»Äܹ»À´»ØµÄ¹ö¶¯¶ÁÈ¡¡£ÕâÖÖ½á¹û¼¯µÄ´´½¨·½Ê½ÈçÏ£º
Statement st = conn.CreateStatement
ResultSet rs = Statement.excuteQuery(sqlStr); 
ÓÉÓÚÕâÖÖ½á¹û¼¯²»Ö§³Ö£¬¹ö¶¯µÄ¶ÁÈ¥¹¦ÄÜËùÒÔ£¬Èç¹û»ñµÃÕâÑùÒ»¸ö½á¹û¼¯£¬Ö»ÄÜʹÓÃËüÀïÃæµÄnext()·½·¨£¬Öð¸öµÄ¶ÁÈ¥Êý¾Ý¡£ 
2.¿É¹ö¶¯µÄResultSetÀàÐÍ¡£
Õâ¸öÀàÐÍÖ§³Öǰº
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    Ôڳɹ¦ÊµÏÖJavaµ÷ÓÃC++Ö®ºó£¬½ÓÏÂÀ´Ïëµ½ÄÜ·ñͨ¹ýJNAʵÏÖJavaµ÷ÓÃFortran£¬½ñÌìÊÔÑéÁËһϣ¬»¹ÊDZȽÏÈÝÒ׵ġ£
ÍøÉÏÓÐÒ»¸öJavaµ÷ÓÃF95µÄÀý×Ó£¬µ«ÊÇÎÒ¿¼ÂDz»½öҪʵÏÖF95µÄµ÷Ó㬻¹ÒªÊµÏÖF77µÄµ÷Óã¬ËùÒÔ·ÑÁËһЩÖÜÕÛ¡£
ÎÊÌâµÄ¹Ø¼üÔÚÓÚF77Ϊ¹ý³ÌÃû×Ô¶¯Ìí¼ÓÁËÒ»¸öβ²¿µÄÏ»®Ïߣ¬ËùÒÔsub1Õâ¸ö¹ý³Ì£¬µ½JavaÒ»¶Ë£¬¾Í±ä³ÉÁËsub1_£¬ ......
	
    
        
    
    
×î½ü¹«Ë¾Åöµ½ÐèÒªÓÃͼ±íµÄÐÎʽÏÔʾһЩÊý¾Ý£¬ÎҾͿªÊ¼µ½ÍøÉϲéѯ£¬²éµ½ÁËjfreechartºÍamcharts,ÕâÁ½ÕßÎÒ¶¼ÊµÏÖ¹ýÁË£¬jfreechart×îºóÉú³ÉͼƬ£¬µ«ÊÇͼƬЧ¹û²»ÊÇÎÒÏëÒªµÄ£¬È»ºóÓÖÑо¿amcharts ËüµÄЧ¹ûȷʵºÜºÃ£¬¶øÇÒ¹Ù·½ÍøÕ¾ÉÏ»¹ÓкÃЩÀý×ӿɹ©ÏÂÔØ£¬ÍøÖ·ÊÇ:www.amcharts.com
£¨ÏëÒªÍê³ÉÒ»¸öamchartsͼÐÎÐèÒªswfobjects. ......
	
    
        
    
    
package¡¢import 
µÄÏà¹ØÎÊÌâÊÇjavaÖеÄÒ»¸ö²»´ó²»Ð¡µÄÎÊÌ⣬µ«classpathÎÊÌâÈ´ÊÇjavaµÄÒ»¸öÖøÃûµÄÄÑÌâ¡£½ñÍíµÃÏÐÑо¿ÁËһϣ¬ÔÚÕâÀォÎÒµÄÑо¿³É¹û¸ú¸÷λ
ÅóÓÑ·ÖÏíһϡ£ÓÉÓÚͬ°üµÄÇé¿öºÜ¼òµ¥£¬ËùÒÔÕâÀï¾Í²»ÌÖÂÛͬ°üÇé¿ö£¬Ö»ÌÖÂÛ²»Í¬°üºÍ²»Í¬Â·¾¶µÄÇé¿ö¡£ÎªÁËÄÜÈöÁÕ߸üÈÝÒ×Àí½â£¬ÎÒÕâÀïÒÔ¾ÙÀýµÄ·½Ê½À´ËµÃ÷ÎÊ
Ìâ¡£
¡ ......
	
    
        
    
    JAVAÁ¬½ÓÊý¾Ý¿â´óÈ«
 
 
1£®Oracle8/8i/9iÊý¾Ý¿â£¨thinģʽ£©
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
String url="jdbc:oracle:thin:@localhost:1521:ts"; //tsΪÊý¾Ý¿âµÄSID 
String user="sa"; 
String password=""; 
Connection conn= DriverManager.getConnection(url,u ......
	
    
        
    
    ÒÔǰ¶¼ÊÇÓÃÒ»°ãµÄsocket±à³Ì£¬ÓÃÏß³ÌÀ´¿ØÖÆ¡£×î½üͻȻÓÃnioÀ´×öЩ¶«Î÷¡£
nioµÄºÃ´¦ÎÒÀ´ËµÒ»Ï£ºµÚÒ»£¬¶Áд¶¼ÊÇ»ùÓÚ¿éµÄ£¬Ð§Âʸߡ£µÚ¶þ£¬Í¨¹ýÒýÈëselector,¼ò»¯ÁËÍøÂç±à³ÌÄ£ÐÍ£¬Òì²½·Ç×èÈû¡£
¼ÈÈ»ÓÐÕâô¶àºÃ´¦£¬ÄǾÍд¸öNIO TCPÍøÂçÁÄÌìÊÒÀ´Á·Á·ÊÖ°É¡£
ÒòΪûÓÐдgui£¬ÊÇ»ùÓÚ¿ØÖÆÌ¨µÄËùÒÔûд˽Á˵IJ¿·Ö£¬Ö»Ð´Á˹«¹²ÁÄÌìÊ ......