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 NIO APIÏê½â
ÔÚJDK
1.4ÒÔǰ£¬JavaµÄIO²Ù×÷¼¯ÖÐÔÚjava.ioÕâ¸ö°üÖУ¬ÊÇ»ùÓÚÁ÷µÄ×èÈû£¨blocking£©API¡£¶ÔÓÚ´ó¶àÊýÓ¦ÓÃÀ´Ëµ£¬ÕâÑùµÄAPIʹÓúܷ½
±ã£¬È»¶ø£¬Ò»Ð©¶ÔÐÔÄÜÒªÇó½Ï¸ßµÄÓ¦Óã¬ÓÈÆäÊÇ·þÎñ¶ËÓ¦Óã¬ÍùÍùÐèÒªÒ»¸ö¸üΪÓÐЧµÄ·½Ê½À´´¦ÀíIO¡£´ÓJDK 1.4Æð£¬NIO
API×÷Ϊһ¸ö»ùÓÚ»º³åÇø£¬²¢ÄÜÌṩ·Ç×èÈû(non-blo ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
package com.xinnuo.jdbc;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/*
* ¸ÃÀàÖ»ÄÜ´´½¨Ò»¸öʵÀý£¬ÆäËü¶ÔÏóÄܹ»µ÷ÓÃÆä¾²Ì¬·½·¨£¨Ò²³ÆÎªÀà·½·¨£©»ñµÃ¸ÃΨһʵÀýµÄÒýÓá£
* DBConnectionManagerÀàµÄ½¨¹¹º¯ÊýÊÇ˽Óеģ¬ÕâÊÇΪÁ˱ÜÃâÆäËü¶ÔÏó´´½¨¸ÃÀ ......
ÏëÏë×Ô¼ºÃ÷Äê¾ÍÒª±ÏÒµÁË£¬µ«×Ô¼ºÐÄÀï×ÜÊǺܵ£ÐÄ£¬Ò²²»ÖªµÀ×Ô¼ºÑ§Õâ¸öµ½µ×ÊǶԻ¹ÊÇ´í£¡×ÜÊÇÌý˵ÏÖÔÚ×ö³ÌÐòµÄ¹¤×÷²»ºÃÕÒ£¬¹¤×ʺܵͣ¬ÏÖÔÚÓкöàͬѧ¶¼Ã»Ñ§ÁË£¬Ò²²»ÖªµÀ×Ô¼ºÊDz»ÊÇ»¹Òª¼á³ÖÏÂÈ¥£¬ÊDz»ÊÇ»¹ÒªjiavaÕâÌõ·¡£¸Ð¾õºÃÃÔã....... ......
×î½üÔÚCSDN£¬¿´µ½ÁËÒ»µÀȤζÌ⣺123456789Õâ¾Å¸ö°´Ë³ÐòÅÅÁеÄÊý£¬ÒªÇóÔÚËüÃÇÖ®¼ä²åÈëÈô¸É¸ö+£¬-£¬*£¬/ £¬Ê¹Æä½á¹ûÕýºÃµÈÓÚ
100È磺1*2*3*4+5+6+7*8+9=100¡£
¿´ÁËÌâÄ¿ºó£¬Ë¼¿¼Èç¹ûÓÃjavaÈçºÎʵÏÖ¡£ÒÔÏÂÊÇÎҵĽâÌâ˼·£º
˼Ïë±È½Ï¼òµ¥£¬ÏȽ«²åÈë+£¬-£¬*£¬/ºóµÄËùÓÐ×Ö·û´®¶¼Çî¾Ù³öÀ´£¬È»ºó¼ÆËãÄÄЩ×Ö·û´®µÈÓÚ100¡£
Õ ......