/******************************************************************************

  * VirginsDaoJdbc.java - Implement the Dao interface for the Virgins

  * 

  * PicMan - The BuckoSoft Picture Manager in Java

  * Copyright(c) 2005 - Dick Balaska

  * 

  */

 package com.buckosoft.PicMan.db;

 import java.util.List;

 import javax.sql.DataSource;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 import java.sql.Types;

 import org.apache.commons.logging.Log;

 import org.apache.commons.logging.LogFactory;

 import org.springframework.dao.DataAccessException;

 import org.springframework.jdbc.core.SqlParameter;

 import org.springframework.jdbc.object.SqlFunction;

 import org.springframework.jdbc.object.SqlUpdate;

 import org.springframework.jdbc.object.MappingSqlQuery;

 import com.buckosoft.PicMan.domain.Virgin;

 /** Implement the Dao Interface for the {@link com.buckosoft.PicMan.domain.Virgin}s.

  * @author Dick Balaska

  * @since 2005/07/31

  * @see <a href="http://cvs.buckosoft.com/Projects/java/PicMan/PicMan/src/com/buckosoft/PicMan/db/VirginsDaoJdbc.java">VirginsDaoJdbc.java</a>

  */

 public class VirginsDaoJdbc implements VirginsDao {

         private final static boolean DEBUG = false;

         private final static boolean DEBUGCONNECTIONLEAK = false;

         protected final Log logger = LogFactory.getLog(getClass());

 //        private        PicManFacade        pmf;

         private DataSource ds;

         /** Set the reference to the JDBC datasource.

          * @param ds The datasource as configured by Spring.

          * @see <a href="http://cvs.buckosoft.com/Projects/java/PicMan/PicMan/WebContent/WEB-INF/picManDatabase/picManDatabase.xml">picManDatabase.xml</a>

          */ 

         public void setDataSource(DataSource ds) {

                 this.ds = ds;

         }

         /** Get the list of Virgins, the Pics that haven't been filtered yet.

          * @return The List

          */

         @SuppressWarnings("unchecked")

         public List<Virgin> getVirgins() throws DataAccessException {

                 if (DEBUG)

                         logger.info("Getting Virgins");

                 VirginsQuery vq = new VirginsQuery(ds);

                 return(vq.execute());

         }

         /* (non-Javadoc)

          * @see com.buckosoft.PicMan.db.VirginsDao#getVirgins(int)

          */

         @SuppressWarnings("unchecked")

         public List<Virgin> getVirgins(int max) throws DataAccessException {

                 if (DEBUG)

                         logger.info("Getting Virgins(" + max + ")");

                 VirginsQuery vq = new VirginsQuery(ds, max);

                 return(vq.execute(max));

         }

         /* (non-Javadoc)

          * @see com.buckosoft.PicMan.db.VirginsDao#isVirgin(java.lang.String)

          */

         public boolean isVirgin(String picName) {

                 VirginsQuery vq = new VirginsQuery(ds, picName);

                 Virgin v = (Virgin)vq.findObject(picName);

                 if (DEBUG)

                         logger.info("IsVirgin: " + picName + ": " + v != null ? "true" : "false");

                 return(v != null ? true : false);

         }

         /** Add a pic to the Virgin database

          * @param picName The name of the pic to add

          */

         public void        addVirgin(String picName) throws DataAccessException {

                 if (DEBUG)

                         logger.info("addVirgin: " + picName);

                 VirginInsert vi = new VirginInsert(ds);

                 Virgin v = new Virgin();

                 v.setName(picName);

                 vi.insert(v);

         }

         /** Delete a pic from the Virgin database

          * @param picName The name of the pic to remove

          */

         public void        deleteVirgin(String picName) throws DataAccessException {

                 if (DEBUG)

                         logger.info("deleteVirgin: " + picName);

                 VirginDelete vd = new VirginDelete(ds);

                 Virgin v = new Virgin();

                 v.setName(picName);

                 vd.delete(v);

         }

         /** Get the number of Virgins in the database

          * @return the count

          */

         public int        getVirginCount() {

                 if (DEBUG)

                         logger.info("getVirginCount:");

                 if (DEBUGCONNECTIONLEAK)

                         return(69);

                 if (sql_getVirginCountQUERYr == null)

                         sql_getVirginCountQUERYr = new VirginsCount(ds);

                 return(sql_getVirginCountQUERYr.run());

         }

         private VirginsCount        sql_getVirginCountQUERYr;

         ///////////////////////////////////////////////////////////////////////////

         class VirginsQuery extends MappingSqlQuery {

                 VirginsQuery(DataSource ds) {

                         super(ds, "SELECT * from virgins");

                         compile();

                 }

                 VirginsQuery(DataSource ds, int max) {

                         super(ds, "SELECT * from virgins LIMIT ?");

                         declareParameter(new SqlParameter(Types.INTEGER));

                         compile();

                 }

                 VirginsQuery(DataSource ds, String picName) {

                         super(ds, "SELECT * from virgins WHERE pic = ?");

                         declareParameter(new SqlParameter(Types.VARCHAR));

                         compile();

                 }

                 protected Object mapRow(ResultSet rs, int rowNum) throws SQLException {

                         Virgin v = new Virgin();

                         v.setName(rs.getString("pic"));

                         return(v);

                 }

         }

         /**

          * <code>Virgin</code> Count Object.

          */

         class VirginsCount extends SqlFunction {

                 VirginsCount(DataSource ds) {

                         super(ds, "SELECT COUNT(*) from virgins");

                         compile();

                 }                

         }

         /**

          * <code>Virgin</code> Insert Object.

          */

         protected class VirginInsert extends SqlUpdate {

                 /**

                  * Create a new instance of VirginInsert.

                  * @param ds the DataSource to use for the insert

                  */

                 protected VirginInsert(DataSource ds) {

                         super(ds, "INSERT INTO virgins VALUES(?)");

                         declareParameter(new SqlParameter(Types.VARCHAR));

                         compile();

                 }

                 protected void insert(Virgin v) {

                         Object[] objs = new Object[] {

                                         v.getName()};

                         super.update(objs);

                         // retrieveIdentity(owner);

                 }

         }

         /**

          * <code>Virgin</code> Delete Object.

          */

         protected class VirginDelete extends SqlUpdate {

                 /**

                  * Create a new instance of VirginRemove.

                  * @param ds the DataSource to use for the delete

                  */

                 protected VirginDelete(DataSource ds) {

                         super(ds, "DELETE FROM virgins WHERE pic = (?)");

                         declareParameter(new SqlParameter(Types.VARCHAR));

                         compile();

                 }

                 protected void delete(Virgin v) {

                         Object[] objs = new Object[] {

                                         v.getName()};

                         super.update(objs);

                         // retrieveIdentity(owner);

                 }

         }

 }