10
|
1 package de.mpiwg.web.jsp;
|
|
2
|
|
3 import java.sql.Connection;
|
|
4 import java.sql.ResultSet;
|
|
5 import java.sql.Statement;
|
|
6 import java.util.ArrayList;
|
|
7 import java.util.List;
|
|
8
|
|
9 import javax.servlet.http.HttpServletRequest;
|
|
10 import javax.servlet.http.HttpServletResponse;
|
|
11
|
|
12 import org.apache.log4j.Logger;
|
|
13
|
|
14 import de.mpiwg.gazetteer.db.DBBook;
|
|
15 import de.mpiwg.gazetteer.db.DBSectionVersion;
|
|
16 import de.mpiwg.gazetteer.utils.DBService;
|
|
17
|
|
18 public class BooksPage extends AbstractJSPPage{
|
|
19
|
|
20 private static Logger logger = Logger.getLogger(BooksPage.class);
|
|
21
|
|
22 public static String bean = "booksBean";
|
|
23 public static String page = "pages/books.jsp";
|
|
24 private List<DBBook> completeBookList;
|
|
25
|
|
26
|
|
27 public void loadParameters(HttpServletRequest request, HttpServletResponse response){
|
|
28 this.request = request;
|
|
29 this.response = response;
|
|
30
|
|
31 }
|
|
32
|
|
33 public List<DBBook> getCompleteBookList() {
|
|
34 return completeBookList;
|
|
35 }
|
|
36
|
|
37 public void loadBooks(){
|
|
38 logger.debug("loadBooks");
|
|
39
|
|
40 if(this.completeBookList == null){
|
|
41 logger.debug("loading book list");
|
|
42 this.completeBookList = new ArrayList<DBBook>();
|
|
43 if(getSessionBean().getUser() != null){
|
|
44 // === load book table from db ==
|
|
45 for(DBBook book : DBService.getInstance().getBooks()){
|
|
46 // TODO: get editor and date by book id
|
|
47
|
|
48 this.completeBookList.add(book);
|
|
49 }
|
|
50 }
|
|
51 } else {
|
|
52 // book list already been loaded
|
|
53 }
|
|
54 }
|
|
55
|
|
56
|
|
57
|
|
58 }
|