9:设置weblogic连接池:
. {4 A3 x' U6 m( L- K- h. |3 J! c& `0 a
pool的配置: ; o0 g' d! l1 a# l, l/ H4 e
假设已配置服务:expserv # z1 _+ h' U0 d; {" K8 j
且数据库服务器机器名为:expserv + v3 Q: I. e+ o* I; _& f( {2 C
数据库sid:expservSID,用户名和密码都为:expserv # i# U: P. I( U# H6 }
以weblogic7.0为例,首先启动服务 2 Z8 I! ~ {+ E; c
http://localhost:port/console
; o% ? Z M. y- l, A- T打开service\jdbc\connection pools
* i) V1 r7 T* o7 a4 w8 ^% h, j配置oraclePool如下:
1 w* d1 ~- W3 P/ F3 |Configuration: , k/ N; m. @4 J8 C6 J
Name: oraclePool ! m: V9 B, e8 z: @, a% E! V l- M
URL: jdbc:oracle:thin:@expserv:1521:expservSID ! H2 Q b9 v2 ^, ?
Driver Classname: oracle.jdbc.driver.OracleDriver " V) v9 A5 x, b) R
Properties(key=value): user=expserv
' e) l9 z" ?2 CTargets: $ ^( s# W' X0 S6 D) u
Targets-Server:expserv ( _* ]* j+ Y; Z8 y* x" {% w/ @
在weblogic7.0中除了数据库密码,其他的pool参数都可以在config.xml中直接用文本编辑器直接修改。 9 m( u# H) |" w0 X) n3 h2 A
1 j" c- B1 Q+ r: t& K: Z7 k, x( f10:数字转货币大写(js)
! }' I- C9 ` V% I" i3 c: E+ Jfunction ChangeToBig(value) 4 ~. z( o; t* Z
{
7 t- {2 `! ^& N1 {/ D' tvar intFen,i; ( M0 M; X6 L- k$ \8 `
var strArr,strCheck,strFen,strDW,strNum,strBig,strNow; 8 P, T1 e4 x+ `6 e# F% ^* _
% I, D, l2 L6 i K- f2 d
if(trim(value)=="") //数据为空时返回"零" ; @% ]! R6 [/ G8 I4 V; G
return "零"; " B: G" J/ U% P% Y' O# W
if (isNaN(value)) //数据非法时提示,并返回空串
8 f& R% {. D8 k4 Q# x{
4 T8 y9 ~9 W9 o4 H, a/ GstrErr = "数据"+value+"非法!" , X# H( I2 @7 t
alert(strErr); 2 Y& |# k( a9 b+ @9 } s
return "";
% D. ^+ F* q8 V! S- r} , v2 X8 u$ e: L2 B$ ~, u
strCheck = value+"."; # [( |" z' i7 @ {% l; W
strArr = strCheck.split("."); 2 x% R/ ?& @; L, c- e. D, b
strCheck = strArr[0];
i) L" k! y0 I$ s8 Bif(strCheck.length>12) //数据大于等于一万亿时提示无法处理 5 C+ F: Q: _5 L) z4 x* x9 C9 _7 z
{ 7 e- v8 R6 i/ g; i) U
strErr = "数据"+value+"过大,无法处理!" $ ~7 ]$ T6 B( }8 B u+ X
alert(strErr); . G" n3 v9 D; g, U$ R3 W# W4 Q) P! ?* U
return ""; w6 y' x$ i1 f
} * n; J2 T' `* @# ]5 N& Y% U
try . }8 q ~7 x* `9 Q
{
( v) p$ b1 i: {$ d0 P! Ui = 0;
1 A5 H# `; i8 wstrBig = "";
1 R9 m# l& y8 U7 F$ v7 dintFen = value*100; //转换为以分为单位的数值
3 q! o8 [# y! {4 Y |5 MstrFen = intFen.toString(); , N! E' M* N( I& A* \3 {0 Z
strArr = strFen.split("."); 1 l7 T" D2 T5 v! w6 U
strFen = strArr[0];
& g9 ~7 b S: f, ~) ?2 YintFen = strFen.length; //获取长度 , N4 O) Y# Q" ]; P) a
strArr = strFen.split(""); //将各个数值分解到数组内 + m$ }2 k3 [; f( @7 M. h3 T
while(intFen!=0) //分解并转换 4 R- O C2 @% o) K: I
{ , f) T# Z! g9 i: d3 }
i = i+1;
$ ?+ k( O2 N% \( g( Rswitch(i) //选择单位
7 N; ?% ?0 U" {6 \$ H% t& z! \$ z{
# x1 ]/ x& I$ _- g- o+ R2 q! ncase 1:strDW = "分";break;
) k" t& n& \9 j% e* |case 2:strDW = "角";break; 8 n: `% b! E5 v* a$ Z' ^ B! z R5 V
case 3:strDW = "元";break; . k$ R7 O# _0 Z+ u* |
case 4:strDW = "拾";break;
& h2 ~/ G) q, n6 n$ xcase 5:strDW = "佰";break;
( Q6 G, i' i- `8 ucase 6:strDW = "仟";break;
3 U5 W4 v2 a8 ^3 w0 J0 Q! Dcase 7:strDW = "万";break;
; s* M5 G0 P' ?. s3 v5 \' Y Hcase 8:strDW = "拾";break;
6 O. O* p0 T; U6 j( ccase 9:strDW = "佰";break;
3 Q% b9 }( Q( q5 gcase 10:strDW = "仟";break; , x8 b6 ^7 q2 B% F- V- l! x
case 11:strDW = "亿";break; 6 J. c" p, G5 D8 U
case 12:strDW = "拾";break; - J$ @$ @% O- M2 x
case 13:strDW = "佰";break; 3 M' E* P4 Y( u) w! e3 o
case 14:strDW = "仟";break;
" E5 u3 E& u/ N0 t5 _}
! S9 o% p( Y* h/ P' Fswitch (strArr[intFen-1]) //选择数字 0 W) U* Q8 m3 m
{ . {' g2 t( L' F+ v: Z# Y! _
case "1":strNum = "壹";break; - O, u, q" Y( {" |
case "2":strNum = "贰";break; + ?' w2 P {% P; j' X9 t" I' h! E
case "3":strNum = "叁";break; - y. [4 g& |; \/ x
case "4":strNum = "肆";break;
5 l' }' l$ b! C( l5 d8 S4 hcase "5":strNum = "伍";break;
% \1 _( t( s6 G3 a0 b; u! F, u- hcase "6":strNum = "陆";break;
5 O6 m$ [' z" c; B6 v$ }+ f4 scase "7":strNum = "柒";break;
* _- G* R1 d$ d: `case "8":strNum = "捌";break;
/ S# G; ^* E: ]) D! c2 D4 bcase "9":strNum = "玖";break;
c! { }6 z) A, `6 q9 z( Pcase "0":strNum = "零";break;
3 e7 G5 {% I! O3 T& _} |