捌玖网络工作室's Archiver

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

jsp+javascript打造级连菜单

<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"!Uy[] x@`
         c pageencoding="gb2312"
!\rg&bZv X Z(i0G %>9Mxl3`%`a
<style>
{e-p} W2@ .f9{ font-size:9pt; }
'ib9Tz T%do6t0y .bgc{ background-color:#aecaf9; color: #0033ff }mlXc!PT9|N/]
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;6ka5u'_$]?X
  border-bottom: solid 1px #4e7dc1;
_ ir}!^   border-left: solid 1px #aecaf9; I^ Ad!|Hc7vS
  border-right: solid 1px #5679bd;M!n1zP4b
  padding:1px;
?_:buLL:}   margin:0px;}:n v&lX0M.I
</style>/t6q1[#xA&@
<script language="javascript">
7w1Z| ^w2H ^ <!--@2t:GS#Bi{
function rv();U;Y ^u{ nN
{cS#oKvR&z VRI
  var val="";)K?eD!YN!R'c
  for(i=0;i<combo_box.list2.length;i++){
l.KG3u!h*y\;J    val+=","+combo_box.list2[i].value;
S_2jMd1xo   }Y!kSJht
  if(val.charat(0)==","){(x-cg9z Pd*D M
   val=val.substr(1,val.length);\*S1?&{ { @9Ac?
  }
3r'W6sKgNtax   opener.form1.frecname.value=val;'e(H1L?8C7e1tPz*x \
  self.close();
m K6b(GN-UW&IZ h:} }
^8t&jvI //--> ]w3\g5RLk:G
</script>LVJC.js6~_
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
;vVk#OYK!@ c <jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />0}6RZu ^y"fJ
<%
g!d%Hn-Ka   cdatasource ds=new cdatasource();  //数据联结bean实例
6J0|BF4d#R   java.sql.connection conn=ds.getconnection();&]l.w6[Wi'P
  java.sql.statement stmt=null;
"D2H{1t5d'I   java.sql.resultset rs=null;U m5QBqG u|
  cdatacheck dc=new cdatacheck();1L2n6y)l2F
%>2eC\t*K%W6C|zU
<%z,LP|$S
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";
i}#C%jM4O stmt=conn.createstatement(); k.s_4` sO@K
rs=stmt.executequery(sqlu);e` Uph N8dx
%>
+|&l UCY v(} O <script language='javascript'>
8^}4Y]J ij3r c arr = new array();
Ii R\{"A <%  int temp=0;
7I] t'd3X-Z+{2r while(rs.next())
0|a6Xk],SG'O~ {
'b8T{ ls\ P+A %>
+G I[Wq$b`Q arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");
5t/J,{v*w!c|4x <%_9h~%\_5['qK
temp = temp + 1;
](Iot3x7C }
P9W} Q"v~ O %>
k6N4G6Ww cgR J temp=<%=temp%>;
+n$Mp x,J function changelocation(id){
_.Qon0K-i7e document.combo_box.city.length=0; //初始化第2级菜单的长度,下标从0开始
4^'f#I^TMpB var i = 0;
F"Z1aq&D `r? document.combo_box.city.options[0]=new option('-------','');
QM@`n%nI6h for(i=0;i<temp;i++){ 1P;XY,]2Y?%Qj
if(arr[i][1]==id){//如果相等,证明在第2级里面有输入第1级组织的子集,arr[总数目][部门] /e u?4}U
document.combo_box.city.options[document.combo_box.city.length] = new option(arr[i][0], arr[i][0]); |dN6u|'FP
}
Sx wa#_|)J } p-_*p"OD8]2E
} .~ @ F1IR7oZ
</script>@!H2It7?zC3D-c

5_y9Q.i MJ spN <form name="combo_box">3^2B5L9T5T8N.x
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">O&jN j x R
  <tr height="24"> DI1Y e/~ }
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>LUrp^m
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>RT \ZkMo
    <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>([SD{i9sY.Y
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>
s*f t;YP8]   </tr>
p2TS|,m   <tr>
8g-{Xe;Jy0Jp     <td>~:\:qh7W
  <select multiple id=prov name="prov"    style="width:150;height:200" class="bgc">*PU;[V8oXa BR
  <option value="0">请选择部门 ---></option>
\,k9m7E xz6P/Q)i HB <%[CR7f+r"@i'|
    string sqld="select * from tdept";
H s/l C a7l|(r0L stmt=conn.createstatement();
9U&K3c&l(s,T)vO)V rs=stmt.executequery(sqld);JUA@#tF/jYi
while(rs.next())
Bn)nWs`k s {| QSew"jjz
%>
x8BAe5V @)P!W"Z ^   <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>2g$ehkOV$W
<%
NN'OF7m#E6I }yR)R[,{qDA
%>
B.]]0PEVc;t5L   </select>
4qiQ%V I~1?0a/R </td>j4P%x1NK
    <td> yL&yD%mf
  <select multiple id=city style="width:150;height:200" class="bgc">
)q npka;fYKnS,N   </select>
2w!jXw~&\7T:]*c </td>+wnh)d#M b)|!| xq+W
    <td nowrap align="center" class="bgc">
(v'\,bC5m7cBZ   <input type="button"  value="<<" class="buttons">z(]2h,S%Yx
  <input type="button"  value=">>" class="buttons"> qHqcd HLc
</td>x{q&ubR
    <td>
;BV+k$]1WdsFl   <select multiple size="10" name="list2" style="width:150;height:200" class="bgc"> F.[?(_ XIHiq
  </select>
%e*vrdO </td>0s7\;s[c }3NBU'A
  </tr> GM;_2Gy R$h/P"x
    <tr class="bgc"> asH2Uh+C4@i
    <td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了!" ></td>
Eg CG Q0A9o-j E$C m |k   </tr>
~4rr)b0\#\O </table>pf*J5? \7y,L
</form>
p;T(L|fOb <script language="javascript">
+I$u)`.V ~ G //人名移动J)vhl(\
function move(fbox, tbox) { ~#N*~{:rU"l6s9Q
var arrfbox = new array();
(iZ,OLhL o+Z` var arrtbox = new array();#^.c z z3x
var arrlookup = new array();&I3T/kF*GO'k(e5^*Z
var i;UR*Q'Bj
for (i = 0; i < tbox.options.length; i++) { k6gh'e'D7r)Ib
arrlookup[tbox.options[i].text] = tbox.options[i].value;~6| M*F_1BNL
arrtbox[i] = tbox.options[i].text;$Y%Np@ AW
}
E.e2Zof2b-a var flength = 0;"hG'NY8{'rRO
var tlength = arrtbox.length;Tj$q)i [o4]
for(i = 0; i < fbox.options.length; i++) {
-P kky$m~ arrlookup[fbox.options[i].text] = fbox.options[i].value;
_L e.i EH J if (fbox.options[i].selected && fbox.options[i].value != "") {"c:y6dA!AM
arrtbox[tlength] = fbox.options[i].text;
6I$kz"\x.gT/k tlength++;
)J[HelY(BY,^ }
MSpl[2{!h else {L2Q1a%dO)p(?l[7e~]
arrfbox[flength] = fbox.options[i].text;
]:T|7N1t Qk2Z flength++;Q4VA(ydc:V:[:Z
   }
| W5}8c}W uE }2\ Kd/L ^q0WY
arrfbox.sort();
&Ke1~OZ arrtbox.sort();
V2`$iG,??
ce8F.^ KGrP/b{6x fbox.length = 0;o NH e%w$P
tbox.length = 0;
Q*P1mj*h#XDU%| var c; L%iW6AB"nRK2c
for(c = 0; c < arrfbox.length; c++) {_{P y4V:M0^#V
var no = new option();Yc zc/Gr })[$[
no.value = arrlookup[arrfbox[c]];Q6tqO5q4la([A6y&k
no.text = arrfbox[c];%Lc'TYi6Ro:`_2t
fbox[c] = no;9N_5T9[zh+G
}"B:u6U5HK1gbt
for(c = 0; c < arrtbox.length; c++) {w3G3sr6jN)x,r
var no = new option();
u;GT B4S no.value = arrlookup[arrtbox[c]];
r+[8k3Y5N&N no.text = arrtbox[c];9b;~1U$EWq+_(@-~
tbox[c] = no;+R-U/x^%e*B8}q ^8c
   }A U$hX.Lr~
}Cp+?m9hT
</script>
A n} ^*a </body>
2T [8w)TS6rA [/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.