course_addexe.jsp

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

<%
/*
程序员:苏楠
用途:添加课程确认
时间:2003-8-19 14:28
*/
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding

	String 	PrivXP="添加课程信息";
	String 	PrivME="00601";
	String 	PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>	
<%@ page language="java" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.io.*" %>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool" />
<%
	
   String id=request.getParameter("id");

	/*if(id.length()>20)
	{
		id=id.substring(0,20);
	}*/
	//输入的课程编号是否已经存在 
	String sql="SELECT ID FROM LRN_COURSE_INFO WHERE ID='"+id+"'";
	com.dbConnection.MyResultSet RS1 = work.executeQuery(sql);
	if(RS1 != null && RS1.next())
	{
		work.close(RS1);
		String msg="课程编号"+id+"已经存在，请选用另一个编号！<a href='javascript:history.back()'>请返回</a>";
		out.print(msg);
		return;
	}
    work.close(RS1);
	   
	String query = "";
	String name="";
	String ref_book="";
	String text_book="";
	String note="";
	//int standard_fee=0;
	String standard_fee="";
	String credit="";
	String course_time="";
	String major_id="";
	String course_status="";
	 name=request.getParameter("name"); 
	 ref_book=request.getParameter("ref_book"); 
	 text_book=request.getParameter("text_book");
	 note=request.getParameter("note"); 
	 standard_fee=request.getParameter("standard_fee");
	 credit=request.getParameter("credit");
	 course_time=request.getParameter("course_time");
	 major_id=request.getParameter("major_id");
	//String exam_type=request.getParameter("exam_type");
	//String teaching_type=request.getParameter("teaching_type");
	 course_status=request.getParameter("course_status");
	//String course_type=request.getParameter("course_type");
	//String password=request.getParameter("password");
	String password="";
	//password=com.whaty.encrypt.jcrypt.crypt(id,password);
	
	if(standard_fee==null||standard_fee.equals(""))
	{
		standard_fee="0";
	}
	if(ref_book==null||ref_book.equals(""))
	{
		ref_book="无";
	}
	if(note==null||note.equals(""))
	{
		note="略";
	} 
        if(text_book==null||text_book.equals(""))
        {
        text_book="略";
        }
	
	query="insert into lrn_course_info(id,course_name,"
			+"credit,course_time,major_id, "
			+"course_status,ref_book,note,standard_fee,text_book,ftp_passwd)"
			+" values "
			+"('"+id+"','"+name+"',"+credit+","+course_time+",'"+major_id+"',"
			+"'"+course_status+"',"
			+"'"+com.whaty.encode.SQLEncoder.encode(ref_book)+"',?,"+standard_fee+",'"+com.whaty.encode.SQLEncoder.encode(text_book)
			+"','"+password
			+"')";
	//out.print(query);
	int ret=work.executeUpdate(query,com.whaty.encode.SQLEncoder.encode(note));
    	if(0 != ret)
	{
		// for Linux
		/*String strCmd = "/usr/sbin/useradd  ";
		strCmd = strCmd + "-d "+ com.whaty.parameter.g_courseware + "/" +id; 
		strCmd = strCmd + " -s /usr/bin/passwd -p "+ password + " -n c"+id;
		
		Runtime.getRuntime().exec(strCmd);
		strCmd = "/bin/mkdir "+ com.whaty.parameter.g_courseware+"/"+id;
		Runtime.getRuntime().exec(strCmd);
		strCmd = "/bin/mkdir "+ com.whaty.parameter.g_courseware+"/"+id+"/course";
		
		Runtime.getRuntime().exec(strCmd);
		strCmd = "/bin/chmod 755 "+com.whaty.parameter.g_courseware + "/" +id;
		Runtime.getRuntime().exec(strCmd);
		strCmd = "/bin/chmod 777 "+com.whaty.parameter.g_courseware + "/" +id+"/course";
		Runtime.getRuntime().exec(strCmd);
		
	// for Window2000
	String CoursewarePath=GLOBAL.g_basedir+"/courseware/"+id;
    	java.io.File myDir=new java.io.File(CoursewarePath);
	if (!myDir.isDirectory()) myDir.mkdir();

	String CPath=CoursewarePath+"/course";
	java.io.File yourDir=new java.io.File(CPath);
	if (!yourDir.isDirectory()) yourDir.mkdir();
	*/
	
	
		
%>

<script language="javascript">
	alert("<%=name+"课程的讯息加入成功"%>");
	window.navigate ("listcourse.jsp");
</script>


<%
	}
	else
	{
%>
<script language="javascript">
	alert("<%=name+"课程的讯息加入不成功"%>");
	history.back();
</script>
<%
	}
%>