데이터베이스 예제(컨트롤러)

-- wspark.java -- (컨트롤러)

package com.wspark.web.servlet;  //패키지

import java.io.*;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.*;

import com.wspark.web.bo.JDBCSampleBO;

public class wspark extends HttpServlet {

private static final long serialVersionUID = 1L;

public void init() {
try {

  //데이터베이스 지정
  Class.forName("org.gjt.mm.mysql.Driver");
} catch (ClassNotFoundException e) {
 
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
doPost(request, response);
}
 
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
String cmd = request.getParameter("cmd");

// wspark의 파라미터에 따라 해당페이지와 결과를 디스패쳐로 넘긴다.
if (cmd.equals("jdbcsample")) {
  JDBCSampleBO jdbcSampleBO = new JDBCSampleBO();
  jdbcSampleBO.execute(request, response);

  //Context생성후 RequestDispatcher 생성
  RequestDispatcher rd = getServletContext().getRequestDispatcher("/WEB-INF/jsp/jdbcsample.jsp");
  rd.forward(request, response);
}
}

}