📄 showgrade.jsp
字号:
<%-- Document : ShowGrade Created on : 2008-5-9, 7:23:11 Author : Administrator--%><%@page contentType="text/html" pageEncoding="GBK"%><%@ page import="java.sql.*" %><%@ page errorPage="ErrorPage.jsp" %><jsp:useBean id="userinf" scope="session" class="Source.userInf" /><jsp:useBean id="jdbcBean" scope="session" class="Source.JDBCBean"/><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd"><% ResultSet rs; String sql = ""; String ShowStr = ""; String userid = ""; if (userinf.isHasLogin()) { userid = userinf.getUserID(); sql = "SELECT grade.CNo,grade.credit, grade.grade,course.courseName,teacher.userName " + "from grade join course on grade.CNo=course.courseId join teacher on grade.TNo=teacher.userID " + "where grade.SNo='" + userid + "'"; rs = jdbcBean.executeQuery(sql); while (rs.next()) { ShowStr += "<tr><td><a href='ShowCourse.jsp?CId=" + rs.getString("CNo") + "'>" + rs.getString("courseName") + "</a></td><td>" + rs.getString("userName") + "</td><td>" + rs.getInt("credit") + "</td><td>" + rs.getInt("grade") + "</td></tr>"; } jdbcBean.close(); rs.close(); } else { session.setAttribute("inf", "请重新登录!"); session.setAttribute("returnStr", "<a href='Login.jsp'>Return</a>"); response.sendRedirect("Information.jsp"); }%><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=GBK" /> <title>Show Grade</title> <style type="text/css"> <!-- #main { background-color: #CCCCCC; width: 750px; margin-right: auto; margin-left: auto; padding-bottom: 30px; padding-top: 30px; } #main #title { background-position: center; background-color: #FFFFFF; width: 600px; margin-right: auto; margin-left: auto; vertical-align: text-top; text-align: center; padding-top: 20px; padding-bottom: 20px; } .STYLE3 { width: 600px; background-color: #666666; margin-right: auto; margin-left: auto; font-size: xx-large; font-weight: bold; color: #FFFFFF; } --> </style> </head> <body> <div id="main"> <div class="STYLE3" id="content">Show Grade</div> <div id="title"> <table align="center" border="1"> <tr> <th scope="col">课程名</th> <th scope="col">任课老师</th> <th scope="col">学分</th> <th scope="col">成绩</th> <%=ShowStr%> </tr> </table> <div align="right"><a href="student.jsp">返回</a> </div> </div> </div> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -