KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > hsqlview


1 import java.io.File JavaDoc;
2 import java.io.IOException JavaDoc;
3 import java.io.*;
4 import java.sql.*;
5
6
7 public class hsqlview {
8
9    private static String JavaDoc path="../../db/hsql/hsql";
10    private static final String JavaDoc imebaze="hsql";
11
12    private static String JavaDoc username="sa";
13
14    public static void main(String JavaDoc args[]){
15
16     try{
17
18       String JavaDoc absPath=path;
19
20       Class.forName("org.hsqldb.jdbcDriver");
21       Connection conn=DriverManager.getConnection("jdbc:hsqldb:"+path,"sa","");
22
23       Statement stmt=conn.createStatement();
24       String JavaDoc[] types = {"TABLE"};
25       ResultSet rs=conn.getMetaData().getTables(imebaze,null,"%",types);
26       //kreiranje tabele
27 // int rs201=stmt.executeUpdate("create table objectid(next DECIMAL(19,0) NOT NULL);");
28
29       while ( rs.next() ){
30         ResultSet rs1=null;
31         String JavaDoc tableName=rs.getString(3);
32         System.out.println("");
33         System.out.println("Working...."+tableName);
34         if(tableName.equalsIgnoreCase("objectid")) {
35           //tableName=username+"."+tableName;
36 rs1=stmt.executeQuery("SELECT * FROM "+tableName);
37         }
38         else {
39           //tableName=username+"."+tableName;
40 rs1=stmt.executeQuery("SELECT * FROM "+tableName+" ORDER BY OID");
41         }
42
43           ResultSet rs2=conn.getMetaData().getColumns(imebaze,null,tableName,null);
44           String JavaDoc imeKolone="";
45           String JavaDoc vrednost="";
46           int brojKolone=0;
47
48             while(rs2.next()){
49               System.out.print(" "+rs2.getString(4));
50               brojKolone++;
51             }
52             System.out.println("");
53          while(rs1.next()){
54            for(int i=1;i<brojKolone+1;i++){
55               System.out.print(" "+rs1.getString(i));
56            }
57            System.out.println("");
58          }
59          System.out.println("");
60          rs1.close();
61          rs2.close();
62
63 //
64 }
65 //
66 rs.close();
67       conn.close();
68       stmt.close();
69     }catch(Exception JavaDoc e){
70       e.printStackTrace();
71     }
72   }
73
74 }
75
Popular Tags