|
 
- UID
- 1
- 帖子
- 738
- 精华
- 28
- 积分
- 14381
- 金币
- 2476
- 威望
- 1647
- 贡献
- 1424
|
<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"
0 X7 g% E3 G1 O c pageencoding="gb2312"
G0 V) [1 h3 e2 y%>/ C; ~/ B5 D8 z: z5 X. U8 Q
<style>
8 g; K V4 H& S9 X3 ].f9{ font-size:9pt; }& z M7 v1 E% v& `! d
.bgc{ background-color:#aecaf9; color: #0033ff }3 g$ Q. {' o) |$ y/ w
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;
$ @+ o3 s0 q9 X" R border-bottom: solid 1px #4e7dc1;
+ A- H; i \! h8 d$ B4 Q border-left: solid 1px #aecaf9;
! b% F+ \# G: P" O7 ~" ] border-right: solid 1px #5679bd;
/ @$ a* m8 m! C1 c padding:1px;
' p) J! |# H9 \5 i margin:0px;}
. s/ C$ `8 r: h7 }5 U; |- A</style>8 J- U$ V1 X+ P' t+ W
<script language="javascript">
& G' }* |+ I: N3 g<!--
( C& _( b8 L9 D! u9 a7 Vfunction rv()
3 N( m% D2 b# M0 o{$ v6 |3 `$ O' ~2 s6 w- d
var val="";
* p/ ~% U { O) }/ j& `, c' c for(i=0;i<combo_box.list2.length;i++){* f0 {+ J# k' X7 r
val+=","+combo_box.list2.value;
+ }6 p3 O& h1 N }
% J/ @, K- z" q9 m if(val.charat(0)==","){( A9 a! p) Q& u: o& B' u2 B9 ?
val=val.substr(1,val.length);5 g4 w7 @8 k# f0 x4 p6 s
}& _/ [2 ~! y% x8 Z# v- C
opener.form1.frecname.value=val;
6 ?2 k/ B b0 s+ R self.close();
t* I- g4 @+ O1 Z}
1 }9 z6 ]8 Q8 ^" N//-->
: ~, `% J2 S" a/ O</script>5 o& O- P2 }: q2 {" p& I; [ }
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
2 X* D: y! N r+ O: Y6 Z<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />
% y$ k9 y0 t3 b; F<%6 J* T2 I; t+ _5 u
cdatasource ds=new cdatasource(); //数据联结bean实例+ h$ i$ {2 R. ^% p( H7 D
java.sql.connection conn=ds.getconnection();
' l& n4 R2 |+ \ java.sql.statement stmt=null;
; c+ ~& y& _5 E' E; p( @ java.sql.resultset rs=null;! K3 E3 e0 `9 b
cdatacheck dc=new cdatacheck();/ r! C, u3 q: [) _( \5 G2 R
%>: F& r: R: x- D0 R) o* I
<%/ j) z0 w m. _. k5 X# W& ?$ P
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";
- L7 E( c4 O" a. D; o: lstmt=conn.createstatement(); k: U9 |+ S/ F
rs=stmt.executequery(sqlu);$ o, V6 n) W% D6 b+ o5 `0 Y
%>
) d" I& P3 ?6 W1 l7 |<script language='javascript'>
: H$ C4 m% n9 X, v o5 larr = new array();3 V& q5 V1 I7 m! x5 l
<% int temp=0;
2 U" M7 O# R/ ]) i( {; @4 Twhile(rs.next())
% h8 N: e% _( J0 t% ]9 _{
7 T. g3 n9 C! I3 B. j1 e f%>) e9 j0 z4 X, R8 w. }( a7 x3 W6 Y
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");- X. p; v Z7 f# ?$ t& g0 b
<%
9 B {8 C$ I8 f, p" c Atemp = temp + 1;
% N" H) I$ [$ h) m+ c}+ V3 R7 @: f7 Q' b# `
%>
0 M$ Y ]' f" ^/ q& E* U3 b' p9 Dtemp=<%=temp%>;* T) V! R' h- l+ _* J
function changelocation(id){
" f& j4 G* }. x7 P' c. c6 y7 Jdocument.combo_box.city.length=0; //初始化第2级菜单的长度，下标从0开始
( r' r( M# _( N% l3 Gvar i = 0;
" Q6 @% n0 `. k {0 C- l" Kdocument.combo_box.city.options[0]=new option('-------',''); 1 F& k- g3 e- F9 P
for(i=0;i<temp;i++){
+ r, d$ F; p' w) W3 I8 d& Sif(arr[1]==id){//如果相等，证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
& l6 |" S. H9 `, n1 N7 f2 Tdocument.combo_box.city.options[document.combo_box.city.length] = new option(arr[0], arr[0]); 0 M+ {7 @+ {' H1 v
}
. x, U/ s2 i0 `1 o}
" N% u! l' y7 j. \/ P" I: z; t3 V3 G}
4 G- V! G+ v; Q8 f" e( @, D; M( o</script>
; Y* S5 D5 e% D1 n' m' h! K. T6 k7 U
! k( @" T$ j$ e4 S- {6 y9 @<form name="combo_box">. ^9 K, Z. N( l8 F6 D. r
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59"> z8 e' i1 S) }( Y% E
<tr height="24">
! @0 L6 r9 u+ t% \% x/ M8 ~ x <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>5 O; ^, F8 ^" r* {& G# l
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>& Q# u0 ?* ?) P' E6 g+ U
<td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>) n k3 T% V4 t' @
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>* E4 H: {* c q) Z$ G8 |
</tr>
$ O& f3 H+ k8 X- L) I, _) } <tr> " Q: {4 b2 ]/ x3 I# h
<td>
1 Q2 r3 {0 q' `) b1 i5 D <select multiple id=prov name="prov" style="width:150;height:200" class="bgc">
5 N. U& I! w* a% R( y <option value="0">请选择部门 ---></option>9 }# }/ n$ _8 |) K& v9 ~/ [. r
<%& R2 L! [" O3 X' I
string sqld="select * from tdept";7 R- w6 }5 B- K. h) q$ t4 ]
stmt=conn.createstatement();& f, j& m# l3 N! f o) D, X( M
rs=stmt.executequery(sqld);
* ? k5 v5 M# q& x9 j9 l0 [; @* jwhile(rs.next())1 t( N$ w, O# t- ]& ~# N/ b
{6 c7 N+ C8 }0 P
%>
) _' ]* l' {- L L# g* K; w6 e <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>
2 ~8 f% @) K( A) W& X1 h<%) }; b! V1 \: z
}9 W7 K, X6 x8 u8 H2 r
%> ( K+ M/ Z3 U( ^
</select>
/ |8 h/ f" i7 n9 a ^2 V</td>
: {3 u+ D& F. Z' x6 e <td>& V0 j& D5 q( }' T: A3 N2 _
<select multiple id=city style="width:150;height:200" class="bgc">+ s" `# V- d Q1 b# O
</select>) L2 y6 o# D. F" } a
</td>
% U- S1 E% f, I <td nowrap align="center" class="bgc">6 Y F$ [# Y W5 C8 _+ N" h# x7 F5 b
<input type="button" value="<<" class="buttons">0 ^$ a( Q \7 V, a
<input type="button" value=">>" class="buttons">
) ?$ G- q% O V( Y# v3 P6 }1 P# s- P</td>
8 v0 {- q9 Z: u7 m0 C+ O' ` <td>
; J' G: \2 n: Z. {, B4 w) E. D <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
+ _6 T& L: T: {6 D8 K: S </select>
4 O1 @& t: y4 J" n( i</td>
, E6 L8 O# ~8 p+ E _ </tr>
) b$ r% v/ W) ^1 n- R6 C5 t <tr class="bgc"> 7 c- x7 r1 }3 M: F/ Y# d
<td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了！" ></td>0 g: M% x- V D# c+ ]3 O" e( @
</tr>
8 z' `$ J( P8 J+ f</table>
. U* P3 _* q; L- v7 b( @1 L. k/ F</form># p: ]; P% r# V; c( P
<script language="javascript">
4 x R9 [* T. O! n# t: }. ~1 l& t$ F//人名移动
& a4 r( Q! i# C; V" Q! y6 Qfunction move(fbox, tbox) {
; \5 N: z! P5 D+ Z9 l+ u; [0 Yvar arrfbox = new array();
8 f6 d" {7 E* |$ z- m! pvar arrtbox = new array();
6 B# F9 G' h( {6 U9 y& S& [3 V2 m$ Ivar arrlookup = new array();# k8 t: m) X( a
var i;6 w& K' ^7 K2 u$ l' _3 B
for (i = 0; i < tbox.options.length; i++) {, p* U& z( P' Z
arrlookup[tbox.options.text] = tbox.options.value;2 y/ Y: g' Z- F# f" p2 L
arrtbox = tbox.options.text;
3 F/ W) c9 m4 i+ D: f. W) j}
+ ]3 Z, c6 e, g" L' m! p) E qvar flength = 0;0 g( \7 q& y* w' U# a
var tlength = arrtbox.length;1 ^. a$ g( R; F: t, ]
for(i = 0; i < fbox.options.length; i++) {
% ~0 k' U' W" f3 i& q- s+ sarrlookup[fbox.options.text] = fbox.options.value;* X$ d* b% `; B9 @9 Y3 E5 h
if (fbox.options.selected && fbox.options.value != "") {$ D+ C9 j9 S8 K6 d% ]; V
arrtbox[tlength] = fbox.options.text;1 ]: m/ [' V7 ]
tlength++;& R# O& r; w1 D: W" m" K d
}
6 B# u) }5 a1 z: y5 [' c9 ?. }6 Selse {, W; c2 n( f6 Z8 _. W" z0 U' H
arrfbox[flength] = fbox.options.text;+ Z4 i5 n, c7 Y3 _$ w6 r+ z
flength++;) o5 m4 c' E9 ?- Q) i/ \) m
}
6 m5 y+ m2 Q; {& [: m% ~+ I}6 _2 W! @. a- j6 r8 q3 V& _
arrfbox.sort();, B) _% m3 U p" S* ]# v
arrtbox.sort();
. f s' z$ v+ S0 n& k0 ~, y, M" G) y
/ K$ N8 H7 g8 Y. ^$ ?1 l* R5 Wfbox.length = 0;, P1 }$ Y+ Y0 h; q
tbox.length = 0;
9 l2 ? F: X7 Ivar c;6 L& M- \$ I( L' s( ]" C) T
for(c = 0; c < arrfbox.length; c++) {+ U3 [2 B* W& [) s9 P! V/ R; n7 z
var no = new option();6 C, L# t* j- g0 k0 w6 `9 ]4 o
no.value = arrlookup[arrfbox[c]];
8 _+ ?$ b1 p9 c9 ~/ Nno.text = arrfbox[c];
6 o0 b2 n$ R( |6 n- E; p% w+ Ifbox[c] = no;
9 u5 R6 l. k3 s" Y% @/ ]}# o) [6 C$ R% x# G
for(c = 0; c < arrtbox.length; c++) {
+ A, |# [9 }1 e) Y$ M6 Ivar no = new option();% r# k* z% i- L0 B1 w) L
no.value = arrlookup[arrtbox[c]];& v- n4 v; j3 q1 K
no.text = arrtbox[c];
& k! Z7 e$ M7 ~0 P& m# D8 k0 etbox[c] = no;
3 H9 P8 a9 C- z; f5 [) d5 x }% Y: U; ^3 k' _0 p- L6 S
}
+ O' y0 T( }: L4 C( p0 |5 m3 @4 T# ]</script>6 u# q* x/ i' i, @2 W5 j
</body>
3 P. e$ M2 j& O3 I |
|
发表于 2007-12-5 17:43
| 