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
Ïà¹ØÎĵµ£º
Javaѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
Ê®½øÖÆ×ª³ÉÊ®Áù½øÖÆ£º
Integer.toHexString(int i)
Ê®½øÖÆ×ª³É°Ë½øÖÆ
Integer.toOctalString(int i)
Ê®½øÖÆ×ª³É¶þ½øÖÆ
Integer.toBinaryString(int i)
Ê®Áù½øÖÆ×ª³ÉÊ®½øÖÆ
Integer.valueOf("FFFF",16).toString()
°Ë½øÖÆ×ª³ÉÊ®½øÖÆ
Integer.valueOf("876",8).toString()
¶þ½øÖÆ×ªÊ®½øÖÆ
Intege ......
ÖÚËùÖÜÖª£¬ÔÚ³ÌÐò¿ª·¢ÖУ¬ÄÑÃâ»áÓöµ½ÐèҪƥÅä¡¢²éÕÒ¡¢Ìæ»»¡¢ÅжÏ×Ö·û´®µÄÇé¿ö·¢Éú£¬¶øÕâЩÇé¿öÓÐʱÓֱȽϸ´ÔÓ£¬Èç¹ûÓô¿±àÂ뷽ʽ½â¾ö£¬ÍùÍù»áÀ˷ѳÌÐòÔ±µÄʱ¼ä¼°¾«Á¦¡£Òò´Ë£¬Ñ§Ï°¼°Ê¹ÓÃÕýÔò±í´ïʽ£¬±ã³ÉÁ˽â¾öÕâһì¶ÜµÄÖ÷ÒªÊֶΡ£
´ó
¼Ò¶¼ÖªµÀ£¬ÕýÔò±í´ïʽÊÇÒ»ÖÖ¿ÉÒÔÓÃÓÚģʽƥÅäºÍÌæ»»µÄ¹æ·¶£¬Ò»¸öÕýÔò±í´ï ......
ÁªÍ¨£º³¹µ×·ÅÆúORÓûÇܹÊ×Ý£¿
ÒµÄÚÈÕǰ´«³öÏûÏ¢£¬ÓÉÓÚÆ»¹û¼á³Ö·Ö³Éģʽ£¬ÁªÍ¨¸ß²ã¶ÔÓÚÒýÈëÆ»¹û̬¶ÈÒÑÎÞÔçÏȼá¾ö¡£“Ëæ×ÅÊÖ»úµÄ²»¶Ï¸üл»´ú£¬Ò»µãÓпÉÄܰüº¬µÄ¹¦ÄÜÌØ±ðÊÇÁªÍ¨¼ÓÈë¹È¸è¿ª·ÅÊÖ»úÁªÃË£¬ÔÚÊý¾Ý±£»¤ºÍ¼á¹ÌÐ×÷¼Æ»®ÍÆ×ÔÓпª·Å²Ù×÷ƽ̨ÊÖ»ú£¬ÔÚÊý¾Ý±£»¤ºÍ¼á¹ÌÐ×÷ javaµç×ÓÊéÃâ·ÑÏÂÔØiPhoneÔÚÆäÕ½ÂÔÖ ......