📄 listcourse.jsp
字号:
<%
/*
程序员:苏楠
用途:课程列表
时间:2003-8-19 14:28
*/
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="浏览课程信息";
String PrivME="00604";
String PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool" />
<link href="../css/style.css" rel="stylesheet" type="text/css">
<%
String query="select id,course_name,credit,course_time,course_status,major_id,major_name from (select c.id as id,c.course_name,c.credit,c.course_time,c.course_status,c.major_id as major_id,m.name as major_name from lrn_course_info c,lrn_major_info m where m.id=c.major_id) order by id";
//out.print(query);
//----------分页开始---------------
int pagesize =0;
int totalItems = work.countselect(query);
String temp_pagesize = (String)session.getValue("pagesize");
if (temp_pagesize == null || temp_pagesize.length() == 0 || temp_pagesize.equals("null"))
{
pagesize = 10;
}
else
{
pagesize = Integer.parseInt(temp_pagesize);
}
String spageInt = request.getParameter("pageInt");
if(null == spageInt || spageInt.equals(""))
spageInt = "1";
int pageInt = Integer.parseInt(spageInt);
if (totalItems <= (pageInt - 1) * pagesize)
{
pageInt = pageInt - 1;
if(pageInt < 1)
{
pageInt = 1;
}
}
int maxPage = (totalItems + pagesize - 1) / pagesize;
if(pageInt > maxPage)
pageInt = maxPage;
int pageNext = pageInt + 1;
int pageLast = pageInt - 1;
String link="";
//----------分页结束---------------
com.dbConnection.MyResultSet RS=work.execute_oracle_page(query,pageInt,pagesize);
%>
<html>
<head><title>课程列表</title></head>
<body leftmargin=0 topmargin=0 bgcolor=FFFFFF>
<table width="90%" border="0" align=center cellpadding="2" cellspacing="1" bgcolor="3F6C61">
<tr class="t08_bgwhite_p2"><td colspan="9" align="center">课程列表</td><tr>
<tr><td class="t12_14_bgE3EAE9">课程编号</td>
<td class="t12_14_bgE3EAE9">课程名称</td>
<td class="t12_14_bgE3EAE9">学分</td>
<td class="t12_14_bgE3EAE9">学时</td>
<td class="t12_14_bgE3EAE9">专业</td>
<!--<td class="t12_14_bgE3EAE9">课程类别</td>-->
<td class="t12_14_bgE3EAE9">课程状态</td>
</tr>
<%
String id="";
String course_name="";
String credit="";
String course_time="";
String course_status="";
String tempstatus="";
String major_name="";
String major_id="";
while(RS!=null&&RS.next())
{
id=RS.getString("id");
course_name=RS.getString("course_name");
credit=RS.getString("credit");
course_time=RS.getString("course_time");
//String course_type=RS.getString("course_type");
course_status=RS.getString("course_status");
major_name=RS.getString("major_name");
major_id=RS.getString("major_id");
tempstatus=course_status;
if(course_status.equals("0000")){
tempstatus="有效";
}
if(course_status.equals("1111")){
tempstatus="无效";
}
if(course_status.equals("2222")){
tempstatus="过期";
}
%>
<tr> <td class="t08_bgwhite_p2"><%=id%></td>
<td class="t08_bgwhite_p2"><a href="course_edit.jsp?id=<%=id%>&pageInt=<%=pageInt%>"><%=course_name%></a></td>
<td class="t08_bgwhite_p2"><%=credit%></td>
<td class="t08_bgwhite_p2"><%=course_time%></td>
<td class="t08_bgwhite_p2"><%=major_name%></td>
<!--<td class="t08_bgwhite_p2"><%//=course_type%></td>-->
<td class="t08_bgwhite_p2"><%=tempstatus%></td>
</tr>
<%
}
work.close(RS);
%>
<%@ include file="../pub/dividepage.jsp" %>
</table>
<p align=center><a href="course_main.jsp">返回管理界面</a></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -