queryservlet.java

对入学者很实用用JAVA的基本语言写的

package page;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

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

public class QueryServlet extends HttpServlet {

	public QueryServlet() {
		super();
	}

	public void destroy() {
		super.destroy();
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);

	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		String id = request.getParameter("id");
		String sql = "SELECT * FROM STUDENTS WHERE ID=?";
		List list = JDBCTraining.query(sql, id);
		// Student stu = (Student)list.get(0);
		request.getSession().setAttribute("list", list);
		response.sendRedirect("query.jsp");
	}

	public void init() throws ServletException {

	}

}