¼òµ¥µÄ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 ²
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......