user_addexe.jsp

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

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

<%@ page language="java" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="com.jspsmart.upload.*"%>
<%@ page import="java.util.*" %>
<%@ page import="java.io.RandomAccessFile" %>

<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool"/>
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />

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

	String 	PrivXP="添加学生";
	String 	PrivME="00101";
%>
<%@ include file="../pub/privGuarding.jsp" %>	
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>

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

<%
	mySmartUpload.initialize(pageContext);
	mySmartUpload.upload();
	
	String Out_ImageHTML = "";	
    String sql = "";
	String site_id = mySmartUpload.getRequest().getParameter("site_id");
	String major_id = mySmartUpload.getRequest().getParameter("major_id");
	String edu_type_id = mySmartUpload.getRequest().getParameter("edu_type_id");
	String grade_id = mySmartUpload.getRequest().getParameter("grade_id");
	String name = mySmartUpload.getRequest().getParameter("name");
	String password = mySmartUpload.getRequest().getParameter("password");
	String oldsite = fixnull(mySmartUpload.getRequest().getParameter("oldsite"));
	String reg_no = mySmartUpload.getRequest().getParameter("reg_no");
	String zzmm = fixnull(mySmartUpload.getRequest().getParameter("zzmm"));
	String folk = fixnull(mySmartUpload.getRequest().getParameter("folk"));
	String hometown = fixnull(mySmartUpload.getRequest().getParameter("hometown"));
	String address = fixnull(mySmartUpload.getRequest().getParameter("address"));
	String zip_address = fixnull(mySmartUpload.getRequest().getParameter("zip_address"));
	String phone = fixnull(mySmartUpload.getRequest().getParameter("phone"));
	String id_card = mySmartUpload.getRequest().getParameter("id_card");
	String gender = fixnull(mySmartUpload.getRequest().getParameter("gender"));
	String birthday = fixnull(mySmartUpload.getRequest().getParameter("birthday"));
	String email = fixnull(mySmartUpload.getRequest().getParameter("email"));
	String edu = fixnull(mySmartUpload.getRequest().getParameter("edu"));
	String graduated_sch = fixnull(mySmartUpload.getRequest().getParameter("graduated_sch"));
	String graduated_major = fixnull(mySmartUpload.getRequest().getParameter("graduated_major"));
	String work_place = fixnull(mySmartUpload.getRequest().getParameter("work_place"));
	String position = fixnull(mySmartUpload.getRequest().getParameter("position"));
	String title = fixnull(mySmartUpload.getRequest().getParameter("title"));
	String begin_date = mySmartUpload.getRequest().getParameter("begin_date");
	String graduated_time = mySmartUpload.getRequest().getParameter("graduated_time");
	String alteration = fixnull(mySmartUpload.getRequest().getParameter("alteration"));
	String note = fixnull(mySmartUpload.getRequest().getParameter("note"));
	String remark = fixnull(mySmartUpload.getRequest().getParameter("remark"));
	
	//上传照片开始
	if (id_card != null)
	{
		String BaseURL = com.whaty.parameter.g_root;
		String pic_id = "";
		String s_filename = "";
		
		com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(0);
		s_filename = myFile.getFileName();
		
		if (!myFile.isMissing() && s_filename != null && s_filename.length() != 0)
		{
			s_filename = id_card + s_filename.substring(s_filename.indexOf("."),s_filename.length());
			pic_id = s_filename;
			s_filename = "/www/htdocs/webapps/whatymanager/work/manager/user/photo/" + s_filename;
			myFile.saveAs(s_filename);
			Out_ImageHTML = "<IMG src=" + BaseURL + "/work/manager/user/photo/" + pic_id + " width=100 , height=150>";
		}
	}
 	//上传照片结束
 	
	sql = "insert into lrn_user_info(id,site,major_id,edu_type_id,grade_id,name,password,oldsite,reg_no,zzmm,folk,hometown,address,zip_address,phone,id_card,gender,birthday,email,edu,graduated_sch,graduated_major,work_place,position,title,begin_date,graduated_time,alteration,note,remark,photo_link) values(to_char(s_lrn_user_info_id.nextval),'" + site_id + "','" + major_id + "','" + edu_type_id + "','" + grade_id + "','" + name + "','" + password + "','" + oldsite + "','" + reg_no + "','" + zzmm + "','" + folk + "','" + hometown + "','" + address + "','" + zip_address + "','" + phone + "','" + id_card + "','" + gender + "','" + birthday + "','" + email + "','" + edu + "','" + graduated_sch + "','" + graduated_major + "','" + work_place + "','" + position + "','" + title + "',to_date('" + begin_date + "','yyyy-mm-dd'),to_date('" + graduated_time + "','yyyy-mm-dd'),'" + alteration + "','" + note + "','" + remark + "','" + Out_ImageHTML + "')";
	int count = 0;
	
	//out.print(sql);
	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_manage.jsp");
%>