001 /**
002 * ========================================
003 * JFreeReport : a free Java report library
004 * ========================================
005 *
006 * Project Info: http://reporting.pentaho.org/
007 *
008 * (C) Copyright 2000-2007, by Object Refinery Limited, Pentaho Corporation and Contributors.
009 *
010 * This library is free software; you can redistribute it and/or modify it under the terms
011 * of the GNU Lesser General Public License as published by the Free Software Foundation;
012 * either version 2.1 of the License, or (at your option) any later version.
013 *
014 * This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
015 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
016 * See the GNU Lesser General Public License for more details.
017 *
018 * You should have received a copy of the GNU Lesser General Public License along with this
019 * library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
020 * Boston, MA 02111-1307, USA.
021 *
022 * [Java is a trademark or registered trademark of Sun Microsystems, Inc.
023 * in the United States and other countries.]
024 *
025 * ------------
026 * $Id: SQLReportDataFactory.java,v 1.5 2007/04/01 18:49:26 taqua Exp $
027 * ------------
028 * (C) Copyright 2000-2005, by Object Refinery Limited.
029 * (C) Copyright 2005-2007, by Pentaho Corporation.
030 */
031 package org.jfree.report.modules.data.sql;
032
033 import java.sql.Connection;
034 import java.util.HashMap;
035
036 import org.jfree.report.DataSet;
037 import org.jfree.report.ReportData;
038 import org.jfree.report.ReportDataFactoryException;
039
040 /**
041 * Creation-Date: 19.02.2006, 17:37:33
042 *
043 * @author Thomas Morgner
044 */
045 public class SQLReportDataFactory extends SimpleSQLReportDataFactory
046 {
047 private HashMap querymappings;
048
049 public SQLReportDataFactory(final Connection connection)
050 {
051 super(connection);
052 querymappings = new HashMap();
053 }
054
055
056 public SQLReportDataFactory(final ConnectionProvider connectionProvider)
057 {
058 super(connectionProvider);
059 querymappings = new HashMap();
060 }
061
062 public void setQuery(String name, String queryString)
063 {
064 if (queryString == null)
065 {
066 querymappings.remove(name);
067 }
068 else
069 {
070 querymappings.put(name, queryString);
071 }
072 }
073
074 /**
075 * Queries a datasource. The string 'query' defines the name of the query. The
076 * Parameterset given here may contain more data than actually needed.
077 * <p/>
078 * The dataset may change between two calls, do not assume anything!
079 *
080 * @param query
081 * @param parameters
082 * @return
083 */
084 public ReportData queryData(final String query, final DataSet parameters)
085 throws ReportDataFactoryException
086 {
087 if (query == null)
088 {
089 throw new NullPointerException("Query is null.");
090 }
091 final String realQuery = getQuery(query);
092 if (realQuery == null)
093 {
094 throw new ReportDataFactoryException("Query '" + query + "' is not recognized.");
095 }
096 return super.queryData(realQuery, parameters);
097 }
098
099 public String getQuery(String name)
100 {
101 return (String) querymappings.get(name);
102 }
103
104 public String[] getQueryNames()
105 {
106 return (String[]) querymappings.keySet().toArray(
107 new String[querymappings.size()]);
108 }
109
110 }