📄 showcourse.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.net.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<style type="text/css">
<!--
body {
background-image: url(images/surface.jpg);
}
-->
</style></head>
<body>
<%!
ResultSet result = null;
Connection con = null;
String accountID = "";
String judge1,judge="";
Statement smt = null;
%>
<jsp:useBean id="statement" class="student.Connect" />
<%
if(session.isNew()) response.sendRedirect("Index.jsp");
else
{
Object id = session.getAttribute("id");
accountID = id.toString();
}
con = statement.getCon();
smt = con.createStatement();
String sql = "select Course.C_ID,Course.C_Name,Course.teacher,Course.score,Course.semester from Course,Student_Course where Student_Course.S_ID = '"+accountID+"' and Course.semester<>'2007年秋' and Course.semester=Student_Course.semester and Course.C_ID=Student_Course.C_ID order by Course.semester";
result = smt.executeQuery(sql);
while(result.next())
{
judge1=result.getString(5);
if(judge=="")
{
judge=judge1;
out.println("<table border = '0' >");
out.println("<tr>"+"<th>课程号</th><th>课程名</th><th>任课老师</th><th>学分</th><th>学期</th>");
out.println("<tr><td>"+result.getInt(1)+"</td><td>"+result.getString(2)+"</td><td>"+result.getString(3)+"</td><td>"+result.getString(4)+"</td><td>"+judge1+"</td>");
}
else
{
if(!judge.equals(judge1))
{
out.println("</table>");
out.println("<table border = '0' >");
out.println("<hr>");
out.println("<tr>"+"<th>课程号</th><th>课程名</th><th>任课老师</th><th>学分</th><th>学期</th>");
out.println("<tr><td>"+result.getInt(1)+"</td><td>"+result.getString(2)+"</td><td>"+result.getString(3)+"</td><td>"+result.getString(4)+"</td><td>"+judge1+"</td>");
judge=judge1;
}
else
{
out.println("<tr><td>"+result.getInt(1)+"</td><td>"+result.getString(2)+"</td><td>"+result.getString(3)+"</td><td>"+result.getString(4)+"</td><td>"+judge1+"</td>");
}
}
}
out.println("</table>");
con.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -