Endless Endeavor

환경  :   WINDOWS7,  ECLIPSE JUNO,  JDK7,  ,TOMCAT7.0

만드실 파일 : Controller.java, Impl.java, Lislmpl.java, web.xml, start.jsp, test.jsp, test.param

    ↓ 완성파일

Test.zip

결과 화면)

 -> 

Interface

package MVC;

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

public interface Impl {
	public String boardImpl(HttpServletRequest req, HttpServletResponse res);
}

Class

package MVC;

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

public class Listlmpl implements Impl {

	@Override
	public String boardImpl(HttpServletRequest req, HttpServletResponse res) {
		
		return "test.jsp";
	}

}

package MVC;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Properties;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Controller extends HttpServlet {
	Map map = new HashMap();

	@Override
	public void init(ServletConfig config) throws ServletException {
		String readProperties = config.getInitParameter("param");
		Properties prop = new Properties();
		FileInputStream fis = null;
		try {
			fis = new FileInputStream(readProperties);
			prop.load(fis);
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		Iterator i = prop.keySet().iterator();
		while (i.hasNext()) {
			String key = (String) i.next();
			String className = prop.getProperty(key);
			try {
				Class makeClass = Class.forName(className);
				Object o = makeClass.newInstance();
				map.put(key, o);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}

	public void excute(HttpServletRequest req, HttpServletResponse res)
			throws ServletException, IOException {
		String view = null;
		Impl impl = null;
		try {
			String uri = req.getRequestURI();
			if (uri.indexOf(req.getContextPath()) == 0) {
				uri = uri.substring(req.getContextPath().length());
			}
			impl = (Impl) map.get(uri);
			view = impl.boardImpl(req, res);
		} catch (Exception e) {
			e.printStackTrace();
		}
		RequestDispatcher rd = req.getRequestDispatcher(view);
		rd.forward(req, res);
	}

	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		excute(req, resp);
	}

	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		excute(req, resp);
	}
}

Control.java

먼저 이파일을 하나 만든다.

결과화면이다.

급하게 만든 게시판이다. 쓰기와 로그인 리스트와 페이징만 되는 게시판이다.

게시판의 기능으로 읽기도 있을것이며 삭제, 수정, 답글달기 댓글달기는

MVC패턴의 게시판을 하면서 하겠습니다.

list.jsp파일 내용

package endless.test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class BoardDao {
	Board board;
	Connection connection;
	PreparedStatement preparedStatement;
	DataBaseChoice dbchoice = new DataBaseChoice();
	Vector boardlist;
	ResultSet resultset;

	public void insert(Object object) throws SQLException,
			ClassNotFoundException {
		board = (Board) object;
		connection = dbchoice.makeConnection();
		String insertQuery = "INSERT INTO BOARD (id,title,content,hit,writedate) VALUES (?,?,?,0,now())";
		preparedStatement = connection.prepareStatement(insertQuery);
		preparedStatement.setString(1, board.getId());
		preparedStatement.setString(2, board.getTitle());
		preparedStatement.setString(3, board.getContent());
		preparedStatement.executeUpdate();

		preparedStatement.close();
		connection.close();

	}

	public int getBoardCount() throws SQLException, ClassNotFoundException {
		int value = 0;
		connection = dbchoice.makeConnection();
		String countQuery = "SELECT COUNT(*) FROM BOARD";
		preparedStatement = connection.prepareStatement(countQuery);
		resultset = preparedStatement.executeQuery();

		if (resultset.next()) {
			value = resultset.getInt(1);
		}
		return value;
	}

	public Vector getBoard(int startRow, int endRow)
			throws SQLException, ClassNotFoundException {
		boardlist = new Vector();

		connection = dbchoice.makeConnection();
		String pagingQuery = "SELECT * FROM (SELECT @ROWNUM :=@ROWNUM +1 AS ROW, A.* FROM (SELECT * FROM BOARD ORDER BY WRITENUM DESC) A, (SELECT @ROWNUM := 0) B) C WHERE C.ROW BETWEEN ? AND ?";
		preparedStatement = connection.prepareStatement(pagingQuery);
		preparedStatement.setInt(1, startRow);
		preparedStatement.setInt(2, endRow);

		resultset = preparedStatement.executeQuery();

		while (resultset.next()) {
			board = new Board();

			board.setWritenum(resultset.getInt("writenum"));
			board.setId(resultset.getString("id"));
			board.setTitle(resultset.getString("title"));
			board.setContent(resultset.getString("content"));
			board.setHit(resultset.getInt("hit"));
			board.setWritedate(resultset.getTimestamp("writedate"));

			boardlist.add(board);
		}

		preparedStatement.close();
		connection.close();

		return boardlist;

	}

}