您所在位置：主题：请各位帮忙！！！！！！11111
xufengqam
[专家分：0] 发布于 2005-11-30 18:07:00
在运行出现如图错误！又两张图分别传送！！！！可能太长请各位多费心了！！！
<!-- 查询学生密码 -->
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="test.ConnSQLServer"/>
<%!
ResultSet rs=null;
String classid="";
String classname="";
String priv_ok="";
int totaltime=0;
int totalques=0;
int totalpaper=0;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>课程信息管理</title>
<link rel="stylesheet" href="../public/style.css">
<style type="text/css">
<!--
.style1 {font-family: "华文新魏"}
.style2 {font-size: x-small}
-->
</style>
</head>
<body class="ss">
<center>
<%
priv_ok=(String)session.getAttribute("adminpriv");
if( priv_ok!=null&& priv_ok.equals("8") ){
rs= conn.executeQuery("select* from Test_Classinfo");
if(! rs.next()){
out.println("<center>");
out.println("数据库中还无课程信息!<br>");
out.println("单击此处<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
}else{
%>
<table bgColor="#FFFFE8" border="1" borderColorDark="#ffff00" borderColorLight="#000000" cellSpacing="1" width="80%">
<tr>
<th width="20%">课程代号</th>
<th width="16%">课程名称</th>
<th width="16%">考试时间</th>
<th width="16%">考试数目</th>
<th width="16%">试卷数目</th>
<th width="16%" colspan="2">操作</th>
</tr>
<%
do{
classid=rs.getString("classid");
classname=rs.getString("classname");
totaltime=rs.getInt("totaltime");
totalques=rs.getInt("totalques");
totalpaper=rs.getInt("totalpaper");
%>
<tr align="center">
<form action="classchange.jsp" method="post">
<td><%=classid %></td>
<input type="hidden" name="classid" value="<%=classid%>">
<td><input type="text" name="classname" value="<%=classname%>"></td>
<td><input type="text" name="totaltime" value="<%=totaltime%>"></td>
<td><input type="text" name="totalques" value="<%=totalques%>"></td>
<td><%=totalpaper%></td>
<input type="hidden" name="totalpaper" value="<%=totalpaper%>">
<td><input type="submit" name="oper" value="修改"></td>
<td><input type="submit" name="oper" value="删除"></td>
</form>
</tr>
<% } while(rs.next());%>
<tr>
<td colspan="7"><hr color="white"></td>
</tr>
<form action="classadd.jsp">
<tr align="center">
<td><input type="text" name="classid"value=""></td>
<td><input type="text" name="classname"value=""></td>
<td><input type="text" name="totaltime"value=""></td>
<td><input type="text" name="totalques"value=""></td>
<td> </td>
<td colspan="2">
<input type="submit" value="添加">
</td>
</tr>
</form>
</table>
<%
}
}else{
out.println("权限不足!<br>");
out.println("单击此处<a href=javascript:history.back()>返回</a><br>");
}
%>
</form>
</center>
<p align="center" class="style1"><span class="style2">©2005</span>徐峰 设计制作</p>
</body>
</html>
[img]http://E:新建文件/1.jpg[/img][img]http://E:新建文件/2.jpg[/img]
<!-- 查询学生密码 -->
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="test.ConnSQLServer"/>
<%!
ResultSet rs=null;
String classid="";
String classname="";
String priv_ok="";
int totaltime=0;
int totalques=0;
int totalpaper=0;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>课程信息管理</title>
<link rel="stylesheet" href="../public/style.css">
<style type="text/css">
<!--
.style1 {font-family: "华文新魏"}
.style2 {font-size: x-small}
-->
</style>
</head>
<body class="ss">
<center>
<%
priv_ok=(String)session.getAttribute("adminpriv");
if( priv_ok!=null&& priv_ok.equals("8") ){
rs= conn.executeQuery("select* from Test_Classinfo");
if(! rs.next()){
out.println("<center>");
out.println("数据库中还无课程信息!<br>");
out.println("单击此处<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
}else{
%>
<table bgColor="#FFFFE8" border="1" borderColorDark="#ffff00" borderColorLight="#000000" cellSpacing="1" width="80%">
<tr>
<th width="20%">课程代号</th>
<th width="16%">课程名称</th>
<th width="16%">考试时间</th>
<th width="16%">考试数目</th>
<th width="16%">试卷数目</th>
<th width="16%" colspan="2">操作</th>
</tr>
<%
do{
classid=rs.getString("classid");
classname=rs.getString("classname");
totaltime=rs.getInt("totaltime");
totalques=rs.getInt("totalques");
totalpaper=rs.getInt("totalpaper");
%>
<tr align="center">
<form action="classchange.jsp" method="post">
<td><%=classid %></td>
<input type="hidden" name="classid" value="<%=classid%>">
<td><input type="text" name="classname" value="<%=classname%>"></td>
<td><input type="text" name="totaltime" value="<%=totaltime%>"></td>
<td><input type="text" name="totalques" value="<%=totalques%>"></td>
<td><%=totalpaper%></td>
<input type="hidden" name="totalpaper" value="<%=totalpaper%>">
<td><input type="submit" name="oper" value="修改"></td>
<td><input type="submit" name="oper" value="删除"></td>
</form>
</tr>
<% } while(rs.next());%>
<tr>
<td colspan="7"><hr color="white"></td>
</tr>
<form action="classadd.jsp">
<tr align="center">
<td><input type="text" name="classid"value=""></td>
<td><input type="text" name="classname"value=""></td>
<td><input type="text" name="totaltime"value=""></td>
<td><input type="text" name="totalques"value=""></td>
<td> </td>
<td colspan="2">
<input type="submit" value="添加">
</td>
</tr>
</form>
</table>
<%
}
}else{
out.println("权限不足!<br>");
out.println("单击此处<a href=javascript:history.back()>返回</a><br>");
}
%>
</form>
</center>
<p align="center" class="style1"><span class="style2">©2005</span>徐峰 设计制作</p>
</body>
</html>
[img]http://E:新建文件/1.jpg[/img][img]http://E:新建文件/2.jpg[/img]