Mercurial > hg > LGServices
annotate src/main/java/de/mpiwg/web/jsp/BooksPage.java @ 11:f15b0214cc1c
Adding query for table SectionVersion
| author | "jurzua <jurzua@mpiwg-berlin.mpg.de>" |
|---|---|
| date | Tue, 26 May 2015 14:59:37 +0200 |
| parents | efe0e7174139 |
| children | d57fe2179f61 |
| rev | line source |
|---|---|
| 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; | |
|
11
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
7 import java.util.HashMap; |
| 10 | 8 import java.util.List; |
|
11
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
9 import java.util.Map; |
| 10 | 10 |
| 11 import javax.servlet.http.HttpServletRequest; | |
| 12 import javax.servlet.http.HttpServletResponse; | |
| 13 | |
| 14 import org.apache.log4j.Logger; | |
| 15 | |
| 16 import de.mpiwg.gazetteer.db.DBBook; | |
| 17 import de.mpiwg.gazetteer.db.DBSectionVersion; | |
| 18 import de.mpiwg.gazetteer.utils.DBService; | |
| 19 | |
| 20 public class BooksPage extends AbstractJSPPage{ | |
| 21 | |
| 22 private static Logger logger = Logger.getLogger(BooksPage.class); | |
| 23 | |
| 24 public static String bean = "booksBean"; | |
| 25 public static String page = "pages/books.jsp"; | |
| 26 private List<DBBook> completeBookList; | |
|
11
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
27 private Map<String, DBSectionVersion> sectionVersionMap = null; |
| 10 | 28 |
| 29 | |
| 30 public void loadParameters(HttpServletRequest request, HttpServletResponse response){ | |
| 31 this.request = request; | |
| 32 this.response = response; | |
| 33 | |
| 34 } | |
| 35 | |
| 36 public List<DBBook> getCompleteBookList() { | |
| 37 return completeBookList; | |
| 38 } | |
| 39 | |
| 40 public void loadBooks(){ | |
| 41 logger.debug("loadBooks"); | |
| 42 | |
|
11
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
43 this.loadSectionsVersion(); |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
44 |
| 10 | 45 if(this.completeBookList == null){ |
| 46 logger.debug("loading book list"); | |
| 47 this.completeBookList = new ArrayList<DBBook>(); | |
| 48 if(getSessionBean().getUser() != null){ | |
| 49 // === load book table from db == | |
| 50 for(DBBook book : DBService.getInstance().getBooks()){ | |
| 51 // TODO: get editor and date by book id | |
| 52 | |
|
11
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
53 book.setCurrentSectionVersion(sectionVersionMap.get(book.getId())); |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
54 |
| 10 | 55 this.completeBookList.add(book); |
| 56 } | |
| 57 } | |
| 58 } else { | |
| 59 // book list already been loaded | |
| 60 } | |
| 61 } | |
| 62 | |
|
11
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
63 private void loadSectionsVersion(){ |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
64 this.sectionVersionMap = new HashMap<String, DBSectionVersion>(); |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
65 |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
66 try { |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
67 for(DBSectionVersion sv : DBService.getInstance().getSectionVersionList()){ |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
68 this.sectionVersionMap.put(sv.getBooks_id(), sv); |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
69 } |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
70 } catch (Exception e) { |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
71 addMsg("There is an internal error: " + e.getLocalizedMessage()); |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
72 e.printStackTrace(); |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
73 } |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
74 |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
75 |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
76 } |
| 10 | 77 |
|
11
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
78 |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
79 |
|
f15b0214cc1c
Adding query for table SectionVersion
"jurzua <jurzua@mpiwg-berlin.mpg.de>"
parents:
10
diff
changeset
|
80 |
| 10 | 81 |
| 82 } |