捌玖网络工作室's Archiver

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

jsp+javascript打造级连菜单

<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;";_8\OSO5jb
         c pageencoding="gb2312"
WDHH/k)j#P2? %>
.dc%D^BN+XTz7]G <style>4zC!L!b;M#x4_nsx
.f9{ font-size:9pt; }
aV)b X:h .bgc{ background-color:#aecaf9; color: #0033ff }HZoCX2n^
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;
U-d AHxq Lf   border-bottom: solid 1px #4e7dc1;
H]M3J0uUs)|p-s8|   border-left: solid 1px #aecaf9;
$]a1X-S{ `A   border-right: solid 1px #5679bd; P/D Ig.J!},XZ
  padding:1px;
%w+J(?${W-Lc   margin:0px;}G:G"Y*zz
</style>j4B)MW&N \&C
<script language="javascript">
hQ6\ eZ4y6G L/P <!--
0z*q;D*H n@ U,K!]2~ function rv()l9k8h,sS _/Q@#x*JCf%__
{
!{0D g*m_,X^ Zq4Kv   var val="";DVU'^dR%z7k:~N
  for(i=0;i<combo_box.list2.length;i++){%nNF ~(P3?Y(BLQ
   val+=","+combo_box.list2[i].value;
7J Hh7v0fLC   }2q4YY/oq[n
  if(val.charat(0)==","){ Vb3g:}un"M/b
   val=val.substr(1,val.length);gj?L |8~;i
  }
9c^RD Y+o2C!K@Y   opener.form1.frecname.value=val;
3F zN aR;[$wb   self.close();;_([5F~0]Nb f Ji
}
F'J8[5^8L{3uc9l n //-->#u+QS.V0wb7A
</script>
s4w'tY0H/n`7m <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">)mbk8Ad| F
<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />
(C&D idw7I Q{ <%c;R~1e4U;fq
  cdatasource ds=new cdatasource();  //数据联结bean实例
^AY VV$igB#n   java.sql.connection conn=ds.getconnection();G-CB"Z9ri
  java.sql.statement stmt=null;*f%j Av:Y.i2BU
  java.sql.resultset rs=null;
6hC~;Iq w|/`y4[jo   cdatacheck dc=new cdatacheck();
&i4o$w;[UW'l %>
5N|6F@%Pc <%~#n)\;j H L&T
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";
'~)pL&XOuJ stmt=conn.createstatement();
W[\bt rs=stmt.executequery(sqlu);h7A gC@Y(S
%>CE0Jv8f
<script language='javascript'>7N.do)O2Y#C1i&p
arr = new array();Ek$qs ?P7j;a
<%  int temp=0;H bl0x(@5G.}
while(rs.next())y lA j;n tu K
{
5A&UV P$l %>(w Aj_.b*? G*m
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");
!r'JwlW'S n'P#]$Bx <%
h0Q`wQ*E temp = temp + 1;
2C(Fsid Q/l)Ys }
pw]7ymYH:B %>
fil? e temp=<%=temp%>;
9y$OO[^ U function changelocation(id){ $D0Cq\r(J2z
document.combo_box.city.length=0; //初始化第2级菜单的长度,下标从0开始 SeL&i2[~{4B*U u"F
var i = 0; (O8n h` pIb#boX0k
document.combo_box.city.options[0]=new option('-------','');
"~-Cw W'W for(i=0;i<temp;i++){
p5`V%l:P+B X8O if(arr[i][1]==id){//如果相等,证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
%oa&v M Ya document.combo_box.city.options[document.combo_box.city.length] = new option(arr[i][0], arr[i][0]); &^$\L0t Q-ujOA
}
,p{*MB*C$\ } 9^DJhMBL
}
J`9gm6dn6b </script>
&he;VVPF
"S6[ `x rdO.P6Yd <form name="combo_box">
,Wy W:|2p <table border="0" cellspacing="0" cellpadding="0" height="210" width="59">
~6o'}*GJ1Y8H(U   <tr height="24">
AJv1qK     <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>-dAJuf9p
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>? WtB8bB(t \
    <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>
T#L?mt+S0@     <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>+MUFhk3a|l9pq
  </tr>
WEH N SS7bL`   <tr>
.MO@ t }     <td>(ot9\+H_O
  <select multiple id=prov name="prov"    style="width:150;height:200" class="bgc"> JvZ`%T!d$@:C5t
  <option value="0">请选择部门 ---></option>
w\$x+ZO"\$]nP <%&~;Pda_{,VEr
    string sqld="select * from tdept";tv`H)VsD
stmt=conn.createstatement();(D S1|(a0Y_I
rs=stmt.executequery(sqld); ]8oSJ.oy
while(rs.next())1{ U.\;M2b ~%[
{
$T0lNX-v %>
4K^1@?*l_&m;X   <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>
o b)S\k Xtg;V7Y ^p&U <%x|%d5| {U c)pd\T
}%fh0S1Fd Xh
%>
O|IN5F   </select>
?/t2X,FR </td>
5SF%{(U7k&IKL     <td>
BkDj ~.h}   <select multiple id=city style="width:150;height:200" class="bgc">
"u(f5}4o5`   </select> a,] s+c,W
</td>)yr7|9S4y8k)w3`
    <td nowrap align="center" class="bgc">k:^#Rc1?P#r;^
  <input type="button"  value="<<" class="buttons">
tuB.\n#T%l0H C?   <input type="button"  value=">>" class="buttons">
Vx0R ExM:G+s5` </td>%k(qZ%st
    <td> reM B)FH}V Zh
  <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
`)wW|)Kb A3e   </select>
1{{$t~K~W </td>
;r!QZe!Hj:o   </tr>
!xV ^M8g~ Nl~(Z9F     <tr class="bgc">
5s?(F$lx"LU     <td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了!" ></td> R,k'F\(wyv'R;lD
  </tr>
,mL w5TTW&[.d#VV| </table>
M,y#LY+a z }s </form>
2uJ(?5A;M/K,L MD <script language="javascript">R[J r%O} mC
//人名移动
#S2J O(J W |6at`\ function move(fbox, tbox) {
[\P7pj!T6`'C(L var arrfbox = new array();"tX5V0X,P`1l{
var arrtbox = new array();
)K$J{M-D ]1u sR var arrlookup = new array();
x?&v~5T c!y,m var i;
N0d'?'nq5om_*T for (i = 0; i < tbox.options.length; i++) {
k1L8]3`6|+D arrlookup[tbox.options[i].text] = tbox.options[i].value;4tF1v&uHQ@%M
arrtbox[i] = tbox.options[i].text;c9}IP\(dvS+Y_G
}!g2j/t h5s*K*wTA
var flength = 0;Y1kF#T2j2j
var tlength = arrtbox.length;
Wjm3xH c(H,l for(i = 0; i < fbox.options.length; i++) {
T-BPpPGf$e arrlookup[fbox.options[i].text] = fbox.options[i].value;E,@5tw:O
if (fbox.options[i].selected && fbox.options[i].value != "") {3C3^.NZZ{
arrtbox[tlength] = fbox.options[i].text;
.t,b N1k}@}4c ^-] tlength++;CR\!U0{\JcnKb
}f:Fu$~4\
else {
+c:Q[b-I@ arrfbox[flength] = fbox.options[i].text;1l,|%B2dAdB4q*u
flength++;/u}/T9L~H}
   }_ kxO {M
}9BftW(t C:A7\K
arrfbox.sort();
)A i9lK.\h(l D&t arrtbox.sort();n#S.D"{(x5nw
U^ a v%E
fbox.length = 0;
eq*O6d2lF J tbox.length = 0;
"`$G1R)@ r%jvDt,A4g3T var c;(e'm4G)ss&Z%^1j
for(c = 0; c < arrfbox.length; c++) {UL+{X/q'@;CX
var no = new option();IS wW1csq
no.value = arrlookup[arrfbox[c]];
-bU o D-K+wFDU8d no.text = arrfbox[c];
f3\?B8epz fbox[c] = no;6AH^NA9X\w`
}
)Gg&]/aS+C6} for(c = 0; c < arrtbox.length; c++) {
*Jp8V#vR'h(S var no = new option();
"l#S*N'?'S'lc3s no.value = arrlookup[arrtbox[c]];
^%Ya"nq5M no.text = arrtbox[c];
gQ!c9a;^,x tbox[c] = no;$l+ds$L7c%h9D~
   }
%RO)al8f8FB6b6i/_e I } ka@,V.sGR7_
</script>
(j0}:G6o5Hj </body>j)Sw*C;^Du b
[/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.