📄 course_edit.jsp

📁 远程教育系统中课程管理系统,包括现行教育体系中特别是高等院校中复杂的课程管理.强烈推荐
💻 JSP
字号:
<%
/*
程序员:苏楠
用途:编辑课程
时间:2003-8-19 13:52
*/
%>
<%@ page contentType="text/html;charset=gb2312" %> 
<%@ page language="java" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding

	String 	PrivXP="修改课程信息";
	String 	PrivME="00602";
	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 fixnull(String str)
	{
	    if(str == null || str.equals("null") || str.equals("null"))
			str = "不详";
			return str;
	
	}
%>
<%
	String pageInt=request.getParameter("pageInt");
	String id=request.getParameter("id");
	String query="select course_name,major_id,credit,course_time,standard_fee,text_book,ref_book,note,course_status from lrn_course_info where id='"+id+"'";

	//String id="";
	String course_name="";
	String credit="";
	String course_time="";
	String fee="";
	String tbook="";
	String rbook="";
	String major="";
	String exam_type="";
	String course_type="";
	String tech_type="";
	String course_status="";
	String note="";
	com.dbConnection.MyResultSet RS=work.executeQuery(query);
	if(RS!=null&&RS.next())
	{
		//id=RS.getString("id");
		course_name=fixnull(RS.getString("course_name"));
		credit=fixnull(RS.getString("credit"));
		course_time=fixnull(RS.getString("course_time"));
		fee=fixnull(RS.getString("standard_fee"));
		tbook=fixnull(RS.getString("text_book"));
		rbook=fixnull(RS.getString("ref_book"));
		note=fixnull(RS.getString("note"));
		major=RS.getString("major_id");
		course_status = RS.getString("course_status");
	}
	work.close(RS);
%>
<html>
<head><title>编辑课程</title></head>
<script language=javascript src="../js/check.js">
</script>
<script>
function pageGuarding()
{	
	if(isNull(document.courseinfo.name.value))
	{
	}
	else
	{
		alert("课程名为空!");
		document.courseinfo.name.focus();
		document.courseinfo.name.select();
		return false;
	}
	if(isNull(document.courseinfo.credit.value))
	{
	}
	else
	{
		alert("学分为空!");
		document.courseinfo.credit.focus();
		document.courseinfo.credit.select();
		return false;
	}
	
	if(isNum(document.courseinfo.credit.value))
	{
	}
	else
	{
		alert("学分输入不是数字!");
		document.courseinfo.credit.focus();
		document.courseinfo.credit.select();
		return false;
	}
        if(isNum(document.courseinfo.course_time.value))
	{
	}
	else
	{
		alert("输入学时不是数字!");
		document.courseinfo.course_time.focus();
		document.courseinfo.course_time.select();
		return false;
	}
        if(document.courseinfo.course_time.value.length<2)
	{
	alert("学时格式不正确");
	document.courseinfo.course_time.focus();
	document.courseinfo.course_time.select();
	return false;
	}
   }
</script>
<script language=javascript>			
		function del()
		{
		if(confirm("你确实要删除<%=course_name%>课程吗?"))
		{
			window.location="delcourse.jsp?id=<%=id%>&name=<%=course_name%>&pageInt=<%=pageInt%>";
		}
		return true;
		}
</script>
<body leftmargin=0 topmargin=0 bgcolor=FFFFFF>
<form name="courseinfo" action="course_editexe.jsp" method="post" onsubmit="return pageGuarding()">
<input type="hidden" name=pageInt value="<%=pageInt%>">
<input type="hidden" name="id" value="<%=id%>">
<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="t08_bgwhite_p2"><%=id%></td>
</tr>	
<tr >
	<td class="t12_14_bgE3EAE9">课程名*</td>
	<td class="t08_bgwhite_p2"><input type="text" name="name" id="name" value="<%=course_name%>">
	</td>
</tr>		
	<tr ><td class="t12_14_bgE3EAE9">学分*</td>
	    <td class="t08_bgwhite_p2"><input type="text" name="credit" id="credit" value="<%=credit%>">
	     </td>
	</tr>		
	<tr><td class="t12_14_bgE3EAE9">学时*</td>
	    <td class="t08_bgwhite_p2"><input type="text" name="course_time" id="course_time" value="<%=course_time%>" maxlength="3">
	   2~3位数字</td>
	</tr>		
	<tr><td class="t12_14_bgE3EAE9">标准收费</td>
	    <td class="t08_bgwhite_p2"><input type="text" name="standard_fee" id="standard_fee" value="<%=fee%>">
	</td>
	</tr>	
	<tr><td class="t12_14_bgE3EAE9">讲课教材</td>
	    <td class="t08_bgwhite_p2"><input type="text" name="text_book" id="text_book" value="<%=tbook%>">
	   </td>
	</tr>	
	<tr><td class="t12_14_bgE3EAE9">参考书目</td>
	    <td class="t08_bgwhite_p2"><input type="text" name="ref_book" id="ref_book" value="<%=rbook%>">
	   </td>
	</tr>	
	<tr><td class="t12_14_bgE3EAE9">专业*</td>
	    <td class="t08_bgwhite_p2">
	   <select name="major_id" id="major_id">
	      <%
	   String T_sql="select id,name  from lrn_major_info  where status='1111'";
	   com.dbConnection.MyResultSet rs=work.executeQuery(T_sql);
	   String name="";
	   String id_major="";
	   while(rs!=null&&rs.next())
	   {
	   name=rs.getString("name");
	   id_major=rs.getString("id");
	   %>
	   <option value="<%=id_major%>" <%if(id_major.equals(major)) out.print("selected");%>><%=name%></option>
	   <%}
	   work.close(rs);%>
	   </select>
	   </td>
	</tr>	
<!--	<tr><td class="t12_14_bgE3EAE9">考核方式</td>
	    <td class="t08_bgwhite_p2">
	   <select name="exam_type" id="exam_type">
	   <option value="笔试" selected>笔试</option>
	   </select>
	   </td>
	</tr>	-->
<!--	<tr><td class="t12_14_bgE3EAE9">课程类别</td>
	    <td class="t08_bgwhite_p2">
	   <select name="course_type" id="course_type">
	   <option value="公共课" selected>公共课</option>
	   </select>
	   </td>
	</tr>	-->
<!--	<tr><td class="t12_14_bgE3EAE9">教学方式</td>
	    <td class="t08_bgwhite_p2">
	   <select name="teaching_type" id="teaching_type">
	   <option value="讲课" selected>讲课</option>
	   </select>
	   </td>
	</tr>	-->
	<tr>
		<td class="t12_14_bgE3EAE9">状态</td>
	    <td class="t08_bgwhite_p2">
	   		<select name="course_status" id="course_status">
	   			<option value="0000" <% if(course_status!=null && course_status.equals("0000"))  out.print("selected");%>>有效</option>
	   			<option value="1111" <% if(course_status!=null && course_status.equals("1111")) out.print("selected");%>>停用</option>
	  		</select>
	   </td>
	</tr>	
	<tr>
		<td class="t12_14_bgE3EAE9">课程简介</td>
	    <td class="t08_bgwhite_p2">
	    	<textarea class="smallarea" cols="55" name="note" rows="12"><%=note%></textarea>
	    </td>
	</tr>	
<tr class="t05_bgwhite_p2_c">
	<td>
		<input type="submit" value="修改" name=submit>
	</td>
	<td align="left">
		<input type="button" name="submit" value="删除课程" onclick="return del()">
		<a href="listcourse.jsp?pageInt=<%=pageInt%>">返回课程列表</a>
	</td>
</tr>
</table>
</form>
</body>
</html>
💿 文件大小 25 K
👤 上传用户 quanliao77
📂 所属分类教育系统应用
🏷️ 相关标签

#远程教育 #管理系统
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -