1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski package com.sun.star.report.pentaho; 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski import com.sun.star.report.DataSource; 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski import org.jfree.report.DataSourceException; 28*b1cdbd2cSJim Jagielski import org.jfree.report.ReportData; 29*b1cdbd2cSJim Jagielski 30*b1cdbd2cSJim Jagielski public class StarReportData implements ReportData 31*b1cdbd2cSJim Jagielski { 32*b1cdbd2cSJim Jagielski 33*b1cdbd2cSJim Jagielski private final DataSource dataSource; 34*b1cdbd2cSJim Jagielski private int currentRow; 35*b1cdbd2cSJim Jagielski private final int rowCount; 36*b1cdbd2cSJim Jagielski StarReportData(final DataSource dataSource)37*b1cdbd2cSJim Jagielski public StarReportData(final DataSource dataSource) 38*b1cdbd2cSJim Jagielski throws com.sun.star.report.DataSourceException 39*b1cdbd2cSJim Jagielski { 40*b1cdbd2cSJim Jagielski if (dataSource == null) 41*b1cdbd2cSJim Jagielski { 42*b1cdbd2cSJim Jagielski throw new NullPointerException(); 43*b1cdbd2cSJim Jagielski } 44*b1cdbd2cSJim Jagielski this.dataSource = dataSource; 45*b1cdbd2cSJim Jagielski this.currentRow = 0; 46*b1cdbd2cSJim Jagielski this.rowCount = dataSource.getRowCount(); 47*b1cdbd2cSJim Jagielski } 48*b1cdbd2cSJim Jagielski setCursorPosition(final int row)49*b1cdbd2cSJim Jagielski public boolean setCursorPosition(final int row) throws DataSourceException 50*b1cdbd2cSJim Jagielski { 51*b1cdbd2cSJim Jagielski try 52*b1cdbd2cSJim Jagielski { 53*b1cdbd2cSJim Jagielski final boolean ret = dataSource.absolute(row); 54*b1cdbd2cSJim Jagielski if (ret) 55*b1cdbd2cSJim Jagielski { 56*b1cdbd2cSJim Jagielski currentRow = row; 57*b1cdbd2cSJim Jagielski } 58*b1cdbd2cSJim Jagielski return ret; 59*b1cdbd2cSJim Jagielski } 60*b1cdbd2cSJim Jagielski catch (com.sun.star.report.DataSourceException e) 61*b1cdbd2cSJim Jagielski { 62*b1cdbd2cSJim Jagielski throw new DataSourceException("Failed to move cursor", e); 63*b1cdbd2cSJim Jagielski } 64*b1cdbd2cSJim Jagielski } 65*b1cdbd2cSJim Jagielski close()66*b1cdbd2cSJim Jagielski public void close() 67*b1cdbd2cSJim Jagielski throws DataSourceException 68*b1cdbd2cSJim Jagielski { 69*b1cdbd2cSJim Jagielski try 70*b1cdbd2cSJim Jagielski { 71*b1cdbd2cSJim Jagielski dataSource.close(); 72*b1cdbd2cSJim Jagielski } 73*b1cdbd2cSJim Jagielski catch (com.sun.star.report.DataSourceException e) 74*b1cdbd2cSJim Jagielski { 75*b1cdbd2cSJim Jagielski throw new DataSourceException("Failed to close datasource", e); 76*b1cdbd2cSJim Jagielski } 77*b1cdbd2cSJim Jagielski } 78*b1cdbd2cSJim Jagielski getCursorPosition()79*b1cdbd2cSJim Jagielski public int getCursorPosition() 80*b1cdbd2cSJim Jagielski throws DataSourceException 81*b1cdbd2cSJim Jagielski { 82*b1cdbd2cSJim Jagielski return currentRow; 83*b1cdbd2cSJim Jagielski } 84*b1cdbd2cSJim Jagielski 85*b1cdbd2cSJim Jagielski /** 86*b1cdbd2cSJim Jagielski * This operation checks, whether a call to next will be likely to succeed. If 87*b1cdbd2cSJim Jagielski * there is a next data row, this should return true. 88*b1cdbd2cSJim Jagielski * 89*b1cdbd2cSJim Jagielski * @return 90*b1cdbd2cSJim Jagielski * @throws org.jfree.report.DataSourceException 91*b1cdbd2cSJim Jagielski * 92*b1cdbd2cSJim Jagielski */ isAdvanceable()93*b1cdbd2cSJim Jagielski public boolean isAdvanceable() throws DataSourceException 94*b1cdbd2cSJim Jagielski { 95*b1cdbd2cSJim Jagielski return currentRow < rowCount; 96*b1cdbd2cSJim Jagielski } 97*b1cdbd2cSJim Jagielski next()98*b1cdbd2cSJim Jagielski public boolean next() 99*b1cdbd2cSJim Jagielski throws DataSourceException 100*b1cdbd2cSJim Jagielski { 101*b1cdbd2cSJim Jagielski try 102*b1cdbd2cSJim Jagielski { 103*b1cdbd2cSJim Jagielski if (dataSource.next()) 104*b1cdbd2cSJim Jagielski { 105*b1cdbd2cSJim Jagielski currentRow += 1; 106*b1cdbd2cSJim Jagielski return true; 107*b1cdbd2cSJim Jagielski } 108*b1cdbd2cSJim Jagielski return false; 109*b1cdbd2cSJim Jagielski } 110*b1cdbd2cSJim Jagielski catch (com.sun.star.report.DataSourceException e) 111*b1cdbd2cSJim Jagielski { 112*b1cdbd2cSJim Jagielski throw new DataSourceException("Failed to move cursor", e); 113*b1cdbd2cSJim Jagielski } 114*b1cdbd2cSJim Jagielski } 115*b1cdbd2cSJim Jagielski get(final int column)116*b1cdbd2cSJim Jagielski public Object get(final int column) 117*b1cdbd2cSJim Jagielski throws DataSourceException 118*b1cdbd2cSJim Jagielski { 119*b1cdbd2cSJim Jagielski if (!isReadable()) 120*b1cdbd2cSJim Jagielski { 121*b1cdbd2cSJim Jagielski throw new DataSourceException("Failed to query column."); 122*b1cdbd2cSJim Jagielski } 123*b1cdbd2cSJim Jagielski 124*b1cdbd2cSJim Jagielski try 125*b1cdbd2cSJim Jagielski { 126*b1cdbd2cSJim Jagielski return dataSource.getObject(column + 1); 127*b1cdbd2cSJim Jagielski } 128*b1cdbd2cSJim Jagielski catch (com.sun.star.report.DataSourceException e) 129*b1cdbd2cSJim Jagielski { 130*b1cdbd2cSJim Jagielski throw new DataSourceException("Failed to query column.", e); 131*b1cdbd2cSJim Jagielski } 132*b1cdbd2cSJim Jagielski } 133*b1cdbd2cSJim Jagielski getColumnCount()134*b1cdbd2cSJim Jagielski public int getColumnCount() 135*b1cdbd2cSJim Jagielski throws DataSourceException 136*b1cdbd2cSJim Jagielski { 137*b1cdbd2cSJim Jagielski try 138*b1cdbd2cSJim Jagielski { 139*b1cdbd2cSJim Jagielski return dataSource.getColumnCount(); 140*b1cdbd2cSJim Jagielski } 141*b1cdbd2cSJim Jagielski catch (com.sun.star.report.DataSourceException e) 142*b1cdbd2cSJim Jagielski { 143*b1cdbd2cSJim Jagielski throw new DataSourceException("Failed to query column count.", e); 144*b1cdbd2cSJim Jagielski } 145*b1cdbd2cSJim Jagielski } 146*b1cdbd2cSJim Jagielski getColumnName(final int column)147*b1cdbd2cSJim Jagielski public String getColumnName(final int column) 148*b1cdbd2cSJim Jagielski throws DataSourceException 149*b1cdbd2cSJim Jagielski { 150*b1cdbd2cSJim Jagielski try 151*b1cdbd2cSJim Jagielski { 152*b1cdbd2cSJim Jagielski return dataSource.getColumnName(column + 1); 153*b1cdbd2cSJim Jagielski } 154*b1cdbd2cSJim Jagielski catch (com.sun.star.report.DataSourceException e) 155*b1cdbd2cSJim Jagielski { 156*b1cdbd2cSJim Jagielski throw new DataSourceException("Failed to query column name.", e); 157*b1cdbd2cSJim Jagielski } 158*b1cdbd2cSJim Jagielski } 159*b1cdbd2cSJim Jagielski isReadable()160*b1cdbd2cSJim Jagielski public boolean isReadable() throws DataSourceException 161*b1cdbd2cSJim Jagielski { 162*b1cdbd2cSJim Jagielski return currentRow > 0 && rowCount > 0; 163*b1cdbd2cSJim Jagielski } 164*b1cdbd2cSJim Jagielski } 165