新手求助!!!代码改写!!帮帮忙啊!! 是不是要连接数据库的bean哦?搜索一下有很多的。至于上面的语句改成jsp是很容易的。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 连接数据库的代码都在conn.asp里面,至于asp页面也无非是循环读取数据,自己改都很快的 呵呵!我是JSP才入门啊!什么都不懂啊! 这个是我改的 还有很多毛病!大家帮我找找啊!<%@ page contentType="text/html;charset=gb2312"%><%@ page language="java" import="java.sql.*,java.util.Date" %><jsp:useBean id="dB" scope="page" class="conn" /><html><head><title>读取数据库的四级连动</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><script language="javascript"><!--function xb() { eval("parent.location='we.jsp?xb="+document.form1.select3.value+"'")}function class1() { eval("parent.location='we.jsp?xb=<%=request("xb")%>&class1="+document.form1.select1.value+"'")}function name1() { document.form1.name.value=document.form1.select2.value}//--></script></head><body><form name="form1" method="post" action="login.asp"> <table width="147" border="0" cellspacing="0" cellpadding="5"> <tr> <td> <div align="left"> <select name="select3" onchange="xb()"> <option selected>选择所在院系</option> <% set rs=conn.createStatement(); sql="select distinct departname from departs" rs.open sql,conn while (rs2.next()) %> <option value="<%=rs("departname")%>" <%if request("xb")=rs("departname")%>><%=rs("departname")%></option> </select> </div></td> </tr> <tr> <td width="137"> <div align="left"> <select name="select1" id="select1" onchange="class1()"> <option selected>选择所在班级</option> <% xb=request("xb") if xb<>"" set rs=conn.createStatement(); sql="select distinct classname from departs where departname='"&xb&"'" rs1.open sql,conn while (rs2.next()) %> <option value="<%=rs1("classname")%>" <%if request("class1")=rs1("classname")%>><%=rs1("classname")%></option> <% set rs1=nothing %> </select> </div></td> </tr> <tr> <td> <div align="left"> <select name="select2" onchange="name1()"> <option selected>选择学生姓名</option> <% class1=request("class1") if class1<>"" then set rs=conn.createStatement(); sql="select distinct studentname from student where departname='"&xb&"' and classname='"&class1&"'" rs2.open sql,conn while (rs2.next()) %> <option value="<%=rs2("studentname")%>"><%=rs2("studentname")%></option> <% set rs2=nothing conn.close set conn=nothing %> </select> </div></td> </tr></table></form></body></html>还有bean的代码可否帮我写一下。 onclick="window.open......传递参数问题 (Struts2) JAVA WEB 怎么发布呢 JSP 数据传递安全问题 ? 数据保存一会对一会报错,帮看看什么原因,一定加分 这一句话什么意思? servlet不能运行,大家帮忙看看 请介绍一个较好的jsp开发工具(IDE) IReport子报表问题! SpringBoot多线程如何捕捉子线程异常 jsp如何读注册表 在JSP中如何實現象本社區的給分功能
我是JSP才入门啊!什么都不懂啊!
大家帮我找找啊!
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sql.*,java.util.Date" %>
<jsp:useBean id="dB" scope="page" class="conn" />
<html>
<head>
<title>读取数据库的四级连动</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><script language="javascript">
<!--
function xb() {
eval("parent.location='we.jsp?xb="+document.form1.select3.value+"'")
}function class1() {
eval("parent.location='we.jsp?xb=<%=request("xb")%>&class1="+document.form1.select1.value+"'")
}function name1() {
document.form1.name.value=document.form1.select2.value
}
//-->
</script>
</head>
<body>
<form name="form1" method="post" action="login.asp">
<table width="147" border="0" cellspacing="0" cellpadding="5">
<tr>
<td>
<div align="left">
<select name="select3" onchange="xb()">
<option selected>选择所在院系</option>
<%
set rs=conn.createStatement();
sql="select distinct departname from departs"
rs.open sql,conn
while (rs2.next())
%>
<option value="<%=rs("departname")%>" <%if request("xb")=rs("departname")%>><%=rs("departname")%></option>
</select>
</div></td>
</tr>
<tr>
<td width="137">
<div align="left">
<select name="select1" id="select1" onchange="class1()">
<option selected>选择所在班级</option>
<%
xb=request("xb")
if xb<>""
set rs=conn.createStatement();
sql="select distinct classname from departs where departname='"&xb&"'"
rs1.open sql,conn
while (rs2.next())
%>
<option value="<%=rs1("classname")%>" <%if request("class1")=rs1("classname")%>><%=rs1("classname")%></option>
<%
set rs1=nothing
%>
</select>
</div></td>
</tr>
<tr>
<td>
<div align="left">
<select name="select2" onchange="name1()">
<option selected>选择学生姓名</option>
<%
class1=request("class1")
if class1<>"" then
set rs=conn.createStatement();
sql="select distinct studentname from student where departname='"&xb&"' and classname='"&class1&"'"
rs2.open sql,conn
while (rs2.next())
%>
<option value="<%=rs2("studentname")%>"><%=rs2("studentname")%></option>
<%
set rs2=nothing
conn.close
set conn=nothing
%>
</select>
</div></td>
</tr>
</table>
</form>
</body>
</html>还有bean的代码可否帮我写一下。