📄 jisuan.java.bak
字号:
//Jisuan.java
//计算考试成绩的servlet
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;
public class Jisuan extends HttpServlet
{
//初始化数据库类
static Connection conn;
DBConnectionBean dbcb = new DBConnectionBean();
//定义doPost方法用来接受数据
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
int AllFenS = 0;
int AllFenF = 0;
//定义输出流
req.setCharacterEncoding("gb2312");
res.setContentType("text/html;charset=gb2312");
PrintWriter out = res.getWriter();
//提取表单数据
String BID = req.getParameter("BID");
String select1 = req.getParameter("select1").trim();
String select2 = req.getParameter("select2").trim();
String select3 = req.getParameter("select3").trim();
String select4 = req.getParameter("select4").trim();
String select5 = req.getParameter("select5").trim();
String select6 = req.getParameter("select6").trim();
String select7 = req.getParameter("select7").trim();
String select8 = req.getParameter("select8").trim();
String select9 = req.getParameter("select9").trim();
String select10 = req.getParameter("select10").trim();
String yesDanan1 = req.getParameter("yesDanan1").trim();
String yesDanan2 = req.getParameter("yesDanan2").trim();
String yesDanan3 = req.getParameter("yesDanan3").trim();
String yesDanan4 = req.getParameter("yesDanan4").trim();
String yesDanan5 = req.getParameter("yesDanan5").trim();
String yesDanan6 = req.getParameter("yesDanan6").trim();
String yesDanan7 = req.getParameter("yesDanan7").trim();
String yesDanan8 = req.getParameter("yesDanan8").trim();
String yesDanan9 = req.getParameter("yesDanan9").trim();
String yesDanan10 = req.getParameter("yesDanan10").trim();
//计算分数
if(select1.equals(yesDanan1))
{
AllFenS = AllFenS + 10;
}
if(select2.equals(yesDanan2))
{
AllFenS = AllFenS + 10;
}
if(select3.equals(yesDanan3))
{
AllFenS = AllFenS + 10;
}
if(select4.equals(yesDanan4))
{
AllFenS = AllFenS + 10;
}
if(select5.equals(yesDanan5))
{
AllFenS = AllFenS + 10;
}
if(select6.equals(yesDanan6))
{
AllFenS = AllFenS + 10;
}
if(select7.equals(yesDanan7))
{
AllFenS = AllFenS + 10;
}
if(select8.equals(yesDanan8))
{
AllFenS = AllFenS + 10;
}
if(select9.equals(yesDanan9))
{
AllFenS = AllFenS + 10;
}
if(select10.equals(yesDanan10))
{
AllFenS = AllFenS + 10;
}
AllFenF = AllFenS;
try
{
//桥接连接数据库,保存考生成绩
conn = dbcb.openConnection();
System.out.println("数据库连接成功...."+select5+yesDanan5);
PreparedStatement s = conn.prepareStatement
("UPDATE allStuday SET Score=?, tag = 1 WHERE SID=?");
s.setInt(1,AllFenF);
s.setString(2,BID);
int rows = s.executeUpdate();
System.out.println("发送SQL命令成功....");
if(rows==1)
{
System.out.println("用户 " + BID + "成绩为" + AllFenF + "保存成功!");
}
out.println("<html>");
out.println("<head>");
out.println("<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>");
out.println("<title>");
out.println("已答题完毕");
out.println("</title>");
out.println
("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/youno.js'>");
out.println("</script>");
out.println("<link href='/myside/examin/img/cssexamin.css' rel='stylesheet' type='text/css'>");
out.println("</head>");
out.println("<body>");
out.println("<div align='center'>");
out.println("您的成绩已经存在，请输入您的用户名，以便查询您的成绩!");
out.println("<form name='form1' method='post' action='/myside/examin/loginC.jsp'>");
out.println("I D:");
out.println("<input name='textfield' type='text' value=" + BID + " size='15'>");
out.println("<input type='submit' name='Submit' value='提交'>");
out.println("<p>");
out.println("</p>");
out.println("</div>");
out.println("</body>");
out.println("</html>");
out.close();
}
//三个常见异常
catch(SQLException e)
{
System.out.println(e.toString());
}
catch(Exception e)
{
System.out.println(e.toString());
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -