📄 course_search.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>
<body topmargin="10" leftmargin="10" rightmargin="0">
<br>
<table width=60% border="0" cellpadding="2" cellspacing="1" bgcolor="#3F6C61" align=center>
<form action="course_list.jsp" method="post" name=frm>
<tr>
<td width="40%" class="t12_14_bgE3EAE9"> 根据什么查找 </td>
<td width="60%" class="t08_bgwhite_p2">
<select name="search_type" >
<option value="id" > 课程编号 </option>
<option value="course_name" > 课程名称 </option>
<option value="credit" > 学分 </option>
<option value="course_time" > 学时 </option>
<option value="standard_fee" > 标准收费 </option>
<option value="text_book" > 讲课教材 </option>
<option value="ref_book" > 参考书目 </option>
</select>
</td>
</tr>
<tr>
<td width='166' height="23" class="t12_14_bgE3EAE9"> 查找的值是 </td>
<td class="t08_bgwhite_p2">
<input type=text name="search_value" size=20> </td>
</tr>
<tr>
<td colspan="2" width='166' height="23" class="t12_14_bgE3EAE9"> </td>
</tr>
<%
com.dbConnection.MyResultSet rs;%>
<tr class="t08_bgwhite_p2">
<td class="t12_14_bgE3EAE9" >选择专业</td><td>
<select name="major_id">
<option value="all">全部</option>
<option value="0">公共课</option>
<%
String sql="select m.id as major_id,m.name as major_name,d.id as dep_id,d.name as dep_name from lrn_major_info m,lrn_dep_info d where m.dep_id=d.id order by d.name,m.name";
rs=work.executeQuery(sql);
while (rs!=null&&rs.next()){
String major_id=rs.getString("major_id");
String major_name=rs.getString("major_name");
String dep_name=rs.getString("dep_name");
%>
<option value="<%=major_id%>">(<%=dep_name%>)<%=major_name%></option>
<%
}
work.close(rs);
%>
</select>
</td>
</tr>
<tr class="t08_bgwhite_p2">
<td colspan=2 align=center>
<input type=submit value="查询" class=smart>
</td>
</tr>
</form>
</table>
<p align=center><a href="course_main.jsp">返回</a></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -