package de.mpiwg.gazetteer.db;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;

public class DBBook implements Comparable<DBBook>{

	private String id;
	private String name;
	private Integer line;
	private String period;
	//
	private String author;
	private String edition;
	private String volume;
	private String dynasty;
	
	private String level1;
	private String level2;
	private String admin_type;
	private String in_jibengujiku;
	
	private Integer start_year;
	private Integer end_year;
	private String comments;
	private String toc_correction;
	
	

	private DBSectionVersion currentSectionVersion;
	
	public DBBook(ResultSet rs) throws SQLException{
		this.name = rs.getString("name");
		this.id = rs.getString("id");
		this.line = rs.getInt("line");
		this.period = rs.getString("period");
		this.author = rs.getString("author");
		this.edition = rs.getString("edition");
		this.volume = rs.getString("volume");
		this.dynasty = rs.getString("dynasty");
		
		this.level1 = rs.getString("level1");
		this.level2 = rs.getString("level2");
		
		this.admin_type = rs.getString("admin_type");
		this.in_jibengujiku = rs.getString("in_jibengujiku");
		
		this.start_year = rs.getInt("start_year");
		this.end_year = rs.getInt("end_year");
		this.comments = rs.getString("comments");
		//this.toc_correction = Integer.parseInt(rs.getString("toc_correction"));
		this.toc_correction = rs.getString("toc_correction");
		
	}
	
	@Override
	public int compareTo(DBBook o) {
		return this.getName().compareTo(o.getName());
	}

	public String getTocCorrection() {
		return toc_correction;
	}


	public void setTocCorrection(String toc_correction) {
		this.toc_correction = toc_correction;
	}

	
	public String getId() {
		return id;
	}


	public void setId(String id) {
		this.id = id;
	}


	public String getName() {
		return name;
	}


	public void setName(String name) {
		this.name = name;
	}


	public Integer getLine() {
		return line;
	}

	public void setLine(Integer line) {
		this.line = line;
	}


	public String getComments() {
		return comments;
	}
	public void setComments(String comments){
		this.comments = comments;
	}
	
	
	public String getPeriod() {
		return period;
	}


	public void setPeriod(String period) {
		this.period = period;
	}


	public String getAuthor() {
		return author;
	}


	public void setAuthor(String author) {
		this.author = author;
	}


	public String getEdition() {
		return edition;
	}


	public void setEdition(String edition) {
		this.edition = edition;
	}


	public String getVolume() {
		return volume;
	}


	public void setVolume(String volume) {
		this.volume = volume;
	}


	public String getDynasty() {
		return dynasty;
	}


	public void setDynasty(String dynasty) {
		this.dynasty = dynasty;
	}


	public String getLevel1() {
		return level1;
	}


	public void setLevel1(String level1) {
		this.level1 = level1;
	}


	public String getLevel2() {
		return level2;
	}


	public void setLevel2(String level2) {
		this.level2 = level2;
	}


	public String getAdmin_type() {
		return admin_type;
	}


	public void setAdmin_type(String admin_type) {
		this.admin_type = admin_type;
	}


	public String getIn_jibengujiku() {
		return in_jibengujiku;
	}


	public void setIn_jibengujiku(String in_jibengujiku) {
		this.in_jibengujiku = in_jibengujiku;
	}


	public Integer getStart_year() {
		return start_year;
	}


	public void setStart_year(Integer start_year) {
		this.start_year = start_year;
	}


	public Integer getEnd_year() {
		return end_year;
	}


	public void setEnd_year(Integer end_year) {
		this.end_year = end_year;
	}


	public DBSectionVersion getCurrentSectionVersion() {
		return currentSectionVersion;
	}


	public void setCurrentSectionVersion(DBSectionVersion currentSectionVersion) {
		this.currentSectionVersion = currentSectionVersion;
	}

	
	
}