¹ØÓÚĸ°åÒ³¼ÓÔØJavascriptµÄʱºòÓÐʲôҪעÒâµÄÎÊÌâÂð
Èç¹û´æÔÚÒýÓùØÏµµÄ»°Òª×¢ÒâÏȺó˳Ðò
Ò³ÃæÔªËØµÄID»á±ä
Òª¼ÓÔØ¶ÔÁË
×¢Òâ·¾¶¡£¡£¡£
ѧϰ
½« <script>±êǩдÔÚFooterÀïÃæ
×¢Òâ·¾¶
Èç¹ûÄãµÄÒýÓÃÒ³ÔÚ²»Í¬µÄÎļþ¼Ð
¾ÍҪעÒâÁË
ǰÌáÊÇÄãµÄĸ°æÒ³ ÊÇÒýÓõÄjsÎļþ
»¹ÓÐÄ£°åÒ ......
±³¾°£ºÎÒÏë¶ÔÎÒ±àдµÄ¼ÓÃܽâÃÜÓÃwrap½øÐдúÂë°ü×°¼ÓÃÜ¡£
1¡¢ÎÒ´´½¨µÄÒ»¸ö°ü£¬ÀïÃæÓÐÃÜÔ¿ºÍ¼ÓÃܽâÂëµÄ·½·¨£¬ÓÉÓÚÒª±£»¤ÃÜÔ¿²»±»ÈË͵ÇÔ£¬ËùÒÔÎÒ¶ÔÕâ¸ö³ÌÐò½øÐÐwrap¼ÓÃÜ
2¡¢½«ÎÒÉÏÃæ´´½¨µÄPL/SQL³ÌÐò±£´æÎªsource.sql,·ÅÔÚEÅÌÏ¡£
3¡¢´ò¿ªDosÃüÁ¶Ôsource.sql½øÐмÓÃÜ
E:\>wrap iname=source.sql oname=p ......
ÎÒÔÚoracleÖеÄÁ¬½Ó×Ö·û´®¡°jdbc:oracle:thin:¡±ÕâÑùÔõôҲ¿ÉÒÔÁ¬½ÓÉÏÊý¾Ý¿â£¿£¿Çë¸÷λ°ï°ï棡
ÄǾÍÊÇjdbcµÄ·½Ê½°¡
jdbc:oracle:thin:@localhost:1521:DataBaseName
Java code:
jdbc:oracle:thin:@192.168.1.123:1521:orcl
javaµÄjdbcÖ±Á¬¡£ÄãºóÃæÃ»ÓÐip:host:SID£¿Ó¦¸ÃÁ¬²»Éϰɣ¿ÊDz»ÊÇÕâôŪµÄ:
Java code: ......
oracle¹ý³Ì,º¯ÊýÀïÃæ,ÓкܶàÖÐÎÄ,Õâ»á²»»áÓ°Ïì¼ÓÃÜ
²»»á¡£ÊÔÊÔ¾ÍÖªµÀÁË¡£
Â¥Ö÷£¬°ïÎÒ¿´¿´ÎÒ·¢µÄwrap¼ÓÃܵĴíÎó£¬Ð»Ð»£¡
http://topic.csdn.net/u/20100129/10/ac7a4541-9bca-42da-972c-5dda51d07040.html?49174
{{ ......
´ËfunctionʵÏÖµÄÊǽ«Ð¡Ð´Êý×Öת»»³É´óд×Öĸ,¿´µÄÊéÉϵÄÀý×Ó,ËÄܰïÎÒ½âÊÍÏÂÎÊÌâ³öÔÚÄÄ£¿
SQL code:
CREATE OR REPLACE FUNCTION smalltobig(smallmoney in VARCHAR2)
RETURN bigmoney IS
BigWrite VARCHAR2(54);
Bignum VARCHAR2(2);
RMB VARCHAR2(2);
moneyplace NUMBER;
dotplace NUMBER;
mon ......
ÎÒдÁËÒ»¸ö´¥·¢Æ÷£¬È磺
create or replace trigger Trig_BeforeUpdate_smgp
Before UPDATE ON smscom.smgp_mt_hn
for each row
declare
begin
IF :new.status <> -1
THEN
--½«ÒÑ·µ»Ø×´Ì¬±¨¸æµÄÊý¾Ý·ÅÈëÀúÊ·±í£¬Í¬Ê±ÔÚ½Ó¿Ú±íÖÐɾ³ý
&nb ......