这篇文章主要介绍了jsp中select的onchange事件用法,以实例形式较为详细的分析了JSP数据库查询、遍历及结合JavaScript响应鼠标事件处理select相关技巧,需要的朋友可以参考下
本文实例讲述了jsp中select的onchange事件用法。分享给大家供大家参考,具体如下:
- <script language = "JavaScript">
- var onecount;
- onecount=0;
- subcat = new Array();
- <%
- int count = 0;
- java.sql.ResultSet rs1 = DBManage.executeQuery("select hydm,zhydm,zhymc from zhy ");//读取数据
- while(rs1.next())
- {
- String selhydm=rs1.getString("hydm").trim();
- String zhydm=rs1.getString("zhydm").trim();
- String zhymc=rs1.getString("zhymc").trim();
- %>
- subcat[<%=count%>] = new Array("<%=zhydm%>","<%=selhydm%>","<%=zhymc%>");//产生数组
- <%
- count = count + 1;
- }
- if(rs1!=null) DBManage.closeCOnn();
- %>
- onecount=<%=count%>;
- function changelocation(id)
- {
- document.form1.selzhy.length = 0;
- var hydm=id;
- var i;
- document.form1.selzhy.options[0] = new Option('选择子行业分类','');
- for (i=0;i < onecount; i++)
- {
- if (subcat[i][1] == hydm)
- {
- document.form1.selzhy.options[document.form1.selzhy.length] = new Option(subcat[i][2], subcat[i][0]);
- }
- }
- }
- </script>
- <table width="500" border="0" cellspacing="0" cellpadding="0" align="center">
- <tr>
- <td width="180" height="20" align="right">选择行业分类:</td>
- <td width="320">
- <select name="selhy" onChange="changelocation(document.form1.selhy.options[document.form1.selhy.selectedIndex].value)" size="1" >
- <option value="2">请选择行业分类</option>
- <%
- rs = DBManage.executeQuery("select * from hy");
- while(rs.next())
- {
- String hydm=rs.getString("hydm").trim();
- String hymc=rs.getString("hymc").trim();
- %>
- <option value="<%=hydm%>"><%=hymc%></option>
- <%
- }
- if(rs!=null) DBManage.closeCOnn();
- %>
- </select>
- </td>
- </tr>
- <tr>
- <td height="20" align="right">选择子行业分类:</td>
- <td>
- <select name="selzhy" >
- <option value="" selected>请选择子行业分类</option>
- </select>
- </td>
- </tr>
- </table>
- <form name=form1>
- <select name=province onchange="cityName(this.selectedIndex)">
- <option value="">请选择省名</option>
- </select>
- <select name=city>
- <option value="">请选择城名</option>
- </select>
- </form>
- <script language=javascript>
- var city1 = ["杭州", "宁波", "温州", "绍兴", "金华", "湖州"];
- var city2 = ["南京", "苏州", "无锡", "常州", "镇江", "徐州"];
- var city3 = ["合肥", "翕县", "黄山", "祁门", "休宁"];
- var city4 = ["南昌", "九江", "赣州", "上饶", "新余", "景德镇"];
- var provinceName = ["浙江", "江苏", "安徽", "江西"];
- function province()
- {
- var e = document.form1.province;
- for (var i=0; i<provinceName.length; i++)
- e.options.add(new Option(provinceName[i], provinceName[i]));
- }
- function cityName(n)
- {
- var e = document.form1.city;
- for (var i=e.options.length; i>0; i--) e.remove(i);
- if (n == 0) return;
- var a = eval("city"+ n); //得到城市的数组名
- for (var i=0; i<a.length; i++) e.options.add(new Option(a[i], a[i]));
- }
- function window.onload()
- {
- province(); //初始时给省名下拉菜单赋内容
- }
- </script>
希望本文所述对大家JSP程序设计有所帮助。
新闻热点
疑难解答