|
 
- UID
- 1
- 帖子
- 738
- 精华
- 28
- 积分
- 14355
- 金币
- 2463
- 威望
- 1647
- 贡献
- 1411
|
<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"
2 j0 P$ F9 A7 ]( `" J, \& ]( u! c c pageencoding="gb2312": O8 O! a( d! J# z6 x( i% j
%>
& k- N- x0 ?* d1 R- |<style>
4 T: N6 ] x- h* p.f9{ font-size:9pt; }7 |2 ~6 p% m" A8 g
.bgc{ background-color:#aecaf9; color: #0033ff }( Q& C# r6 U+ k1 V: q
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;( }( [# ?, ?* B5 v7 I) y
border-bottom: solid 1px #4e7dc1;
) {( m9 C0 l$ B8 Z border-left: solid 1px #aecaf9;4 Z; I' v0 r( ^$ z Y0 c4 B" P
border-right: solid 1px #5679bd;
* f, D; ^/ X+ E8 y2 b) p1 R padding:1px;1 j5 |* ?4 N7 e5 Q# C* _) y! B
margin:0px;}
" W1 Y0 n" C- {6 M8 v</style>
2 L: d" B% a- |2 T( U<script language="javascript">
' J& b# n" T% }8 v<!--
8 Y8 i7 G5 n% n% o9 cfunction rv()( D' ]: g1 H) C2 `
{; U3 T4 D4 s( b5 u/ M# N
var val="";
) a7 O! ~: d: V5 X2 _0 p for(i=0;i<combo_box.list2.length;i++){
" }7 ]6 S9 \' P1 D3 E val+=","+combo_box.list2.value;, s9 x5 N8 I! i
}& s3 B8 y% M1 z3 d+ g, b
if(val.charat(0)==","){; U. j( Z {' J! g( v; f" c: y
val=val.substr(1,val.length);
0 J4 p5 ^' \6 s( E8 _. m }
: U7 Q0 B9 H- ] opener.form1.frecname.value=val;7 Q4 |0 O. O0 l' U h. `
self.close();/ m* J5 {: W7 o" L* |% S' Y
}
1 I, p( y4 L! q( Z8 L% G7 \//-->
- |# c6 R* i2 v- n3 {5 Z: E. K- w</script>
' C( B3 W+ C: o! q; [) Q<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
" R% s' x9 _$ k<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />
' P0 F( v4 P2 ~& n& [3 v<%
/ r! L' l8 a1 O. Y/ K cdatasource ds=new cdatasource(); //数据联结bean实例
' p0 f7 X* U, F% Z. P! q' f java.sql.connection conn=ds.getconnection();
; q, t1 d3 V& f/ q java.sql.statement stmt=null;
; H6 J7 H4 g# c- w% R java.sql.resultset rs=null;
7 D3 [' }7 Y5 F/ t3 s" n; M0 s+ u cdatacheck dc=new cdatacheck();, E0 Q4 r; Z. j7 m/ c
%>
3 W' M8 z' K+ _$ z* x6 B<%
( ^7 \& }; z- B+ K- {7 Kstring 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";
. }& O" c0 _8 j: F5 U) d @stmt=conn.createstatement();. b# N: ^' V& f9 _0 K
rs=stmt.executequery(sqlu);" Y( u3 H0 k% \+ q
%>
0 o ^; | d3 d2 d/ {' b! ~<script language='javascript'>9 B1 V& r, M! t, \3 y8 w: U4 B
arr = new array();
# Q! F+ R) Z1 @<% int temp=0;3 w1 R! V! e5 n3 \+ G0 y
while(rs.next())
) e; N$ j, o3 T- g- S" ?{
1 p9 H M% r, [! z%>& a8 [8 W0 O# ^1 E7 q" x
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");
' C. u+ C3 U" v<%
" l, ?* y# @. @% F! p: ~+ @temp = temp + 1;4 o* F" y% j" \$ F+ w4 v) H) H
}' i r; {. X2 C# z7 r8 o
%>
* @5 m' N5 ]/ t8 ^0 K+ Mtemp=<%=temp%>;
. S- ]1 O7 d* r) `function changelocation(id){ ) Y4 p; N' X& b; C# o0 G5 R! ~( n
document.combo_box.city.length=0; //初始化第2级菜单的长度，下标从0开始
3 J$ W: _# x E3 jvar i = 0;
" R' I0 @" Q5 C, Q W+ n; Tdocument.combo_box.city.options[0]=new option('-------',''); * |- C! f) @# n: `$ I
for(i=0;i<temp;i++){
8 R. p7 H3 i0 C4 O$ \ i( _- Vif(arr[1]==id){//如果相等，证明在第2级里面有输入第1级组织的子集,arr[总数目][部门] : {! s$ T! t! c* x/ c3 p" p4 \( Q
document.combo_box.city.options[document.combo_box.city.length] = new option(arr[0], arr[0]); 3 m( D O. o5 d! O9 [" c
}
3 q+ K& F* ~: N ]}
: U+ P) c5 Q, `# v$ ^} + N" E3 k7 B" j- [
</script>
: A5 W4 A3 w/ q/ N& e! E& I0 o' C( t r
<form name="combo_box">* b* E, L3 H# v1 S t
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">
+ R, L* I4 S( I. ~5 K <tr height="24">8 Y* }$ i: q2 G9 M; ?
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>; {, S9 s$ B4 l* l4 u
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>
# N5 \( _ ?( H( n' c' i <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>
% |: b, P+ J. L <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>4 g6 C" `0 Z: \7 X5 H( ~" B7 a
</tr>
& l+ m: C( W D <tr> * A/ V o4 Y( r
<td>: V6 t, d" g# s( d4 T
<select multiple id=prov name="prov" style="width:150;height:200" class="bgc">
6 L& ~4 J, d) H; Q# ^; x4 @# v+ e; G <option value="0">请选择部门 ---></option>) Q3 O' q6 @) m0 i: H1 _
<%) ]# `% t1 V$ g0 A
string sqld="select * from tdept";% }" f2 F; T: A v8 C, q
stmt=conn.createstatement();8 P6 T* f8 v9 p% i6 B
rs=stmt.executequery(sqld);& N5 ]" A% ?$ [7 [9 _1 c$ S
while(rs.next())
; Y) ]3 D/ l+ y' j# G$ P" k! x{
; z- b* E: O2 `! F$ ]9 Z2 b o/ h%>
* X5 d }" `% \+ K <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>
9 x5 Q9 L/ @4 E& P; y, I. D' |<%$ B4 j" T# X- {& x$ c, P0 j# m @
}
8 X, U3 ?$ h0 r5 R%>
* o; k) x" N" t* M. R5 | </select>! w( j2 {8 o! |" z5 `) h$ s
</td>
8 H' Q p" [# ~# E <td>
' `; n1 U) |( q2 X1 r0 U <select multiple id=city style="width:150;height:200" class="bgc">
# m/ t0 ]' W5 c9 K- q8 w </select>* y2 {/ I" e% {% W* F6 H/ {( w
</td>, E" \/ ]0 Y) {5 {" y: {
<td nowrap align="center" class="bgc"># L: l' p+ K- K3 O' q5 _* N
<input type="button" value="<<" class="buttons">" c) A% T0 }5 c1 I& F
<input type="button" value=">>" class="buttons">
2 j7 ?% ~; a+ Z9 m' \2 @8 ~</td>
3 J+ h M( Y, t/ F <td>
, Y" h: D+ O$ a# {4 ^9 I <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
0 h* m: `, L5 S' W! `+ v </select>: h& @$ V4 b5 {( X% F' j2 ^3 ^
</td>
8 }9 @# K/ k6 A3 i) h6 g </tr>1 Y7 x" H1 i6 ^ z, l- h( R" p
<tr class="bgc">
* i y0 p# X1 t7 e6 M/ o, { <td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了！" ></td>
( s0 u- Z/ N. ]- ] </tr>
7 R7 ]0 h/ ]1 ]# w$ M" m9 R</table>
4 i! y G5 x. A9 {' M</form>
+ D {' R- R& R/ X" B' q<script language="javascript"> m+ B! C1 x, F0 ]/ `5 G
//人名移动
$ l) w1 g; W, B$ afunction move(fbox, tbox) {! t# P6 z$ _+ H0 T* C i, u; a3 X
var arrfbox = new array();' `( [2 m" ~: r# j- z
var arrtbox = new array();
/ {. T% C& t9 ^var arrlookup = new array();" @- D0 Y- F0 S% e) c0 {
var i;
# o& K3 a4 S5 E% N2 Q) a2 Sfor (i = 0; i < tbox.options.length; i++) {9 |1 k) p( A4 b: X% @! B, }5 P
arrlookup[tbox.options.text] = tbox.options.value;) C( I+ ]6 f. M1 G& p/ g
arrtbox = tbox.options.text;5 P( ~* s& {3 E2 F
}
8 k. _ S3 @$ z, X! U$ B8 evar flength = 0;* y( `4 s& \4 y! A
var tlength = arrtbox.length;
3 `0 }( r& u2 L: Vfor(i = 0; i < fbox.options.length; i++) {
0 w$ a4 [; y9 M" Varrlookup[fbox.options.text] = fbox.options.value;+ I/ x$ \! O C1 ~) Y
if (fbox.options.selected && fbox.options.value != "") {$ G- b, k6 K" j3 T
arrtbox[tlength] = fbox.options.text;
1 F5 C( n2 X2 ]1 D u( N1 Rtlength++;+ g4 ]- f" } c1 b* E$ s* {" z
}- D1 f7 `8 Q$ c; ~
else {
) }, n0 j4 s4 d: D: h3 q, J! S# Earrfbox[flength] = fbox.options.text;
6 L& F& g( q( z0 W4 _flength++;
& r& x- D3 L! P/ f. {5 \ }/ {. H* I z9 ~
}$ f, F, i8 b! q8 I' d) z9 N% m% F& A9 @
arrfbox.sort();8 Y8 v/ e* T! ?9 p, d& P
arrtbox.sort();- d. s' W" j; L9 e3 H
1 E( h- Q8 \. |2 U' Y
fbox.length = 0;; G" ~1 v' \( N# `
tbox.length = 0;$ W$ V( |" J: l( Q" l
var c;: N$ ?! v# A: S
for(c = 0; c < arrfbox.length; c++) {4 { b8 U5 x0 }0 }
var no = new option();8 z8 ]: ]; T. w! `3 @
no.value = arrlookup[arrfbox[c]];7 d" R: T) Q# T$ M& @) J9 F6 u
no.text = arrfbox[c];
* i" I' a, ^ ?% Gfbox[c] = no;
5 A3 h* ^+ @# q7 b}
6 m( n; a0 i; r/ Cfor(c = 0; c < arrtbox.length; c++) {' m& `$ \% ?) R' f6 a0 X/ t
var no = new option();' R7 g1 J; n+ H) ?2 x( F8 A
no.value = arrlookup[arrtbox[c]];
3 x* B6 Z0 S- Nno.text = arrtbox[c];& x" @4 [* l( N6 @
tbox[c] = no;
# P( q9 U' P4 r9 W2 W& r& n }0 R! p0 t" \; l
}% m* ]; x& k+ x* F- Y
</script>
& b0 m7 e1 k7 s5 p" q2 d1 ?, C</body>
" j5 c% ^) s, ?2 l0 n |
|
发表于 2007-12-5 17:43
| 