jsp+javascript打造级连菜单(页 1) - ASP,PHP,CGI,JSP技术 - 捌玖网络工作室 |网页制作|平面设计|建站交流|代码资料|建站教程|主机域名|asp、php、jsp代码|网站素材

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

jsp+javascript打造级连菜单

<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"
      c pageencoding="gb2312"x u-Uj^o y
%>
<style>
.f9{ font-size:9pt; }
.bgc{ background-color:#aecaf9; color: #0033ff }IZB,l(|!x4j [/bWp
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;
  border-bottom: solid 1px #4e7dc1;
  border-left: solid 1px #aecaf9;4AC)q:T[@x7CEo!o
  border-right: solid 1px #5679bd; IL"j]r0Q9d6u
  padding:1px;
  margin:0px;}
</style>
<script language="javascript">

</script>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />ij&T$fs |4Vp'T'g
<%Qn+\u:VT(V U7L
  cdatasource ds=new cdatasource();  //数据联结bean实例
  java.sql.connection conn=ds.getconnection();$jw.t^OJ!V
  java.sql.statement stmt=null;
  java.sql.resultset rs=null;TSg)z!A%bh
  cdatacheck dc=new cdatacheck();]"g&_r6|6Nn(|S6oi
%> l$P(H\,EWgX3w(d
<%8{0e"P)x"z7X-Q
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";
stmt=conn.createstatement();
rs=stmt.executequery(sqlu);
%>@'C%PX)q
<script language='javascript'>#F0W:DJ#G{
arr = new array();
<%  int temp=0;
while(rs.next());qq[7qc w [*e
{
%>
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");
<%:H6k2i5_"yO ? pM~
temp = temp + 1;${m9aKZ_
}
%>0{ }lVz.I(|AB
temp=<%=temp%>;ywOi&z&k E2v
function changelocation(id){ BK,|3_/Rv
document.combo_box.city.length=0; //初始化第2级菜单的长度，下标从0开始 /d"]i ~BM)| Bt
var i = 0; ;M4M3kyOz7\GNJL
document.combo_box.city.options[0]=new option('-------','');
for(i=0;i<temp;i++){
if(arr[i][1]==id){//如果相等，证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
document.combo_box.city.options[document.combo_box.city.length] = new option(arr[i][0], arr[i][0]);
}
}
} 2V:N aRVbgk
</script>

<form name="combo_box">
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">2L7l jg;gwLk:C
  <tr height="24">aRc0\-~y-D*h:j$ojk
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>
<td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>(|QK2y/UD
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>DI:R}"pAE
  </tr>
  <tr> '|N*N#zTR4Z)\8CR
<td>B|"AA1xL[
  <select multiple id=prov name="prov" style="width:150;height:200" class="bgc">
  <option value="0">请选择部门 ---></option>
<%
string sqld="select * from tdept";B}&Y!\[$E8}
stmt=conn.createstatement();7\]'K;{Z*[O-?
rs=stmt.executequery(sqld);
while(rs.next())
{
%>CqEf)K
  <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>
<%bNl,vo:~A,Nq
}8Y&l;fa5lM E0_
%> oI1xY vQbc-t
  </select>9UmT%hd8]5xcp
</td>(?o7V|:Aweu(C
<td>
  <select multiple id=city style="width:150;height:200" class="bgc">7e+g jK+RE2Y
  </select>
</td>(W$Xeh-rW%B;Gl*Gd
<td nowrap align="center" class="bgc">U$l g-J-K][
  <input type="button"  value="<<" class="buttons">
  <input type="button"  value=">>" class="buttons">#Gv7z0KA&F3O'`Y
</td>+N[ @Yz/w
<td>#v)f*g@:a!W(y4u
  <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
  </select>
</td>GS1?+fZ:n'}r}
  </tr>#}o"Ux aOh[
<tr class="bgc">
<td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了！" ></td>:v\4MiO+xT
  </tr>
</table>h3uwC"Vm!F-x R
</form>
<script language="javascript">j7xnpL6V%Q B8h
//人名移动-X~kf oj:n{s
function move(fbox, tbox) {!d7Z4Zodk(sg
var arrfbox = new array();Qf@5hKK
var arrtbox = new array();
var arrlookup = new array();
var i;
for (i = 0; i < tbox.options.length; i++) {
arrlookup[tbox.options[i].text] = tbox.options[i].value;
arrtbox[i] = tbox.options[i].text;.U`AO7at]y&f&y
}l$R;mP^&_[d
var flength = 0;2l rH.j+B1zJ
var tlength = arrtbox.length;
for(i = 0; i < fbox.options.length; i++) {
arrlookup[fbox.options[i].text] = fbox.options[i].value;
if (fbox.options[i].selected && fbox.options[i].value != "") {
arrtbox[tlength] = fbox.options[i].text;
tlength++; ]b Ck!| yOu
}S ~vh3q U6K3}
else {
arrfbox[flength] = fbox.options[i].text;1f@&gIm
flength++;
}*_\{(~u
}
arrfbox.sort();
arrtbox.sort();

fbox.length = 0;\7]FJ*Ac
tbox.length = 0;PbK/v)l#P
var c;
for(c = 0; c < arrfbox.length; c++) {_P\J!P
var no = new option();
no.value = arrlookup[arrfbox[c]];#Q&~$wF,i~L
no.text = arrfbox[c];@ T!Sq"A+z
fbox[c] = no;-x#R'nejQ@6k!y
}
for(c = 0; c < arrtbox.length; c++) {
var no = new option();YFKK;Q)X4C
no.value = arrlookup[arrtbox[c]];1N^1]$fBl"j{y-Q
no.text = arrtbox[c];"f8Y3U^.J2jW
tbox[c] = no;
}
}6MYeEg)Q5H
</script>{5C3EQl+L!s
</body>Ny7{{k3Mt
[/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i]

页: [1]

捌玖网络工作室's Archiver

jsp+javascript打造级连菜单