📄 inputresult.jsp

📁 可以让初学者有一个感性的认识
💻 JSP
字号:
<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>

<BODY bgcolor=white><Font size=3>

<%!	public String getString(String s)
	{
		if(s==null)s="";
		try
		{
			byte a[]=s.getBytes("ISO-8859-1");
			s=new String(a);
		} catch(Exception e1){}
		return s;
	}
%>

<%	String s1=response.encodeRedirectURL("inputMessage.jsp");
	String s2=response.encodeRedirectURL("inputResult.jsp");
%>

<%	String account="",secret="";
	if(session.isNew())
		response.sendRedirect("login.jsp");
	else
	{
		account=(String)session.getAttribute("account");
		secret=(String)session.getAttribute("secret");
		secret=getString(secret);
		account=getString(account);
	}

	Connection con=null;
	Statement sql=null;
	ResultSet rs=null;
	boolean boo=false;
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}catch(ClassNotFoundException event){}
	try
	{
		con=DriverManager.getConnection("jdbc:odbc:manage","","");
		sql=con.createStatement();
		String condition="SELECT * FROM verify WHERE 帐号="+"'"+account+"'";
		rs=sql.executeQuery(condition);
		while(rs.next())
		{
			String	n=rs.getString("帐号");
			String	s=rs.getString("密码");
			if(account.equals(n)&&secret.equals(s))
			{boo=true;break;}
		} 
	}catch(SQLException e1){}
	if(boo)		
	{
		out.print("<P>输入学生的考试科目、成绩等信息：");
		out.print("<FORM action="+s2+" method=post>");
		out.print("<BR>学号：");
		out.print("<INPUT type=text name=number2>");
		out.print("<BR>科目: ");
		out.print("<INPUT type=text name=subject>");
		out.print("<BR>成绩: ");
		out.print("<INPUT type=text name=result>");
		out.print("<BR> <INPUT type=submit value=提交>");
		out.print("<FORM>");
	}
	else
		response.sendRedirect("login.jsp");
%>

<%	String number2=request.getParameter("number2");
	String subject=request.getParameter("subject");
	String result=request.getParameter("result");
	if(number2==null)number2="########";	
	number2=getString(number2);
	number2= number2.trim();
	subject = getString(subject);
	result = getString(result);
	String basicmessage="SELECT * FROM 基本信息 WHERE 学号="+"'"+number2+"'";
	try
	{
		sql=con.createStatement();
		rs=sql.executeQuery(basicmessage);
		boolean line=rs.next();
		if(line==false)
		{
			out.print("您还没有输入基本信息，");
			out.print("如果你输入的学号不在<BR>学生的基本信息表中，");
			out.print("请单击按钮：连接到学生<BR>基本信息输入页面");
		}
		else
		{
			out.print("<BR>学号"+ rs.getString(1));
			out.print("<BR>姓名" +rs.getString(2));
			out.print("<BR>专业" +rs.getString(3));
			out.print("<BR>年级" +rs.getString(4));
			String resultmessage="INSERT INTO 成绩 VALUES"+"("+"'"+number2+"','"+subject+"','"+result+"'"+")";
			sql.executeUpdate(resultmessage);
			out.print("<BR>成绩已被录入");
		}
	} catch(SQLException event)
	{
		out.print("<BR>"+subject+"该课程的成绩已经存在<BR>不允许重复输入");
	}
	con.close();
%>

	<BR><BR>
	<A href="inputMessage.jsp">连接到学生基本信息录入页面</A>

</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明

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