<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%><%@ page import="java.sql.* "%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>jsp实现三级联动的下拉列表框效果</title><% Connection conn=null; Statement stmt=null; ResultSet rs=null,rs1=null,rs2=null; String sql; int count; int count2; String drivername="com.mysql.jdbc.Driver"; String url="jdbc:mysql://localhost:3306/test?characterEncoding=utf-8"; try{ Class.forName(drivername); conn=DriverManager.getConnection(url,"root","root"); stmt=conn.createStatement(); sql="select * from test.city order by locationid asc"; rs=stmt.executeQuery(sql); }catch(SQLException e){ System.out.println(e.getMessage()); } %><script language="javascript">var onecount;onecount=0;subcat=new Array();<%count=0;while(rs.next()){ %> subcat[<%=count%>]=new Array("<%=rs.getString("districtname")%>","<%=rs.getInt("locationid")%>","<%=rs.getInt("districtid")%>"); <% count = count + 1 ;
}rs.close();rs=null;%>onecount=<%=count%>;function changelocation(locationid){document.myform.smalllocation.length=0;var locationid=locationid;var i;document.myform.smalllocation.options[0]=new Option('==所选城市的地区==',''); for(i=0;i<onecount;i++){if (subcat[i][1] == locationid) { document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]); } }
}</script><% sql="select * from village order by districtid asc"; rs2=stmt.executeQuery(sql);%><script language="javascript">var onecount2;onecount2=0;subcat2=new Array();<%count2=0;while(rs2.next()){ %> subcat2[<%=count2%>]=new Array("<%=rs2.getString("villagename")%>","<%=rs2.getInt("districtid")%>","<%=rs2.getInt("villageid")%>"); <% count2 = count2 + 1 ;
}rs2.close();rs2=null;%>onecount2=<%=count2%>;function changelocation2(districtid) { document.myform.village.length = 0;
var districtid=districtid; var j; document.myform.village.options[0] = new Option('==所选地区的县区==',''); for (j=0;j < onecount2; j++) { if (subcat2[j][1] == districtid) { document.myform.village.options[document.myform.village.length] = new Option(subcat2[j][0], subcat2[j][2]); } }
} </script>
</head><body><form name="myform" method="post"> 分类：<select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)" size="1"> <option selected>请选择你所在的省份</option> <% sql ="select * from province order by locationname asc"; rs1 = stmt.executeQuery(sql); while(rs1.next()){ %> <option value="<%=rs1.getInt("locationid")%>"><%=rs1.getString("locationname")%></option>
<% } rs1.close(); rs1 = null; conn.close(); conn =null;
%> </select><select name="smalllocation" onChange="changelocation2(document.myform.smalllocation.options[document.myform.smalllocation.selectedIndex].value)"><option selected value="">==所有地区==</option> </select><select name="village" size="1"> <option selected>==所有县区==</option> </select> </form>
</body></html>
}rs.close();rs=null;%>onecount=<%=count%>;function changelocation(locationid){document.myform.smalllocation.length=0;var locationid=locationid;var i;document.myform.smalllocation.options[0]=new Option('==所选城市的地区==',''); for(i=0;i<onecount;i++){if (subcat[i][1] == locationid) { document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]); } }
}</script><% sql="select * from village order by districtid asc"; rs2=stmt.executeQuery(sql);%><script language="javascript">var onecount2;onecount2=0;subcat2=new Array();<%count2=0;while(rs2.next()){ %> subcat2[<%=count2%>]=new Array("<%=rs2.getString("villagename")%>","<%=rs2.getInt("districtid")%>","<%=rs2.getInt("villageid")%>"); <% count2 = count2 + 1 ;
}rs2.close();rs2=null;%>onecount2=<%=count2%>;function changelocation2(districtid) { document.myform.village.length = 0;
var districtid=districtid; var j; document.myform.village.options[0] = new Option('==所选地区的县区==',''); for (j=0;j < onecount2; j++) { if (subcat2[j][1] == districtid) { document.myform.village.options[document.myform.village.length] = new Option(subcat2[j][0], subcat2[j][2]); } }
} </script>
</head><body><form name="myform" method="post"> 分类：<select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)" size="1"> <option selected>请选择你所在的省份</option> <% sql ="select * from province order by locationname asc"; rs1 = stmt.executeQuery(sql); while(rs1.next()){ %> <option value="<%=rs1.getInt("locationid")%>"><%=rs1.getString("locationname")%></option>
<% } rs1.close(); rs1 = null; conn.close(); conn =null;
%> </select><select name="smalllocation" onChange="changelocation2(document.myform.smalllocation.options[document.myform.smalllocation.selectedIndex].value)"><option selected value="">==所有地区==</option> </select><select name="village" size="1"> <option selected>==所有县区==</option> </select> </form>
</body></html>
