JSP大小类用列表框来实现怎么做
<TD> <select name= "selectm " id= "select ">
<option value= " "> 大类 </option>
<%
rs=p_dbBean.executeQuery( "select * from aa ");
while (rs.next())
{
%>
<option value= " <%=rs.getString( "id ")%> "> <%=rs.getString( "aa ")%> </option>
<%
}
%>
</select>
</TD>
<td> <select name= "selectm1 " id= "select1 ">
<option value= " "> 小类 </option>
<%
rs1=p_dbBean.executeQuery( "select * from bb where tt= ' " + mm + " ' ");
while (rs1.next())
{
%>
<option value= " <%=rs1.getString( "TT ")%> "> <%=rs1.getString( "gg ")%> </option>
<%
}
%>
</select> </td>
[解决办法]
描述的不清楚~……
[解决办法]
动态二级联动菜单
<form name=Form type=post>
<select name= "dep " onchange= "onChange(this.value) "> //当值改变时就执行函数
<option value= "部门ID "> 部门名 </option> //中间的option是从数据库读出生成的
</select>
<select name= "name ">
<option value= "0 "> 请先选择部门 </option>
</select>
</form>
<script LANGUAGE=JavaScript>
<!--
var name=new Array();
<%
for(int i=0;i <parrStsUserList.size();i++)
{
pobjCp = (Cp)parrStsUserList.get(i);
out.println( "name[ "+i+ "]=new Array( ' "+pobjCp.getCpID()+ " ', ' "+pobjCp.getCpname()+ " ', ' "+pobjCp.getCpuseid()+ " '); ");
}
%>
-->
</script>
getCpID是ID，getCpname是名字（王小二），getCpuseid是他的部门ID
<script LANGUAGE=JavaScript>
<!--
function onChange(dep)
{
ln = Form.name.options.length;
while(ln--) {
Form.name.options[ln] = null;//清空员工姓名的select的值
}
for(i=0;i <name.length;i++)
{
if(name[i][2]==dep)//如果name[i][2]部门ID等于dep时
{
Form.name.add(new Option(name[i][0],name[i][1]));//就给员工姓名的select增加一个option,name[i][0],name[i][1]这两个的位置你自己试试
}
}
}
-->
</script>
[解决办法]
基本有三种方式：
1）select 响应onchange事件是，进行表单提交
2）先取出数据动态生成js数组，使用js函数来完成这项工作
3）考虑使用ajax技术，不用刷新页面呦
[解决办法]
看不明白楼主？
[解决办法]
简单的说法就是：先选择大类的值，然后依据大类的值从数据库检索出小类的选项供你选择。
[解决办法]
是这样的
<table>
<tr>
<td style="width:10%">
</td>
</tr>
</table>
[解决办法]
以前学习这块儿的时候写的，楼主可以参考一下
<%@ page language="java" import="java.util.*,java.sql.*,com.allan.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script language="javascript">
function F_super(val){
window.location.href="select.jsp?superID="+val;
}
</script>
</head>
<body>
<%
Test test = new Test();//实现数据库操作的JavaBean
ResultSet rs = test.query("select * from super group by superID");
int superID = -1;//super表中存放大类的ID和name,sub表存放小类的ID和name
String superName ="";
if(rs.next()){
superID = rs.getInt(1);
}
else{
out.println("<script language='javascript')>alert('请输入类别信息')；</script>");
return;
}
int pid = -1;//存放当前大类的ID
if(request.getParameter("superID")==""|request.getParameter("superID")==null){
pid = superID;//默认为第一个大类的ID
}else{
pid = Integer.parseInt(request.getParameter("superID"));
}
Test test1 = new Test();
ResultSet rs1 = test1.query("select * from sub where pid="+pid);
int subID = -1;
String subName = "";
%>
<select name="supertype" id="supertype" onChange="F_super(this.value)">
<%
rs.first();
do{
superID=rs.getInt(1);
superName=rs.getString(2);
%>
<option value="<%=superID %>"<%if(superID==pid){out.println("selected");} %>><%=superName %></option>
<%}while(rs.next()); %>
</select>
<select name="typeID" id="typeID">
<%while(rs1.next()){
subID=rs1.getInt(1);
subName=rs1.getString(2);
%>
<option value="<%=subID %>"><%=subName %></option>
<%} %>
</select>
</body>
</html>
