📄 threemenu.txt
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%@ page import="com.db.*"%>
<%String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<%
//通过查询数据据库取出级联菜单第一级菜单目录
Connection con = DB.getDBConnection();
String sql = "select ID,name,fatherID from threeSelect where fatherID='0'";
List list = new ArrayList();
list = DB.dbqueryList(sql, con);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'twoselect.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<div align=center>
<center>
<form name="main" method="post" action="save.jsp">
<table id=AutoNumber1 style="font-size:10pt;border-collapse:collapse" borderColor=#c0c0c0 cellPadding=0 width=760 border=1>
<tr>
<td align=middle width=68>
国 家
</td>
<td width=682>
<select name="maintype" onChange="changemaintype(document.main.maintype.options[document.main.maintype.selectedIndex].value);">
<option value="">
--请选择--
</option>
<%for (int i = 0; i < list.size(); i++) {
Map map = (Map) list.get(i);
String id = map.get("ID").toString();
String name = map.get("NAME").toString();
%>
<option value="<%=id%>">
<%=name%>
<%}
%>
</select>
</td>
</tr>
<tr>
<td align=middle width=68>
省 份
</td>
<td width=682>
<select name="detailtype" onChange="changedetailtype(document.main.detailtype.options[document.main.detailtype.selectedIndex].value);">
<option value="">
--请先选择国家--
</option>
</select>
</td>
</tr>
<tr>
<td align=middle width=68>
城 市
</td>
<td width=682>
<select name="three">
<option value="">
--请先选择城市--
</option>
</select>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="提交">
</td>
</tr>
</table>
</form>
</body>
<script language="JavaScript">
var subcat2=new Array();
<%
String sql1="select ID,name,fatherID from threeSelect";
List list1=new ArrayList();
list1=DB.dbqueryList(sql1,con);
%>
<%for(int i=0;i<list1.size();i++)
{
Map map1=(Map)list1.get(i);
%>
var count=<%=list1.size()%>;
subcat2[<%=i%>]=new Array("<%=map1.get("FATHERID").toString()%>","<%=map1.get("ID").toString()%>","<%=map1.get("NAME").toString()%>");
<% }
%>
function changemaintype(locationid)
{
document.main.detailtype.options[0]=new Option("--请选择--","");
document.main.three.options[0]=new Option("--请选择--","");
document.main.detailtype.length=1;
document.main.three.length=1;
var locationid=locationid;
var ii;
for(ii=0;ii<count;ii++)
{
if((subcat2[ii][0]==locationid))
{
document.main.detailtype.options[document.main.detailtype.length]=new Option(subcat2[ii][2],subcat2[ii][1]);
}
}
}
function changedetailtype(locationid)
{
document.main.three.options[0]=new Option("--请选择--","");
document.main.three.length=1;
var locationid=locationid;
var iii;
for(iii=0;iii<count;iii++)
{
if((subcat2[iii][0]==locationid))
{
document.main.three.options[document.main.three.length]=new Option(subcat2[iii][2],subcat2[iii][1]);
}
}
}
</script>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -