# HG changeset patch # User Zoe Hong # Date 1432643974 -7200 # Node ID efe0e7174139d3341bc07a0773e3cf03751b3a07 # Parent 58f5747004742691f7ce6663a72de43d0f6fa0ff add BooksPage diff -r 58f574700474 -r efe0e7174139 src/main/java/de/mpiwg/gazetteer/db/DBSectionVersion.java --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/main/java/de/mpiwg/gazetteer/db/DBSectionVersion.java Tue May 26 14:39:34 2015 +0200 @@ -0,0 +1,12 @@ +package de.mpiwg.gazetteer.db; + +public class DBSectionVersion { + private String id; + private String version; + private String editor; + private String date; + private String books_id; + + + +} diff -r 58f574700474 -r efe0e7174139 src/main/java/de/mpiwg/web/jsp/BooksPage.java --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/main/java/de/mpiwg/web/jsp/BooksPage.java Tue May 26 14:39:34 2015 +0200 @@ -0,0 +1,58 @@ +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 completeBookList; + + + public void loadParameters(HttpServletRequest request, HttpServletResponse response){ + this.request = request; + this.response = response; + + } + + public List getCompleteBookList() { + return completeBookList; + } + + public void loadBooks(){ + logger.debug("loadBooks"); + + if(this.completeBookList == null){ + logger.debug("loading book list"); + this.completeBookList = new ArrayList(); + 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 + } + } + + + +} diff -r 58f574700474 -r efe0e7174139 src/main/webapp/pages/books.jsp --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/main/webapp/pages/books.jsp Tue May 26 14:39:34 2015 +0200 @@ -0,0 +1,239 @@ +<%@page import="de.mpiwg.gazetteer.bo.LGBranch"%> +<%@page import="org.apache.commons.lang.StringUtils"%> +<%@page import="de.mpiwg.gazetteer.db.DBSection"%> +<%@page import="de.mpiwg.gazetteer.db.DBBook"%> +<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> + + + + + + + + + + + + + + + + + + + + + +
+ + <% if(sessionBean.getUser() == null) { %> + + <% } else { + sessionBean.getBooksPage().loadParameters(request, response); + sessionBean.getBooksPage().loadBooks(); + + %> + + + +
+ + + + + + + + + + + + + + + + + + + + + + <% for(DBBook book : sessionBean.getBooksPage().getCompleteBookList() ) { %> + + + + + + + + + + + + + + + + + + + + + <% } %> +
<%=book.getId() %><%=book.getName() %><%=book.getEdition() %><%=book.getLevel1()%><%=book.getLevel2() %><%=book.getPeriod() %><%=book.getDynasty() %><%=book.getAdmin_type() %><%=book.getStart_year() %>TODOTODO/>TODO:last editorTODO:edit time
+ +
+ <% } %> +
+ + + +