package lj_cust;

import java.io.*;
import java.text.*;
import java.sql.*;
import oracle.jdbc.driver.*;

public class WebTest {

	public WebTest() { }

	public static void main(String[] args) throws Exception{
		try {
			Connection conn = null;
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
				conn = DriverManager.getConnection("jdbc:oracle:thin:@LARRYServer:1521:wind","system","manager");

				Statement stmt = conn.createStatement();
				ResultSet rs = stmt.executeQuery("select OWNER,TABLE_NAME from dba_tables where owner = 'WCUSER'");
				ResultSetMetaData rm = rs.getMetaData();
				int cols = rm.getColumnCount();

				System.out.println("<TABLE CELLSPACING=\"2\" CELLPADDING=\"5\" BORDER=\"1\">");

				System.out.println("<TR>");
				for(int j=1; j<=cols; j++) { System.out.println("<TD>" + rm.getColumnName(j) + "</TD>"); }
				System.out.println("</TR>");

				while(rs.next()){
					System.out.println("<TR>");
					for(int i=1; i<=cols;i++){
						System.out.println("<TD>" + rs.getString(i) + "</TD>");
					}
					System.out.println("</TR>");
				}
				System.out.println("</TABLE>");
			}
			catch(SQLException e) {
				System.out.println("SQLException: " + e.getMessage() + "<BR>");
				while((e = e.getNextException()) != null)
				System.out.println(e.getMessage() + "<BR>");
			}
			catch(ClassNotFoundException e){
				System.out.println("ClassNotFoundException: " + e.getMessage() + "<BR>");
			}
			finally {
				if(conn != null){
					try {
						conn.close();
					}
					catch (Exception ignored) {}
				}
			}
		}
		catch (Exception e){ }
	}
}