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ÀàÐÍ¡£
Õâ¸öÀàÐÍÖ§³Öǰº
Ïà¹ØÎĵµ£º
ListµÄÓ÷¨
List°üÀ¨List½Ó¿ÚÒÔ¼°List½Ó¿ÚµÄËùÓÐʵÏÖÀà¡£ÒòΪList½Ó¿ÚʵÏÖÁËCollection½Ó¿Ú£¬ËùÒÔList½Ó¿ÚÓµÓÐCollection½Ó¿ÚÌṩµÄËùÓг£Ó÷½·¨£¬ÓÖÒòΪListÊÇÁбíÀàÐÍ£¬ËùÒÔList½Ó¿Ú»¹ÌṩÁËһЩÊʺÏÓÚ×ÔÉíµÄ³£Ó÷½·¨£¬Èç±í1Ëùʾ¡£
±í1 List½Ó¿Ú¶¨ÒåµÄ³£Ó÷½·¨¼°¹¦ÄÜ
´Ó±í1¿ÉÒÔ¿´³ö£¬List½Ó¿ÚÌṩµÄÊʺÏÓÚ×ÔÉíµÄ ......
Ôڳɹ¦ÊµÏÖJavaµ÷ÓÃC++Ö®ºó£¬½ÓÏÂÀ´Ïëµ½ÄÜ·ñͨ¹ýJNAʵÏÖJavaµ÷ÓÃFortran£¬½ñÌìÊÔÑéÁËһϣ¬»¹ÊDZȽÏÈÝÒ׵ġ£
ÍøÉÏÓÐÒ»¸öJavaµ÷ÓÃF95µÄÀý×Ó£¬µ«ÊÇÎÒ¿¼ÂDz»½öҪʵÏÖF95µÄµ÷Ó㬻¹ÒªÊµÏÖF77µÄµ÷Óã¬ËùÒÔ·ÑÁËһЩÖÜÕÛ¡£
ÎÊÌâµÄ¹Ø¼üÔÚÓÚF77Ϊ¹ý³ÌÃû×Ô¶¯Ìí¼ÓÁËÒ»¸öβ²¿µÄÏ»®Ïߣ¬ËùÒÔsub1Õâ¸ö¹ý³Ì£¬µ½JavaÒ»¶Ë£¬¾Í±ä³ÉÁËsub1_£¬ ......
<!--
@page { margin: 0.79in }
P { margin-bottom: 0.08in }
-->
JavaÖеÄ
io
ÎÒ¶ÔÁ÷µÄÀí½âÊÇ£ºÔ´µ½Ä¿µÄµØµÄ¹ì¼££¬ËùÒÔÁ÷µÄÒ»¶ËÊÇÊý¾ÝÔ´£¨ÊäÈëÁ÷£©»òÕß½ÓÊÕÆ÷£¨Êä³öÁ÷£©£¬ÁíÒ»¶ËÊÇ
ioÖеÄij¸öÀࣻÕâÀï˵Ã÷Ï£¬
Scanne ......
1. Multiply-Thread
Locks offer two primary features: mutual exclusion and visibility. Mutual exclusion means only one thread at a time may hold a given lock, so only one thread at a time will be using the shared data. Visibility is to ensure that changes made to shared data prior to releasing a lo ......
ÒÔǰ¶¼ÊÇÓÃÒ»°ãµÄsocket±à³Ì£¬ÓÃÏß³ÌÀ´¿ØÖÆ¡£×î½üͻȻÓÃnioÀ´×öЩ¶«Î÷¡£
nioµÄºÃ´¦ÎÒÀ´ËµÒ»Ï£ºµÚÒ»£¬¶Áд¶¼ÊÇ»ùÓÚ¿éµÄ£¬Ð§Âʸߡ£µÚ¶þ£¬Í¨¹ýÒýÈëselector,¼ò»¯ÁËÍøÂç±à³ÌÄ£ÐÍ£¬Òì²½·Ç×èÈû¡£
¼ÈÈ»ÓÐÕâô¶àºÃ´¦£¬ÄǾÍд¸öNIO TCPÍøÂçÁÄÌìÊÒÀ´Á·Á·ÊÖ°É¡£
ÒòΪûÓÐдgui£¬ÊÇ»ùÓÚ¿ØÖÆÌ¨µÄËùÒÔûд˽Á˵IJ¿·Ö£¬Ö»Ð´Á˹«¹²ÁÄÌìÊ ......