Mercurial > hg > LGServices

comparison src/main/java/de/mpiwg/gazetteer/utils/DBService.java @ 14:3387d855a194

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
new: toc status in books page
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Fri, 29 May 2015 11:00:09 +0200
parents 9c6e74761f60
children 9c4937b290c6
comparison
equal deleted inserted replaced
13:9c6e74761f60 14:3387d855a194
5 import java.sql.DriverManager; 5 import java.sql.DriverManager;
6 import java.sql.ResultSet; 6 import java.sql.ResultSet;
7 import java.sql.SQLException; 7 import java.sql.SQLException;
8 import java.sql.Statement; 8 import java.sql.Statement;
9 import java.util.ArrayList; 9 import java.util.ArrayList;
10 import java.util.Collection;
11 import java.util.Date; 10 import java.util.Date;
12 import java.util.HashMap; 11 import java.util.HashMap;
13 import java.util.List; 12 import java.util.List;
14 import java.util.Map; 13 import java.util.Map;
15 14
18 import org.hibernate.Session; 17 import org.hibernate.Session;
19 18
20 import de.mpiwg.gazetteer.bo.DBEntry; 19 import de.mpiwg.gazetteer.bo.DBEntry;
21 import de.mpiwg.gazetteer.bo.LGBranch; 20 import de.mpiwg.gazetteer.bo.LGBranch;
22 import de.mpiwg.gazetteer.bo.LGFile; 21 import de.mpiwg.gazetteer.bo.LGFile;
23 import de.mpiwg.gazetteer.bo.SearchRulesFile;
24 import de.mpiwg.gazetteer.bo.Sequence;
25 import de.mpiwg.gazetteer.db.DBBook; 22 import de.mpiwg.gazetteer.db.DBBook;
26 import de.mpiwg.gazetteer.db.DBSection; 23 import de.mpiwg.gazetteer.db.DBSection;
27 import de.mpiwg.gazetteer.db.DBSectionVersion; 24 import de.mpiwg.gazetteer.db.DBSectionVersion;
28 25
29 public class DBService { 26 public class DBService {
80 long end = System.currentTimeMillis(); 77 long end = System.currentTimeMillis();
81 logger.debug("Time execution loading Book Map [ms]: " + (end - start)); 78 logger.debug("Time execution loading Book Map [ms]: " + (end - start));
82 } 79 }
83 80
84 public List<DBBook> getBooks(){ 81 public List<DBBook> getBooks(){
82 try {
83 this.loadBookMap();
84 } catch (SQLException e) {
85 // TODO Auto-generated catch block
86 e.printStackTrace();
87 }
88
85 // getBookMap().values() returns a Collection. In this way, we can use List. 89 // getBookMap().values() returns a Collection. In this way, we can use List.
86 return new ArrayList<DBBook>(getBookMap().values()); 90 return new ArrayList<DBBook>(getBookMap().values());
87 } 91 }
88 92
89 public DBBook getBook(String id){ 93 public DBBook getBook(String id){
114 stmt = conn.createStatement(); 118 stmt = conn.createStatement();
115 ResultSet rs = stmt.executeQuery(query); 119 ResultSet rs = stmt.executeQuery(query);
116 120
117 while(rs.next()){ 121 while(rs.next()){
118 DBBook book = new DBBook(rs); 122 DBBook book = new DBBook(rs);
119
120 123
121 this.bookMap.put(book.getId(), book); 124 this.bookMap.put(book.getId(), book);
122 } 125 }
123 } catch (Exception e) { 126 } catch (Exception e) {
124 e.printStackTrace(); 127 e.printStackTrace();
631 } 634 }
632 // ---- 635 // ----
633 636
634 return section_version; 637 return section_version;
635 } 638 }
639
640 public void updateTocCorrection(String bookId, Integer finishedStatus) throws SQLException {
641 Connection conn = null;
642 Statement stmt = null;
643 try {
644 String query = "UPDATE books SET toc_correction='"+ finishedStatus + "' WHERE id='" + bookId + "'";
645 conn = getNewConnection();
646 stmt = conn.createStatement();
647 int rs = stmt.executeUpdate(query);
648
649 } catch (Exception e) {
650 e.printStackTrace();
651 }finally{
652 conn.close();
653 }
654
655 DBBook book = this.bookMap.get(bookId);
656 book.setToc_correction(finishedStatus);
657
658
659 }
636 660
637 } 661 }