捌玖网络工作室's Archiver

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

jsp+javascript打造级连菜单

<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"8S(jYu+f
         c pageencoding="gb2312"
TuVTZt$eI!?d %>
O6j;V'T~ <style>
B;E mu8qi|Q .f9{ font-size:9pt; }
&Q'M&T-r*e9aLu8O .bgc{ background-color:#aecaf9; color: #0033ff };{H!S!th!R)k
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;
n)s2q%}5V   border-bottom: solid 1px #4e7dc1;&OcLB4F1s2Z
  border-left: solid 1px #aecaf9;
(rbHO {   border-right: solid 1px #5679bd;6uD%TE/G*O
  padding:1px;Q(`)W&Agy O
  margin:0px;}
:Sd+K\9D"q ot1w </style>
G.Rs/K2Cf1y <script language="javascript">;Vd)g$~y|x
<!--
8?Ow+fW'mYy hl function rv()8n5j o:d|v T
{
t[ y-e ]8t   var val="";v P6N+M N9ze C
  for(i=0;i<combo_box.list2.length;i++){6tv9Po%W+Q4v3V%d
   val+=","+combo_box.list2[i].value; [a6h(KEvp
  }fu kc3Ov W
  if(val.charat(0)==","){wZW0w l^w
   val=val.substr(1,val.length);"AHl(?2z*D*?W
  }1r,Q c*TSt?)S
  opener.form1.frecname.value=val;t(o0qV+`-N\5E dp
  self.close();
"oH[ \2SC:b_ y"T }
n"HS"[?+gS //-->
u;g['M*@$?/b </script>^9uz1|i~a}l#u ?
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
_m`4r8H I B3n a <jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />|.[5F b Rs
<%
6]M3H9z(e$S(X   cdatasource ds=new cdatasource();  //数据联结bean实例
dQ}e0v"kC   java.sql.connection conn=ds.getconnection();
F v'R#RNE$Ei   java.sql.statement stmt=null;
l4J t1on Z[,y   java.sql.resultset rs=null;1]7i][)R5c+v0|
  cdatacheck dc=new cdatacheck();
0dd2i6n%P0S1?,a %>#J$H*Qu%u1i'F7j
<%9R/T2Sa(j*S%uBT(W*B%kjn
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";
'V/rG{-b2I3s stmt=conn.createstatement();
+Z*hQ3}O%~2z3m rs=stmt.executequery(sqlu);*]SW-G]qB1\
%>O3p'd[:[
<script language='javascript'> zq$_(Y b^M5}9OOf
arr = new array();
D9C r @"y,ipg*~ <%  int temp=0;
)tx#B4?S)iW while(rs.next())
(xsM'Y$R*ap} {zz@(H8Gx@B
%>%LW/Z.iw0M
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");
a*p9z0UV@_f&W#Zl/tz <%
?}_:e,UC)W:qao temp = temp + 1;T;u:d2U(eQx){
}
V&[ w5{y3Xh %>
CmNm](QQ6]i temp=<%=temp%>;r.P[0}Om Z(d ~
function changelocation(id){
{ As{+zM%d$O document.combo_box.city.length=0; //初始化第2级菜单的长度,下标从0开始 } S't5g T%czN:qL
var i = 0; [1rmwsS4Su
document.combo_box.city.options[0]=new option('-------',''); 7SjM(a#AHv
for(i=0;i<temp;i++){
.QEIA4V;SaX r] if(arr[i][1]==id){//如果相等,证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
M$Bf V _.^ document.combo_box.city.options[document.combo_box.city.length] = new option(arr[i][0], arr[i][0]); v C,M$C1G'lc
} bZ(pn%Ub7SoK'R
} *[#w-XvgJ
} ?*j?5J,N _B.{3FN
</script>
zV9q6]n
!jCz`&w^r <form name="combo_box">F Yi+\zP h
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">.S4JAv.~r
  <tr height="24">X]x`0v1zP
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td> d9wf[ci
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>*Rw | {Gz6j!\7q-p
    <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>`'O'A eT`0N
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>qm |&c8NTiAe
  </tr>6@)TLJ i!CeT
  <tr> ,k9x-il:~}R
    <td>
'vG,H N n#X(u0m.x   <select multiple id=prov name="prov"    style="width:150;height:200" class="bgc">3Qb baYN-cW
  <option value="0">请选择部门 ---></option>
7j k$UPZ Pl_2SO p <%k` D)h/o
    string sqld="select * from tdept";
ZeSm@8Rm stmt=conn.createstatement();
v*U]R%H aiW&Z rs=stmt.executequery(sqld);
:\qtZ T+q while(rs.next())
.]FIvm {w.x~%Hb0Q-~S%w
%>
@ZG&Za4m   <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>
ncV |+h$fbvD:c t| <%
5T yY#? c)RTn }N'nm^"jM6D5t9k
%>
xz(S2hmRA   </select>
w1Y}3hNgq?!^ </td>$I]+TSW(@
    <td>
/TEW:Ced^   <select multiple id=city style="width:150;height:200" class="bgc">
] Q#J&sv:@r@   </select>)Xg^I~Ql
</td>[\6}VdN
    <td nowrap align="center" class="bgc">,| FE1@1Q?
  <input type="button"  value="<<" class="buttons">.Aut@!^L'E'v7v
  <input type="button"  value=">>" class="buttons">!Vz5V[#D!S
</td>
0gtx P-e+e!n     <td>V \ Y1M7?\#Vu,yDi
  <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
k+_#F?sv8l   </select>
2O;d5g+_Y </td>u'|)f&U(LL2~6k2T&_?
  </tr>
u Be }/jd     <tr class="bgc"> 8I/ia(G UF!w!mJ CU
    <td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了!" ></td>
l9M.?^ Ry   </tr> U+b k\O` k3y
</table>
8o-onf4^P-~ </form>
@;X"k6q.|od;FWy4I3w q <script language="javascript">/]a2H@Vv[ x
//人名移动
k]4]5E1[%~ function move(fbox, tbox) {$V#E*Lf@h
var arrfbox = new array();)pH1O7Ygt
var arrtbox = new array();p3J\2K ~h+}6h&h
var arrlookup = new array();
{Jl!vf%d6vu!@O C var i;
p*m N7{tvjs(^8u for (i = 0; i < tbox.options.length; i++) {
X4K+[)Z&?"Nj arrlookup[tbox.options[i].text] = tbox.options[i].value;
f+{&QhXvT arrtbox[i] = tbox.options[i].text;p J ^5`c~\ m
}
h A*T5\X/^5zn var flength = 0;e;l`%JI6{h
var tlength = arrtbox.length;S'Qe | ]{0K
for(i = 0; i < fbox.options.length; i++) {%l;e {R!?J
arrlookup[fbox.options[i].text] = fbox.options[i].value;
)H uvPb0x if (fbox.options[i].selected && fbox.options[i].value != "") {
&nA!k.ryd;_ arrtbox[tlength] = fbox.options[i].text;
K3LRe2k E'Lo tlength++;X Q4Fm!Uf
}
0v i-B/i8N.^ else {
f_(El#BWE3R arrfbox[flength] = fbox.options[i].text;
*NE R+]U#D ta(] flength++;l#k"pkT9A
   }:_m+tF l'F8p*Xx
}
?b Drl f arrfbox.sort();
CZ+x@OP{/_f'@%LNU arrtbox.sort();
Vg~:oS7D9NY1e q.F} K*obe
fbox.length = 0;
c#[b5?0y%Q(U+| tbox.length = 0;
4SCG6k-N6Jq:d?E var c;t8eQ%q1H-^*y[
for(c = 0; c < arrfbox.length; c++) {
r wY sxa$k7@7S8\ var no = new option();
V7G(E1HKe no.value = arrlookup[arrfbox[c]];
~` p)z{o no.text = arrfbox[c];.h)M1V_@-X%bl"S
fbox[c] = no;k2GiE$Phf%P
}k-VM b2qvF_,c?e
for(c = 0; c < arrtbox.length; c++) {
X;z%T \ wR j,r var no = new option();
TML9nR_QL no.value = arrlookup[arrtbox[c]];Z/`8X-c L"\[
no.text = arrtbox[c];
#rAG'Gr.~ tbox[c] = no;&G;XCk'R#s
   }
M[J5Q)XPX }`;l/BX7[U!g R'cx
</script> }'Rih#A-Cy k
</body>`FT?/`^
[/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.