delstudent.java

中学教学管理系统

import java.io.IOException;
import java.io.PrintWriter;

import java.sql.*;
import utility.*;

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


public class delStudent extends HttpServlet {
/**
	 * 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();

		String strSql = "SELECT * FROM student"
			+ " WHERE stuUnifiedNo = '" + request.getParameter("jwtyNumber")+"'";
		
		try{
			Connection con = DBConnection.getConnection();
			Statement stmt = con.createStatement();

			ResultSet rs = stmt.executeQuery(strSql);
			if (!rs.next()){
				out.println("不存在教委统一编号为"+request.getParameter("jwtyNumber")+"的学生！");
				out.println("<br><br><br><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'>");
			}
			else {
				strSql = "DELETE  FROM student WHERE stuUnifiedNo = '" 
						+ request.getParameter("jwtyNumber")+"'";
				stmt.executeUpdate(strSql);

				con.close();
				out.println("删除学生成功!");
				out.println("<br><br><br><input type='button' name='back' id='back' value='继续删除' onClick='javascript:history.go(-1)'>");
				out.println("<br><br><br><input type='button' name='back' id='back' value='返回' onClick='javascript:window.close()'>");
			}
		}
		catch(Exception e){
			out.println("删除失败!请检查数据库连接！");
			out.println("<br><br><br><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'>");
			e.printStackTrace();
		}
	}
}