📄 course_list.jsp
字号:
<%/*
用途:查询课程
程序员:guoyehong
完成时间:2004-8-25 11:23
修改情况：
修改时间： 修改原因： 修改人：
*/ %>
<%@ page contentType="text/html;charset=gbk" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="查找课程信息";
String PrivME="00606";
String PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>
<%@ page import="java.sql.*" %>
<%@page import="oracle.jdbc.driver.*"%>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool" />
<html>
<head>
<title>查询课程</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/style.css" rel="stylesheet" type="text/css">
</head>
<%
String search_type = request.getParameter("search_type");
String search_value = request.getParameter("search_value");
String major_idtemp = request.getParameter("major_id");
if (search_value!=null)
{
search_value=search_value.trim();
}
String query = "";
String sql_level="";
String msg = "";
String link="";
com.dbConnection.MyResultSet RS;
//out.print("search_type=" + search_type + "<br>");
//out.print("search_value=" + search_value + "<br>");
//out.print("major_idtemp=" + major_idtemp + "<br>");
String sql="";
int totalItems = 0;
//生成查询专业的语句
if(major_idtemp.equals("all"))
sql_level = "(select c.id,c.course_name,c.major_id,c.credit,c.course_time,c.standard_fee,c.text_book,c.ref_book,c.course_status,m.name as major_name from lrn_course_info c,lrn_major_info m where c.major_id=m.id(+)) ";
else
sql_level = "(select c.id,c.course_name,c.major_id,c.credit,c.course_time,c.standard_fee,c.text_book,c.ref_book,c.course_status,m.name as major_name from lrn_course_info c,lrn_major_info m where c.major_id=m.id(+) and c.major_id='"+major_idtemp+"') ";
//如果不输入查询值，则生成如下sql语句
if (search_value == null || search_value.equals(""))
{
//生成总SQL语句
query = "select id,course_name,major_id,credit,course_time,standard_fee,text_book,ref_book,course_status,major_name from "+sql_level+" ";
//out.print(query);
//翻页用的传递参数的连接link
link = "&search_type="+search_type+"&search_value="+search_value+"&major_id=" + major_idtemp;
}
//如果输入查询值，则生成如下语句
else
{
query = "select id,course_name,major_id,credit,course_time,standard_fee,text_book,ref_book,course_status ,major_name from "+sql_level+" where "+search_type+" like '%"+search_value+"%'";
//out.print(query);
//翻页用的传递参数的连接link
link = "&search_type="+search_type+"&search_value="+search_value+"&major_id=" + major_idtemp;
}
//out.print(query);
totalItems = work.countselect(query);
if(totalItems < 1)
{
out.print("没有符合条件的课程！ ");
out.print("<a href=course_main.jsp>返回</a>");
return;
}
//----------分页开始---------------
int pagesize =0;
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;
//----------分页结束---------------
RS=work.execute_oracle_page(query,pageInt,pagesize);
//com.dbConnection.MyResultSet RS=work.executeQuery(query);
int row_count=0;
%>
<html><head><title>课程列表</title></head>
<body topmargin=0 leftmargin=0 bgcolor=FFFFFF>
<br>
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="3F6C61">
<tr>
<td height="24" colspan="9" align="center" class="t08_bgwhite_p2"> 课程列表 </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>
</tr>
<%
String id="";
String course_name="";
String credit="";
String course_time="";
String course_status="";
String tempstatus="";
String major_name="";
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");
major_name=RS.getString("major_name");
course_status=RS.getString("course_status");
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"><%if(major_name==null) out.print("公共课"); else out.print(major_name);%></td>
<td class="t08_bgwhite_p2"><%=tempstatus%></td>
</tr>
<%
}
work.close(RS);
%>
</table>
<%@ include file="../pub/dividepage.jsp" %>
<p align=center><a href="course_main.jsp">返回管理界面</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -