关jsp中二级联动下拉框代码解决方案

关jsp中二级联动下拉框代码
本人才学javaweb,一头雾水,希望大家能够帮我解决一下:

我是想达到这样的目的:

就是选择一个省份的时候第二级菜单就显示相应的市区以及直辖市,然后直接添加到数据库里面就是!用jsp页面上写!

------解决方案--------------------
方法有很多种,可以在省的控件上做一个onchange事件,每一个省份都有一个key一个value,然后根据key去找该key下面的所有市县,或者ajax发送请求,去数据库找,或者省市县的值都写死,固定来找,
------解决方案--------------------
直接在页面上添加,那么多的省要添加多少个啊
------解决方案--------------------
onchange吧,我才刚实现了
------解决方案--------------------
<html>
<head>
<title>多级关联菜单</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<head>
<script language="JavaScript">
<!--
function Dsy()
{
 this.Items = {};
}
Dsy.prototype.add = function(id,iArray)
{
 this.Items[id] = iArray;
}
Dsy.prototype.Exists = function(id)
{
 if(typeof(this.Items[id]) == "undefined") return false;
 return true;
}
function change(v){
 var str="0";
 for(i=0;i<v;i++){ str+=("_"+(document.getElementById(s[i]).selectedIndex-1));};
 var ss=document.getElementById(s[v]);
 with(ss){
length = 0;
options[0]=new Option(opt0[v],opt0[v]);
if(v && document.getElementById(s[v-1]).selectedIndex>0 || !v)
{
if(dsy.Exists(str)){
ar = dsy.Items[str];
for(i=0;i<ar.length;i++)options[length]=new Option(ar[i],ar[i]);
if(v)options[1].selected = true;
}
}
if(++v<s.length){change(v);}
 }
}
var dsy = new Dsy();
dsy.add("0",["安徽","北京","福建","甘肃","广东","广西","贵州","海南","河北","河南","黑龙江","湖北","湖南","吉林","江苏","江西","辽宁","内蒙古","宁夏","青海","山东","山西","陕西","上海","四川","天津","*","*","云南","浙江","重庆"]);
dsy.add("0_0",["安庆","蚌埠","巢湖","池州","滁州","阜阳","合肥","淮北","淮南","黄山","六安","马鞍山","宿州","铜陵","芜湖","宣城","亳州"]);
//-->
</script>
<script language = JavaScript>
<!--
var s=["s1","s2","s3"];
var opt0 = ["-省-","-市-"];
function setup()
{
 for(i=0;i<s.length-1;i++)
document.getElementById(s[i]).onchange=new Function("change("+(i+1)+")");
 change(0);
}
//-->
</script>
</head>
<body onload="setup()">
<form name="frm">
<select id="s1"><option>省</option></select>
<select id="s2"><option>市</option></select>
</form>
</body>
</html>


------解决方案--------------------
<html>
<head>
<title>全国省市县无刷新多级关联菜单</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<head>
<script language="JavaScript">
<!--
function Dsy()
{
 this.Items = {};
}
Dsy.prototype.add = function(id,iArray)
{
 this.Items[id] = iArray;
}
Dsy.prototype.Exists = function(id)
{
 if(typeof(this.Items[id]) == "undefined") return false;