updatelist.java

这是我自己做的一个选课系统

package org.chooseClass.servlet;

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

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

import org.chooseClass.database.DBConnect;

public class UpdateList extends HttpServlet {

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

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @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 doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("gb2312");
		String department_id=request.getParameter("department");
		//设置输出信息的格式及字符集
		response.setContentType("text/xml;charset=utf-8");
		response.setHeader("Cache-Control","no-cache");
		//创建输出流对象
		PrintWriter out=response.getWriter();
		
		//依据验证结果输出不同的数据信息
		out.println("<response>");
		try{
			String sql = "select major_id,major_name from major where department_id='"+department_id+"'";
			DBConnect dbc = new DBConnect(sql);
			ResultSet rs = dbc.executeQuery();
			while(rs.next()){
				out.println("<id>"+rs.getString("major_id")+"</id>");
				out.println("<major>"+rs.getString("major_name")+"</major>");
				
			}
		}catch(Exception e){
			
		}
        out.println("</response>");
		
		out.flush();
		out.close();
	}

	/**
	 * 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");
		String department_id=request.getParameter("department");
		//设置输出信息的格式及字符集
		response.setContentType("text/xml;charset=utf-8");
		response.setHeader("Cache-Control","no-cache");
		//创建输出流对象
		PrintWriter out=response.getWriter();
		
		//依据验证结果输出不同的数据信息
		out.println("<response>");
		try{
			String sql = "select major_id,major_name from major where department_id='"+department_id+"'";out.print(sql);
			DBConnect dbc = new DBConnect(sql);
			ResultSet rs = dbc.executeQuery();
			while(rs.next()){
				out.println("<id>"+rs.getString("major_id")+"</id>");
				out.println("<major>"+rs.getString("major_name")+"</major>");
				
			}
		}catch(Exception e){
			
		}
        out.println("</response>");
		
		out.flush();
		out.close();
	}
}