teacher_editexe.jsp

远程教育系统中教师管理系统,包含完整的教师管理,包括现有教育体系中的复杂教师管理.推荐

<%
/*
程序员:苏楠
用途:修改老师信息确认
2003-8-19 10:40
*/
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding

	String 	PrivXP="修改教师信息";
	String 	PrivME="00202";
	String 	PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>	
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>
<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 password=request.getParameter("password"); 
  String email=request.getParameter("email"); 
  String phone=request.getParameter("phone");
  String address=request.getParameter("address"); 
  String zip_code=request.getParameter("zip_code");
  String work_place=request.getParameter("work_place"); 
  String position=request.getParameter("position");
  String title=request.getParameter("title");
  String gender=request.getParameter("gender"); 
  String teach_level=request.getParameter("teach_level");
  String status=request.getParameter("status");
  String note=request.getParameter("note");
 // String site=request.getParameter("site");
  String work_kind=request.getParameter("work_kind");
  String teach_time=request.getParameter("teach_time");
 String reg_time=request.getParameter("reg_time");
	if(email.equals(""))
	     email="无";
	if(phone.equals("")) 
	   phone="不详";
	if(address.equals("")) 
	   address="不详";
	if(zip_code.equals("")) 
	   zip_code="不详";
	if(work_place.equals("")) 
	   work_place="不详";
	if(position.equals("")) 
	  position="不详";
	if(title.equals("")) 
	   title="不详";
	if(note.equals("")) 
	   note="略";
	if(work_kind.equals("")) 
	   work_kind="略";
	if(teach_time.equals("")) 
	   teach_time="略";
	if (reg_time.equals("不详"))
	   reg_time="";
	 	   
	//id="T"+id;
	//输入的教师编号是否已经存在
	String sql="select id from lrn_teacher_info where id='"+id+"'";
	//out.print(sql);
	
	com.dbConnection.MyResultSet RS = work.executeQuery(sql);
	if(!RS.next())
	 {
		work.close(RS);
		String msg="教师编号"+id+"不存在！";
		out.print(msg);
                return;
	 }
	work.close(RS);
	String query="";
    query="update lrn_teacher_info set"
		+" name='"+com.whaty.encode.SQLEncoder.encode(name)+"', password='"+com.whaty.encode.SQLEncoder.encode(password)+"', email='"+com.whaty.encode.SQLEncoder.encode(email)+"', phone='"+com.whaty.encode.SQLEncoder.encode(phone)+"', address='"+com.whaty.encode.SQLEncoder.encode(address)+"',"
		+" zip_code='"+com.whaty.encode.SQLEncoder.encode(zip_code)+"', gender='"+com.whaty.encode.SQLEncoder.encode(gender)+"', work_place='"+com.whaty.encode.SQLEncoder.encode(work_place)+"', position='"+com.whaty.encode.SQLEncoder.encode(position)+"', title='"+com.whaty.encode.SQLEncoder.encode(title)+"', status='"+com.whaty.encode.SQLEncoder.encode(status)+"', teach_level='"+com.whaty.encode.SQLEncoder.encode(teach_level)+"', note='"+com.whaty.encode.SQLEncoder.encode(note)+"', work_kind='"+com.whaty.encode.SQLEncoder.encode(work_kind)+"', teach_time='"+com.whaty.encode.SQLEncoder.encode(teach_time)+"', reg_time=to_date('" + reg_time + "','yyyy-mm-dd') where  id='"+com.whaty.encode.SQLEncoder.encode(id)+"'";		
	//out.print(query);	
	int ret = work.executeUpdate(query);
	if(ret != 0)
	{
 %>
<script language="javascript">
alert("教师<%=name%>信息修改成功！");
window.navigate("teacher_edit.jsp?id=<%=id%>&pageInt=<%=pageInt%>");
</script>  
<%
  }
  else
  {
%>
<script language="javascript">
alert("教师<%=name%>信息修改不成功！");
history.back();
</script>  
<%
  }
%>