⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 22.jsp

📁 基于JSP的网上考试系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" import="java.util.*" import="java.lang.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />

<BODY>学号:张晓明<BR>
题号:第一题<BR>
考生答案:<BR>
<%linejdbc.setdrivername();%>
<%
String da = request.getParameter("answer").replaceAll("\n", "<BR>");

Connection con = linejdbc.getopenConnection();
PreparedStatement p = con.prepareStatement("UPDATE chengji SET daan =? WHERE (xuehao = '123') AND (tihao = '2')");
			p.setString(1,da);
			
			 int rows = p.executeUpdate();
			//System.out.println("发送SQL命令成功....");
			if(rows==1)
							{
								System.out.println("用户 ");
							}
							PreparedStatement s = con.prepareStatement("SELECT daan FROM chengji WHERE (xuehao = '123') AND (tihao = '2')");
							ResultSet results = s.executeQuery();;
			 results.next();
			  String lala=results.getString("daan");
			 %>
	<%=lala%><BR>		
满分:10分<BR>
判定分数:<INPUT TYPE="text" NAME="">
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -