course_editexe.jsp

远程教育系统中课程管理系统,包括现行教育体系中特别是高等院校中复杂的课程管理.强烈推荐

<%
/*
程序员:苏楠
用途:修改课程信息确认
2003-8-19 10:40
*/
%>
<%@ 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" %>	
<link href="../../../css/style.css" rel="stylesheet" type="text/css">
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool" />
<%
  String pageInt=request.getParameter("pageInt");
  String id=request.getParameter("id");
  String name=request.getParameter("name"); 
  String credit=request.getParameter("credit"); 
  String course_time=request.getParameter("course_time"); 
  String fee=request.getParameter("standard_fee");
  String tbook=request.getParameter("text_book"); 
  String rbook=request.getParameter("ref_book");
  String major_id=request.getParameter("major_id"); 
  // String exam_type=request.getParameter("exam_type");
  // String course_type=request.getParameter("course_type");
  //  String teaching_type=request.getParameter("teaching_type"); 
  String course_status=request.getParameter("course_status");
 
  String note=request.getParameter("note");
  //String site=request.getParameter("site");
	
	if(fee.equals(""))
	{
		fee="0";
	}
	if(rbook.equals(""))
	{
		rbook="无";
	}
	if(note.equals(""))
	{
		note="略";
	} 
	
	//输入的课程编号是否已经存在
	String sql="SELECT ID FROM LRN_COURSE_INFO WHERE ID='"+id+"'";
	//out.print(sql);
	
	//com.dbConnection.MyResultSet RS = work.executeUpdate(sql);
	int temp_have=work.executeUpdate(sql);
	if(temp_have<0)
	 {
		
		String msg="课程编号"+id+"不存在！";
		out.print(msg);
                return;
	 }
	//work.close(RS);
	
        String query="UPDATE LRN_COURSE_INFO SET"
			+" course_name='"+com.whaty.encode.SQLEncoder.encode(name)+"',"
			+" credit="+credit+","
			+" course_time="+course_time+","
			+" standard_fee="+fee+","
			+" text_book='"+com.whaty.encode.SQLEncoder.encode(tbook)+"',"
			+" ref_book='"+com.whaty.encode.SQLEncoder.encode(rbook)+"',"
			+" major_id='"+com.whaty.encode.SQLEncoder.encode(major_id)+"',"
			//+" exam_type='"+com.whaty.encode.SQLEncoder.encode(exam_type)+"',"
			//+" course_type='"+com.whaty.encode.SQLEncoder.encode(course_type)+"',"
			//+" teaching_type='"+com.whaty.encode.SQLEncoder.encode(teaching_type)+"',"
			//+" site='"+com.whaty.encode.SQLEncoder.encode(site)+"',"
			+" course_status='"+com.whaty.encode.SQLEncoder.encode(course_status)+"',"
			+" note=?";
			
	
	query+=" WHERE ID='"+com.whaty.encode.SQLEncoder.encode(id)+"'";		
	//out.print(query);	
	int ret = work.executeUpdate(query,com.whaty.encode.SQLEncoder.encode(note));
	if(ret != 0)
	{
 %>
<script language="javascript">
alert("课程<%=name%>信息修改成功！");
window.navigate("course_edit.jsp?id=<%=id%>&pageInt=<%=pageInt%>");
</script>  
<%
  }
  else
  {
%>
<script language="javascript">
alert("课程<%=name%>信息修改不成功！");
history.back();
</script>  
<%
  }
%>