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

¼òµ¥µÄsqlÓï¾ä - Oracle / »ù´¡ºÍ¹ÜÀí

network_traffic_24h±íµÄ½á¹¹ÊÇ
SQL code:
ID NUMBER(20)
RECORD_TIME DATE
LINK_ID NUMBER(10)
VLINK_ID NUMBER(10)
LINKLAYER_PROTOCOL NUMBER(10)
NETWORK_PROTOCOL NUMBER(10)
BYTE_IN NUMBER(20)
BYTE_OUT NUMBER(20)
PKTNUM_IN NUMBER(20)
PKTNUM_OUT NUMBER(20)
UNICAST_BYTE_IN NUMBER(20)
UNICAST_BYTE_OUT NUMBER(20)
UNICAST_PKTNUM_IN NUMBER(20)
UNICAST_PKTNUM_OUT NUMBER(20)

ÏÖÔÚÎÒҪȡµÃnetwork_traffic_24h±íÖÐUNICAST_BYTE_INÓëUNICAST_BYTE_OUT µÄºÍµÄÊý¾Ý£¬¶ÁÈ¡Êý¾Ý£¬ÊÇÔõôдµÄ
È»ºóÎÒÊÇ´ÓÊý¾Ý¿âÖжÁÈ¡£¬
select sum(UNICAST_BYTE_IN+UNICAST_BYTE_OUT ) from network_traffic_24h
while (rs.next)
{
  ÕâÀïÈçºÎд£¬Ê¹ÓÃint ·µ»Ø
 }
}
}

º¹,¼ÇµÃÊÇ
integer i=rs.getInt(1);

Äܲ»ÄÜдµÄȫһµã¡£ÔõôÕÕ×ÅÄãµÄд²»¶Ô°¡¡£Ã»ÓÐÈ¡³öÖµ°¡


http://www.javaeye.com/topic/560109
ÎÒÒ²Íü¼Ç²î²»¶àÁË,²Î¿¼ÏÂʲôÀý×Ó°É,ÎÒ¾õµÃÄã·¢µ½JAVA°æ¿ÉÄܸüºÏÊÊ

Èç¹ûÎÒҪȡµÃÊǺÍ
ÄÇôÎÒÊä³ö
System.out.println(rs.getInt(9)+rs.getInt(10£©);
dataset.setValue("µ¥²¥",(rs.getInt(9)+rs.getInt(10)));
ÕâÑù¾ÍÄÜ¿´µ½ÎÒ×îǰͷ˵µÄºÍÁ˰ɣ¡

9ºÍ10ÕâÁ½¸öÊý×Öд´íÁËÂð£¿

Ó¦¸Ã¾ÍÊÇÕâÑùµÄ°É£¬Ê¹ÓÃID ²


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ