user_editexe.jsp

来自「远程教育系统中完整的学生管理系统,包括学生注册,学生管理等最新代码,推荐」· JSP 代码 · 共 88 行

<%
	/*---------------------------------------------
	功能描述:执行修改学生
	编写时间: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.length() == 0 || str.equals("null"))
			str = "不详";
			return str;
	
	}
%>

<% 	
	String id_card = request.getParameter("id_card");
	String gender = fixnull(request.getParameter("gender"));
	String birthday = fixnull(request.getParameter("birthday"));
	String email = fixnull(request.getParameter("email"));
	String zzmm = fixnull(request.getParameter("zzmm"));
	String folk = fixnull(request.getParameter("folk"));
	String hometown = fixnull(request.getParameter("hometown"));
	String address = fixnull(request.getParameter("address"));
	String zip_address = fixnull(request.getParameter("zip_address"));
	String phone = fixnull(request.getParameter("phone"));
	String edu = fixnull(request.getParameter("edu"));
	String graduated_sch = fixnull(request.getParameter("graduated_sch"));
	String graduated_major = fixnull(request.getParameter("graduated_major"));
	String work_place = fixnull(request.getParameter("work_place"));
	String position = fixnull(request.getParameter("position"));
	String title = fixnull(request.getParameter("title"));
	String begin_date = request.getParameter("begin_date");
	String graduated_time = request.getParameter("graduated_time");
	String alteration = fixnull(request.getParameter("alteration"));
	String note = fixnull(request.getParameter("note"));
	String remark = fixnull(request.getParameter("remark"));
	String id = request.getParameter("id");
	String name = request.getParameter("name");
	String password = request.getParameter("password");
	String oldsite = fixnull(request.getParameter("oldsite"));
	String reg_no = request.getParameter("reg_no");
	String sql = "";
	
 	sql = "update lrn_user_info set name = '"+name+"',password = '"+password+"',oldsite = '"+oldsite+"',id_card = '" + id_card + "',reg_no='" + reg_no + "',birthday = '" + birthday + "',email = '" + email + "',gender = '" + gender + "',zzmm = '" + zzmm + "',folk = '" + folk + "',hometown = '" + hometown + "',address = '" + address + "',zip_address = '" + zip_address + "',phone = '" + phone + "',edu = '" + edu + "',graduated_sch = '" + graduated_sch + "',graduated_major = '" + graduated_major + "',work_place = '" + work_place + "',position = '" + position + "',title = '" + title + "',begin_date = to_date('" + begin_date + "','yyyy-mm-dd'),graduated_time = to_date('" + graduated_time + "','yyyy-mm-dd'),alteration = '" + alteration + "',note = '" + note + "',remark = '" + remark + "' where id = '" + id + "'";
 	int count = work.executeUpdate(sql);
	
	if (count < 1)
	{
%>

<p align="center">修改学生信息失败！</p>
<p align="center">
  <a href="javascript:history.back()">返回</a>
</p>

<%
		return;
	}
	
	response.sendRedirect("user_info.jsp?id=" + id);
%>