9:设置weblogic连接池: 1 o$ s) |/ i' z
9 a. ~9 Q* w- e, dpool的配置:
' M8 n/ |2 X0 I% b" C0 N" ^/ m假设已配置服务:expserv
- K8 b1 T1 r8 V% ?( _; S且数据库服务器机器名为:expserv
% o0 L7 D. n- B2 |0 M6 e; s h, y数据库sid:expservSID,用户名和密码都为:expserv / j) q% D/ |' o$ N
以weblogic7.0为例,首先启动服务
7 u2 k" t; U: O! i+ V5 F' F# V6 Z& ghttp://localhost:port/console 1 _: r6 z! ^( S! Q% F
打开service\jdbc\connection pools # V ]% T: g3 t2 ]6 N
配置oraclePool如下:
( ?; _8 n9 ]- g) M/ }9 ^/ sConfiguration: ) s; k) v" o7 I* ^+ a; R. z/ w& e
Name: oraclePool 9 u/ h8 O1 L' f
URL: jdbc:oracle:thin:@expserv:1521:expservSID % L+ ]) y& G; ~3 I+ Y# X
Driver Classname: oracle.jdbc.driver.OracleDriver
/ L' E& [! n" F: R7 s+ _Properties(key=value): user=expserv
0 O! H; A/ B+ j8 B7 aTargets:
% O& u+ g# D1 E9 E6 ZTargets-Server:expserv ' k1 m5 o1 N* x; J8 N6 N7 X
在weblogic7.0中除了数据库密码,其他的pool参数都可以在config.xml中直接用文本编辑器直接修改。
: {: E; ?. j$ }7 }+ g9 g& U: _: R
' }- {+ k* ?% m1 S5 T10:数字转货币大写(js)
: t) {5 ~( L/ ~" c- C2 C6 Bfunction ChangeToBig(value)
, V8 O! n+ {+ W) w. k{
; r2 {- Y# K& T- _0 R# ivar intFen,i;
$ ~ \+ y/ t2 j, Y$ |) v* Wvar strArr,strCheck,strFen,strDW,strNum,strBig,strNow; ; s( ^+ ^8 Y8 u$ p# X1 i) a
" I8 n6 V9 S# N" M. t, Aif(trim(value)=="") //数据为空时返回"零" * J; v9 O3 J7 _4 r P6 E n
return "零"; 7 G) i8 B5 g4 e, n1 ^- o: `1 C; Q
if (isNaN(value)) //数据非法时提示,并返回空串
7 j- ^: V ], c9 r) Y& l- t{ 6 _ ^) N! }" v( B
strErr = "数据"+value+"非法!"
) _: s8 p% s2 w8 malert(strErr); ' g# p3 L# ?: M" m) d
return ""; @. O5 |9 V" Y# F# w( y
}
: O) ~3 O; u& g# bstrCheck = value+".";
" a5 d3 I, ?5 M# B9 I( C& KstrArr = strCheck.split("."); 7 p% K& p; p$ Y) N& ~3 F
strCheck = strArr[0]; 3 |$ a9 P- F7 l4 E
if(strCheck.length>12) //数据大于等于一万亿时提示无法处理 6 `# j& o; B ?% \4 R2 P
{
; G l$ Y" W f+ k7 ostrErr = "数据"+value+"过大,无法处理!" , Q7 n! K& |0 B1 A% [' ]- e
alert(strErr); $ t7 {. ]) {' P, n$ Q
return "";
& J& |2 B$ X H5 G0 c) M} . v$ H8 G6 z' H
try
5 a& t1 n+ [3 G% U: q- k p- f7 c{
; k7 U4 a# m! ^8 Y: C% bi = 0;
6 j7 G% \' n* ]strBig = "";
7 `. w% e2 R. ^8 k& t; G) p( MintFen = value*100; //转换为以分为单位的数值 & g# u2 W' M8 _1 q
strFen = intFen.toString();
+ T. F8 c8 I6 Q. C' s" W CstrArr = strFen.split(".");
: l, |7 K) y" i# h# fstrFen = strArr[0];
: O& @0 I, l9 h4 f' Z; m2 {( aintFen = strFen.length; //获取长度 & [1 u( P& i5 n% R8 \ Y# h, P; i
strArr = strFen.split(""); //将各个数值分解到数组内
5 m7 D' A2 Q* ^* pwhile(intFen!=0) //分解并转换 / |, I6 V7 {$ h0 E2 C/ Z9 M6 c
{ - m0 r g5 b1 g7 e9 s
i = i+1; , W' ]9 x) e: i7 W
switch(i) //选择单位
7 b, s1 a% r" Q& R, Y/ e{
& D( T* o9 t3 F+ D# ]case 1:strDW = "分";break; 9 k# Q) l# q) q$ _. b1 I5 J
case 2:strDW = "角";break;
G" x4 E1 O0 K$ G! ucase 3:strDW = "元";break; - Z7 q+ T) i% C I7 C0 Z
case 4:strDW = "拾";break;
" ?+ O* S, q& g0 S4 Mcase 5:strDW = "佰";break;
+ c2 k5 ` M( f7 J5 ]3 S4 vcase 6:strDW = "仟";break;
0 _6 n2 I$ h) Mcase 7:strDW = "万";break;
4 Y( n R: v: G% E. U8 U9 z; D- `& Zcase 8:strDW = "拾";break;
- H% Y4 j# n& }% w. ^* F: m Jcase 9:strDW = "佰";break;
: o% x# t O, o" G9 t7 ]case 10:strDW = "仟";break;
6 C5 X o4 L( Ucase 11:strDW = "亿";break; : b. F( _3 W, w$ G/ g
case 12:strDW = "拾";break; ; B! \( `# v0 R2 q' g" D6 y
case 13:strDW = "佰";break;
2 \' e# m7 F/ @8 jcase 14:strDW = "仟";break;
7 M5 N6 z! |/ S. j& C7 n}
) ], s& A# _8 Z; K& bswitch (strArr[intFen-1]) //选择数字
8 t, x8 a+ Y5 i/ k1 }{ 2 I1 f4 p! A e" R& p9 P
case "1":strNum = "壹";break; 9 Y. u2 w8 b; Q! i5 t' n* s
case "2":strNum = "贰";break;
' }/ M' K7 @" E. D+ U0 o" Tcase "3":strNum = "叁";break; % k0 z$ W* H% L) d- @; F. e1 o
case "4":strNum = "肆";break; $ z) }0 o( b$ G( }
case "5":strNum = "伍";break; ) m+ g; b7 @9 l, R! O5 u5 @
case "6":strNum = "陆";break;
1 y4 J. x' e& w- A9 e' R' A Rcase "7":strNum = "柒";break; ; t$ @7 U- N$ V
case "8":strNum = "捌";break; 3 d2 r2 k* Q8 U8 W
case "9":strNum = "玖";break; : W) V, O/ J! B+ S2 h! |, a2 Q
case "0":strNum = "零";break;
& c, j! }5 ~. `/ c: m} |