联动select选项的选定

最新推荐文章于 2022-10-25 20:50:54 发布

laiahu

最新推荐文章于 2022-10-25 20:50:54 发布

阅读量1.1k

点赞数

分类专栏： Java 文章标签： null import string sql html javascript

本文链接：https://blog.csdn.net/laiahu/article/details/1618689

版权

Java 专栏收录该内容

74 篇文章 0 订阅

订阅专栏

联动select的选定

<%@ page language="java" contentType="text/html; charset=gbk"
    pageEncoding="gbk"%>
<%@ page import="java.sql.*"%>
<%@ page import="my.bbs.connections.DBConn"%>
<%@ page import="my.bbs.com.ConvertString" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>添加汽车的品牌种类(//联动select的选定)</title>
<script language="javascript">

</script>
</head>
<body>
<%!
//显示所有的汽车种类
String str2="";
ConvertString convert = new ConvertString();
private void showOptions2(Connection conn) {

Statement stmt = null;
ResultSet rs = null;
try {
  stmt = conn.createStatement();
  String sql = "select * from car_type where ct_isparent=1 and ct_pid=0";
  rs = stmt.executeQuery(sql);

  while (rs.next()) {
   str2 += "<option value='" + rs.getInt("ct_id") + "'>"
     + convert.convertString(rs.getString("ct_name")) + "</option>";
  }
} catch (SQLException e) {
  e.printStackTrace();
} finally {
  try {
   if (rs != null) {
    rs.close();
    rs = null;
   }
   if (stmt != null) {
    stmt.close();
    stmt = null;
   }
   if(conn!=null) {
    conn.close();
    conn = null;
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
}
}

%>
<%
DBConn dbConn2 = new DBConn();
Connection conn = dbConn2.getConn();
str2=""; //显示种类
showOptions2(conn);

%>
<form atcion="" method="post" name="carTypeForm">
<table>
<tr>
    <td>所属种类</td>
    <td><select name="ct_pid" οnchange="changelocation(document.carTypeForm.ct_pid.options[document.carTypeForm.ct_pid.selectedIndex].value)">
         <option value="">==主种类==</option>
         <%=str2%></select></td>
</tr>
    <tr>
    <td>所属种类系列</td>
    <td><select name="ct_id" ></select></td>
</tr>
</table>
</form>
</body>
</html>