捌玖网络工作室's Archiver

admin 发表于 2007-12-5 17:43

jsp+javascript打造级连菜单

<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"
b1b6f nb5t2V          c pageencoding="gb2312"
&Z |NQc$| u %>
evr#t b3e <style> er%K+M4O?7\G
.f9{ font-size:9pt; }\.`L!|'g h,w4c)d
.bgc{ background-color:#aecaf9; color: #0033ff }w-@3w*Xe`'[7D
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;3O*U:D6jD8U+XAX F
  border-bottom: solid 1px #4e7dc1;C9`'y'] v5G?
  border-left: solid 1px #aecaf9; aT/LQ3BN9Dl'A
  border-right: solid 1px #5679bd;Nv#A4jw}!Vm
  padding:1px;
9l)m2r![jP C[ k+Y   margin:0px;}
M+o XO2k;} </style>
NT'@ eo <script language="javascript">
8`o7a]N(Mn:l*] <!--TR\:N#G8_;@3RIh.c e
function rv()
Wp#{FEG {)KSN6q`ry3O
  var val="";
I-a;r cY@X/ss O   for(i=0;i<combo_box.list2.length;i++){s.A[1`]3[tg
   val+=","+combo_box.list2[i].value;
:nU g5}1@R7}   },~G1f!cav]g
  if(val.charat(0)==","){2}.|*{!_`)k'CI(Em
   val=val.substr(1,val.length);
vS%Dt|#N.Z&}   }b3b8Y$HM \
  opener.form1.frecname.value=val;
-@bf0I"i#H(V   self.close();
C[#o!z^q;HQ }
+R8s?-jl y#C //-->*T)T;aQ!bB4C
</script>G`@/y&t&QZ3l
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">i"s-NQ+]8~
<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />
p8^0l I-M)ul(p <%w`W})wKy2b
  cdatasource ds=new cdatasource();  //数据联结bean实例0q-Q B,`kj
  java.sql.connection conn=ds.getconnection();(Jt,}t zaQ"d5S
  java.sql.statement stmt=null;
i&@iA U/hBv0l0p0k   java.sql.resultset rs=null; |CmF7NW
  cdatacheck dc=new cdatacheck();_-|n(AP'kX
%> @1o;a!sA
<%'xp[ G[ x#b
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";
;w;{[ [7@ C`4A2s m stmt=conn.createstatement();5~ W!byAa g
rs=stmt.executequery(sqlu);
t{-r6DE %>7kF$wt&@XD
<script language='javascript'>Uu.?K E n
arr = new array();"WIe%|zDZ
<%  int temp=0;
GDH0K"?E2|~ while(rs.next())
fWW7QG wJJG {'F1y/p ~9b{
%>
#w8|}k:M/?n,tC arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");6s3a_ wd
<%
"R5e~1[5|/ITJN-\E temp = temp + 1;g&L WR5YO
}
z4B'kjP$QW"?+a:H4F %>!Fj5Q-eg5[
temp=<%=temp%>;R B6v{3m'{+uwc'H
function changelocation(id){ U1U;lm+UY
document.combo_box.city.length=0; //初始化第2级菜单的长度,下标从0开始
%~ d5W(Z$p4YZ var i = 0;
!bM;ZJ.p"`PW document.combo_box.city.options[0]=new option('-------','');
}1hH$o;W2fk for(i=0;i<temp;i++){
&^`5M$nxRi if(arr[i][1]==id){//如果相等,证明在第2级里面有输入第1级组织的子集,arr[总数目][部门] ]&da(eZN
document.combo_box.city.options[document.combo_box.city.length] = new option(arr[i][0], arr[i][0]);
6ml"~nf P } 6MY"F\;[5r3\G
} hA(_@7TmJ/@(B
} -q[#~l\7X1\I
</script>N0sB9jv_

uN%l{Yq7l.IQU <form name="combo_box">
q[7ps'H G F <table border="0" cellspacing="0" cellpadding="0" height="210" width="59">:we*h:C;B] j
  <tr height="24">
&Q*a.J4o)x8G&\.iG     <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>
A)`er5Tme9o*wa-u     <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>S+P ~-g D?TW!N
    <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>$@;F-INXu R
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>@?(y?+x,cf M SD8H
  </tr>
5T;SR&U6m   <tr>
s}2G#P%v[+u }     <td>
e t(J f0w#q   <select multiple id=prov name="prov"    style="width:150;height:200" class="bgc">$sZq5`,C1i
  <option value="0">请选择部门 ---></option>5t9P G6SQ!WX1i
<%
^(G8Y,B:X]LpE     string sqld="select * from tdept"; @ _Sggm
stmt=conn.createstatement();
oQ^`Wn\y rs=stmt.executequery(sqld);7N/U [&k5I1wh
while(rs.next())
;@JvK \3yZ {
m9]#O;z&Rv %>
'[ zZ-LR \6O Y(g!L   <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>
aM!^cCCGf <%
6OB&yTx/M5k8h }Jr%l O uZ%M3~
%> \ }S-wA4z7`3[Y
  </select>7m%_8N,b`
</td>Aw3M3~-E @5D Y
    <td>
\.PH7|nk&u\   <select multiple id=city style="width:150;height:200" class="bgc">Ph.ql1rn3s
  </select>%U x5O] `b)L/?
</td>:z v*Di2?5eqw
    <td nowrap align="center" class="bgc">7G*f/^2N _H'y Q
  <input type="button"  value="<<" class="buttons">qw$D}9X.Fpz!G ]
  <input type="button"  value=">>" class="buttons">
9?k.H/]%o~+e }mJ0r </td>
jd%qF&\&L7?*E8F     <td>
6DrE-SnrMu_'jaL   <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
'zsHz1z   </select>
wiow _$yN+w6Yx </td>
iq5\3P4` y-@   </tr>
*F&Z'Z$\7v)sC8dW.{     <tr class="bgc">
([g6x3u,O6TbM_     <td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了!" ></td>
f!PY-mG%Ktm&K   </tr>
"\'q7T9H`o4@ { QG </table>9knZYl
</form>
3soT!~/xG?m <script language="javascript">]ed&@)h"a
//人名移动
!Jq/M4}WP function move(fbox, tbox) {[0?`F K"~2n
var arrfbox = new array();dI mxX g+m
var arrtbox = new array();
t)MgX7d#|;Lp d-kx-@ var arrlookup = new array();b `[PA~
var i;A~ ?+HE+^3Aq
for (i = 0; i < tbox.options.length; i++) {
-g-@B#DM$F#?!@ arrlookup[tbox.options[i].text] = tbox.options[i].value;#l$i x"nH|j
arrtbox[i] = tbox.options[i].text;
9x-m.a"H w8K5W }H/V6Bjv~IX
var flength = 0;
M)p/nOI/p3p var tlength = arrtbox.length;
/E wh_ e @qb z(Z for(i = 0; i < fbox.options.length; i++) {
$KUr+zQe {$R;tI8rW arrlookup[fbox.options[i].text] = fbox.options[i].value;
+OLyCQ TC"v/?"m if (fbox.options[i].selected && fbox.options[i].value != "") {5g*JsWyF
arrtbox[tlength] = fbox.options[i].text;'{jJ@Bd ?%C ZX
tlength++;%Biv/nG
}
x \.ZWF3wEH else {|Oo r0R3`Mf
arrfbox[flength] = fbox.options[i].text;s P@;_@/O,\b
flength++;
X;X1w$R+B3| G(dA    }
wr XC*Jjq:rs&l }
!a.g h*|i(kboN arrfbox.sort();
fi*N"^GOSk arrtbox.sort();
Qn zW.i (o u7`R p4k!B^]y
fbox.length = 0;
DEv9k,Lg tbox.length = 0;xHY3S*YwR+H
var c;6dd L _1bmo&\WS
for(c = 0; c < arrfbox.length; c++) {eM yHo:vF _5GjI
var no = new option();/S[Tc?i Q
no.value = arrlookup[arrfbox[c]];
$V[m\6V\o z'o no.text = arrfbox[c];-t.n{s(~*~ s
fbox[c] = no;
+b$d-p,u5WP }
{FLYi0^_0~8M:Bq for(c = 0; c < arrtbox.length; c++) {0V lI.m4bRxd
var no = new option();XI)m.Q2D;F x
no.value = arrlookup[arrtbox[c]];!e.xws(i$A:LX0qs
no.text = arrtbox[c];;S.\-q-WAw E k%I6~
tbox[c] = no;nUNphHV_K A/r
   }v3l4@3Xs3q.n
}+MBb z#CGr3UD
</script>
$H }0WP"u </body>&u `AZ:f$P9D
[/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i]

页: [1]
【捌玖网络】已经运行:


Powered by Discuz! Archiver 7.2  © 2001-2009 Comsenz Inc.