|
 
- UID
- 1
- 帖子
- 738
- 精华
- 28
- 积分
- 14325
- 金币
- 2448
- 威望
- 1647
- 贡献
- 1396
|
<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"
+ h- F7 z! U8 B. J- l c pageencoding="gb2312"
H% p% \( l/ `6 l%>
- c8 m% \5 r1 @* E( G* E b) ^4 r<style>
. a7 |1 {' L/ @7 A& O.f9{ font-size:9pt; }3 ?, c z3 a3 m) t, D% w
.bgc{ background-color:#aecaf9; color: #0033ff }
9 D% n6 F6 y( _ m) ~" I. ~' ?.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;# Q% \6 n, E- U0 I7 _. B
border-bottom: solid 1px #4e7dc1;9 }9 |8 o0 g9 v+ W
border-left: solid 1px #aecaf9;+ h+ u7 z! `, K' F# r) o9 r
border-right: solid 1px #5679bd;8 f& U* @5 a! w# L, s; O
padding:1px;
5 Q( H1 B; N) Z margin:0px;}2 C/ i) ]: Q' l3 Q* Y
</style>
! g1 l: _; f# K<script language="javascript">6 y. g5 J- M0 u. J, e4 e: B
<!--: u4 ~9 i" W1 s `6 w1 c- U
function rv()9 v0 s( {: d, L3 W* o0 \9 q+ c
{
& c4 ^% ~; y, ?, N+ q1 L; u var val="";9 V% S* }2 U& {. ]3 s
for(i=0;i<combo_box.list2.length;i++){
# D( V8 Z, x5 a val+=","+combo_box.list2.value;! ^+ D) z, X2 d% k ^* L
}
7 O) m& U3 |2 @& o) _ if(val.charat(0)==","){
, n" t9 l8 w/ C; _6 l! B/ y val=val.substr(1,val.length);0 X+ W5 y8 {& R/ G2 g
}
! r9 T) ]1 R! L6 n- b: M# o% V opener.form1.frecname.value=val;
- O: M2 b9 ~0 l0 m2 l self.close();$ G" x. x3 Y. P
}
, m+ a/ r: _( H+ }3 a# W( L, F1 M//-->1 F* {% i) @- K y3 V3 v
</script>) P e) L$ Z- ~7 o$ X2 A
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
$ L% K$ u7 s3 M9 ]! a5 C1 Q0 b<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />
9 T" M* a* J+ }4 k% h+ Y' Z<%1 q5 s" [' A) q- W6 [3 A% h
cdatasource ds=new cdatasource(); //数据联结bean实例2 l0 M, [( x/ W% a/ X
java.sql.connection conn=ds.getconnection();" N& Y/ V D$ }* t: T) k
java.sql.statement stmt=null;
; B1 \0 @9 D$ { P java.sql.resultset rs=null;: Y+ g% x" N a; G9 ~6 D4 N; l
cdatacheck dc=new cdatacheck();
: c7 r, _, a- a! y* t4 T%>
% U1 {5 C1 | t+ f* u<%
% E* T1 j, M4 [- F3 astring 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";
# C& r% s' G ]; W! astmt=conn.createstatement();
! h+ ?7 o" U: ?# ^) h" z, e% Qrs=stmt.executequery(sqlu);! G( |! f# _' L0 s6 {4 U
%>
$ `5 r6 P& k) J( J+ V<script language='javascript'>
1 d6 _' c7 p. S2 k" v0 Yarr = new array();! f& q, m$ |/ `6 G& L5 C
<% int temp=0;
^3 E& \/ Q6 D, Z5 V) k$ zwhile(rs.next())% ^" L2 W* [: x d$ g* E
{
( S9 p2 X, K" l' ~%>
2 a( J+ I, X' C% m1 tarr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");# F' Q+ n" O# m9 `4 c
<%9 S( g. v+ p/ Q- X
temp = temp + 1;
# |9 R" M2 C: j/ ~! h/ v# O3 D}
# A5 y1 Y( V! C%>
! `( E6 L9 q) f2 o+ C- e% Atemp=<%=temp%>;5 Z |- c$ K6 h. U' F" W9 Y
function changelocation(id){
" Y5 g; C8 G2 g1 n9 c# K0 gdocument.combo_box.city.length=0; //初始化第2级菜单的长度，下标从0开始
# l, S0 N2 W$ J& z: ?9 cvar i = 0; - `; K9 r& f/ P- K' B% i
document.combo_box.city.options[0]=new option('-------',''); 6 }1 j( V, ^" p- Z. i- t
for(i=0;i<temp;i++){
& a/ k# C" |( j# ]3 q' ^# x1 d- oif(arr[1]==id){//如果相等，证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
' n8 B& j7 k0 Tdocument.combo_box.city.options[document.combo_box.city.length] = new option(arr[0], arr[0]); 0 N; }; Y2 o7 p- \
} P |4 o1 X! L) g1 _) b3 y1 U7 m
}
8 M$ ]6 a q! g2 E}
; q4 d7 v2 q3 X( T, t' r</script>
8 s, b$ ?9 Z2 y3 Z8 }, j2 S6 T; l' u M$ [: x4 a
<form name="combo_box"> b" t* I' S! p& W* G
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">
4 D1 G0 L8 N0 P. \ <tr height="24">
, A5 d" {% b/ x; y3 t/ { <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>7 A) E' Y' t7 V6 M
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>
+ d' w5 N* f1 ]! }. \' d6 S$ y <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>
$ Z4 D" A9 g: G1 V <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>
5 w2 k1 F- F% ~5 U </tr> h% N0 C' Q$ `$ d9 @
<tr> $ i5 s, Z2 L% z3 K8 l. R2 C
<td>
! k1 g# C5 T; U" w8 k& ^ <select multiple id=prov name="prov" style="width:150;height:200" class="bgc">3 u5 e2 i1 u* N! C7 Q+ M
<option value="0">请选择部门 ---></option>
: w, Q6 u) i0 ], P<%
1 y% W" L9 P+ ~$ h. K( j string sqld="select * from tdept";' G( ?8 B/ Y& Z+ T4 g! d% k8 j5 |/ ]/ F
stmt=conn.createstatement();
! J. K( Q" F0 s d: G1 T% Prs=stmt.executequery(sqld);
: h* G+ s* G' g/ `8 Bwhile(rs.next())
- c8 e/ ?" d$ ~- j" m{
4 l, s! r0 b) P" n; B%>
8 O& W) _ J( G) a4 b) L <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>
! F3 a9 @7 p# e. C<%6 O- o5 V" {! n- a! z
}
5 x0 _& ]" J, I2 T6 p. s5 X%> 6 L% T, z& G! e3 T$ K
</select>
0 G3 p9 q" j& ~/ l7 b6 @3 K</td>
7 b3 i& K& T; z/ V, ]9 n4 R) j4 i <td>
, d0 R4 M5 z- _ s <select multiple id=city style="width:150;height:200" class="bgc">- b: T; v! _$ i: @3 @
</select>2 y' x4 B0 V, S7 r# L- q
</td>
/ Y6 B* A4 A" q <td nowrap align="center" class="bgc">: h3 m2 L* ^/ d0 f t' O0 p
<input type="button" value="<<" class="buttons">
|/ E" d9 |2 I+ L. G2 w <input type="button" value=">>" class="buttons">% v8 m: [9 ^4 s3 X6 y" B5 s
</td>
/ m* \! ~% _3 d% {6 s <td>
1 K. G3 {) ?5 y, s* r <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">4 O5 O$ ~* ]0 e9 c% G+ Z
</select>, ]2 G {5 H- j4 ^2 i
</td>
' A5 O Q8 x S7 I$ Y. ^% L </tr>
8 {4 k& F! c& c3 D3 A+ } <tr class="bgc"> # F/ r$ V* D4 c _: R- j( A0 A( L
<td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了！" ></td>
/ U. n4 m! d0 C3 k% Z6 |+ c </tr>3 L) Y# {( @6 U: E
</table>
9 F; j3 Y$ _" G4 {</form>
% ]0 q8 }! }; Z5 k2 @0 K<script language="javascript">
9 A6 ]* h* M. n ?/ c: G//人名移动6 U7 g+ t% I" T2 C
function move(fbox, tbox) {% `; L5 E1 p- i: v8 C
var arrfbox = new array();+ `9 c" _* m9 `. H
var arrtbox = new array();; u( \' h: L) O
var arrlookup = new array();
& K' F1 x v. K4 [var i;% z5 q9 o) I0 F1 B5 F/ e( S
for (i = 0; i < tbox.options.length; i++) {
# N; N" ?. r7 L. U/ s$ Xarrlookup[tbox.options.text] = tbox.options.value;! h$ L) h3 {! n. c
arrtbox = tbox.options.text;
2 Q6 p) a' X$ b2 h' O( F}/ |! H! Y/ T7 Y* q$ l
var flength = 0;) c- v4 L5 z9 ]4 Z
var tlength = arrtbox.length;
+ m9 a$ f9 n" a2 r/ n7 @for(i = 0; i < fbox.options.length; i++) {; N" H$ f/ i- v1 P' {
arrlookup[fbox.options.text] = fbox.options.value;
, b9 a* ]6 G1 \2 o! k2 s: R' Qif (fbox.options.selected && fbox.options.value != "") {# B1 z l( e, g4 \
arrtbox[tlength] = fbox.options.text;5 V U& P; E8 e+ t
tlength++;. t1 e7 x. H" P8 S6 |, w
}8 ~ N0 p6 T5 n
else {- [4 |+ x8 @3 `
arrfbox[flength] = fbox.options.text;
4 @0 ^3 s& a# p D/ M# B) w1 v; B! `1 [flength++;7 A2 w9 w7 T7 L9 t! Y0 S( b1 O
}6 e- w: J W s4 _8 I4 W
}
; d* E* _" Y( {. ~! p& ^arrfbox.sort();! `! A: H8 p! p) Q# w
arrtbox.sort();! g5 E8 Y; ~+ f! q
5 |- z+ Q7 L/ f4 y4 Z6 G
fbox.length = 0;/ ?0 Z- p+ j' v# U7 S0 F6 ?
tbox.length = 0;3 q+ T' E- E2 C+ o0 Y1 L) F
var c;
0 y* W( D# u4 t+ Y9 p2 G! hfor(c = 0; c < arrfbox.length; c++) {2 o4 E/ z1 _9 H$ c
var no = new option();
' z( S# e/ z2 K' x& jno.value = arrlookup[arrfbox[c]];3 `- e* `2 P- `" P5 E) `
no.text = arrfbox[c];
' C( f) X2 M1 Nfbox[c] = no;
/ E% Y5 D" f' B$ p$ X}1 X/ [" W( O6 D5 ~& \3 j* S6 ?
for(c = 0; c < arrtbox.length; c++) {, v7 |* k5 m) t$ x0 n: w, G
var no = new option();
# d# c: D7 v! N4 U# ~3 s7 _no.value = arrlookup[arrtbox[c]];
) z# j# h/ ] e. R' D; o- Q! zno.text = arrtbox[c];! g: r y9 i5 k! a- ^
tbox[c] = no;, ]3 N/ A: m. f) {# ?6 {/ w
}
, N3 Z2 V4 Y9 |}
5 t. s, @7 l: z' \+ o5 o1 F; @</script>7 i+ H+ f! f9 {
</body> f& N0 m! h v" X% A' ?! U
|
|
发表于 2007-12-5 17:43
| 