java js 二级联动下拉列表_Jsp+javascript打造二级级联下拉菜单

数据库需求分析：

class(一级栏目信息)：classId(自动编号)，className(栏目名称)

Nclass(二级栏目信息)：NclassId(自动编号)，NclassName(栏目名称)，parentId(一级栏目id，与class表中的classId关联)

级联菜单

ResultSet rs=stmt.executeQuery(sql);

%>

var onecount;

onecount=0;

subcat = new Array();

int count = 0;

while(rs.next()){

%>

subcat[] = new Array("","","");

count++;

}

rs.close();

%>

onecount=;

function changelocation(locationid)

{

document.myform.NclassId.length = 0;

var locationid=locationid;

var i;

for (i=0;i < onecount; i++)

{

if (subcat[i][2] == locationid)

{

document.myform.NclassId.options[document.myform.NclassId.length] = new Option(subcat[i][0], subcat[i][1]);

}

}

}

一级分类

==请选一级分类== SELECT * FROM class ${row.className}

选择二级分类

==请选二级分类==