sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿
¾ÍÊǺܶà¸öÂß¼ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£
Ã»Íæ¹ýOµÄ£¬°ï¶¥¡£
ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ý³Ì¡±Îļþ¼ÐÏÂÃæÁË£¿£¿Ò²²»·ÖÀàµÄ£¿
UP.
(¡Ño¡Ñ)¡..........
ÄÇ´ó¼Òд´æ´¢¹ý³ÌµÄʱºò£¬¶¼ÊÇÔõô¹ÜÀ ......
ÔÚÒ»¸ö¹¤³ÌÖÐÈç¹ûÆäÖÐÒ»¸ö·ÇÖ÷´°ÌåµÄ´°Ì幨±Õ,ÔõÑù²ÅÄÜÖªµÀ¹Ø±ÕµÄÊÇÄĸö´°Ìå,ÓÐûÓпÉÒԽػñµÄÏûÏ¢?ÆäËü·½·¨Ò²¿ÉÒÔ,ǰÌáÊDz»ÔÚ´°ÌåÖмÓÈëÈκδúÂë,ÒòΪ´°ÌåÌ«¶àÕâÑùÐ޸ĵĴúÂëÌ«¶à
CSDNÈËÔ½À´Ô½ÉÙÁË- -!!!
²»¼ÓÈëÈκδúÂëµÄ»°¾ÍÖ»ÄÜÄã×Ô¼ºÖªµÀ¹Ø±ÕµÄÊÇÄĸö´°ÌåÁË£¬³ÌÐòÎÞ´ÓÖªµÀÁË£¡
¾ÍËã¿ÉÒÔ»ñÈ¡ÏûÏ¢£¬Äã¹Ø±ÕµÄ´°ÌåÃ»Ó ......
ÈçºÎ¿ÉÒÔÈÃpanelÒÆ¶¯²»ÊÜ´°ÌåÏÞÖÆ¿ÉÒÔËæÒâÒÆ¶¯
Áí½¨Ò»¸ö×Ó´°Ìå,°ÑÒªÒÆ¶¯µÄPanel·ÅÉÏÃæ²»¾ÍokÁË
Õâ¸öÂï ÔËÐÐÆÚ»¹ÊDZàÒëÆÚ£¿
¾ÍÊǽ¨Ò»¸öÎޱ߿òµÄÒÆ¶¯´°Ìå¡£
ÊÇÔËÐкó»¹ÓÐÒÔÉÏÁ½¸ö·½·¨ÎÒ¶¼ÓÃÁ˲»ºÃʹ
ÎÒÕâ¸öÊÇ·ÅÔÚframeÉϵÄ
......
ÔõÑù½«jspÒ³ÃæµÄJavaScript´úÂëת»»³ÉjsÎļþ£¿
ÒýÓÃ
Ö±½Ó°ÑJavaScript´úÂë¸´ÖÆ£¬È»ºó½¨Á¢¸öÎļþxxx.js½«¸´ÖƵĴúÂëÕ³Ìùµ½xxx.jsÖС£
È»ºóÔÙÔÀ´µÄjspÒ³ÃæÍ¨¹ý
<script language="javascript" src="<%=request.getContextPath()%>/xxx.js"></script>
ÒýÈë¸Õ²Å±£´æµÄjsÎļþ¡£
......
ÎÒÏëÿÌì×Ô¶¯Ö´ÐÐÒÔÏÂSQL£¬Ä¿µÄ¾ÍÊÇÿÌì´Ó1¿ªÊ¼µÝÔö
begin
EXECUTE IMMEDIATE 'DROP SEQUENCE SEQ_QCNO';
EXECUTE IMMEDIATE 'CREATE SEQUENCE SEQ_QCNO START WITH 1 MAXVALUE 999 MINVALUE 1 CYCLE NOCACHE NOORDER';
end;
Ö±½ÓÔÚtoadÖÐÖ´ÐÐÕâ¶ÎÊÇûÓÐÎÊÌâµÄ£¬¿ÉÒ»µ«É ......
Õâ¸öÊÇsqlserverµÄ·ÖÒ³´æ´¢¹ý³Ì£¬°ïæתÏÂoracleµÄ·ÖÒ³´æ´¢¹ý³Ì£¬ÄܲâÊÔͨ¹ý£¬ÔÚÏߵȡ£¡£¡£
SQL code:
CREATE PROCEDURE GetRecordfromPage
@tblName varchar(255), -- ±íÃû
@RetColumns varchar(1000) = '*', -- ÐèÒª·µ»ØµÄÁУ¬Ä¬ÈÏΪȫ²¿ ......