modifystudent.java

中学教学管理系统

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import utility.DBConnection;


public class modifyStudent extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public modifyStudent() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}
	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("gb2312");
		response.setContentType("text/html");
		response.setCharacterEncoding("gb2312");
		PrintWriter out = response.getWriter();
		
		try {
		Connection con = DBConnection.getConnection();
		Statement stmt = con.createStatement();
		
		String stuUnifiedNo = request.getParameter("jwtyNumber");
		String classNo = request.getParameter("bjNumber");
		String stuNo = request.getParameter("bnNumber");
		String stdName = request.getParameter("studentName");
		String stdSex = request.getParameter("gender");
		String stdAddr = request.getParameter("address");
		String stdPhone = request.getParameter("phoneNumber");
		String stdPass = request.getParameter("password");
		String stdGrade = request.getParameter("grade");
		String xueli = request.getParameter("xueLi");
		String stdEnterTime = request.getParameter("enterTime");
		String photoName = request.getParameter("photoName");
		String JCDescription = request.getParameter("jcDescription");

		//检查外键约束--班级编号必须存在
		String strCheck = "SELECT * FROM class WHERE classNo = '" + classNo + "'";
		ResultSet rs = stmt.executeQuery(strCheck);
		if (!rs.next()){
			out.println("不存在班级编号为"+classNo+"的班级！");
			out.println("<p><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'></p>");
			con.close();
		}
		else{
			String strAdd = "";
			strAdd = "UPDATE student SET classNo='"+classNo+"',stuNo='"+stuNo+"',stdSex='"+stdSex
				+"',stdAddr='"+stdAddr+"',stdPhone='"+stdPhone+"',stdPass='"+stdPass
				+"',stdGrade='"+stdGrade+"',stdAntecedent='"+xueli
				+"',stdEnterTime='"+stdEnterTime+"',photoName='"+photoName+"',JCDescription='"
				+JCDescription+"'";
			stmt.executeUpdate(strAdd);
			con.close();
			out.println("学生信息修改成功！");
			out.println("<br><br><br><p><input type='button' name='back' id='back' value='继续修改' onClick='javascript:history.go(-2)'></p>");
			out.println("<p><input type='button' name='back' id='back' value='返回' onClick='javascript:window.close()'></p>");
		}
		}
		catch (Exception e){
			out.print("修改失败！请检查输入格式或数据库连接！");
			out.println("<p><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'></p>");
		}
	}		
	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}