import java.util.logging.Logger;
import org.slf4j.LoggerFactory;
public class PublicationDAO extends DAO<Publication, Long> {
private static final org.slf4j.Logger logger = LoggerFactory.getLogger(PublicationDAO.class);
private static final String SQL_INSERT
<BUG>= "INSERT INTO PUBLICATION (docID, monographID, publisherID, type, doc_title, date_printed, date_electronic, start_page, end_page, language) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
</BUG>
private static final String SQL_SELECT
= "SELECT * FROM DOCUMENT ,MONOGRAPH ,PUBLISHER, PUBLICATION WHERE publicationID = ? AND DOCUMENT.docID = PUBLICATION.docID AND MONOGRAPH.monographID = PUBLICATION.monographID AND PUBLISHER.publisherID = PUBLICATION.publisherID";
private static final String SQL_SELECT_BY_DOCID

import java.util.logging.Logger;
import org.slf4j.LoggerFactory;
public class PublicationDAO extends DAO<Publication, Long> {
private static final org.slf4j.Logger logger = LoggerFactory.getLogger(PublicationDAO.class);
private static final String SQL_INSERT
= "INSERT INTO PUBLICATION (docID, monographID, publisherID, type, doc_title, date_printed, date_electronic, first_page, last_page, language) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
private static final String SQL_SELECT
= "SELECT * FROM DOCUMENT ,MONOGRAPH ,PUBLISHER, PUBLICATION WHERE publicationID = ? AND DOCUMENT.docID = PUBLICATION.docID AND MONOGRAPH.monographID = PUBLICATION.monographID AND PUBLISHER.publisherID = PUBLICATION.publisherID";
private static final String SQL_SELECT_BY_DOCID
