|
 
- UID
- 1
- 帖子
- 738
- 精华
- 28
- 积分
- 14247
- 金币
- 2414
- 威望
- 1647
- 贡献
- 1362
|
<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"4 X. K7 \3 ^9 U. q
c pageencoding="gb2312"' T* |2 R1 A7 c3 X
%>
, U4 T" }, @. F l, O<style>5 t( `1 J! ^6 u+ Q! m
.f9{ font-size:9pt; }1 x) n6 h( C5 J( ^
.bgc{ background-color:#aecaf9; color: #0033ff }
g2 Q# @$ E* a3 C.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;
: j4 h0 O& J- d7 d! X4 m( t" L border-bottom: solid 1px #4e7dc1;. W9 n, D- {/ u
border-left: solid 1px #aecaf9;* A4 a3 H* Z* H) P I. d* j* W
border-right: solid 1px #5679bd;% V( W" c1 W9 c* \' y
padding:1px;' x. l$ Z' ?, K0 M& J
margin:0px;}
& E% K4 o3 Q+ O$ k/ j</style>6 d1 e3 N9 r) T/ {! B, t, E
<script language="javascript">
4 w' h: [0 t' z: R" E7 f0 b& M<!--
: A& c: i+ J- ~ N& Xfunction rv()
# M. h5 k* a# w{, h" U7 \7 ~5 Q8 D* @
var val="";3 N: k* B" P6 }9 a3 o+ x
for(i=0;i<combo_box.list2.length;i++){
2 j# E# H- t% @0 W) c$ O9 H) V& ~ val+=","+combo_box.list2.value;
& U' J$ n# [( ?8 \ }
- o. c) ?4 [) R( @$ U( D; P if(val.charat(0)==","){* i: \! Z7 @; R5 J, s7 a
val=val.substr(1,val.length);, A2 y3 Z2 w& i! G) ~2 s3 Q5 c9 S- E
}
) a) v$ j5 X, f opener.form1.frecname.value=val;
: Z% d# y) ~: }; C0 f- H self.close();: `9 O1 O# p& t8 n" K1 T" u
}- `" u# b1 U/ R6 ]! O
//-->0 L* q v/ B6 n0 f! ?8 y
</script>" S& X* b1 g3 a a
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
6 w- n, q5 ]7 I7 c: x<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />
1 p6 N) \$ C# \% @ k% H0 d! T<%& `+ q; m# z9 @0 `8 w1 U
cdatasource ds=new cdatasource(); //数据联结bean实例
# t- w3 p: x( d+ x4 y java.sql.connection conn=ds.getconnection();8 P+ ~9 x- Y+ {2 L J3 z8 V
java.sql.statement stmt=null; F9 z) C+ E2 O
java.sql.resultset rs=null;
9 R, I y) P2 J5 n5 J cdatacheck dc=new cdatacheck();
6 U) h. ], T3 a( ~& |; K& e" F%>
. G" h1 X* b; t<%
; ^9 J# _+ z: S1 l/ ?string sqlu="select t1.fno, t1.fname, t2.fname as fdept from tuser t1 left outer join tdept t2 on t1.fdept = t2.fno order by t2.fname";
) T. c; l+ L. \+ dstmt=conn.createstatement();7 F1 g; N- o, p6 v# ]
rs=stmt.executequery(sqlu);; |8 {* W4 Q. Q Z0 z! i
%>1 c; ]& ]5 Q1 f( m1 m, ~; I
<script language='javascript'>6 f+ [5 E0 p( D% ~$ A" K
arr = new array();
+ @. h) ~. ~2 U- z2 s9 P<% int temp=0;5 O3 i/ o* ^6 {- f% h& I" `1 |. e* S* R
while(rs.next())
9 i# B- K/ [5 a# ~' ~) L{( q& s2 i2 @. s
%>/ ?8 P/ T N- M1 A9 j: Q4 o+ U- }
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");5 Q% j& L2 H, ~& }8 d) u3 }6 ~
<%" ?$ k) D1 m. u
temp = temp + 1;5 u* X2 [ ? F1 p. z$ s6 c/ R
}* }& D. F/ q+ ^
%># V/ R: z; }0 O: V/ L) S
temp=<%=temp%>;7 O; [7 b3 u* N, D: z! M' K; ~
function changelocation(id){ $ e, |& Z- R( E: `; ?
document.combo_box.city.length=0; //初始化第2级菜单的长度，下标从0开始
5 v$ m& }2 |$ {" D8 I2 avar i = 0; / E+ D! M {7 R7 S0 \
document.combo_box.city.options[0]=new option('-------',''); # T: k& z% O' s
for(i=0;i<temp;i++){ ' |. K3 c7 c8 D- O% o/ H5 i5 Y
if(arr[1]==id){//如果相等，证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
1 f- E/ W8 w9 G8 u! Cdocument.combo_box.city.options[document.combo_box.city.length] = new option(arr[0], arr[0]);
; D! l1 q% a- n1 c8 q, O+ z$ L} * W8 M5 y( U7 F2 y) d) R
} 9 c% r+ H( C# r7 y, |
}
2 C$ H* i* ?4 X7 t</script>0 M: x. b/ N% P+ ^6 {; Y
7 u6 |$ X$ L3 \0 s$ ?<form name="combo_box">/ M* p" ]2 R# d1 p! r( a
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">
' D+ i; l/ {7 Y9 u* y <tr height="24">
( e4 K$ ^$ f: C2 B6 G <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>4 C1 _3 k; ?2 z0 d8 d4 W, h
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>& t1 }8 m2 l* H ]
<td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>1 j: C$ v$ {. W k7 t
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>% n& H) h& K0 D' \- t# s) M' K. d
</tr>
8 N- D: R- B9 V% u% _ <tr> 4 c Y+ u- M& u7 D( |7 Z
<td>
8 x* U: R7 T$ d* Y" t4 R <select multiple id=prov name="prov" style="width:150;height:200" class="bgc">+ O9 k; D H5 N. g6 z
<option value="0">请选择部门 ---></option>
8 j% ^9 x, \* g1 V) n% V<%
8 ^( p, i0 m; [& S) b) P string sqld="select * from tdept";% S2 _! o7 i9 c' `! P( s
stmt=conn.createstatement();
2 f8 W4 _/ ^( z1 V: o4 r; `4 qrs=stmt.executequery(sqld);. Z/ B' R( e! u0 a
while(rs.next())$ ~* H! Z2 K% x6 U5 s d
{5 Y2 c- I8 Z T8 T- D3 W8 ?
%>
# i4 L v) p$ H$ C h* m6 U% n <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option> X l" O" t' u
<%' X/ u% k1 [( _6 u1 g) v' L$ J
}" z+ q" o! w9 T: B' ~
%> % ~, x1 T4 n3 i3 l! u' E
</select>, V8 X. S5 g$ `) e9 [
</td>- N' \' w' h# Y& N, u* g# {
<td>
/ X( v3 r1 I+ a/ c- F% v) Y <select multiple id=city style="width:150;height:200" class="bgc">
1 R- b- I( L/ u2 w </select>
# `% a2 S- k2 c5 n& v</td>
2 U4 Q2 `3 o0 d6 d2 p) w( \/ q <td nowrap align="center" class="bgc">
5 r! G! ]! e) Q5 T <input type="button" value="<<" class="buttons">
- v# J' q5 Q6 } [7 F <input type="button" value=">>" class="buttons">' ]/ w% b. S5 S: J! W/ o" }# ]
</td>
3 H& S$ C* ]2 S: e1 ~- y7 ?! N <td>6 z2 J& \; J2 K3 E8 G
<select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
" G0 ~' @- z! @- E T$ R9 C+ r$ e </select> U, M, T: f, ? ^" Q4 Q3 J( R
</td>
: O5 _- K% S9 n' \" n </tr>
: }; J0 { r5 h7 I6 }4 V <tr class="bgc"> 7 x/ q7 {1 h3 L$ d3 ^& K- W# k
<td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了！" ></td>- q" W: `; s! M) f! b' D
</tr>( z" s q: b2 i, ]8 H1 s
</table>
9 j, J1 K8 c. j8 X! h9 _1 h</form>
% E# L% {9 |: k* j ^0 y3 W<script language="javascript">2 z5 W8 v3 k! H9 U, l& s
//人名移动
0 { v" m; D! l l7 `function move(fbox, tbox) {
. \; h" B; t1 G" x6 Nvar arrfbox = new array();
$ a$ G$ _ `9 H3 ^var arrtbox = new array();* R3 J5 H- d. c# T3 ^
var arrlookup = new array();& S5 n7 D4 g) a+ X# R# u
var i;* \& T! o3 F, H7 C2 r! J
for (i = 0; i < tbox.options.length; i++) {
( N0 E( f! r( Carrlookup[tbox.options.text] = tbox.options.value;
4 ~, M: w' b5 T2 {! \( {arrtbox = tbox.options.text;: Y) H* Y' x" X
}! H" d! A: @2 N% N
var flength = 0;
! L3 P2 T# i1 D# u* {: x4 ~4 x6 Cvar tlength = arrtbox.length;
" [. X9 _ g( u" \3 T _1 rfor(i = 0; i < fbox.options.length; i++) {: E. E# Z) ^: [* H
arrlookup[fbox.options.text] = fbox.options.value;
* }! @6 g3 j" h& a" h& c" wif (fbox.options.selected && fbox.options.value != "") {
6 A. V6 C% z& N3 y* \. carrtbox[tlength] = fbox.options.text;& c; ~. a/ p ?4 s5 x) q4 {* ]( I
tlength++;6 z4 K4 \8 b2 @ y( S
}
* W5 \2 _7 X& [9 B* O7 K) Z) T1 jelse {
+ t5 }+ Z1 W9 `7 j4 `arrfbox[flength] = fbox.options.text;8 V/ S* g8 k6 D/ y
flength++;
* Q0 V! I' D c7 W v1 g }6 |4 m3 V, s6 W. q _
}
1 r! H+ `/ P8 f% y+ e2 U ~arrfbox.sort();; Z+ h8 ]8 G) @9 j7 R0 R
arrtbox.sort();; j! @; p- g; E5 j( ^8 L! s
i; o( F9 o- ^3 `. Jfbox.length = 0;5 s- g5 I: Y9 w) [+ c5 [2 W
tbox.length = 0;
+ n! h- i, d7 }3 K. Ivar c;- y8 g! ^9 V b9 C$ s
for(c = 0; c < arrfbox.length; c++) {
, @) A4 u* A, d, K2 I0 Gvar no = new option();
% ~% R- S& r9 [9 G% H- W nno.value = arrlookup[arrfbox[c]];
9 ]# ?1 C4 n5 I# k/ O5 xno.text = arrfbox[c];' e8 i5 j& k/ i1 Z; |, o# ^$ {
fbox[c] = no;( A2 H R0 J* P' P& x2 S7 }" R
}, @( W Y% v- t% x# D( H
for(c = 0; c < arrtbox.length; c++) {# V/ \$ @. h$ q$ T! t% H0 M
var no = new option();( m& Z8 t3 K# X* e
no.value = arrlookup[arrtbox[c]];7 F; Z, Z- ]. F* N; ^) O. J
no.text = arrtbox[c];% K- z9 q% k% H
tbox[c] = no;( K0 T% r0 {" L7 A% |0 n
}
4 L% ^2 m! g& E* ~2 z}! W6 s7 M. @' j$ l
</script>
$ t/ R( [6 R6 ^: ]. K2 K/ j& l</body>
. t$ m3 ]- X5 B4 p |
|
发表于 2007-12-5 17:43
| 