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

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 List ÅÅÐò Collections.sort() ¶Ô List ÅÅÐò

class User {
String name;
String age;

public User(String name,String age){
this.name=name;
this.age=age;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getName() {
return name;
}
public void setName(St ......

ѧϰJavaµÄѧϰ˳Ðò


ѧϰJavaµÄѧϰ˳Ðò
µÚÒ»½×¶Î(ËĸöÔÂ)
 
1.j2se
  ÃæÏò¶ÔÏó£­·â×°¡¢¼Ì³Ð¡¢¶à̬
ÄÚ´æµÄ·ÖÎö
µÝ¹é
¼¯ºÏÀà(Set,List,MapµÄ×ÓÀà)¡¢·ºÐÍ¡¢×Ô¶¯´ò°üÓë½â°ü¡¢Annotation
IOÁ÷(IOÁ÷ºÍÏ̱߳àдһ¸öQQÁÄÌì³ÌÐò)
¶àÏ̡߳¢Ïß³Ìͬ²½
TCP/UDP
AWT¡¢Ê¼þÄ£ÐÍ¡¢ÄäÃûÀà (ÄܲéѯÊý¾Ý¿âÏÔʾÔÚJtableÉÏÃæ)
ÕýÔò± ......

JAVA Socket³¬Ê±Ç³Îö

JAVA Socket³¬Ê±Ç³Îö
  Ì×½Ó×Ö»ò²å×ù(socket)ÊÇÒ»ÖÖÈí¼þÐÎʽµÄ³éÏó£¬ÓÃÓÚ±í´ïÁ½Ì¨»úÆ÷¼äÒ»¸öÁ¬½ÓµÄ“ÖÕ¶Ë”¡£Õë¶ÔÒ»¸öÌØ¶¨µÄÁ¬½Ó£¬Ã¿Ì¨»úÆ÷É϶¼ÓÐÒ»¸ö“Ì×½Ó×Ö”£¬¿ÉÒÔÏëÏóËüÃÇÖ®¼äÓÐÒ»ÌõÐéÄâµÄ“ÏßÀ”¡£JAVAÓÐÁ½¸ö»ùÓÚÊý¾ÝÁ÷µÄÌ×½Ó×ÖÀࣺServerSocket£¬·þÎñÆ÷ÓÃËü“ÕìÌý&rdquo ......

JAVA NIO TCP SOCKET ÁÄÌìȺ·¢

ÒÔǰ¶¼ÊÇÓÃÒ»°ãµÄsocket±à³Ì£¬ÓÃÏß³ÌÀ´¿ØÖÆ¡£×î½üͻȻÓÃnioÀ´×öЩ¶«Î÷¡£
nioµÄºÃ´¦ÎÒÀ´ËµÒ»Ï£ºµÚÒ»£¬¶Áд¶¼ÊÇ»ùÓÚ¿éµÄ£¬Ð§Âʸߡ£µÚ¶þ£¬Í¨¹ýÒýÈëselector,¼ò»¯ÁËÍøÂç±à³ÌÄ£ÐÍ£¬Òì²½·Ç×èÈû¡£
¼ÈÈ»ÓÐÕâô¶àºÃ´¦£¬ÄǾÍд¸öNIO TCPÍøÂçÁÄÌìÊÒÀ´Á·Á·ÊÖ°É¡£
ÒòΪûÓÐдgui£¬ÊÇ»ùÓÚ¿ØÖÆÌ¨µÄËùÒÔûд˽Á˵IJ¿·Ö£¬Ö»Ð´Á˹«¹²ÁÄÌìÊ ......

JavaÖеÄö¾ÙÀàÐÍ£¬enum

public class MyEnumTestMain {
public enum MyenumTest{red,blue,green,black}//¶¨Òåö¾ÙÀàÐÍ

public static void main(String[] args) {
MyenumTest mt = MyenumTest.red;//redÏ൱ÓÚö¾ÙµÄ¾²Ì¬ÊôÐÔ

switch(mt){
case red:
System.out.println("red");
break;
case blue:
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ