|
 
- UID
- 1
- 帖子
- 738
- 精华
- 28
- 积分
- 14427
- 金币
- 2499
- 威望
- 1647
- 贡献
- 1447
|
<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"
5 H% ?0 B+ \ U* x; S c pageencoding="gb2312"
6 d. j) d: G3 k& b, I/ i%>
' ?! f8 x9 d- W3 U1 b; q( k<style>
* F( G- X( r# Q0 Q.f9{ font-size:9pt; }/ M* N, ^* a1 H
.bgc{ background-color:#aecaf9; color: #0033ff }% f( Y/ F4 _% U2 I" C
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;
8 ~: L2 Y0 j! `9 @! Y; G. O border-bottom: solid 1px #4e7dc1;9 {. s! v4 l( o$ {
border-left: solid 1px #aecaf9;& r1 A8 c0 a9 {# o* H. ~, d3 t- G
border-right: solid 1px #5679bd;# M' _3 _3 y' O% J! R
padding:1px;9 y* F6 b, c4 l9 G9 Z$ U1 `
margin:0px;}& O6 n) q x' |9 t$ C0 x, A* y
</style>
, x$ _ o' @6 b1 t0 X: k4 i$ I) J<script language="javascript">
: b" ?$ D8 B+ ]+ n0 z* u<!--! T0 ~3 b2 j" M2 |" A# y. q3 A6 l
function rv(); A, _+ O( v5 U p+ k( u
{ L" z. Q3 ^1 |% i+ v. y8 U J
var val="";
) }# m# X. M m- K. o6 a( z& ? for(i=0;i<combo_box.list2.length;i++){
( q- z4 q0 |) f2 H val+=","+combo_box.list2.value;$ ]) q9 m/ @7 J) q: \4 |
}5 F2 C" j; a9 G, S2 Q
if(val.charat(0)==","){. z8 E: h" r2 n" }$ o9 I
val=val.substr(1,val.length);; h! k# {4 h3 s
}) ^. ?& c- K+ ~- E2 c3 o
opener.form1.frecname.value=val;
; q+ B, z4 v4 n9 `/ U/ ^ self.close();
" A F, X. u9 U# `! n4 P}
6 _1 K7 M2 W4 _: E& M7 }" k' @% w) g//-->
$ D. T* T& d# X( g</script>
9 ]* P3 Y0 E# d. K8 Z) Y<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
3 C4 y0 X7 N% [4 k6 r<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />
" |/ J0 n" p9 w* d<%
/ I4 s; s7 [8 j- q& q( d cdatasource ds=new cdatasource(); //数据联结bean实例
2 {' u1 {; P1 x& B5 m java.sql.connection conn=ds.getconnection();( C8 J/ Q$ j9 b8 J
java.sql.statement stmt=null;
- A) L) V* v8 y2 Z7 u" T java.sql.resultset rs=null;
. f' ^0 [1 f0 j: h9 s0 l9 I cdatacheck dc=new cdatacheck();+ \% I4 x/ W- Q# I
%>8 C" N9 S8 W" P- p5 C
<%0 i9 \6 B6 N0 f# N; J
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";
+ ^7 t5 D. Y9 x( Y/ y/ \4 Q8 T& \0 x7 hstmt=conn.createstatement();
# v5 k: ?- G9 Z: x: Crs=stmt.executequery(sqlu);/ q7 Y; z, x- M& ~, z8 A
%>
: I, W8 v" P4 i5 W& O- F3 B: B4 p<script language='javascript'>
/ ?' l$ O3 n: Q# G8 ~5 Zarr = new array();
8 W5 V' l$ w) ?8 P4 @<% int temp=0;) j0 J8 Z; n! A/ S6 B- {
while(rs.next())
0 C2 f! N: e$ Y5 E8 D{
. e: l( ^3 ~( ?+ r2 h; @%>1 D/ t' c0 I- C8 K. v! Z% g
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");
/ J0 O5 j3 Q# T, s- l0 i<%/ h1 E( }/ S5 h( l5 V
temp = temp + 1;
$ q/ _) U5 B! l9 w}0 \. e; j- C: u
%>7 ]0 x' G3 [ J5 U' M% B
temp=<%=temp%>;9 D h- x d* p E6 u5 g
function changelocation(id){
6 M* i# u& E1 v# m W. `document.combo_box.city.length=0; //初始化第2级菜单的长度，下标从0开始 3 f3 G+ O- L5 B: J4 ] J: a7 `5 c
var i = 0; * l0 m6 Y" w+ n0 C! r" ]; T
document.combo_box.city.options[0]=new option('-------',''); p) ^0 \! m! Y
for(i=0;i<temp;i++){ 9 x6 N8 a% [$ b2 M8 Y7 z
if(arr[1]==id){//如果相等，证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
3 ^) ] s6 Q4 Y. Tdocument.combo_box.city.options[document.combo_box.city.length] = new option(arr[0], arr[0]); e z# o1 ]: `% r. S
} - |7 ]) \, V: Y/ x2 B1 n
} + h5 E7 P# M) B
} % R4 \9 v$ M3 E3 K+ {0 T
</script>
, e$ f9 c/ I5 f4 ]. O
i8 r( |' b8 {5 c) v$ V) ?<form name="combo_box">
% c. O A0 }3 _9 X) n: S- z<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">
: V4 `/ L% F4 I& F) K2 @+ I <tr height="24">7 V: k* \6 T5 r2 C4 C4 G' }3 W
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>
4 M4 p. D0 y$ K9 q+ C; N <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>
" v% F# y" H; e/ r# H9 U <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>" ?' M2 _9 L" y8 r# I$ {
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>
9 s# f2 N. }7 {& d1 {1 Y: @. k </tr>3 k! J- D) H# s s: ?. |9 n+ ^
<tr> : x$ P' [) b/ J* X8 x% w+ ^
<td> V9 Z4 N% |* ]. w& u: t$ \
<select multiple id=prov name="prov" style="width:150;height:200" class="bgc">9 w8 X R% B, w0 ^3 W
<option value="0">请选择部门 ---></option>
& G0 x; k* v& `- R<%* h% w! T. L$ A5 |# J" e( a
string sqld="select * from tdept";
% ^8 U; n7 L" g; U1 Bstmt=conn.createstatement();
1 _; E4 `% E& g# e5 }rs=stmt.executequery(sqld);
( a. c# t. B) r+ t/ | Vwhile(rs.next())
# A* k2 f( x3 }' {, _{- q5 M1 P# S$ z+ `) A% A
%>7 m8 R: E/ x# y) b. b* I
<option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>4 G- M$ @' m1 u% f! q B7 v
<%% J0 h( `; {5 n% E; l! ^
}/ t' p L p$ ?2 u5 n4 v
%> ( J5 A% r: G( I- Q% c7 K
</select>, E3 o! `3 j5 T6 X2 f; m9 N
</td>
% C0 T( z; P ?" N <td>3 `9 G+ e7 m# l$ D; E. p$ y9 g
<select multiple id=city style="width:150;height:200" class="bgc">1 e, Q" T5 h+ z: D. i
</select>
+ m/ m' o3 L/ Y: \% `' y0 A7 L</td>
. `: I4 j0 r3 l' K `9 W q; y! M <td nowrap align="center" class="bgc">, D7 p( ^0 B. A X3 u
<input type="button" value="<<" class="buttons">
1 s2 V; B1 I5 P5 t <input type="button" value=">>" class="buttons">
& X5 c- C1 C. \0 L7 }</td>
% Q8 }5 R0 M! ~# B/ D8 ^ <td>
+ l. [/ N: U% { <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">) _. T/ F, A: K3 Y# O' R
</select> W- I0 c+ Y3 E! o) |. ?% {0 }
</td>
( q) Y. ?% d/ o2 t7 ~' T2 T' E </tr>- n( t' X) ?& v, R! k& `9 r/ c7 d
<tr class="bgc">
& J2 S# X& y4 Y6 c; D/ d+ U3 S <td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了！" ></td>
" i- P1 ]' J+ N/ @5 l& h8 u </tr>
3 _2 D" o* [( d3 V) r</table>/ Z, h& g* I) I2 o# t2 ?! h
</form>- g& o: e( w, n
<script language="javascript">
, k8 K7 N; u# _3 i" F% u//人名移动
$ Z0 `8 O3 I$ hfunction move(fbox, tbox) {
2 g; j9 q! A) D5 R( p: Lvar arrfbox = new array();
( y3 b9 [4 C* t7 h1 xvar arrtbox = new array();6 Z7 ?$ Q: v5 \% A; K$ S% m) Z; H
var arrlookup = new array();/ y$ \4 w6 N' S8 }; x4 H9 ~, _
var i;
7 v; M1 t5 M/ _0 R4 ^( L' }" v ifor (i = 0; i < tbox.options.length; i++) {; h$ V. Y# p" W& S1 `" z
arrlookup[tbox.options.text] = tbox.options.value;4 `- O |$ w B0 _
arrtbox = tbox.options.text;6 V. r: r+ ?# s* ~% M) ?" `3 X4 }1 m
}
' @) N, b7 ~/ _5 O/ Uvar flength = 0;; F/ e }7 h2 g- p f
var tlength = arrtbox.length;
: B0 K9 H: g6 F) Q9 M. w$ ofor(i = 0; i < fbox.options.length; i++) {# Y# n# B6 }' @% e. w7 H
arrlookup[fbox.options.text] = fbox.options.value;
2 A, x3 }% m& M# X: V; R5 [8 a9 b) Vif (fbox.options.selected && fbox.options.value != "") {3 |2 m8 u' V( B3 k
arrtbox[tlength] = fbox.options.text;
* ?" R, v& S9 D5 m2 z$ s: F' Qtlength++;
$ @% r' I' I/ a4 W5 ?5 a}
$ u5 m2 w3 h; b+ delse {" a. i3 _ s w5 E) v8 T
arrfbox[flength] = fbox.options.text;
, x! B _6 Q/ b+ p. v: o- u/ z: F: D9 Rflength++;! D( I% q/ k2 N6 G. T9 B% G
}
' G" ^4 ?+ h. ^* P}
. R7 x# k% \) T& f$ t- h) c7 @# `) farrfbox.sort();
; z: J' D4 u' X# f- y& `; m' F* S4 Rarrtbox.sort();
$ A6 n: |/ }9 h
- g. h5 X1 L1 I- Z* `fbox.length = 0;
4 {6 D+ y$ |) l5 |& h0 Ktbox.length = 0;5 U o9 l9 D: z3 y. x# v2 r
var c;
8 @* P$ O% [$ f3 W% o% g6 q& s# ofor(c = 0; c < arrfbox.length; c++) {
/ A# B* l) f# I/ |2 v) ~8 Kvar no = new option();
) [3 i2 u% a$ e: x0 L' \no.value = arrlookup[arrfbox[c]];
0 j+ D- J3 D6 ^* Z0 t5 Ono.text = arrfbox[c];+ ^* r0 W7 H. [8 k- Q
fbox[c] = no;$ T3 }7 |0 n5 r3 d# U
}
2 L, n) Y1 I+ l1 S1 Nfor(c = 0; c < arrtbox.length; c++) {6 C2 P8 b9 w7 x; p/ Q
var no = new option();
2 j) B3 R- C' s; {. r! _6 N6 h4 n0 Hno.value = arrlookup[arrtbox[c]];
( U z) [3 z, m1 x6 A4 t2 |no.text = arrtbox[c];: x. ~: e) e4 @/ ~* h) \0 z; ]5 r, f
tbox[c] = no;
& @( K1 F' [5 y. D) m7 y }
9 h; n3 H0 W- |6 O}1 w6 i, @* Z7 `8 h5 Z3 ?
</script>
1 M6 }! S! Q$ P! _$ C2 h& @</body>
$ S0 A& K o9 _! f |
|
发表于 2007-12-5 17:43
| 