Mercurial > hg > LGServices

comparison src/main/java/de/mpiwg/web/jsp/BooksPage.java @ 11:f15b0214cc1c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
10:efe0e7174139 11:f15b0214cc1c
2 2
3 import java.sql.Connection; 3 import java.sql.Connection;
4 import java.sql.ResultSet; 4 import java.sql.ResultSet;
5 import java.sql.Statement; 5 import java.sql.Statement;
6 import java.util.ArrayList; 6 import java.util.ArrayList;
7 import java.util.HashMap;
7 import java.util.List; 8 import java.util.List;
9 import java.util.Map;
8 10
9 import javax.servlet.http.HttpServletRequest; 11 import javax.servlet.http.HttpServletRequest;
10 import javax.servlet.http.HttpServletResponse; 12 import javax.servlet.http.HttpServletResponse;
11 13
12 import org.apache.log4j.Logger; 14 import org.apache.log4j.Logger;
20 private static Logger logger = Logger.getLogger(BooksPage.class); 22 private static Logger logger = Logger.getLogger(BooksPage.class);
21 23
22 public static String bean = "booksBean"; 24 public static String bean = "booksBean";
23 public static String page = "pages/books.jsp"; 25 public static String page = "pages/books.jsp";
24 private List<DBBook> completeBookList; 26 private List<DBBook> completeBookList;
27 private Map<String, DBSectionVersion> sectionVersionMap = null;
25 28
26 29
27 public void loadParameters(HttpServletRequest request, HttpServletResponse response){ 30 public void loadParameters(HttpServletRequest request, HttpServletResponse response){
28 this.request = request; 31 this.request = request;
29 this.response = response; 32 this.response = response;
35 } 38 }
36 39
37 public void loadBooks(){ 40 public void loadBooks(){
38 logger.debug("loadBooks"); 41 logger.debug("loadBooks");
39 42
43 this.loadSectionsVersion();
44
40 if(this.completeBookList == null){ 45 if(this.completeBookList == null){
41 logger.debug("loading book list"); 46 logger.debug("loading book list");
42 this.completeBookList = new ArrayList<DBBook>(); 47 this.completeBookList = new ArrayList<DBBook>();
43 if(getSessionBean().getUser() != null){ 48 if(getSessionBean().getUser() != null){
44 // === load book table from db == 49 // === load book table from db ==
45 for(DBBook book : DBService.getInstance().getBooks()){ 50 for(DBBook book : DBService.getInstance().getBooks()){
46 // TODO: get editor and date by book id 51 // TODO: get editor and date by book id
52
53 book.setCurrentSectionVersion(sectionVersionMap.get(book.getId()));
47 54
48 this.completeBookList.add(book); 55 this.completeBookList.add(book);
49 } 56 }
50 } 57 }
51 } else { 58 } else {
52 // book list already been loaded 59 // book list already been loaded
53 } 60 }
54 } 61 }
55 62
63 private void loadSectionsVersion(){
64 this.sectionVersionMap = new HashMap<String, DBSectionVersion>();
65
66 try {
67 for(DBSectionVersion sv : DBService.getInstance().getSectionVersionList()){
68 this.sectionVersionMap.put(sv.getBooks_id(), sv);
69 }
70 } catch (Exception e) {
71 addMsg("There is an internal error: " + e.getLocalizedMessage());
72 e.printStackTrace();
73 }
74
75
76 }
56 77
78
79
80
57 81
58 } 82 }