简单教务信息发布网站(5)

沈阳航空工业学院课程设计报告 附 录

\>

topMargin=5 marginheight=\marginwidth=\>

成绩查询分类如下:

英语四级

英语六级

计算机二级

期末考试

返回主页

Yysj.jsp

<%@ page contentType=\%> <%@ page import=\%>

-19-

沈阳航空工业学院课程设计报告 附 录

<% Connection con; Statement sql; ResultSet rs;

try{Class.forName(\); }

catch(ClassNotFoundException e){}

try { con=DriverManager.getConnection(\,\,\); sql=con.createStatement();

rs=sql.executeQuery(\); out.print(\); out.print(\);

out.print(\+\学号\); out.print(\+\姓名\);

out.print(\+\英语四级\);

out.print(\); while(rs.next()) { out.print(\);

out.print(\+rs.getString(1)+\); out.print(\+rs.getString(2)+\);

out.print(\+rs.getInt(\英语四级\)+\);

out.print(\) ; }

out.print(\); con.close(); }

catch(SQLException e1) {} %>

-20-

沈阳航空工业学院课程设计报告 附 录

返回主页 Yylj.jsp

<%@ page contentType=\%> <%@ page import=\%>

<% Connection con; Statement sql; ResultSet rs;

try{Class.forName(\); }

catch(ClassNotFoundException e){}

try { con=DriverManager.getConnection(\,\,\); sql=con.createStatement();

rs=sql.executeQuery(\); out.print(\); out.print(\);

out.print(\+\学号\); out.print(\+\姓名\);

out.print(\+\英语六级\);

out.print(\); while(rs.next()) { out.print(\);

-21-

沈阳航空工业学院课程设计报告 附 录

out.print(\+rs.getString(1)+\); out.print(\+rs.getString(2)+\);

out.print(\+rs.getInt(\英语六级\)+\);

out.print(\) ; }

out.print(\); con.close(); }

catch(SQLException e1) {} %>

返回主页 Jsjej.jsp

-22-

沈阳航空工业学院课程设计报告 附 录

<%@ page contentType=\%> <%@ page import=\%>

<% Connection con; Statement sql; ResultSet rs;

try{Class.forName(\); }

catch(ClassNotFoundException e){}

try { con=DriverManager.getConnection(\,\,\); sql=con.createStatement();

rs=sql.executeQuery(\); out.print(\); out.print(\);

out.print(\+\学号\); out.print(\+\姓名\);

out.print(\+\计算机二级\);

out.print(\); while(rs.next()) { out.print(\);

out.print(\+rs.getString(1)+\); out.print(\+rs.getString(2)+\);

out.print(\+rs.getInt(\计算机二级\)+\);

out.print(\) ; }

out.print(\); con.close(); }

catch(SQLException e1) {} %>

-23-