Oracle·ÖÒ³´æ´¢¹ý³Ì¼°javaµÄ¾ßÌåµ÷Ó÷½·¨
--°ü
create or replace package pkg_query as
type cur_query is ref cursor;
end pkg_query;
--¹ý³Ì
CREATE OR REPLACE PROCEDURE "PRC_QUERY" (p_tableName
in varchar2, --±íÃû
p_strWhere in varchar2, --²éѯÌõ¼þ
p_orderColumn in varchar2, --ÅÅÐòµÄÁÐ
p_orderStyle in varchar2, --ÅÅÐò·½Ê½
p_curPage in out Number, --µ±Ç°Ò³
p_pageSize in out Number, --ÿҳÏÔʾ¼Ç¼ÌõÊý
p_totalRecords out Number, --×ܼǼÊý
p_totalPages out Number, --×ÜÒ³Êý
v_cur out pkg_query.cur_query) --·µ»ØµÄ½á¹û¼¯
IS
v_sql VARCHAR2(1000) := ''; --sqlÓï¾ä
v_startRecord Number(4); --¿ªÊ¼ÏÔʾµÄ¼Ç¼ÌõÊý
v_endRecord Number(4); --½áÊøÏÔʾµÄ¼Ç¼ÌõÊý
BEGIN
--¼Ç¼ÖÐ×ܼǼÌõÊý
v_sql := 'SELECT TO_NUMBER(COUNT(*)) from ' || p_tableName || ' WHERE 1=1';
IF p_strWhere IS NOT NULL or p_strWhere <> '' THEN
v_sql := v_sql || p_strWhere;
END
Ïà¹ØÎĵµ£º
http://hi.baidu.com/kingtckingtc/blog/item/ca5606f4decd5767ddc4740b.html
JVMÄÚ´æ¶Î·ÖÅ䣬JavaÀ¬»ø»ØÊÕµ÷ÓÅ£¬HeapÉ趨
2009Äê09ÔÂ08ÈÕ ÐÇÆÚ¶þ 14:57
1. JVMÄÚ´æ¶Î·ÖÅä¼°Æô¶¯²ÎÊý£º
J2EE·þÎñÆ÷µÄÄÚ´æ×é³É£º
? Java¶Ñ£ºÎÒÃǵijÌÐòºÍ¶ÔÏó¶¼ÔÚÕâ¸ö¶Ñ½øÐйÜÀí
? C¶Ñ£ºµ±ÒýÓõ½Ò»Ð©NativeµÄ¶ÔÏó£¬ÈçÍøÂç·ÃÎÊ¡¢OCI ......
ÁªÍ¨£º³¹µ×·ÅÆúORÓûÇܹÊ×Ý£¿
ÒµÄÚÈÕÇ°´«³öÏûÏ¢£¬ÓÉÓÚÆ»¹û¼á³Ö·Ö³Éģʽ£¬ÁªÍ¨¸ß²ã¶ÔÓÚÒýÈëÆ»¹û̬¶ÈÒÑÎÞÔçÏȼá¾ö¡£“Ëæ×ÅÊÖ»úµÄ²»¶Ï¸üл»´ú£¬Ò»µãÓпÉÄÜ°üº¬µÄ¹¦ÄÜÌرðÊÇÁªÍ¨¼ÓÈë¹È¸è¿ª·ÅÊÖ»úÁªÃË£¬ÔÚÊý¾Ý±£»¤ºÍ¼á¹ÌÐ×÷¼Æ»®ÍÆ×ÔÓпª·Å²Ù×÷ƽ̨ÊÖ»ú£¬ÔÚÊý¾Ý±£»¤ºÍ¼á¹ÌÐ×÷ javaµç×ÓÊéÃâ·ÑÏÂÔØiPhoneÔÚÆäÕ½ÂÔÖ ......
¶ÓÁÐÊÇÉè¼Æ³ÌÐòÖг£ÓõÄÒ»ÖÖÊý¾Ý½á¹¹¡£ËüÀàËÆÈÕ³£Éú»îÖеÄÅŶÓÏÖÏ󣬲ÉÓÃÒ»ÖÖ±»³ÆΪ
“ÏȽøÏȳö”(FIFO)µÄ´æ´¢½á¹¹¡£Êý¾ÝÔªËØÖ»ÄÜ´Ó¶Óβ½øÈ룬´Ó¶ÓÊ×È¡³ö¡£ÔÚ¶ÓÁÐÖУ¬
Êý¾ÝÔªËØ¿ÉÒÔÈÎÒâÔö¼õ£¬µ«Êý¾ÝÔªËصĴÎÐò²»»á¸Ä±ä¡£Ã¿µ±ÓÐÊý¾ÝÔªËØ´Ó¶ÓÁÐÖб»È¡³ö£¬
ºóÃæµÄÊý¾ÝÔªËØÒÀ´ÎÏòÇ°Òƶ¯Ò»Î»¡£ËùÒÔ£¬ÈκÎʱºò ......
javaÖпÆѧ¼ÆÊý·¨µÄ½â³ý
Êý¾Ý¹ý´ó»ò½Ó½üÓÚ0£¬java»á×Ô¶¯Ê¹ÓÿÆѧ¼ÆÊý·¨ÏÔʾ
ҪʹµÃÊý¾ÝÒÔÕý³£µÄСÊýÏÔʾ¿ÉʹÓÃDecimalFormatÀࣺ
DecimalFormat format = new DecimalFormat("0.00000");
String value = format.format(doubleInstance);
......
×î½üÔÚCSDN£¬¿´µ½ÁËÒ»µÀȤζÌ⣺123456789Õâ¾Å¸ö°´Ë³ÐòÅÅÁеÄÊý£¬ÒªÇóÔÚËüÃÇÖ®¼ä²åÈëÈô¸É¸ö+£¬-£¬*£¬/ £¬Ê¹Æä½á¹ûÕýºÃµÈÓÚ
100È磺1*2*3*4+5+6+7*8+9=100¡£
¿´ÁËÌâÄ¿ºó£¬Ë¼¿¼Èç¹ûÓÃjavaÈçºÎʵÏÖ¡£ÒÔÏÂÊÇÎҵĽâÌâ˼·£º
˼Ïë±È½Ï¼òµ¥£¬ÏȽ«²åÈë+£¬-£¬*£¬/ºóµÄËùÓÐ×Ö·û´®¶¼Çî¾Ù³öÀ´£¬È»ºó¼ÆËãÄÄЩ×Ö·û´®µÈÓÚ100¡£
Õ ......