---

ExcelTest.java

Go to the documentation of this file.

package net.threebit.utils.sosc.test;

/*
        Copyright 2003 Shawn Deleurme
        Copyright 2003 Kevin O'Donnell

        This program is free software; you can redistribute it and/or modify
        it under the terms of the GNU General Public License as published by
        the Free Software Foundation; either version 2 of the License, or
        (at your option) any later version.

        This program is distributed in the hope that it will be useful,
        but WITHOUT ANY WARRANTY; without even the implied warranty of
        MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
        GNU General Public License for more details.

        You should have received a copy of the GNU General Public License
        along with this program; if not, write to the Free Software
        Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.logging.*;
import junit.framework.*;
import net.threebit.utils.sosc.*;

public class ExcelTest extends TestCase {

        private DbTool getDbTool() throws Exception {
                String url = System.getProperty("net.threebit.utils.sosc.DbTool.jdbcURL");
                String className = System.getProperty("net.threebit.utils.sosc.DbTool.jdbcURLClassName");
                String userName = System.getProperty("net.threebit.utils.sosc.DbTool.jdbcURLUserName");
                String password = System.getProperty("net.threebit.utils.sosc.DbTool.jdbcURLPassword");
                return new DbTool(className, url, userName, password);
        }

        public void test1() throws Exception {
                ExcelSheet es = new ExcelSheet("sheetName","title");
                es.setTitle("Test Title");
                es.drawTable("test table", getDbTool().query(" select 1 as one, 2 as two, 3 as three "), "A1");
                es.render( new FileOutputStream("/src/www/kevino/ExcelText.html"));
        }

}

---