捌玖网络工作室's Archiver

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

jsp+javascript打造级连菜单

<%@ page import="java.util.date,yava.fileapp.*,java.sql.*;"1K;]/pY{I
         c pageencoding="gb2312" Sfs%NQ8U
%>
-Y(o,fcSZl$kT;gF <style>
$M&aR P.xvw+J0hm .f9{ font-size:9pt; } N | m e K,[l3X
.bgc{ background-color:#aecaf9; color: #0033ff }$jt1m2l$Nkl
.buttons{font-family:arial; font-size:13px; font-weight:bold; background-color:#6796e4; color:white; border-top: solid 2px #aacafb;:?3G;mtRw
  border-bottom: solid 1px #4e7dc1;
:z B7n[u:N z ~ ~;Ap   border-left: solid 1px #aecaf9;*F X;y8pCN#]
  border-right: solid 1px #5679bd;
QkZKw/r$f   padding:1px;W.?}*uuu{/B7lU
  margin:0px;}
HLh{D </style>;Ey!~ dP)},w
<script language="javascript">ERCn5V'qYq B
<!--&@EWj(j U
function rv()| mJ%[,W6z j j+X
{
eA'jnrvT@   var val="";
U h}/D5VJO   for(i=0;i<combo_box.list2.length;i++){5`^E0f j&{)d]
   val+=","+combo_box.list2[i].value;
#d(FO V7S.|u   } w#UH~!v'~
  if(val.charat(0)==","){
2z&yg_ ]0P    val=val.substr(1,val.length);
-E(P8\Sn   }+S U4hk y|DF&L
  opener.form1.frecname.value=val;2MG#~w[2_
  self.close();
d9w uEL/QE }
[[S.qF/M&l;~ //-->6uK [5B\})z/_\1k7C2lv+v
</script>
'^ G7poo <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">5F-m wmD|
<jsp:usebean id="user" scope="session" class="yava.fileapp.userbean" />
0QgN a6M;H:g <%
f%W*IbJ}ymo#C1M@U   cdatasource ds=new cdatasource();  //数据联结bean实例
|*D@v1|D-gS   java.sql.connection conn=ds.getconnection();
vg1X%_*Aj)[   java.sql.statement stmt=null;
:YC)ra6{!q { t:Yj5n   java.sql.resultset rs=null;
^x0idP~g ?7LR   cdatacheck dc=new cdatacheck();
}.l(q%m#h %>
e,n*nY{*O^'[S <%
K PJ9pu e;a,d#z@ 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";3Z2w }Fv;ca3^`
stmt=conn.createstatement();g~S q[!V2~ v
rs=stmt.executequery(sqlu);S ]"v3d&T{
%>n C(g Wa%Y$H*E
<script language='javascript'>K7|$?m)p vl7i2w
arr = new array();GY9tV~'Um
<%  int temp=0;D/sxU6y MGE b
while(rs.next())
H)^P!VB5nli#_{r0A-QE { d-Z nzpO/^'@)s
%>
Ty:K^X arr[<%=temp%>]=new array("<%=rs.getstring("fname")%>","<%=rs.getstring("fdept")%>");&dk5m6D(P n P
<%
P(yx _D c;r temp = temp + 1;wk7b_9qP"e
}`(ZBcJ `&b
%>
-WY9tx*Q2L7e temp=<%=temp%>;][4X5mD
function changelocation(id){
BYx)UrH document.combo_box.city.length=0; //初始化第2级菜单的长度,下标从0开始
0S8Q7Oc!z}O oJ var i = 0; \CD4p4EH
document.combo_box.city.options[0]=new option('-------',''); )E(z;h7U P~f
for(i=0;i<temp;i++){ [${+O"{%V
if(arr[i][1]==id){//如果相等,证明在第2级里面有输入第1级组织的子集,arr[总数目][部门]
q N vK_M"Y&H&gg document.combo_box.city.options[document.combo_box.city.length] = new option(arr[i][0], arr[i][0]); 5^4xIt-Y
} VDk6MP){r%\
}
|BO-z'wzrO } )u{jHR~%f
</script>8W db(nL^:U
x I9Azd]@S
<form name="combo_box">vB#^M;^)l
<table border="0" cellspacing="0" cellpadding="0" height="210" width="59"> W:U _yQn$~4A
  <tr height="24">${6T2K;U(xLm
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>部门选择</font></td>#j)E]a3}
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>人名选择</font></td>1eM3zYL7t#C
    <td bgcolor="#336699" class="buttons" align=center nowrap><font color=#ffffff>添加/移除</font></td>-lt@3|'SV(cl
    <td bgcolor="#336699" class="buttons" align=center><font color=#ffffff>最终人</font></td>EgG['t!x;w
  </tr>'K(H2s!O U2gm
  <tr>
r)yw3G3RJ`?}n     <td>i?,tA1b`~.\4p
  <select multiple id=prov name="prov"    style="width:150;height:200" class="bgc">
G-d&\PD   <option value="0">请选择部门 ---></option>
5w:T,ovn <%
/Hvr4|S4U!p     string sqld="select * from tdept";
'mR~-i`h stmt=conn.createstatement();
aZRNxqLx rs=stmt.executequery(sqld);
6g,bEdQ#j+Qj#T while(rs.next())P]lqp#n
{
j\f7e ep7]D~6w %>)? M$}{#@A)};E[:n8GX
  <option name="<%=rs.getstring("fno")%>"><%=rs.getstring("fname")%></option>
'ge(w)U%K2a7W NZs C&O <%
;m3e5iD.T9SS9z|AfTf }
D(W1j.p+Q+HqR %>
D"E{ Tw9M(^z   </select>
V B.mJ;lH1F </td>
,u4r&P p&O(Vy     <td>+zyE8v4|`!l\
  <select multiple id=city style="width:150;height:200" class="bgc">g+Q*p,s$r1K4t4Y O
  </select>}+iT#yC5ttO
</td>
z{TWIi     <td nowrap align="center" class="bgc">
r,XHs rFnC   <input type="button"  value="<<" class="buttons">
k:h#Ao`a)D   <input type="button"  value=">>" class="buttons">
.~2X!p&h:db V~ </td>
e:SVJ3U)b@4[6_8P w(?     <td>
w0t MqY+_v   <select multiple size="10" name="list2" style="width:150;height:200" class="bgc">
/l$T0P s,] b   </select>
/T)n6BeMt:x1L </td>6}W'y4sNY6d
  </tr>/~!Vs-|c+[5d.z3B(p
    <tr class="bgc">
6k8V@Y[9ZO.^.g(r%}     <td colspan="4" align="center"><input type="button" name="button1" class="buttons" value="选好了!" ></td> m1yX2EvP
  </tr>
Aeg[dm_I </table>
N*zP v a_ </form>3|M!^~ @9Cg
<script language="javascript">
)bC4n6f]p3Q.i#B //人名移动3ax"S5PK1Z_x,r
function move(fbox, tbox) {
,RoqLLd w var arrfbox = new array();
&x%R@3VT^)h:Y var arrtbox = new array();
~/o y_ izYr var arrlookup = new array();2K'aT%ngeQ#l{&P(m4g
var i;f%Kr~!{j6o/I_y
for (i = 0; i < tbox.options.length; i++) {:i)TcuEyhh
arrlookup[tbox.options[i].text] = tbox.options[i].value;
.y,I$hK5}C8a#Y7t-n arrtbox[i] = tbox.options[i].text;)O7w@-|YL0K
}
O@L(wue var flength = 0;:W'x;[%V:s
var tlength = arrtbox.length;
T0},v R Q1Ry for(i = 0; i < fbox.options.length; i++) {xE8G!`wu
arrlookup[fbox.options[i].text] = fbox.options[i].value;4u[n qq9n ^
if (fbox.options[i].selected && fbox.options[i].value != "") {
YKlmA y arrtbox[tlength] = fbox.options[i].text;
@*N&{s;A|r tlength++;
q-a\.[w }
*i xZ5OsQIf*_P2m else {
^U\j^RC]2x arrfbox[flength] = fbox.options[i].text;
J9BVBM!\$tnp flength++;&QS!^:L?~
   }KN(Uw,n J}s
}
v7nI:[6Q'H!z arrfbox.sort();'L1Z&j/r7xyT2[%o5n
arrtbox.sort();
n9xii pz
t6u;G#}3x fbox.length = 0;gq(hMzeV
tbox.length = 0;E9m6h H S!O$Sx
var c;
RG\1YHL6I5^8[,bI for(c = 0; c < arrfbox.length; c++) {
b si,X*k1~ var no = new option(); ?rld:GcO/Xp
no.value = arrlookup[arrfbox[c]];
|g/c:q,HYb no.text = arrfbox[c];+t(R'g#}$N
fbox[c] = no;'[0c Y*{nw\
}
ym1GrZG/d5P for(c = 0; c < arrtbox.length; c++) {
za5E7~(v&l3T9Q var no = new option();9U/Q ?ec k
no.value = arrlookup[arrtbox[c]];(\[-n5m9R%a0BZf
no.text = arrtbox[c];
6s G&O-};{z6CD M tbox[c] = no;.gr3y6I,n+rL3G GW
   } U+NjSe
}?6C ]YS%F
</script>
Y oc0_]qp </body>_)e4N e&k-_:[j
[/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.