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"O]lv4bj
%>Q?!Q} v)n SS7S
<style>vX:Y.C)vgO8Y
.f9{ font-size:9pt; }:zx#q/A{9N}
.bgc{ background-color:#aecaf9; color: #0033ff }
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;1J,Q_J H(RT
  border-bottom: solid 1px #4e7dc1; WR)tf'S'A
  border-left: solid 1px #aecaf9;5J/e4c EEE5L&\Y@
  border-right: solid 1px #5679bd;
  padding:1px;{6}/{YMCl8^(~B{
  margin:0px;}"R8LL NTK
</style>d,_Hd1]
<script language="javascript">L`&]e%JX"Z*^4n

</script>du{&o!x8K
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />qY4g C nV
<%b7i2yQ5kJ
  cdatasource ds=new cdatasource();  //数据联结bean实例zkAQ_Q(k
  java.sql.connection conn=ds.getconnection();/[6v1B(F%Z!T
  java.sql.statement stmt=null;
  java.sql.resultset rs=null;1nHD4n8I4d
  cdatacheck dc=new cdatacheck();H"Ugp*tm"F"Q(i
%>
<%
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";7flW4y5a$jJ
stmt=conn.createstatement();,G5K(Bfw1S K$B.N7K
rs=stmt.executequery(sqlu);
%>cF8_.u*r.b
<script language='javascript'>$q"_{9h$i0_
arr = new array();
<%  int temp=0;@:_*wr)x(?Q%p:{
while(rs.next())
{
%>
arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");:~)oHu"]]
<%(q/y(Woz|4nj9a5HK
temp = temp + 1;
}M r'`&J&o
%>
temp=<%=temp%>;:H Zfsw3eJb
function changelocation(id){
document.combo_box.city.length=0; //初始化第2级菜单的长度，下标从0开始 Z8] A}(G*i+hn
var i = 0; &RL9PO-?qu-cE
document.combo_box.city.options[0]=new option('-------','');
for(i=0;i<temp;i++){ ;I5bj8qNdJ4TH
if(arr[i][1]==id){//如果相等，证明在第2级里面有输入第1级组织的子集,arr[总数目][部门] &N:W?:g+TDou,n
document.combo_box.city.options[document.combo_box.city.length] = new option(arr[i][0], arr[i][0]);
}
}
}
</script>
5mG2h+hi+~_f
<form name="combo_box"> }O+Ui#E;{v ~
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59">
  <tr height="24">
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>SHtG9FIe X
<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>
<td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>!R b)kGv2Aqg
  </tr>
  <tr>
<td>
  <select multiple id=prov name="prov" style="width:150;height:200" class="bgc">
  <option value="0">请选择部门 ---></option>6DMP5SCs
<%
string sqld="select * from tdept";/Viv8?,oJ+d+YSN
stmt=conn.createstatement();
rs=stmt.executequery(sqld);7Fz5@hY)w:n
while(rs.next())p3`9\B8r1a'L+J-u
{
%>~ b(y.H^FNS
  <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>:N H&{:hl(f5D i
<%!UzBD.^
}
%> 9xI|:q[N,q[|k
  </select>
</td>#{K?0O0LlH b/N
<td>
  <select multiple id=city style="width:150;height:200" class="bgc">T-g%R4_"F7Aj
  </select>E/{2rHXE0U1}
</td>F,Z$Dw}N
<td nowrap align="center" class="bgc">kY-z]@v#gr
  <input type="button"  value="<<" class="buttons">QmA y3@
  <input type="button"  value=">>" class="buttons">p5yr9Dy A{4qWZ
</td>g:?x&M:zBfgBL
<td>
  <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">:g|\#~J]WX
  </select> z5X h ~u%['V
</td>
  </tr>
<tr class="bgc"> /Q D!`.J+D
<td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了！" ></td>v/HD$MNF&vi
  </tr>.qz7w{7D,O-_
</table>
</form>1|(CF-sFi/M
<script language="javascript">
//人名移动
function move(fbox, tbox) {
var arrfbox = new array();"aw)?I(zX
var arrtbox = new array();kE_u gkFq
var arrlookup = new array();G:t+nZ)wp"a%p-K$jI
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;,I*@6Hkr2Mh
}
var flength = 0;GDtgVc$p7f
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 != "") {Zke+K1u4gX&s.O(H
arrtbox[tlength] = fbox.options[i].text;k+Xn*qJC(_
tlength++; M(mJ%M3bl
}#\1P'OE3s_mBqS
else {
arrfbox[flength] = fbox.options[i].text;3Ph~)@)z
flength++;
}n'|2B(jN`M
}
arrfbox.sort();!V+E h)d*Yv/jjg,P
arrtbox.sort();I5_ A,rH!QQq:C
$^pe @O0~
fbox.length = 0;N? ?o_"`NNO
tbox.length = 0;
var c;/N1|,J/i#Q1C
for(c = 0; c < arrfbox.length; c++) {+Y9Q C7m.e'B._b
var no = new option();8qmSeh$l zrV
no.value = arrlookup[arrfbox[c]];'n+[x^c`E
no.text = arrfbox[c];0qf9P!fKx&jV#l:Ce
fbox[c] = no;2Y@-\q,|#[h
}Ne7ew$ZS"U:Ee
for(c = 0; c < arrtbox.length; c++) {B.a[{a7h
var no = new option();X a(k(^i)U3rF
no.value = arrlookup[arrtbox[c]];
no.text = arrtbox[c];@nu"s|8z"o"k_
tbox[c] = no; ]*[3S5mzs1D"en
}?p:j+D(|4O
}
</script>;oF+O'}$pER1aK%T
</body>
[/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i][/i]

页: [1]

捌玖网络工作室's Archiver

jsp+javascript打造级连菜单