My Servlet Code is
我的Servlet代码是
package DBCon;import java.io.*;import java.net.*;import java.util.ArrayList;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;/** * * @author Nayan */public class loadCourseId extends HttpServlet { /** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods. * @param request servlet request * @param response servlet response */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); ArrayList ar1=new ArrayList(); ArrayList ar2=new ArrayList(); int i; i=0; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con=DriverManager.getConnection("jdbc:mysql://localhost/online_exam?"+"user=root&password=pass"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from course"); while(rs.next()) { ar1.add(rs.getString(1)); ar2.add(rs.getString(2)); } request.getSession().setAttribute("CourseID", ar1); request.getSession().setAttribute("CourseName", ar2); RequestDispatcher requestDispatcher=getServletContext().getRequestDispatcher("https://localhost:8080/ONLINE_EXAM/removeCourse.jsp"); requestDispatcher.forward(request,response); } catch(Exception e) { out.println("<h1>"+e.getStackTrace()+"</h1>"); } } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** * Handles the HTTP <code>GET</code> method. * @param request servlet request * @param response servlet response */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Handles the HTTP <code>POST</code> method. * @param request servlet request * @param response servlet response */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Returns a short description of the servlet. */ public String getServletInfo() { return "Short description"; } // </editor-fold>}package DBC
