📄 inquire.jsp

📁 可以让初学者有一个感性的认识

💻 JSP

字号:

<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>

<BODY bgcolor=orange><Font size=3>
<FORM action="" method=post>
	输入学生的学号：
	<INPUT type="text" name="number">
	<INPUT type="submit" value="提交" name="g">
</FORM>

<%!	Connection con=null;
%>

<%		
	String studentNumber=request.getParameter("number");
	if(studentNumber==null) studentNumber ="?";
	byte c[]=studentNumber.getBytes("ISO-8859-1");
	studentNumber =new String(c);

	Statement sql=null;
	ResultSet rs=null;
	if(con==null)
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){out.print(e);}
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:manage","","");
			String condition="SELECT * FROM 成绩 WHERE 学号="+"'"+ studentNumber +"'";
			sql=con.createStatement();
			rs=sql.executeQuery(condition);
			out.print("I am the first.");
		} catch(SQLException e1){ out.print(e1);}
	}
	else
	{
		synchronized(con)
		{
			try
			{
				sql=con.createStatement();
				String condition="SELECT * FROM 成绩 WHERE 学号="+"'"+ studentNumber +"'";
				rs=sql.executeQuery(condition);
			} catch(SQLException e1){ out.print(e1);}
		}
	}
	try
	{
		out.print("<Table Border>");
		out.print("<TR>");
			out.print("<TH width=100>"+"学号");
			out.print("<TH width=100>"+"课程名称");
			out.print("<TH width=50>" +"成绩");
		out.print("</TR>");
		while(rs.next())
		{
			out.print("<TR>");
				out.print("<TD>"+rs.getString(1)+"</TD>");
				out.print("<TD>"+rs.getString(2)+"</TD>");
				out.print("<TD>"+rs. getString ("成绩")+"</TD>");
			out.print("</TR>");
		}
		out.print("</Table>");
	}catch(SQLException e1){}
%>
<BR><A href="main.jsp">返回主页</A>

</FONT>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -