javaºÍphpÊý×Ö´¦ÀíÉÏ
javaʹÓÃMathÀ࣬phpʹÓÃϵͳº¯Êý
ceil¹¦ÄÜ ´óÓÚµÈÓÚijÊý(³£ÓÃÓÚ·ÖÒ³Ò³Êý¼ÆË㣩
phpÖУºceil(a/b)
javaÖУº(int)Math.ceil((double)a/b)) Math.ceilÔÚjavaÖÐÐèÒª´«ÈëdoubleÐÍ£¬¶ø·µ»ØÒ²ÊÇdoubleÐÍ¡£×¢ÒâÕâÀïÓÃ(double)a/b²Å¿ÉÒÔ¡£
a/b,(dobule)(a/b)¶¼²»ÐС£ÒòΪËûÃÇ»áÏÈ×Ô¶¯ÉáÆúСÊýÈ¡µÃÕûÊý
flooer¹¦ÄÜ Ð¡ÓÚµÈÓÚijÊý
round¹¦ÄÜ È¡×î½Ó½üµÄÊý
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
ÌùÔÚÎÒÃǶàÏß³Ì Java ±à³ÌÂÛ̳ÉÏ×î³£¼ûµÄÎÊÌâÖ®Ò»ÊÇ“ÔõÑù´´½¨Ï̳߳أ¿”¡£¼¸ºõÔÚÿ¸ö·þÎñÆ÷Ó¦ÓóÌÐòÖж¼»á³öÏÖÏ̳߳غ͹¤×÷¶ÓÁÐÎÊÌâ¡£±¾ÎÄÖУ¬Brian Goetz ̽ÌÖÁËÏ̳߳ص͝»ú¡¢Ò»Ð©»ù±¾ÊµÏֺ͵÷Óż¼ÊõÒÔ¼°Ò»Ð©Òª±ÜÃâµÄ³£¼ûΣÏÕ¡£
ΪʲôҪÓÃÏ̳߳أ¿
ÖîÈç Web
·þÎñÆ÷¡¢Êý¾Ý¿â·þÎñÆ÷¡¢Îļþ·þÎñÆ÷»òÓÊ ......
package com.xinnuo.jdbc;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/*
* ¸ÃÀàÖ»ÄÜ´´½¨Ò»¸öʵÀý£¬ÆäËü¶ÔÏóÄܹ»µ÷ÓÃÆä¾²Ì¬·½·¨£¨Ò²³ÆÎªÀà·½·¨£©»ñµÃ¸ÃΨһʵÀýµÄÒýÓá£
* DBConnectionManagerÀàµÄ½¨¹¹º¯ÊýÊÇ˽Óеģ¬ÕâÊÇΪÁ˱ÜÃâÆäËü¶ÔÏó´´½¨¸ÃÀ ......
--°ü
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, --±íÃû
& ......