KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > nilostep > xlsql > sql > hsqldb > xlHsqldbSelect


1 /*
2  * xlQueryHsqldbForExcel.java
3  *
4  * Created on 9 juli 2004, 13:20
5  */
6
7 package com.nilostep.xlsql.sql.hsqldb;
8
9 import com.nilostep.xlsql.sql.xlSqlSelect;
10 import java.sql.*;
11
12 /**
13  *
14  * @author Jim Caprioli
15  */
16 public class xlHsqldbSelect extends xlSqlSelect {
17     
18     /** Creates a new instance of xlHsqldbSelect */
19     public xlHsqldbSelect(Connection con) {
20         super(con);
21     }
22     
23     public ResultSet QueryData(String JavaDoc workbook, String JavaDoc sheet)
24                                                         throws SQLException {
25         Statement s = jdbc.createStatement();
26         String JavaDoc sql;
27                 //
28 if (workbook.equalsIgnoreCase("sa")) {
29                 sql = "SELECT * FROM " + "\"" + sheet + "\"";
30             } else {
31                 sql = "SELECT * FROM " + "\"" + workbook + "." + sheet + "\"";
32             }
33         return s.executeQuery(sql);
34     }
35 }
Popular Tags