捌玖网络工作室's Archiver

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

jsp+javascript打造级连菜单

<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"
Zoz0fr          c pageencoding="gb2312"
}|9E(X U vS+F %>
e$a4K*lV&po <style>]W"_6`Qp
.f9{ font-size:9pt; }
R k"k/@#vC .bgc{ background-color:#aecaf9; color: #0033ff }.od1W8g [w\
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;
,N bGem[ Lq   border-bottom: solid 1px #4e7dc1;
K3YT}N$X   border-left: solid 1px #aecaf9;9Py)\/Ma
  border-right: solid 1px #5679bd;&|u6hFW }i]
  padding:1px;GpYNFU
  margin:0px;}
r,cE g2K T </style>
HGC a'v gpv[ <script language="javascript">
2|$C5S.X*r;}$]t L <!--/\8B4j"DaD?
function rv()
w Z9z%qgj%];@P nu {
+kTV/po"vy8}   var val="";1j4{ X xK3h6C%zM|
  for(i=0;i<combo_box.list2.length;i++){
fR0E2A2E/A    val+=","+combo_box.list2[i].value;!sEIED-LG
  }
,I+V-c"\\6v&q   if(val.charat(0)==","){
BDl&r(G,k,V    val=val.substr(1,val.length);
2u5k(?+rHHo   }
w%Ov+ZtwvT   opener.form1.frecname.value=val;
w.Qo |`#p^G   self.close();1? I%b*o/hG
}Y8r [ @-Z R0WT
//-->0a-T'EN7S"}t
</script>bGy"kV wj#h
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">7Y3n H6FH,C
<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />y M-T {Vx2J2F0B}
<% t(e/{6x9TA&R
  cdatasource ds=new cdatasource();  //数据联结bean实例5}4H$h&VY5T
  java.sql.connection conn=ds.getconnection();a-@%v(o T8o3\ ^t
  java.sql.statement stmt=null;
:h0h@Mu(PUc   java.sql.resultset rs=null; R8?X M9v0N0AS5\&[1fW
  cdatacheck dc=new cdatacheck();
$e"Dh UVl].N %>
Op J.eOA/q <%
1rL4Sb&hX;l9~ 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";
7Cgi#`/U&i-C stmt=conn.createstatement();-qb&U8}1N2N
rs=stmt.executequery(sqlu);3b^2e'g+D7kC,a)}l+o
%>5b h v%}3_:X?dS se a
<script language='javascript'>r?7Lj#C9j)Hg,Y'GC
arr = new array();
*R2h$o!ioe&E <%  int temp=0;iq7~5Kqls X
while(rs.next())
.i+_ O@2y8s `G4vF {
u7hCvk ? %>`6c$Z+uX3bk
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");FLmx%[c
<%
a.q]#al&`O$D temp = temp + 1;
"bU9y lnaTH }
rBDxd %>!R1l;d:T?/d ~l
temp=<%=temp%>;
)KD4c x|oH8u function changelocation(id){
~"_QNV2I document.combo_box.city.length=0; //初始化第2级菜单的长度,下标从0开始
9t$K*rH*zymR;I var i = 0;
vwl r J/u/PqN document.combo_box.city.options[0]=new option('-------',''); !sj9]2Xd/[i _%DA0N
for(i=0;i<temp;i++){
5~VP6B)d|5f if(arr[i][1]==id){//如果相等,证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
0Rlj/}tKj document.combo_box.city.options[document.combo_box.city.length] = new option(arr[i][0], arr[i][0]); ;WDrq7cP3C3S.fB
} +KZ oWai(eH k)zeR
} mc4f|:j3` p r
}
{)WP{~J4a </script>\A0se P+f

[;vL oY2N <form name="combo_box">onL6?a0_ _Qe#?
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">b%xx5F~;b9b
  <tr height="24">
6v'l1w%ZN&bfo     <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>
U^-u#wN)c)C5[     <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>/jO??4EDl
    <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>
)AN R Gknz     <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>
$Kj*M;}#da   </tr>
%gpBx[   <tr>
9L t6KE[nSp     <td>
A-dbAI   <select multiple id=prov name="prov"    style="width:150;height:200" class="bgc">
A8SJU.p v   <option value="0">请选择部门 ---></option>
+B-vzl$_Ie;s X <%B)Ba1D.X7Ew7l:Jr
    string sqld="select * from tdept";X ?Z;N^8Z-By
stmt=conn.createstatement();
#zU5Q{p[_ rs=stmt.executequery(sqld);
@ A(mq$iM while(rs.next())
K I9T8o7im,PjR {
(`F6N0re7e,f Hf %>+w;_/F^ QM4p~
  <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>0yHT*Zg#\ H(j
<%
oS |F-dq[!Q9H4tq }
!Ns-R-D3F-H %>
pQgex3p%IW   </select>f;K2v!sF,hw
</td>j#f,}8hM
    <td>
*|,f7Y3JE9dH7HiD~   <select multiple id=city style="width:150;height:200" class="bgc">
1Z:~c [ la   </select>3C;eC/i"[-t?5|zG
</td>U?k"Mi/Q4v
    <td nowrap align="center" class="bgc">
B#[ V6ubF8P   <input type="button"  value="<<" class="buttons"> T"FM0w?~4c+]
  <input type="button"  value=">>" class="buttons">
%Z j5Vh)g$?*{/M8h </td>j+d4K.DGn]3kv,Y }
    <td>1f$^$v0kpGKh
  <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
2p!_$uqV`;M!D   </select>
/l-k$B.@;f!\L~u#PA </td>
})^Z^*J(E.fn   </tr>Y:ijCwD
    <tr class="bgc">
x/Qs1qa%Y\|     <td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了!" ></td>)a6B7F%M}
  </tr>
D5c3G@eVS"@ </table>
jp|*C r </form>
6H x/e we Y P <script language="javascript">
/|oJ`,L6F$lk~ //人名移动|oH_m
function move(fbox, tbox) {seM(F(}iS,v
var arrfbox = new array();b4G J!i3Z8lD
var arrtbox = new array();
XY+{7P8t?5E4v(X;^ var arrlookup = new array();&p*}+e4gO
var i;
\(|2H3a:]fU for (i = 0; i < tbox.options.length; i++) {0u}(bPN-H_
arrlookup[tbox.options[i].text] = tbox.options[i].value;
V?$o%x L\ arrtbox[i] = tbox.options[i].text;
h:JlW~3~wX(}9O }w:hdO\6~
var flength = 0;
H@X4cnW`#S var tlength = arrtbox.length;w{KEr
for(i = 0; i < fbox.options.length; i++) {
RBfj4}-T~ arrlookup[fbox.options[i].text] = fbox.options[i].value;M_ux {
if (fbox.options[i].selected && fbox.options[i].value != "") {
R`W \fK arrtbox[tlength] = fbox.options[i].text;H+DP O-zR4K x$Y
tlength++;?K9Ru^
}P?q:_/@$]U,Y7z-@
else {
#es Ww&Tz Udi arrfbox[flength] = fbox.options[i].text;,Ceg%P Jc0J4r
flength++; h:B Ic%Xbf2e(l-D
   }
(cY"[kevt }b6E+Y6g%B5Rj
arrfbox.sort();5Sg{ k2S*S6a
arrtbox.sort();
&Y\C,Y N b
Mg%b9S]a^'^ fbox.length = 0;Xj U9pA/E[
tbox.length = 0;
&^6J'[{ JWvb var c;
5y#DYW{E RcQ for(c = 0; c < arrfbox.length; c++) {
{5~$\jLPG7^QS var no = new option();:mW ul^X jW s |*k7c
no.value = arrlookup[arrfbox[c]];
l0_.|;rR S no.text = arrfbox[c];!au0J1XK
fbox[c] = no;
e6ag2U0F s-l+p7@\ }
^"M _ qa j for(c = 0; c < arrtbox.length; c++) {7p+L{/p;x O
var no = new option();s%eBi Pl'@}(u
no.value = arrlookup[arrtbox[c]];
4VR&H&v)j} no.text = arrtbox[c];
G Qq/ZT+sJWp tbox[c] = no;
H2F`%l lf{n    }
o2DUd.rB6e }5~(rQO;m
</script>)e7aqgW'W!Zy-Mg
</body>
$Q4q2D,D's [/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.