22.jsp

来自「基于JSP的网上考试系统」· JSP 代码 · 共 40 行

JSP
40
字号
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?