addstudent.java

中学教学管理系统

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

import java.sql.*;

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

import utility.*;


public class addStudent extends HttpServlet {
	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 strCheckFK = "SELECT * FROM class WHERE classNo = '" + classNo + "'";
		ResultSet rs = stmt.executeQuery(strCheckFK);
		if (!rs.next()){
			out.println("不存在班级编号为"+classNo+"的班级！");
			out.println("<br><br><br><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'>");
			con.close();
		}
		
		else{
			//检查主键约束
			String strCheckPK = "SELECT * FROM student WHERE stuUnifiedNo = '" + stuUnifiedNo + "'";
			ResultSet rs2 = stmt.executeQuery(strCheckPK);
			if (rs2.next()){
				out.println("系统中已经存在编号为"+stuUnifiedNo+"的学生！");
				out.println("<br><br><br><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'>");
				con.close();				
			}
			else{
			String strAdd = "";
			strAdd = "INSERT INTO student(stuUnifiedNo,classNo,stuNo,stdName,stdSex,"
					+ "stdAddr,stdPhone,stdPass,stdGrade,stdAntecedent,stdEnterTime"
					+ ",photoName,JCDescription,whereToGo) VALUES('" + stuUnifiedNo + "','" + classNo
					+ "','" + stuNo + "','" + stdName + "','" + stdSex + "','" + stdAddr + "','"
					+ stdPhone + "','" + stdPass + "','" + stdGrade  + "','" 
					+ xueli + "','" + stdEnterTime + "','" + photoName + "','" + 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(-1)'></p>");
			out.println("<p><input type='button' name='back' id='back' value='返回' onClick='javascript:window.close()'></p>");
		}
		}
		}
		catch (Exception e){
			e.printStackTrace();
			out.print("添加失败!请检查输入格式或数据库连接");
			out.println("<br><br><br><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'>");

		}
	}
}