quirestudent.java

来自「实现中小学生校园管理里」· Java 代码 · 共 101 行

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 quireStudent extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public quireStudent() {
		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();
		
		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("查询到学生信息如下：");
				out.println("<table width='100%'  border='1'>");
				out.println("<br>教委统一编号："+rs.getString("stuUnifiedNo"));
				out.println("<br>班级编号："+rs.getString("classNo"));
				out.println("<br>班内编号："+rs.getString("stuNo"));
				out.println("<br>学生姓名："+rs.getString("stdName"));
				out.println("<br>学生性别："+rs.getString("stdSex"));
				out.println("<br>家庭住址："+rs.getString("stdAddr"));
				out.println("<br>电话：	"+rs.getString("stdPhone"));
				out.println("<br>密码：	"+rs.getString("stdPass"));
				out.println("<br>年级：	"+rs.getString("stdGrade"));
				out.println("<br>学历："+rs.getString("stdAntecedent"));
				out.println("<br>入学时间："+rs.getDate("stdEnterTime"));
				out.println("<br>照片名：	"+rs.getString("photoName"));
				out.println("<br>奖惩记录："+rs.getString("JCDescription"));
				out.println("<br>学籍信息："+rs.getString("XJInfor"));
				out.println("<br>毕业去向："+rs.getString("whereToGo"));
				out.println("</table>");
				
				out.println("<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()'>");
			}
			else {
				out.println("系统中不存在学生的信息！");
				out.println("<br><br><br><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'>");
			}
		}
		catch(Exception e){
			e.printStackTrace();
			out.println("数据库连接错误!");
			out.println("<br><br><br><input type='button' name='back' id='back' value='返回' onClick='javascript:history.go(-1)'>");
		}
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}