📄 query_1.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import ="java.sql.*" %>
<HTML>
<HEAD>
<TITLE>成绩查询</TITLE>
<BODY >
<center>
<P><font size=5> 成绩查询 </font>
<FONT size=4>
<P>
<FORM action="query_2.jsp" method=post name=form>
按学号查询：
<INPUT type="text" name="number" value="">
<Input type=submit name="g" value="查询">
</FORM> <br>
<%
String number=null;
String name=null;
float math,english,physics;
Connection con=(Connection)session.getAttribute("con");
ResultSet rs=(ResultSet)session.getAttribute("rs");
if(rs!=null)
{
out.print("数据查询结果");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"学号"+"</th>");
out.print("<TH width=100>"+"姓名"+"</th>");
out.print("<TH width=50>"+"数学成绩"+"</th>");
out.print("<TH width=50>"+"英语成绩"+"</th>");
out.print("<TH width=50>"+"物理成绩"+"</th>");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
number=rs.getString(1);
name=rs.getString(2);
out.print("<TD >"+number+"</TD>");
out.print("<TD >"+name+"</TD>");
math=rs.getInt(3);
out.print("<TD >"+math+"</TD>");
english=rs.getInt(4);
out.print("<TD >"+english+"</TD>");
physics=rs.getInt(5);
out.print("<TD >"+physics+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
}
else
out.println("无数据");
%>
</font>
<br><br>
<a href = "../LoginSuccess.jsp">返回</A>
</center>
</BODY>
</HEAD>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -