user_edit.jsp

远程教育系统中完整的学生管理系统,包括学生注册,学生管理等最新代码,推荐

<%
	/*---------------------------------------------
	功能描述:修改学生
	编写时间:2003-08-20
	编写人:侯雄飞
	email:[e-mail]
	
	修改情况记录
	修改时间：  修改内容：   修改人：
	-----------------------------------------------*/
%>

<%@ page language="java" %>
<%@ page contentType="text/html;charset=gb2312" %>

<%
//////////////////////////////////////////////////////////////
// Privilege Guarding

	String 	PrivXP="修改学生";
	String 	PrivME="00102";
%>
<%@ include file="../pub/privGuarding.jsp" %>	
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>

<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool"/>

<%!
	//判断字符串为空的话，赋值为"不详"
	String fixnull(String str)
	{
	    if(str == null || str.equals("null") || str.equals("null"))
			str = "不详";
			return str;
	
	}
	
	String fixnull2(String str)
	{
	    if(str == null || str.equals("null") || str.equals("null"))
			str = "2000-01-01";
			return str;
	
	}
%>

<%
	String id = request.getParameter("id");
	String name = "";
	String password = "";
	String id_card = "";
	String email = "";
	String phone = "";
	String address = "";
	String zip_address = "";
	String gender = "";
	String work_place = "";
	String position = "";
	String title = "";
	String edu = "";
	String birthday = "";
	String note = "";
	String graduated_time = "";
	String graduated_sch = "";
	String graduated_major = "";
	String folk = "";
	String zzmm = "";
	String hometown = "";
	String nickname = "";
	String begin_date = "";
	String alteration = "";
	String remark = "";
	String oldsite = "";
	String oldsitename = "";
	String reg_no = "";
	
	int count = 0;
	com.dbConnection.MyResultSet rs;
	
	String sql = "select u.id as id,u.name as name,u.password as password,u.id_card as id_card,u.email as email,u.phone as phone,u.address as address,u.zip_address as zip_address,u.gender as gender,u.work_place as work_place,u.position as position,u.title as title,u.edu as edu,u.red_date as red_date,u.comfirm_date as comfirm_date,u.user_type as user_type,u.status as status,u.birthday as birthday,u.note as note,u.graduated_time as graduated_time,u.graduated_sch as graduated_sch,u.graduated_major as graduated_major,u.folk as folk,u.zzmm as zzmm,u.hometown as hometown,u.degree_flag as degree_flag,u.nickname as nickname,u.reg_no as reg_no,u.entrance_date as entrance_date,u.begin_date as begin_date,u.alteration as alteration,u.remark as remark,u.email_flag as email_flag,m.name as m_name,g.name as g_name,s.name as s_name,e.name as e_name,u.oldsite as oldsite,v.name as oldsitename from (select id,name,password,id_card,email,phone,address,zip_address,gender,work_place,position,title,edu,red_date,comfirm_date,user_type,status,login_num,last_login_time,last_login_ip,birthday,site,note,to_char(graduated_time,'yyyy-mm-dd') as graduated_time,graduated_sch,graduated_major,folk,zzmm,hometown,degree_flag,nickname,isdelete,isgraduated,reg_no,grade_id,to_char(entrance_date,'yyyy-mm-dd') as entrance_date,to_char(begin_date,'yyyy-mm-dd') as begin_date,alteration,remark,email_flag,edu_type_id,major_id,oldsite from lrn_user_info where id = '" + id + "') u,(select id,name from lrn_major_info where id<>'0') m,(select id,name from lrn_edu_type) e,(select id,name from lrn_grade_info) g,(select id,name from lrn_site_info) s,(select id,name from lrn_site_info) v where u.major_id = m.id and u.edu_type_id = e.id and u.grade_id = g.id and u.site = s.id and u.oldsite = v.id(+)";
	//out.print(sql);
	
	count = work.countselect(sql);
	if(count < 1)
	{
		out.print("没有符合条件的查询结果");
		return;
	}
	
	rs = work.executeQuery(sql);
	if (rs.next())
	{
		name = rs.getString("name");
		password = fixnull(rs.getString("password"));
		id_card = fixnull(rs.getString("id_card"));
		email = fixnull(rs.getString("email"));
		phone = fixnull(rs.getString("phone"));
		address = fixnull(rs.getString("address"));
		zip_address = fixnull(rs.getString("zip_address"));
		gender = fixnull(rs.getString("gender"));
		work_place = fixnull(rs.getString("work_place"));
		position = fixnull(rs.getString("position"));
		title = fixnull(rs.getString("title"));
		edu = fixnull(rs.getString("edu"));
		birthday = fixnull2(rs.getString("birthday"));
		note = fixnull(rs.getString("note"));
		graduated_time = fixnull(rs.getString("graduated_time"));
		graduated_sch = fixnull(rs.getString("graduated_sch"));
		graduated_major = fixnull(rs.getString("graduated_major"));
		folk = fixnull(rs.getString("folk"));
		zzmm = fixnull(rs.getString("zzmm"));
		hometown = fixnull(rs.getString("hometown"));
		nickname = fixnull(rs.getString("nickname"));
		begin_date = fixnull2(rs.getString("begin_date"));
		alteration = fixnull(rs.getString("alteration"));
		remark = fixnull(rs.getString("remark"));
		oldsite = fixnull(rs.getString("oldsite"));
		oldsitename = fixnull(rs.getString("oldsitename"));
		reg_no = fixnull(rs.getString("reg_no"));
	}
	work.close(rs);
%>
<html>

<head>
<link href="../css/style.css" rel=stylesheet type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改学生信息</title>
<script language=javascript src="../js/calender.js"></script>
<script language=javascript src="../js/check.js">
</script>
<script>
	function userEditGuarding()
	{
		if(isNull(document.user_edit.name.value))
		{
		}
		else
		{
			alert("请填写姓名!");
			document.user_edit.name.focus();
			document.user_edit.name.select();
			return false;
		}
		if(isNull(document.user_edit.password.value))
		{
		}
		else
		{
			alert("请填写密码!");
			document.user_edit.password.focus();
			document.user_edit.password.select();
			return false;
		}
		if(isNull(document.user_edit.reg_no.value))
		{
		}
		else
		{
			alert("请填写学号!");
			document.user_edit.reg_no.focus();
			document.user_edit.reg_no.select();
			return false;
		}
		if(isNull(document.user_edit.id_card.value))
		{
		}
		else
		{
			alert("请填写身份证号!");
			document.user_edit.id_card.focus();
			document.user_edit.id_card.select();
			return false;
		}
		if(validIdCard(document.user_edit.id_card.value))
		{
		}
		else
		{
			alert("身份证号填写有误!");
			document.user_edit.id_card.focus();
			document.user_edit.id_card.select();
			return false;
		}
	}

	function userImageGuarding()
	{
		if(isNull(document.add_image.src.value))
		{
		}
		else
		{
			alert("输入照片文件为空!");
			document.add_image.src.focus();
			document.add_image.src.select();
			return false;
		}
	}
</script>
</head>

<body leftmargin="0" topmargin="0">
<br>
<form name="user_edit" method="POST" action="user_editexe.jsp" onSubmit="return userEditGuarding()">
<table width="500" border=0 align=center cellPadding=2 cellSpacing=1 bgColor=3F6C61>
<tr class="t08_bgwhite_p2"> 
    <td colspan=2> 
      <p align="center"><b>修改学生信息</b></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">姓名*</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="name" size="25" value="<%=name%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">密码*</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="password" size="25" value="<%=password%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">原所属教学点</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="oldsite" size="25" value="<%=oldsite%>">请输入代号</td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">学号*</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="reg_no" size="25" value="<%=reg_no%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">政治面貌</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="zzmm" size="25" value="<%=zzmm%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">民族</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="folk" size="25" value="<%=folk%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">籍贯</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="hometown" size="25" value="<%=hometown%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">通信地址</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="address" size="25" value="<%=address%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">邮政编码</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="zip_address" size="25" value="<%=zip_address%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">联系电话</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="phone" size="25" value="<%=phone%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">身份证*</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="id_card" size="25" value="<%=id_card%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">性别</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="gender" size="25" value="<%=gender%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">出生日期</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" style="text-align: center" name="birthday" size="25" value="<%=birthday%>" align="middle">
	<input name="button" type="button" class="smart" style="height:20" onClick="fPopCalendar(birthday,birthday); return false" value="->">	
    </td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">电子邮件</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="email" size="25" value="<%=email%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">入学前学历</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="edu" size="25" value="<%=edu%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">原毕业学校</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="graduated_sch" size="25" value="<%=graduated_sch%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">原毕业专业</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="graduated_major" size="25" value="<%=graduated_major%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">工作单位</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="work_place" size="25" value="<%=work_place%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">职务</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="position" size="25" value="<%=position%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">职称</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="title" size="25" value="<%=title%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">从事本专业开始时间</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" style="text-align: center" name="begin_date" size="25" value="<%=begin_date%>">
	  <input name="button" type="button" class="smart" style="height:20" onClick="fPopCalendar(begin_date,begin_date); return false" value="->">
	</td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">毕业时间</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" style="text-align: center" name="graduated_time" size="25" value="<%=graduated_time%>">
	<input name="button" type="button" class="smart" style="height:20" onClick="fPopCalendar(graduated_time,graduated_time); return false" value="->"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">学籍异动</td>
    <td width="350" class="t08_bgwhite_p2"><input type="text" name="alteration" size="25" value="<%=alteration%>"></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">个人简历（从高中或中专开始填写）</td>
    <td width="350" class="t08_bgwhite_p2">
    <textarea name="note" cols="25" rows="5"><%=note%></textarea>
	</td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">备注</td>
    <td width="350" class="t08_bgwhite_p2">
    <textarea name="remark" cols="25" rows="5"><%=remark%></textarea> 
	</td>
</tr>
<tr>
	<td colspan="2" class="t08_bgwhite_p2" align="center">
	  <input type="submit" name="submit" value="提交">
	  <input type="button" name="back" value="返回" onclick="javascript:window.navigate('user_info.jsp?id=<%=id%>')">
	</td>
</tr>
</table>
<p align="center">
<input type="hidden" name="id" value="<%=id%>">
</p>
</form>

<form name="add_image" method="POST" action="user_image_addexe.jsp" ENCTYPE="multipart/form-data" onSubmit="return userImageGuarding()">
<table width="500" border=0 align=center cellPadding=2 cellSpacing=1 bgColor=3F6C61>
<tr class="t08_bgwhite_p2"> 
    <td colspan=2> 
      <p align="center"><b>上载照片</b></td>
</tr>
<tr>
    <td width=150 class="t12_14_bgE3EAE9">上载照片文件*:</td>
    <td width="350" class="t08_bgwhite_p2"><input class=smart name="src" size="25" type=file></td>
</tr>
<tr>
	<td colspan="2" class="t08_bgwhite_p2" align="center">
	  <input type="submit" name="submit" value="提交">
	  <input type="button" name="back" value="返回" onclick="javascript:window.navigate('user_info.jsp?id=<%=id%>')">
	</td>
</tr>
</table>
<p align="center">
<input type="hidden" name="id" value="<%=id%>">
<input type="hidden" name="id_card" value="<%=id_card%>">
</p>
<br>
</form>
</body>
</html>