<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8" import="check.DBUtil,java.sql.* " %>
<!DOCTYPE html>
<html>
<style>
table{
text-align:center;
}
td{
word-break : break-all;
}
</style>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<%
String f_week = "";
String s_week = "";
String f_time = "";
String s_time = "";
DBUtil db = new DBUtil();
db.getConn();
ResultSet rs = db.getResult("select * from course");
//String username = (String)session.getAttribute("username");
%>
<table width="1000" border="1" >
<tr>
<td>课程编号</td>
<td>课程名称</td>
<td>授课教师</td>
<td>总学分</td>
<td>上课时间</td>
<td>上课地点</td>
<td>限制人数</td>
<td>已选人数</td>
<td> </td>
</tr>
<%
while(rs.next()){
if(rs.getString(5).equals("1"))
{
f_week = "星期一";
}else if(rs.getString(5).equals("2"))
{
f_week = "星期二";
}else if(rs.getString(5).equals("3"))
{
f_week = "星期三";
}else if(rs.getString(5).equals("4"))
{
f_week = "星期四";
}else if(rs.getString(5).equals("5"))
{
f_week = "星期五";
}
if(rs.getString(6).equals("1"))
{
f_time = "8:05~9:50";
}else if(rs.getString(6).equals("2"))
{
f_time = "10:15~12:00";
}
else if(rs.getString(6).equals("3"))
{
f_time = "13:35~15:20";
}
else if(rs.getString(6).equals("4"))
{
f_time = "15:45~17:30";
}
else if(rs.getString(6).equals("5"))
{
f_time = "18:30~20:45";
}
if(rs.getString(7).equals("1"))
{
s_week = "星期一";
}else if(rs.getString(7).equals("2"))
{
s_week = "星期二";
}else if(rs.getString(7).equals("3"))
{
s_week = "星期三";
}else if(rs.getString(7).equals("4"))
{
s_week = "星期四";
}else if(rs.getString(7).equals("5"))
{
s_week = "星期五";
}
if(rs.getString(8).equals("1"))
{
s_time = "8:05~9:50";
}else if(rs.getString(8).equals("2"))
{
s_time = "10:15~12:00";
}
else if(rs.getString(8).equals("3"))
{
s_time = "13:35~15:20";
}
else if(rs.getString(8).equals("4"))
{
s_time = "15:45~17:30";
}
else if(rs.getString(8).equals("5"))
{
s_time = "18:30~20:45";
}
%>
<tr>
<td><%=rs.getString(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
<td><%=rs.getString(4) %></td>
<td><%=f_week %>:<%=f_time%><br><%=s_week %>:<%=s_time%></td>
<td><%=rs.getString(9) %></td>
<td><%=rs.getString(10) %></td>
<%
ResultSet rs_1 = db.getResult("select count(course_id) from elective where course_id="+rs.getString(1)+"");
while(rs_1.next())
{
%>
<td><%=rs_1.getString(1)%></td>
<%
session.setAttribute("choosed",rs_1.getString(1));
}
%>
<td><a href="checkNumber?course_id=<%=rs.getString(1)%>"><button>选课</button></a></td>
</tr>
</table>
<%session.setAttribute("limited", rs.getString(10));}%>
</body>
</html>
把放下面