Return-Path: 
 <user-java-return-11281-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 7115 invoked from network); 6 Apr 2007 11:09:46 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 6 Apr 2007 11:09:46 -0000
Received: (qmail 33982 invoked by uid 500); 6 Apr 2007 11:09:49 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 33813 invoked by uid 500); 6 Apr 2007 11:09:48 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 33802 invoked by uid 99); 6 Apr 2007 11:09:48 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Apr 2007 04:09:48 -0700
X-ASF-Spam-Status: No, hits=1.4 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (herse.apache.org: 206.46.252.40 is neither permitted
 nor denied by domain of jonathan.prater@gmail.com)
Received: from [206.46.252.40] (HELO vms040pub.verizon.net) (206.46.252.40)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Apr 2007 04:09:39 -0700
Received: from [192.168.0.101] ([141.156.227.102])
 by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr
 3 2006)) with ESMTPA id <0JG200IB8PN551G5@vms040.mailsrvcs.net> for
 user-java@ibatis.apache.org; Fri, 06 Apr 2007 06:09:08 -0500 (CDT)
Date: Fri, 06 Apr 2007 07:08:49 -0400
From: Jonathan Prater <jonathan.prater@gmail.com>
Subject: Problem with selectByExample
To: user-java@ibatis.apache.org
Message-id: <46162A41.4050805@gmail.com>
MIME-version: 1.0
Content-type: multipart/mixed; boundary=------------040003050808040009030406
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
X-Virus-Checked: Checked by ClamAV on apache.org

This is a multi-part message in MIME format.
--------------040003050808040009030406
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello, all!
I have used Abator to generate a SQLMap and POJO classes using the Java5 
generator set.  Now, when I try to use the Example class to do a 
searchByExample select statement, I get a big ugly java.io.IOException.  
Here's the stack trace...
java.sql.SQLException: File input/output error: java.io.IOException: 
Invalid argument
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at 
com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580)
        at 
com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222)
        at 
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
        at 
com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
        at 
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
        at 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
        at 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
        at 
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
        at 
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:95)
        at com.jpprater.libutils.Library.search(Library.java:47)
        at 
com.jpprater.libmgr.LibMgrMainFrame.btnSrchBasicActionPerformed(LibMgrMainFrame.java:132)
        at 
com.jpprater.libmgr.LibMgrMainFrame.access$000(LibMgrMainFrame.java:16)
        at 
com.jpprater.libmgr.LibMgrMainFrame$1.actionPerformed(LibMgrMainFrame.java:50)
        at 
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at 
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at 
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at 
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at 
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6038)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
        at java.awt.Component.processEvent(Component.java:5803)
        at java.awt.Container.processEvent(Container.java:2058)
        at java.awt.Component.dispatchEventImpl(Component.java:4410)
        at java.awt.Container.dispatchEventImpl(Container.java:2116)
        at java.awt.Component.dispatchEvent(Component.java:4240)
        at 
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
        at 
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
        at java.awt.Container.dispatchEventImpl(Container.java:2102)
        at java.awt.Window.dispatchEventImpl(Window.java:2429)
        at java.awt.Component.dispatchEvent(Component.java:4240)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at 
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at 
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at 
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at 
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

The referenced source files for the BookExample and Library classes are 
attached, along with my SQLMap file.  I used the newest Abator from the 
Ibatis website.  My Ibatis version is 2.3, and I'm using JDK 1.6.0 
update 1.  Please help!


--------------040003050808040009030406
Content-Type: text/plain;
 name="BookExample.java"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="BookExample.java"

package com.jpprater.libutils;

import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

public class BookExample {
    /**
     * This field was generated by Abator for iBATIS.
     * This field corresponds to the database table PUBLIC.BKCATALOG
     *
     * @abatorgenerated Fri Apr 06 06:48:10 EDT 2007
     */
    private String orderByClause;

    /**
     * This field was generated by Abator for iBATIS.
     * This field corresponds to the database table PUBLIC.BKCATALOG
     *
     * @abatorgenerated Fri Apr 06 06:48:10 EDT 2007
     */
    private List<Criteria> oredCriteria = new ArrayList<Criteria>();

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table PUBLIC.BKCATALOG
     *
     * @abatorgenerated Fri Apr 06 06:48:10 EDT 2007
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table PUBLIC.BKCATALOG
     *
     * @abatorgenerated Fri Apr 06 06:48:10 EDT 2007
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table PUBLIC.BKCATALOG
     *
     * @abatorgenerated Fri Apr 06 06:48:10 EDT 2007
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table PUBLIC.BKCATALOG
     *
     * @abatorgenerated Fri Apr 06 06:48:10 EDT 2007
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by Abator for iBATIS.
     * This method corresponds to the database table PUBLIC.BKCATALOG
     *
     * @abatorgenerated Fri Apr 06 06:48:10 EDT 2007
     */
    public Criteria createCriteria() {
        Criteria criteria = new Criteria();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This class was generated by Abator for iBATIS.
     * This class corresponds to the database table PUBLIC.BKCATALOG
     *
     * @abatorgenerated Fri Apr 06 06:48:10 EDT 2007
     */
    public static class Criteria {
        private List<String> criteriaWithoutValue;

        private List<Map<String, Object>> criteriaWithSingleValue;

        private List<Map<String, Object>> criteriaWithListValue;

        private List<Map<String, Object>> criteriaWithBetweenValue;

        private Criteria() {
            super();
            criteriaWithoutValue = new ArrayList<String>();
            criteriaWithSingleValue = new ArrayList<Map<String, Object>>();
            criteriaWithListValue = new ArrayList<Map<String, Object>>();
            criteriaWithBetweenValue = new ArrayList<Map<String, Object>>();
        }

        public List<String> getCriteriaWithoutValue() {
            return criteriaWithoutValue;
        }

        public List<Map<String, Object>> getCriteriaWithSingleValue() {
            return criteriaWithSingleValue;
        }

        public List<Map<String, Object>> getCriteriaWithListValue() {
            return criteriaWithListValue;
        }

        public List<Map<String, Object>> getCriteriaWithBetweenValue() {
            return criteriaWithBetweenValue;
        }

        private void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("value", value);
            criteriaWithSingleValue.add(map);
        }

        private void addCriterion(String condition, List<? extends Object> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("values", values);
            criteriaWithListValue.add(map);
        }

        private void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            List<Object> list = new ArrayList<Object>();
            list.add(value1);
            list.add(value2);
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("values", list);
            criteriaWithBetweenValue.add(map);
        }

        private void addCriterionForJDBCDate(String condition, Date value, String property) {
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        private void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        private void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            criteriaWithoutValue.add("ID is null");
            return this;
        }

        public Criteria andIdIsNotNull() {
            criteriaWithoutValue.add("ID is not null");
            return this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return this;
        }

        public Criteria andIsbnIsNull() {
            criteriaWithoutValue.add("ISBN is null");
            return this;
        }

        public Criteria andIsbnIsNotNull() {
            criteriaWithoutValue.add("ISBN is not null");
            return this;
        }

        public Criteria andIsbnEqualTo(String value) {
            addCriterion("ISBN =", value, "isbn");
            return this;
        }

        public Criteria andIsbnNotEqualTo(String value) {
            addCriterion("ISBN <>", value, "isbn");
            return this;
        }

        public Criteria andIsbnGreaterThan(String value) {
            addCriterion("ISBN >", value, "isbn");
            return this;
        }

        public Criteria andIsbnGreaterThanOrEqualTo(String value) {
            addCriterion("ISBN >=", value, "isbn");
            return this;
        }

        public Criteria andIsbnLessThan(String value) {
            addCriterion("ISBN <", value, "isbn");
            return this;
        }

        public Criteria andIsbnLessThanOrEqualTo(String value) {
            addCriterion("ISBN <=", value, "isbn");
            return this;
        }

        public Criteria andIsbnLike(String value) {
            addCriterion("ISBN like", value, "isbn");
            return this;
        }

        public Criteria andIsbnNotLike(String value) {
            addCriterion("ISBN not like", value, "isbn");
            return this;
        }

        public Criteria andIsbnIn(List<String> values) {
            addCriterion("ISBN in", values, "isbn");
            return this;
        }

        public Criteria andIsbnNotIn(List<String> values) {
            addCriterion("ISBN not in", values, "isbn");
            return this;
        }

        public Criteria andIsbnBetween(String value1, String value2) {
            addCriterion("ISBN between", value1, value2, "isbn");
            return this;
        }

        public Criteria andIsbnNotBetween(String value1, String value2) {
            addCriterion("ISBN not between", value1, value2, "isbn");
            return this;
        }

        public Criteria andAuthorIsNull() {
            criteriaWithoutValue.add("AUTHOR is null");
            return this;
        }

        public Criteria andAuthorIsNotNull() {
            criteriaWithoutValue.add("AUTHOR is not null");
            return this;
        }

        public Criteria andAuthorEqualTo(String value) {
            addCriterion("AUTHOR =", value, "author");
            return this;
        }

        public Criteria andAuthorNotEqualTo(String value) {
            addCriterion("AUTHOR <>", value, "author");
            return this;
        }

        public Criteria andAuthorGreaterThan(String value) {
            addCriterion("AUTHOR >", value, "author");
            return this;
        }

        public Criteria andAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("AUTHOR >=", value, "author");
            return this;
        }

        public Criteria andAuthorLessThan(String value) {
            addCriterion("AUTHOR <", value, "author");
            return this;
        }

        public Criteria andAuthorLessThanOrEqualTo(String value) {
            addCriterion("AUTHOR <=", value, "author");
            return this;
        }

        public Criteria andAuthorLike(String value) {
            addCriterion("AUTHOR like", value, "author");
            return this;
        }

        public Criteria andAuthorNotLike(String value) {
            addCriterion("AUTHOR not like", value, "author");
            return this;
        }

        public Criteria andAuthorIn(List<String> values) {
            addCriterion("AUTHOR in", values, "author");
            return this;
        }

        public Criteria andAuthorNotIn(List<String> values) {
            addCriterion("AUTHOR not in", values, "author");
            return this;
        }

        public Criteria andAuthorBetween(String value1, String value2) {
            addCriterion("AUTHOR between", value1, value2, "author");
            return this;
        }

        public Criteria andAuthorNotBetween(String value1, String value2) {
            addCriterion("AUTHOR not between", value1, value2, "author");
            return this;
        }

        public Criteria andTitleIsNull() {
            criteriaWithoutValue.add("TITLE is null");
            return this;
        }

        public Criteria andTitleIsNotNull() {
            criteriaWithoutValue.add("TITLE is not null");
            return this;
        }

        public Criteria andTitleEqualTo(String value) {
            addCriterion("TITLE =", value, "title");
            return this;
        }

        public Criteria andTitleNotEqualTo(String value) {
            addCriterion("TITLE <>", value, "title");
            return this;
        }

        public Criteria andTitleGreaterThan(String value) {
            addCriterion("TITLE >", value, "title");
            return this;
        }

        public Criteria andTitleGreaterThanOrEqualTo(String value) {
            addCriterion("TITLE >=", value, "title");
            return this;
        }

        public Criteria andTitleLessThan(String value) {
            addCriterion("TITLE <", value, "title");
            return this;
        }

        public Criteria andTitleLessThanOrEqualTo(String value) {
            addCriterion("TITLE <=", value, "title");
            return this;
        }

        public Criteria andTitleLike(String value) {
            addCriterion("TITLE like", value, "title");
            return this;
        }

        public Criteria andTitleNotLike(String value) {
            addCriterion("TITLE not like", value, "title");
            return this;
        }

        public Criteria andTitleIn(List<String> values) {
            addCriterion("TITLE in", values, "title");
            return this;
        }

        public Criteria andTitleNotIn(List<String> values) {
            addCriterion("TITLE not in", values, "title");
            return this;
        }

        public Criteria andTitleBetween(String value1, String value2) {
            addCriterion("TITLE between", value1, value2, "title");
            return this;
        }

        public Criteria andTitleNotBetween(String value1, String value2) {
            addCriterion("TITLE not between", value1, value2, "title");
            return this;
        }

        public Criteria andIllustratorIsNull() {
            criteriaWithoutValue.add("ILLUSTRATOR is null");
            return this;
        }

        public Criteria andIllustratorIsNotNull() {
            criteriaWithoutValue.add("ILLUSTRATOR is not null");
            return this;
        }

        public Criteria andIllustratorEqualTo(String value) {
            addCriterion("ILLUSTRATOR =", value, "illustrator");
            return this;
        }

        public Criteria andIllustratorNotEqualTo(String value) {
            addCriterion("ILLUSTRATOR <>", value, "illustrator");
            return this;
        }

        public Criteria andIllustratorGreaterThan(String value) {
            addCriterion("ILLUSTRATOR >", value, "illustrator");
            return this;
        }

        public Criteria andIllustratorGreaterThanOrEqualTo(String value) {
            addCriterion("ILLUSTRATOR >=", value, "illustrator");
            return this;
        }

        public Criteria andIllustratorLessThan(String value) {
            addCriterion("ILLUSTRATOR <", value, "illustrator");
            return this;
        }

        public Criteria andIllustratorLessThanOrEqualTo(String value) {
            addCriterion("ILLUSTRATOR <=", value, "illustrator");
            return this;
        }

        public Criteria andIllustratorLike(String value) {
            addCriterion("ILLUSTRATOR like", value, "illustrator");
            return this;
        }

        public Criteria andIllustratorNotLike(String value) {
            addCriterion("ILLUSTRATOR not like", value, "illustrator");
            return this;
        }

        public Criteria andIllustratorIn(List<String> values) {
            addCriterion("ILLUSTRATOR in", values, "illustrator");
            return this;
        }

        public Criteria andIllustratorNotIn(List<String> values) {
            addCriterion("ILLUSTRATOR not in", values, "illustrator");
            return this;
        }

        public Criteria andIllustratorBetween(String value1, String value2) {
            addCriterion("ILLUSTRATOR between", value1, value2, "illustrator");
            return this;
        }

        public Criteria andIllustratorNotBetween(String value1, String value2) {
            addCriterion("ILLUSTRATOR not between", value1, value2, "illustrator");
            return this;
        }

        public Criteria andSeriesIsNull() {
            criteriaWithoutValue.add("SERIES is null");
            return this;
        }

        public Criteria andSeriesIsNotNull() {
            criteriaWithoutValue.add("SERIES is not null");
            return this;
        }

        public Criteria andSeriesEqualTo(String value) {
            addCriterion("SERIES =", value, "series");
            return this;
        }

        public Criteria andSeriesNotEqualTo(String value) {
            addCriterion("SERIES <>", value, "series");
            return this;
        }

        public Criteria andSeriesGreaterThan(String value) {
            addCriterion("SERIES >", value, "series");
            return this;
        }

        public Criteria andSeriesGreaterThanOrEqualTo(String value) {
            addCriterion("SERIES >=", value, "series");
            return this;
        }

        public Criteria andSeriesLessThan(String value) {
            addCriterion("SERIES <", value, "series");
            return this;
        }

        public Criteria andSeriesLessThanOrEqualTo(String value) {
            addCriterion("SERIES <=", value, "series");
            return this;
        }

        public Criteria andSeriesLike(String value) {
            addCriterion("SERIES like", value, "series");
            return this;
        }

        public Criteria andSeriesNotLike(String value) {
            addCriterion("SERIES not like", value, "series");
            return this;
        }

        public Criteria andSeriesIn(List<String> values) {
            addCriterion("SERIES in", values, "series");
            return this;
        }

        public Criteria andSeriesNotIn(List<String> values) {
            addCriterion("SERIES not in", values, "series");
            return this;
        }

        public Criteria andSeriesBetween(String value1, String value2) {
            addCriterion("SERIES between", value1, value2, "series");
            return this;
        }

        public Criteria andSeriesNotBetween(String value1, String value2) {
            addCriterion("SERIES not between", value1, value2, "series");
            return this;
        }

        public Criteria andGenreIsNull() {
            criteriaWithoutValue.add("GENRE is null");
            return this;
        }

        public Criteria andGenreIsNotNull() {
            criteriaWithoutValue.add("GENRE is not null");
            return this;
        }

        public Criteria andGenreEqualTo(String value) {
            addCriterion("GENRE =", value, "genre");
            return this;
        }

        public Criteria andGenreNotEqualTo(String value) {
            addCriterion("GENRE <>", value, "genre");
            return this;
        }

        public Criteria andGenreGreaterThan(String value) {
            addCriterion("GENRE >", value, "genre");
            return this;
        }

        public Criteria andGenreGreaterThanOrEqualTo(String value) {
            addCriterion("GENRE >=", value, "genre");
            return this;
        }

        public Criteria andGenreLessThan(String value) {
            addCriterion("GENRE <", value, "genre");
            return this;
        }

        public Criteria andGenreLessThanOrEqualTo(String value) {
            addCriterion("GENRE <=", value, "genre");
            return this;
        }

        public Criteria andGenreLike(String value) {
            addCriterion("GENRE like", value, "genre");
            return this;
        }

        public Criteria andGenreNotLike(String value) {
            addCriterion("GENRE not like", value, "genre");
            return this;
        }

        public Criteria andGenreIn(List<String> values) {
            addCriterion("GENRE in", values, "genre");
            return this;
        }

        public Criteria andGenreNotIn(List<String> values) {
            addCriterion("GENRE not in", values, "genre");
            return this;
        }

        public Criteria andGenreBetween(String value1, String value2) {
            addCriterion("GENRE between", value1, value2, "genre");
            return this;
        }

        public Criteria andGenreNotBetween(String value1, String value2) {
            addCriterion("GENRE not between", value1, value2, "genre");
            return this;
        }

        public Criteria andClassificationIsNull() {
            criteriaWithoutValue.add("CLASSIFICATION is null");
            return this;
        }

        public Criteria andClassificationIsNotNull() {
            criteriaWithoutValue.add("CLASSIFICATION is not null");
            return this;
        }

        public Criteria andClassificationEqualTo(String value) {
            addCriterion("CLASSIFICATION =", value, "classification");
            return this;
        }

        public Criteria andClassificationNotEqualTo(String value) {
            addCriterion("CLASSIFICATION <>", value, "classification");
            return this;
        }

        public Criteria andClassificationGreaterThan(String value) {
            addCriterion("CLASSIFICATION >", value, "classification");
            return this;
        }

        public Criteria andClassificationGreaterThanOrEqualTo(String value) {
            addCriterion("CLASSIFICATION >=", value, "classification");
            return this;
        }

        public Criteria andClassificationLessThan(String value) {
            addCriterion("CLASSIFICATION <", value, "classification");
            return this;
        }

        public Criteria andClassificationLessThanOrEqualTo(String value) {
            addCriterion("CLASSIFICATION <=", value, "classification");
            return this;
        }

        public Criteria andClassificationLike(String value) {
            addCriterion("CLASSIFICATION like", value, "classification");
            return this;
        }

        public Criteria andClassificationNotLike(String value) {
            addCriterion("CLASSIFICATION not like", value, "classification");
            return this;
        }

        public Criteria andClassificationIn(List<String> values) {
            addCriterion("CLASSIFICATION in", values, "classification");
            return this;
        }

        public Criteria andClassificationNotIn(List<String> values) {
            addCriterion("CLASSIFICATION not in", values, "classification");
            return this;
        }

        public Criteria andClassificationBetween(String value1, String value2) {
            addCriterion("CLASSIFICATION between", value1, value2, "classification");
            return this;
        }

        public Criteria andClassificationNotBetween(String value1, String value2) {
            addCriterion("CLASSIFICATION not between", value1, value2, "classification");
            return this;
        }

        public Criteria andAgeLevelIsNull() {
            criteriaWithoutValue.add("AGE_LEVEL is null");
            return this;
        }

        public Criteria andAgeLevelIsNotNull() {
            criteriaWithoutValue.add("AGE_LEVEL is not null");
            return this;
        }

        public Criteria andAgeLevelEqualTo(String value) {
            addCriterion("AGE_LEVEL =", value, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelNotEqualTo(String value) {
            addCriterion("AGE_LEVEL <>", value, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelGreaterThan(String value) {
            addCriterion("AGE_LEVEL >", value, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelGreaterThanOrEqualTo(String value) {
            addCriterion("AGE_LEVEL >=", value, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelLessThan(String value) {
            addCriterion("AGE_LEVEL <", value, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelLessThanOrEqualTo(String value) {
            addCriterion("AGE_LEVEL <=", value, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelLike(String value) {
            addCriterion("AGE_LEVEL like", value, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelNotLike(String value) {
            addCriterion("AGE_LEVEL not like", value, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelIn(List<String> values) {
            addCriterion("AGE_LEVEL in", values, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelNotIn(List<String> values) {
            addCriterion("AGE_LEVEL not in", values, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelBetween(String value1, String value2) {
            addCriterion("AGE_LEVEL between", value1, value2, "ageLevel");
            return this;
        }

        public Criteria andAgeLevelNotBetween(String value1, String value2) {
            addCriterion("AGE_LEVEL not between", value1, value2, "ageLevel");
            return this;
        }

        public Criteria andCopyrightIsNull() {
            criteriaWithoutValue.add("COPYRIGHT is null");
            return this;
        }

        public Criteria andCopyrightIsNotNull() {
            criteriaWithoutValue.add("COPYRIGHT is not null");
            return this;
        }

        public Criteria andCopyrightEqualTo(Integer value) {
            addCriterion("COPYRIGHT =", value, "copyright");
            return this;
        }

        public Criteria andCopyrightNotEqualTo(Integer value) {
            addCriterion("COPYRIGHT <>", value, "copyright");
            return this;
        }

        public Criteria andCopyrightGreaterThan(Integer value) {
            addCriterion("COPYRIGHT >", value, "copyright");
            return this;
        }

        public Criteria andCopyrightGreaterThanOrEqualTo(Integer value) {
            addCriterion("COPYRIGHT >=", value, "copyright");
            return this;
        }

        public Criteria andCopyrightLessThan(Integer value) {
            addCriterion("COPYRIGHT <", value, "copyright");
            return this;
        }

        public Criteria andCopyrightLessThanOrEqualTo(Integer value) {
            addCriterion("COPYRIGHT <=", value, "copyright");
            return this;
        }

        public Criteria andCopyrightIn(List<Integer> values) {
            addCriterion("COPYRIGHT in", values, "copyright");
            return this;
        }

        public Criteria andCopyrightNotIn(List<Integer> values) {
            addCriterion("COPYRIGHT not in", values, "copyright");
            return this;
        }

        public Criteria andCopyrightBetween(Integer value1, Integer value2) {
            addCriterion("COPYRIGHT between", value1, value2, "copyright");
            return this;
        }

        public Criteria andCopyrightNotBetween(Integer value1, Integer value2) {
            addCriterion("COPYRIGHT not between", value1, value2, "copyright");
            return this;
        }

        public Criteria andEditionIsNull() {
            criteriaWithoutValue.add("EDITION is null");
            return this;
        }

        public Criteria andEditionIsNotNull() {
            criteriaWithoutValue.add("EDITION is not null");
            return this;
        }

        public Criteria andEditionEqualTo(Integer value) {
            addCriterion("EDITION =", value, "edition");
            return this;
        }

        public Criteria andEditionNotEqualTo(Integer value) {
            addCriterion("EDITION <>", value, "edition");
            return this;
        }

        public Criteria andEditionGreaterThan(Integer value) {
            addCriterion("EDITION >", value, "edition");
            return this;
        }

        public Criteria andEditionGreaterThanOrEqualTo(Integer value) {
            addCriterion("EDITION >=", value, "edition");
            return this;
        }

        public Criteria andEditionLessThan(Integer value) {
            addCriterion("EDITION <", value, "edition");
            return this;
        }

        public Criteria andEditionLessThanOrEqualTo(Integer value) {
            addCriterion("EDITION <=", value, "edition");
            return this;
        }

        public Criteria andEditionIn(List<Integer> values) {
            addCriterion("EDITION in", values, "edition");
            return this;
        }

        public Criteria andEditionNotIn(List<Integer> values) {
            addCriterion("EDITION not in", values, "edition");
            return this;
        }

        public Criteria andEditionBetween(Integer value1, Integer value2) {
            addCriterion("EDITION between", value1, value2, "edition");
            return this;
        }

        public Criteria andEditionNotBetween(Integer value1, Integer value2) {
            addCriterion("EDITION not between", value1, value2, "edition");
            return this;
        }

        public Criteria andNoCopiesIsNull() {
            criteriaWithoutValue.add("NO_COPIES is null");
            return this;
        }

        public Criteria andNoCopiesIsNotNull() {
            criteriaWithoutValue.add("NO_COPIES is not null");
            return this;
        }

        public Criteria andNoCopiesEqualTo(Integer value) {
            addCriterion("NO_COPIES =", value, "noCopies");
            return this;
        }

        public Criteria andNoCopiesNotEqualTo(Integer value) {
            addCriterion("NO_COPIES <>", value, "noCopies");
            return this;
        }

        public Criteria andNoCopiesGreaterThan(Integer value) {
            addCriterion("NO_COPIES >", value, "noCopies");
            return this;
        }

        public Criteria andNoCopiesGreaterThanOrEqualTo(Integer value) {
            addCriterion("NO_COPIES >=", value, "noCopies");
            return this;
        }

        public Criteria andNoCopiesLessThan(Integer value) {
            addCriterion("NO_COPIES <", value, "noCopies");
            return this;
        }

        public Criteria andNoCopiesLessThanOrEqualTo(Integer value) {
            addCriterion("NO_COPIES <=", value, "noCopies");
            return this;
        }

        public Criteria andNoCopiesIn(List<Integer> values) {
            addCriterion("NO_COPIES in", values, "noCopies");
            return this;
        }

        public Criteria andNoCopiesNotIn(List<Integer> values) {
            addCriterion("NO_COPIES not in", values, "noCopies");
            return this;
        }

        public Criteria andNoCopiesBetween(Integer value1, Integer value2) {
            addCriterion("NO_COPIES between", value1, value2, "noCopies");
            return this;
        }

        public Criteria andNoCopiesNotBetween(Integer value1, Integer value2) {
            addCriterion("NO_COPIES not between", value1, value2, "noCopies");
            return this;
        }

        public Criteria andAwardsIsNull() {
            criteriaWithoutValue.add("AWARDS is null");
            return this;
        }

        public Criteria andAwardsIsNotNull() {
            criteriaWithoutValue.add("AWARDS is not null");
            return this;
        }

        public Criteria andAwardsEqualTo(String value) {
            addCriterion("AWARDS =", value, "awards");
            return this;
        }

        public Criteria andAwardsNotEqualTo(String value) {
            addCriterion("AWARDS <>", value, "awards");
            return this;
        }

        public Criteria andAwardsGreaterThan(String value) {
            addCriterion("AWARDS >", value, "awards");
            return this;
        }

        public Criteria andAwardsGreaterThanOrEqualTo(String value) {
            addCriterion("AWARDS >=", value, "awards");
            return this;
        }

        public Criteria andAwardsLessThan(String value) {
            addCriterion("AWARDS <", value, "awards");
            return this;
        }

        public Criteria andAwardsLessThanOrEqualTo(String value) {
            addCriterion("AWARDS <=", value, "awards");
            return this;
        }

        public Criteria andAwardsLike(String value) {
            addCriterion("AWARDS like", value, "awards");
            return this;
        }

        public Criteria andAwardsNotLike(String value) {
            addCriterion("AWARDS not like", value, "awards");
            return this;
        }

        public Criteria andAwardsIn(List<String> values) {
            addCriterion("AWARDS in", values, "awards");
            return this;
        }

        public Criteria andAwardsNotIn(List<String> values) {
            addCriterion("AWARDS not in", values, "awards");
            return this;
        }

        public Criteria andAwardsBetween(String value1, String value2) {
            addCriterion("AWARDS between", value1, value2, "awards");
            return this;
        }

        public Criteria andAwardsNotBetween(String value1, String value2) {
            addCriterion("AWARDS not between", value1, value2, "awards");
            return this;
        }

        public Criteria andLanguageIsNull() {
            criteriaWithoutValue.add("LANGUAGE is null");
            return this;
        }

        public Criteria andLanguageIsNotNull() {
            criteriaWithoutValue.add("LANGUAGE is not null");
            return this;
        }

        public Criteria andLanguageEqualTo(String value) {
            addCriterion("LANGUAGE =", value, "language");
            return this;
        }

        public Criteria andLanguageNotEqualTo(String value) {
            addCriterion("LANGUAGE <>", value, "language");
            return this;
        }

        public Criteria andLanguageGreaterThan(String value) {
            addCriterion("LANGUAGE >", value, "language");
            return this;
        }

        public Criteria andLanguageGreaterThanOrEqualTo(String value) {
            addCriterion("LANGUAGE >=", value, "language");
            return this;
        }

        public Criteria andLanguageLessThan(String value) {
            addCriterion("LANGUAGE <", value, "language");
            return this;
        }

        public Criteria andLanguageLessThanOrEqualTo(String value) {
            addCriterion("LANGUAGE <=", value, "language");
            return this;
        }

        public Criteria andLanguageLike(String value) {
            addCriterion("LANGUAGE like", value, "language");
            return this;
        }

        public Criteria andLanguageNotLike(String value) {
            addCriterion("LANGUAGE not like", value, "language");
            return this;
        }

        public Criteria andLanguageIn(List<String> values) {
            addCriterion("LANGUAGE in", values, "language");
            return this;
        }

        public Criteria andLanguageNotIn(List<String> values) {
            addCriterion("LANGUAGE not in", values, "language");
            return this;
        }

        public Criteria andLanguageBetween(String value1, String value2) {
            addCriterion("LANGUAGE between", value1, value2, "language");
            return this;
        }

        public Criteria andLanguageNotBetween(String value1, String value2) {
            addCriterion("LANGUAGE not between", value1, value2, "language");
            return this;
        }

        public Criteria andBkconditionIsNull() {
            criteriaWithoutValue.add("BKCONDITION is null");
            return this;
        }

        public Criteria andBkconditionIsNotNull() {
            criteriaWithoutValue.add("BKCONDITION is not null");
            return this;
        }

        public Criteria andBkconditionEqualTo(String value) {
            addCriterion("BKCONDITION =", value, "bkcondition");
            return this;
        }

        public Criteria andBkconditionNotEqualTo(String value) {
            addCriterion("BKCONDITION <>", value, "bkcondition");
            return this;
        }

        public Criteria andBkconditionGreaterThan(String value) {
            addCriterion("BKCONDITION >", value, "bkcondition");
            return this;
        }

        public Criteria andBkconditionGreaterThanOrEqualTo(String value) {
            addCriterion("BKCONDITION >=", value, "bkcondition");
            return this;
        }

        public Criteria andBkconditionLessThan(String value) {
            addCriterion("BKCONDITION <", value, "bkcondition");
            return this;
        }

        public Criteria andBkconditionLessThanOrEqualTo(String value) {
            addCriterion("BKCONDITION <=", value, "bkcondition");
            return this;
        }

        public Criteria andBkconditionLike(String value) {
            addCriterion("BKCONDITION like", value, "bkcondition");
            return this;
        }

        public Criteria andBkconditionNotLike(String value) {
            addCriterion("BKCONDITION not like", value, "bkcondition");
            return this;
        }

        public Criteria andBkconditionIn(List<String> values) {
            addCriterion("BKCONDITION in", values, "bkcondition");
            return this;
        }

        public Criteria andBkconditionNotIn(List<String> values) {
            addCriterion("BKCONDITION not in", values, "bkcondition");
            return this;
        }

        public Criteria andBkconditionBetween(String value1, String value2) {
            addCriterion("BKCONDITION between", value1, value2, "bkcondition");
            return this;
        }

        public Criteria andBkconditionNotBetween(String value1, String value2) {
            addCriterion("BKCONDITION not between", value1, value2, "bkcondition");
            return this;
        }

        public Criteria andSignedIsNull() {
            criteriaWithoutValue.add("SIGNED is null");
            return this;
        }

        public Criteria andSignedIsNotNull() {
            criteriaWithoutValue.add("SIGNED is not null");
            return this;
        }

        public Criteria andSignedEqualTo(Boolean value) {
            addCriterion("SIGNED =", value, "signed");
            return this;
        }

        public Criteria andSignedNotEqualTo(Boolean value) {
            addCriterion("SIGNED <>", value, "signed");
            return this;
        }

        public Criteria andSignedGreaterThan(Boolean value) {
            addCriterion("SIGNED >", value, "signed");
            return this;
        }

        public Criteria andSignedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("SIGNED >=", value, "signed");
            return this;
        }

        public Criteria andSignedLessThan(Boolean value) {
            addCriterion("SIGNED <", value, "signed");
            return this;
        }

        public Criteria andSignedLessThanOrEqualTo(Boolean value) {
            addCriterion("SIGNED <=", value, "signed");
            return this;
        }

        public Criteria andSignedIn(List<Boolean> values) {
            addCriterion("SIGNED in", values, "signed");
            return this;
        }

        public Criteria andSignedNotIn(List<Boolean> values) {
            addCriterion("SIGNED not in", values, "signed");
            return this;
        }

        public Criteria andSignedBetween(Boolean value1, Boolean value2) {
            addCriterion("SIGNED between", value1, value2, "signed");
            return this;
        }

        public Criteria andSignedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("SIGNED not between", value1, value2, "signed");
            return this;
        }

        public Criteria andAntiqueIsNull() {
            criteriaWithoutValue.add("ANTIQUE is null");
            return this;
        }

        public Criteria andAntiqueIsNotNull() {
            criteriaWithoutValue.add("ANTIQUE is not null");
            return this;
        }

        public Criteria andAntiqueEqualTo(Boolean value) {
            addCriterion("ANTIQUE =", value, "antique");
            return this;
        }

        public Criteria andAntiqueNotEqualTo(Boolean value) {
            addCriterion("ANTIQUE <>", value, "antique");
            return this;
        }

        public Criteria andAntiqueGreaterThan(Boolean value) {
            addCriterion("ANTIQUE >", value, "antique");
            return this;
        }

        public Criteria andAntiqueGreaterThanOrEqualTo(Boolean value) {
            addCriterion("ANTIQUE >=", value, "antique");
            return this;
        }

        public Criteria andAntiqueLessThan(Boolean value) {
            addCriterion("ANTIQUE <", value, "antique");
            return this;
        }

        public Criteria andAntiqueLessThanOrEqualTo(Boolean value) {
            addCriterion("ANTIQUE <=", value, "antique");
            return this;
        }

        public Criteria andAntiqueIn(List<Boolean> values) {
            addCriterion("ANTIQUE in", values, "antique");
            return this;
        }

        public Criteria andAntiqueNotIn(List<Boolean> values) {
            addCriterion("ANTIQUE not in", values, "antique");
            return this;
        }

        public Criteria andAntiqueBetween(Boolean value1, Boolean value2) {
            addCriterion("ANTIQUE between", value1, value2, "antique");
            return this;
        }

        public Criteria andAntiqueNotBetween(Boolean value1, Boolean value2) {
            addCriterion("ANTIQUE not between", value1, value2, "antique");
            return this;
        }

        public Criteria andLoanedIsNull() {
            criteriaWithoutValue.add("LOANED is null");
            return this;
        }

        public Criteria andLoanedIsNotNull() {
            criteriaWithoutValue.add("LOANED is not null");
            return this;
        }

        public Criteria andLoanedEqualTo(Boolean value) {
            addCriterion("LOANED =", value, "loaned");
            return this;
        }

        public Criteria andLoanedNotEqualTo(Boolean value) {
            addCriterion("LOANED <>", value, "loaned");
            return this;
        }

        public Criteria andLoanedGreaterThan(Boolean value) {
            addCriterion("LOANED >", value, "loaned");
            return this;
        }

        public Criteria andLoanedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("LOANED >=", value, "loaned");
            return this;
        }

        public Criteria andLoanedLessThan(Boolean value) {
            addCriterion("LOANED <", value, "loaned");
            return this;
        }

        public Criteria andLoanedLessThanOrEqualTo(Boolean value) {
            addCriterion("LOANED <=", value, "loaned");
            return this;
        }

        public Criteria andLoanedIn(List<Boolean> values) {
            addCriterion("LOANED in", values, "loaned");
            return this;
        }

        public Criteria andLoanedNotIn(List<Boolean> values) {
            addCriterion("LOANED not in", values, "loaned");
            return this;
        }

        public Criteria andLoanedBetween(Boolean value1, Boolean value2) {
            addCriterion("LOANED between", value1, value2, "loaned");
            return this;
        }

        public Criteria andLoanedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("LOANED not between", value1, value2, "loaned");
            return this;
        }

        public Criteria andLnnameIsNull() {
            criteriaWithoutValue.add("LNNAME is null");
            return this;
        }

        public Criteria andLnnameIsNotNull() {
            criteriaWithoutValue.add("LNNAME is not null");
            return this;
        }

        public Criteria andLnnameEqualTo(String value) {
            addCriterion("LNNAME =", value, "lnname");
            return this;
        }

        public Criteria andLnnameNotEqualTo(String value) {
            addCriterion("LNNAME <>", value, "lnname");
            return this;
        }

        public Criteria andLnnameGreaterThan(String value) {
            addCriterion("LNNAME >", value, "lnname");
            return this;
        }

        public Criteria andLnnameGreaterThanOrEqualTo(String value) {
            addCriterion("LNNAME >=", value, "lnname");
            return this;
        }

        public Criteria andLnnameLessThan(String value) {
            addCriterion("LNNAME <", value, "lnname");
            return this;
        }

        public Criteria andLnnameLessThanOrEqualTo(String value) {
            addCriterion("LNNAME <=", value, "lnname");
            return this;
        }

        public Criteria andLnnameLike(String value) {
            addCriterion("LNNAME like", value, "lnname");
            return this;
        }

        public Criteria andLnnameNotLike(String value) {
            addCriterion("LNNAME not like", value, "lnname");
            return this;
        }

        public Criteria andLnnameIn(List<String> values) {
            addCriterion("LNNAME in", values, "lnname");
            return this;
        }

        public Criteria andLnnameNotIn(List<String> values) {
            addCriterion("LNNAME not in", values, "lnname");
            return this;
        }

        public Criteria andLnnameBetween(String value1, String value2) {
            addCriterion("LNNAME between", value1, value2, "lnname");
            return this;
        }

        public Criteria andLnnameNotBetween(String value1, String value2) {
            addCriterion("LNNAME not between", value1, value2, "lnname");
            return this;
        }

        public Criteria andLndateIsNull() {
            criteriaWithoutValue.add("LNDATE is null");
            return this;
        }

        public Criteria andLndateIsNotNull() {
            criteriaWithoutValue.add("LNDATE is not null");
            return this;
        }

        public Criteria andLndateEqualTo(Date value) {
            addCriterionForJDBCDate("LNDATE =", value, "lndate");
            return this;
        }

        public Criteria andLndateNotEqualTo(Date value) {
            addCriterionForJDBCDate("LNDATE <>", value, "lndate");
            return this;
        }

        public Criteria andLndateGreaterThan(Date value) {
            addCriterionForJDBCDate("LNDATE >", value, "lndate");
            return this;
        }

        public Criteria andLndateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("LNDATE >=", value, "lndate");
            return this;
        }

        public Criteria andLndateLessThan(Date value) {
            addCriterionForJDBCDate("LNDATE <", value, "lndate");
            return this;
        }

        public Criteria andLndateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("LNDATE <=", value, "lndate");
            return this;
        }

        public Criteria andLndateIn(List<Date> values) {
            addCriterionForJDBCDate("LNDATE in", values, "lndate");
            return this;
        }

        public Criteria andLndateNotIn(List<Date> values) {
            addCriterionForJDBCDate("LNDATE not in", values, "lndate");
            return this;
        }

        public Criteria andLndateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("LNDATE between", value1, value2, "lndate");
            return this;
        }

        public Criteria andLndateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("LNDATE not between", value1, value2, "lndate");
            return this;
        }
    }
}
--------------040003050808040009030406
Content-Type: text/plain;
 name="Library.java"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="Library.java"

/*
 * Library.java
 *
 * Created on August 1, 2006, 10:24 PM
 *
 * Library - Utility class representing the full library.
 * Will contain the iBATIS mapping connection to the database.
 * Will include methods for searching, inserting, updating, deleting.
 */

package com.jpprater.libutils;

import com.ibatis.common.resources.*;
import com.ibatis.sqlmap.client.*;
import java.io.*;
import java.util.*;


/**
 *
 * @author Jonathan.Prater
 */
public class Library {
    
    private SqlMapClient mySQLMap;
    private List lastSearchResults;
    private BookExample lastSearch;
    private BookKey lastID;
    private Book lastCall;
    
    /** Creates a new instance of Library */
    public Library(String configname) {
         try {
             Properties theprops = Resources.getUrlAsProperties("file:./cfg/" + configname + ".props");
             Reader thereader = Resources.getResourceAsReader("com/jpprater/libutils/SQLMapConfig.xml");
             mySQLMap = SqlMapClientBuilder.buildSqlMapClient(thereader, theprops);
         } catch (java.lang.Exception e) {
             // if the attempt to load fails, blow up hard and display exception information
             mySQLMap = null;
             e.printStackTrace();
             throw new RuntimeException("error initializing Library class.  Cause:  " + e);
         }
     }
    
    public List search(BookExample searchClass) {
        try {
            lastSearchResults = mySQLMap.queryForList("abatorgenerated_selectByExample", searchClass);
            lastSearch = searchClass;
        } catch (java.lang.Exception e) {
            lastSearchResults = null;
            e.printStackTrace();
        }
        return lastSearchResults;
    }
    
    public Book searchByID(BookKey searchClass) {
        try {
            lastCall = (Book) mySQLMap.queryForObject("abatorgenerated_selectByPrimaryKey", searchClass);
            lastID = searchClass;
        } catch (java.lang.Exception e) {
            lastCall = null;
            e.printStackTrace();
        }
        return lastCall;
    }
    
    public void insert(Book newBook) {
        try {
            @SuppressWarnings("unused")
			int i = (Integer) mySQLMap.insert("abatorgenerated_insert", newBook);
        } catch (java.lang.Exception e) {
            e.printStackTrace();
        }
    }
    
    public void update(Book newData) {
        try {
            @SuppressWarnings("unused")
			int i = mySQLMap.update("abatorgenerated_update", newData);
        } catch (java.lang.Exception e) {
            e.printStackTrace();
        }
    }
    
    public void delete(BookKey delKey) {
        try {
            @SuppressWarnings("unused")
			int i = mySQLMap.delete("abatorgenerated_deleteByPrimaryKey", delKey);
        } catch (java.lang.Exception e) {
            e.printStackTrace();
        }
    }

    public List getLastSearchResults() {
        return lastSearchResults;
    }

    public BookExample getLastSearch() {
        return lastSearch;
    }

    public BookKey getLastID() {
        return lastID;
    }

    public Book getLastCall() {
        return lastCall;
    }
    
    
    
}

--------------040003050808040009030406
Content-Type: text/xml;
 name="PUBLIC_BKCATALOG_SqlMap.xml"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="PUBLIC_BKCATALOG_SqlMap.xml"

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="PUBLIC_BKCATALOG" >
  <resultMap id="abatorgenerated_BkcatalogResult" class="com.jpprater.libutils.Book" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    <result column="ID" property="id" jdbcType="INTEGER" />
    <result column="ISBN" property="isbn" jdbcType="VARCHAR" />
    <result column="AUTHOR" property="author" jdbcType="VARCHAR" />
    <result column="TITLE" property="title" jdbcType="VARCHAR" />
    <result column="ILLUSTRATOR" property="illustrator" jdbcType="VARCHAR" />
    <result column="SERIES" property="series" jdbcType="VARCHAR" />
    <result column="GENRE" property="genre" jdbcType="VARCHAR" />
    <result column="CLASSIFICATION" property="classification" jdbcType="VARCHAR" />
    <result column="AGE_LEVEL" property="ageLevel" jdbcType="VARCHAR" />
    <result column="COPYRIGHT" property="copyright" jdbcType="INTEGER" />
    <result column="EDITION" property="edition" jdbcType="INTEGER" />
    <result column="NO_COPIES" property="noCopies" jdbcType="INTEGER" />
    <result column="AWARDS" property="awards" jdbcType="VARCHAR" />
    <result column="LANGUAGE" property="language" jdbcType="VARCHAR" />
    <result column="BKCONDITION" property="bkcondition" jdbcType="VARCHAR" />
    <result column="SIGNED" property="signed" jdbcType="BOOLEAN" />
    <result column="ANTIQUE" property="antique" jdbcType="BOOLEAN" />
    <result column="LOANED" property="loaned" jdbcType="BOOLEAN" />
    <result column="LNNAME" property="lnname" jdbcType="VARCHAR" />
    <result column="LNDATE" property="lndate" jdbcType="DATE" />
  </resultMap>
  <sql id="abatorgenerated_Example_Where_Clause" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    <iterate property="oredCriteria" conjunction="or" prepend="where" removeFirstPrepend="iterate" >
      (
      <iterate prepend="and" property="oredCriteria[].criteriaWithoutValue" conjunction="and" >
        $oredCriteria[].criteriaWithoutValue[]$
      </iterate>
      <iterate prepend="and" property="oredCriteria[].criteriaWithSingleValue" conjunction="and" >
        $oredCriteria[].criteriaWithSingleValue[].condition$
          #oredCriteria[].criteriaWithSingleValue[].value#
      </iterate>
      <iterate prepend="and" property="oredCriteria[].criteriaWithListValue" conjunction="and" >
        $oredCriteria[].criteriaWithListValue[].condition$
        <iterate property="oredCriteria[].criteriaWithListValue[].values" open="(" close=")" conjunction="," >
          #oredCriteria[].criteriaWithListValue[].values[]#
        </iterate>
      </iterate>
      <iterate prepend="and" property="oredCriteria[].criteriaWithBetweenValue" conjunction="and" >
        $oredCriteria[].criteriaWithBetweenValue[].condition$
        #oredCriteria[].criteriaWithBetweenValue[].values[0]# and
        #oredCriteria[].criteriaWithBetweenValue[].values[1]#
      </iterate>
      )
    </iterate>
  </sql>
  <select id="abatorgenerated_selectByPrimaryKey" resultMap="abatorgenerated_BkcatalogResult" parameterClass="com.jpprater.libutils.BookKey" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    select ID, ISBN, AUTHOR, TITLE, ILLUSTRATOR, SERIES, GENRE, CLASSIFICATION, AGE_LEVEL,
      COPYRIGHT, EDITION, NO_COPIES, AWARDS, LANGUAGE, BKCONDITION, SIGNED, ANTIQUE, LOANED, LNNAME,
      LNDATE
    from PUBLIC.BKCATALOG
    where ID = #id:INTEGER#
  </select>
  <select id="abatorgenerated_selectByExample" resultMap="abatorgenerated_BkcatalogResult" parameterClass="com.jpprater.libutils.BookExample" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    select ID, ISBN, AUTHOR, TITLE, ILLUSTRATOR, SERIES, GENRE, CLASSIFICATION, AGE_LEVEL,
      COPYRIGHT, EDITION, NO_COPIES, AWARDS, LANGUAGE, BKCONDITION, SIGNED, ANTIQUE, LOANED, LNNAME,
      LNDATE
    from PUBLIC.BKCATALOG
    <isParameterPresent >
      <include refid="abatorgenerated_Example_Where_Clause" />
      <isNotNull property="orderByClause" >
        order by $orderByClause$
      </isNotNull>
    </isParameterPresent>
  </select>
  <delete id="abatorgenerated_deleteByPrimaryKey" parameterClass="com.jpprater.libutils.BookKey" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    delete from PUBLIC.BKCATALOG
    where ID = #id:INTEGER#
  </delete>
  <delete id="abatorgenerated_deleteByExample" parameterClass="com.jpprater.libutils.BookExample" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    delete from PUBLIC.BKCATALOG
    <include refid="abatorgenerated_Example_Where_Clause" />
  </delete>
  <insert id="abatorgenerated_insert" parameterClass="com.jpprater.libutils.Book" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    insert into PUBLIC.BKCATALOG (ISBN, AUTHOR, TITLE, ILLUSTRATOR, SERIES, GENRE, CLASSIFICATION,
      AGE_LEVEL, COPYRIGHT, EDITION, NO_COPIES, AWARDS, LANGUAGE, BKCONDITION, SIGNED, ANTIQUE,
      LOANED, LNNAME, LNDATE)
    values (#isbn:VARCHAR#, #author:VARCHAR#, #title:VARCHAR#, #illustrator:VARCHAR#,
      #series:VARCHAR#, #genre:VARCHAR#, #classification:VARCHAR#, #ageLevel:VARCHAR#,
      #copyright:INTEGER#, #edition:INTEGER#, #noCopies:INTEGER#, #awards:VARCHAR#,
      #language:VARCHAR#, #bkcondition:VARCHAR#, #signed:BOOLEAN#, #antique:BOOLEAN#,
      #loaned:BOOLEAN#, #lnname:VARCHAR#, #lndate:DATE#)
    <selectKey resultClass="java.lang.Integer" keyProperty="id" >
      CALL IDENTITY()
    </selectKey>
  </insert>
  <update id="abatorgenerated_updateByPrimaryKey" parameterClass="com.jpprater.libutils.Book" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    update PUBLIC.BKCATALOG
    set ISBN = #isbn:VARCHAR#,
      AUTHOR = #author:VARCHAR#,
      TITLE = #title:VARCHAR#,
      ILLUSTRATOR = #illustrator:VARCHAR#,
      SERIES = #series:VARCHAR#,
      GENRE = #genre:VARCHAR#,
      CLASSIFICATION = #classification:VARCHAR#,
      AGE_LEVEL = #ageLevel:VARCHAR#,
      COPYRIGHT = #copyright:INTEGER#,
      EDITION = #edition:INTEGER#,
      NO_COPIES = #noCopies:INTEGER#,
      AWARDS = #awards:VARCHAR#,
      LANGUAGE = #language:VARCHAR#,
      BKCONDITION = #bkcondition:VARCHAR#,
      SIGNED = #signed:BOOLEAN#,
      ANTIQUE = #antique:BOOLEAN#,
      LOANED = #loaned:BOOLEAN#,
      LNNAME = #lnname:VARCHAR#,
      LNDATE = #lndate:DATE#
    where ID = #id:INTEGER#
  </update>
  <update id="abatorgenerated_updateByPrimaryKeySelective" parameterClass="com.jpprater.libutils.Book" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri Apr 06 06:48:10 EDT 2007.
    -->
    update PUBLIC.BKCATALOG
    <dynamic prepend="set" >
      <isNotNull prepend="," property="isbn" >
        ISBN = #isbn:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="author" >
        AUTHOR = #author:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="title" >
        TITLE = #title:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="illustrator" >
        ILLUSTRATOR = #illustrator:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="series" >
        SERIES = #series:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="genre" >
        GENRE = #genre:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="classification" >
        CLASSIFICATION = #classification:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="ageLevel" >
        AGE_LEVEL = #ageLevel:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="copyright" >
        COPYRIGHT = #copyright:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="edition" >
        EDITION = #edition:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="noCopies" >
        NO_COPIES = #noCopies:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="awards" >
        AWARDS = #awards:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="language" >
        LANGUAGE = #language:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="bkcondition" >
        BKCONDITION = #bkcondition:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="signed" >
        SIGNED = #signed:BOOLEAN#
      </isNotNull>
      <isNotNull prepend="," property="antique" >
        ANTIQUE = #antique:BOOLEAN#
      </isNotNull>
      <isNotNull prepend="," property="loaned" >
        LOANED = #loaned:BOOLEAN#
      </isNotNull>
      <isNotNull prepend="," property="lnname" >
        LNNAME = #lnname:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="lndate" >
        LNDATE = #lndate:DATE#
      </isNotNull>
    </dynamic>
    where ID = #id#
  </update>
</sqlMap>
--------------040003050808040009030406--