<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*"%>
<%request.setCharacterEncoding("GB2312");%>
<%@page pageEncoding="GB2312"%>
<jsp:useBean id="dbConnection" scope="page" class="myapp.DBConnection"/>
<jsp:useBean id="db" scope="page" class="myapp.DBConnection"/>
<jsp:useBean id="db1" scope="page" class="myapp.DBConnection"/>
<html>
<head>
<title>数据查询</title>
</head>
<script>
function sum(){
var
s=document.cj.a1.value/1+document.cj.a2.value/1+document.cj.a3.value/1+document.cj.a4.value
/1
document.cj.a5.value=s;}
</script>
<body>
<p align="center"><font size=2 color='blue'>该学生信息</font></p>
<form name="cj" method="post" action="yuejuan3.jsp">
<table width="650" border="0" bgcolor="#FFFFFF" cellspacing="1" align="center">
<tr style='font-size:9pt;color:#FF6600' bgcolor='#B8D85A' align='center'>
<td>学号</td>
<td>姓名</td>
<td>性别</td>
<td>系别</td>
<td>班级</td>
<td>试卷号</td>
</tr>
<%
dbConnection.getConnection();//调用DBConnection数据库连接方法
String stuNo=request.getParameter("stuNo");
String sql="select stu.stuNo,stuName,stuSex,stuSdept,stuClass,paperNo from stu,allStuPaper where stu.stuNo='"+stuNo+"'and stu.stuNo=allStuPaper.stuNo";//设置查询SQL语句
ResultSet rs=dbConnection.executeQuery(sql);//调用DBConnection数据查询方法
while (rs.next()){//获取学生数据表中的记录
String stuName=rs.getString("stuName");
String stuSex=rs.getString("stuSex");
String stuSdept=rs.getString("stuSdept");
String stuClass=rs.getString("stuClass");
String paperNo3=rs.getString("paperNo");
%>
<tr style='font-size:9pt;' align="left">
<td><input type="text" name="b1" value="<%=stuNo%>" disabled></td>
<td><input type="text" name="b2" value="<%=stuName%>" disabled></td>
<td><input type="text" name="b3" value="<%=stuSex%>" disabled></td>
<td><input type="text" name="b4" value="<%=stuSdept%>" disabled></td>
<td><input type="text" name="b5" value="<%=stuClass%>" disabled></td>
<td><input type="text" name="b6" value="<%=paperNo3%>" disabled></td>
</tr>
<%}
dbConnection.closeConn();//调用DBConnection关闭数据库连接方法
%>
</table>
<p align="left"><font size=2 color='blue'>总 得 分</font></p><input type="text" size="10" maxlength="3" name="a5" disabled >
下一个页面是接受参数的页面，要接受b1，b6和a5这三个参数，但传递过去插入数据库是控制。帮忙解决一下吧：
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*"%>
<%request.setCharacterEncoding("GB2312");%>
<%@page pageEncoding="GB2312"%>
<html>
<head>
<title>提交得分</title>
</head>
<body bgcolor="#ffffff" text="#000000">
<jsp:useBean id="sf" scope="page" class="myapp.DBConnection"/>
<%
sf.getConnection();
String paperNo=request.getParameter("b6");
String grade=request.getParameter("a5");
String stuNo=request.getParameter("b1");
String sql1="select * from report where stuNo='"+stuNo+"'";
ResultSet rs1=sf.executeQuery(sql1);
if(rs1.next())
{
rs1.close();
%>
<jsp:forward page="yuejuan5.htm"/>
<%}
else
{
rs1.close();
System.out.println("grade=" +grade);
System.out.println("paperNo=" +paperNo);
System.out.println("stuNo=" +stuNo);
String sql2="insert into report(paperNo,stuNo,grade)values ('"+paperNo+"','"+stuNo+"','"+grade+"')";
sf.executeUpdate(sql2);
}
%>
<jsp:forward page="yuejuan4.htm"/>
</body>
</html>
