LGServer: src/main/java/de/mpiwg/gazetteer/utils/DBService.java annotate

author	"jurzua <jurzua@mpiwg-berlin.mpg.de>"
date	Tue, 10 Mar 2015 14:50:41 +0100
parents
children	5316e79f9a27

rev	line source
0 7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1 package de.mpiwg.gazetteer.utils;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	2
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	3 import java.io.IOException;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	4 import java.sql.Connection;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	5 import java.sql.DriverManager;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	6 import java.sql.ResultSet;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	7 import java.sql.SQLException;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	8 import java.sql.Statement;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	9 import java.util.ArrayList;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	10 import java.util.Date;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	11 import java.util.List;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	12
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	13 import org.apache.log4j.Logger;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	14 import org.hibernate.Query;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	15 import org.hibernate.Session;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	16
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	17 import de.mpiwg.gazetteer.bo.DBEntry;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	18 import de.mpiwg.gazetteer.bo.LGBranch;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	19 import de.mpiwg.gazetteer.bo.LGFile;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	20 import de.mpiwg.gazetteer.bo.SearchRulesFile;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	21 import de.mpiwg.gazetteer.bo.Sequence;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	22 import de.mpiwg.gazetteer.db.DBBook;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	23 import de.mpiwg.gazetteer.db.DBSection;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	24 import de.mpiwg.web.SessionBean;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	25
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	26 public class DBService {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	27
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	28 private static Logger logger = Logger.getLogger(DBService.class);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	29
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	30 // JDBC driver name and database URL
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	31 static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	32 static final String DB_URL = "jdbc:mysql://localhost/";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	33
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	34 public static List<DBSection> searchSection(List<String> termList) throws SQLException{
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	35 List<DBSection> list = new ArrayList<DBSection>();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	36
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	37 Connection conn = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	38 Statement stmt = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	39
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	40 String query = "SELECT name, id, books_id FROM sections WHERE ";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	41 for(int i=0; i<termList.size() ; i++){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	42 String term = termList.get(i);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	43 if(i>0){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	44 query += " OR ";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	45 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	46 query += "name like '" + term + "%' ";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	47 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	48 query += " limit 50";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	49
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	50 try {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	51 Class.forName(JDBC_DRIVER);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	52 conn = getNewConnection();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	53 stmt = conn.createStatement();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	54
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	55 ResultSet rs = stmt.executeQuery(query);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	56 while (rs.next()) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	57 DBSection section = new DBSection(rs);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	58 DBBook book = getBook0(conn, section.getBookId());
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	59 section.setBook(book);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	60 list.add(section);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	61 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	62 rs.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	63 } catch (Exception e) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	64 e.printStackTrace();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	65 } finally {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	66 conn.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	67 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	68
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	69 return list;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	70 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	71
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	72 public static List<String> suggestSectionName(String term) throws SQLException {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	73 List<String> list = new ArrayList<String>();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	74
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	75 Connection conn = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	76 Statement stmt = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	77
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	78 String query = "SELECT name FROM sections WHERE name like '" + term + "%' limit 50";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	79
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	80 try {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	81 Class.forName(JDBC_DRIVER);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	82 conn = getNewConnection();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	83 stmt = conn.createStatement();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	84
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	85 ResultSet rs = stmt.executeQuery(query);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	86 while (rs.next()) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	87 String name = rs.getString("name");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	88 if(!list.contains(name)){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	89 list.add(name);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	90 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	91 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	92 rs.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	93 } catch (Exception e) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	94 e.printStackTrace();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	95 } finally {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	96 conn.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	97 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	98 return list;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	99 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	100
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	101
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	102 public static List<String> suggestSectionId(String input) throws SQLException {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	103 List<String> list = new ArrayList<String>();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	104
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	105 Connection conn = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	106 Statement stmt = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	107
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	108 String query = "SELECT id FROM sections WHERE id like '" + input + "%' limit 50";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	109
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	110 try {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	111 Class.forName(JDBC_DRIVER);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	112 conn = getNewConnection();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	113 stmt = conn.createStatement();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	114
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	115 ResultSet rs = stmt.executeQuery(query);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	116 while (rs.next()) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	117
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	118 String id = rs.getString("id");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	119 list.add(id);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	120
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	121 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	122 rs.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	123 } catch (Exception e) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	124 e.printStackTrace();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	125 } finally {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	126 conn.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	127 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	128
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	129
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	130
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	131 return list;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	132 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	133
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	134 public static DBSection getSectionWithContent(Long sectionId) throws SQLException {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	135
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	136 Connection conn = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	137 Statement stmt = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	138 DBSection response = new DBSection(sectionId);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	139
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	140 String query = "SELECT * FROM sections WHERE id = '" + sectionId + "'";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	141
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	142 try {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	143 Class.forName(JDBC_DRIVER);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	144 conn = getNewConnection();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	145 stmt = conn.createStatement();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	146
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	147 ResultSet rs = stmt.executeQuery(query);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	148 while (rs.next()) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	149
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	150 String bookId = rs.getString("books_id");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	151 int startPage = rs.getInt("start_page");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	152 int endPage = rs.getInt("end_page");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	153 String sectionName = rs.getString("name");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	154
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	155 response.setBookId(bookId);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	156 response.setName(sectionName);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	157
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	158 System.out.println("bookId=" + bookId + ", startPage=" + startPage + ", endPage=" + endPage);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	159 String content = getContent(conn, bookId, startPage, endPage);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	160 response.setText(content);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	161
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	162 DBBook book = getBook0(conn, bookId);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	163 response.setBook(book);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	164
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	165 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	166 rs.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	167 } catch (Exception e) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	168 e.printStackTrace();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	169 } finally {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	170 conn.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	171 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	172 return response;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	173 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	174
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	175 public static String fixToNewline(String orig){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	176 char[] chars = orig.toCharArray();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	177 StringBuilder sb = new StringBuilder(100);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	178 for(char c : chars){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	179 switch(c){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	180 case '\r':
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	181 case '\f':
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	182 break;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	183 case '\n':
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	184 sb.append("<br>");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	185 break;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	186 default:
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	187 sb.append(c);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	188 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	189 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	190 return sb.toString();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	191 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	192
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	193 //"SELECT `content`, `line`, `books_id` FROM `contents` WHERE `books_id`=\"%s\" AND `line`>=%d AND `line`<=%d
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	194 private static String getContent(Connection conn, String bookId, Integer startLine, Integer endLine) throws Exception{
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	195
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	196 String query = "SELECT content, line FROM contents WHERE books_id = '" + bookId + "' AND line >= '" + startLine + "' AND line <= '" + endLine + "'";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	197
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	198 logger.debug(query);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	199
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	200 Statement stmt = conn.createStatement();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	201 ResultSet rs = stmt.executeQuery(query);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	202
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	203 StringBuilder sb = new StringBuilder();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	204 while(rs.next()){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	205 String line = rs.getString("line");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	206 String content = rs.getString("content");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	207 sb.append("【" + line + "】" + content + "\n");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	208 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	209
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	210 return sb.toString();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	211 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	212
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	213
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	214 public static DBBook getBook(String id) throws SQLException{
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	215 Connection conn = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	216 DBBook book = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	217
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	218 try {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	219 Class.forName(JDBC_DRIVER);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	220
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	221 conn = getNewConnection();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	222 book = getBook0(conn, id);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	223 } catch (Exception e) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	224 e.printStackTrace();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	225 } finally {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	226 conn.close();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	227 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	228 return book;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	229 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	230
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	231 private static DBBook getBook0(Connection conn, String id) throws SQLException{
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	232 DBBook book = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	233
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	234 String query = "SELECT * FROM books WHERE id = '" + id + "'";
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	235 logger.debug(query);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	236
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	237 Statement stmt = conn.createStatement();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	238 ResultSet rs = stmt.executeQuery(query);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	239
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	240 if(rs.next()){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	241 book = new DBBook(rs);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	242 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	243
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	244 return book;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	245 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	246
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	247 /**
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	248 * This method removed all files for a particular fileId.
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	249 * The elimination includes the current version as well as the old versions.
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	250 * @param fileId
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	251 * @return
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	252 */
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	253 protected static int deleteBranchFromDB(Long branchId){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	254 logger.info("Deleting Branch by branchId=" + branchId);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	255
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	256 int modifiedFiles;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	257 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	258 session.getTransaction().begin();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	259
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	260 Query query = session.createQuery("delete LGBranch where id = :id");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	261 query.setLong("id", branchId);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	262 modifiedFiles = query.executeUpdate();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	263
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	264 Query query0 = session.createQuery("delete LGFile where branchId = :branchId");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	265 query0.setLong("branchId", branchId);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	266 modifiedFiles += query0.executeUpdate();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	267
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	268 session.getTransaction().commit();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	269
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	270 return modifiedFiles;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	271 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	272
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	273 protected static List<LGFile> getAllLGFileFromDB(){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	274 List<LGFile> list = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	275
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	276 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	277 session.getTransaction().begin();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	278 Query query = session.createQuery("from LGFile");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	279 list = query.list();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	280 session.getTransaction().commit();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	281
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	282 return list;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	283 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	284
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	285 protected static List<LGFile> getCurrentLGFilesFromDB(){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	286 List<LGFile> list = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	287
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	288 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	289 session.getTransaction().begin();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	290 Query query = session.createQuery("from LGFile where lastVersion = :lastVersion");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	291 query.setBoolean("lastVersion", true);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	292 list = query.list();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	293 session.getTransaction().commit();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	294
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	295 return list;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	296 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	297
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	298 protected static List<LGBranch> getAllLGBranchFromDB(){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	299 List<LGBranch> list = null;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	300
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	301 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	302 session.getTransaction().begin();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	303 Query query = session.createQuery("from LGBranch");
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	304 list = query.list();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	305 session.getTransaction().commit();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	306
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	307 return list;
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	308 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	309
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	310 protected static void saveDBEntry(DBEntry entry, Date date){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	311
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	312 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	313 session.getTransaction().begin();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	314
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	315 saveDBEntry0(session, entry, date);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	316
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	317 session.getTransaction().commit();
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	318 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	319
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	320 public static void saveDBEntry0(Session session, DBEntry entry, Date date){
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	321 entry.setLastChangeDate(date);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	322 if (entry.isPersistent()) {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	323 session.update(entry);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	324 } else {
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	325 entry.setCreationDate(date);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	326 session.save(entry);
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	327 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	328 logger.info("saveDBEntry: " + entry.toString());
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	329 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	330
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	331 public static Connection getNewConnection() throws SQLException, IOException{
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	332 return DriverManager.getConnection(
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	333 DB_URL + PropertiesUtils.getPropValue("db_gazetter_name") + "?useUnicode=yes&characterEncoding=UTF-8",
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	334 PropertiesUtils.getPropValue("db_gazetter_username"),
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	335 PropertiesUtils.getPropValue("db_gazetter_password"));
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	336 }
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	337
7682c04c63a8 First commit of the source code! "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	338 }

0

7682c04c63a8 First commit of the source code!