package de.mpiwg.web.jsp;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

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

import org.apache.log4j.Logger;

import de.mpiwg.gazetteer.db.DBBook;
import de.mpiwg.gazetteer.db.DBSectionVersion;
import de.mpiwg.gazetteer.utils.DBService;

public class BooksPage extends AbstractJSPPage{

	private static Logger logger = Logger.getLogger(BooksPage.class);
	
	public static String bean = "booksBean";
	public static String page = "pages/books.jsp";
	private List<DBBook> completeBookList;

	
	public void loadParameters(HttpServletRequest request, HttpServletResponse response){
		this.request = request;
		this.response = response;
		
	}
	
	public List<DBBook> getCompleteBookList() {
		return completeBookList;
	}

	public void loadBooks(){
		logger.debug("loadBooks");

		if(this.completeBookList == null){
			logger.debug("loading book list");
			this.completeBookList = new ArrayList<DBBook>();
			if(getSessionBean().getUser() != null){
				// === load book table from db ==
				for(DBBook book : DBService.getInstance().getBooks()){		
					// TODO: get editor and date by book id
					
					this.completeBookList.add(book);
				}	
			}
		} else {
			// book list already been loaded
		}
	}
	


}