//import com.ms.wfc.data.*;
import java.sql.*;
import java.awt.*;
import java.io.*;

//Thanks to Rachel Pottinger for writing this

public class connect extends Frame
{
	Panel P;
	TextArea area;
	public connect(){
		
		area = new TextArea("Tuples:",40,100);
		add(area);
	}
	
	public void paint(Graphics g){
		area.paint(g);
	}
	
	
	public void doIt(){
		try {
			
		    //	Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");

		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		java.sql.Connection c = DriverManager.getConnection("jdbc:odbc:444","cse444","cse444");
			java.sql.Statement s= c.createStatement();
			java.sql.ResultSet rs;
			rs = s.executeQuery("Select * from Student");
			java.sql.ResultSetMetaData md = rs.getMetaData();
			while (rs.next()){
				area.append("\nTUPLE: |");
				for (int i = 1; i <= md.getColumnCount();i++){
					area.append(rs.getString(i) + " | ");
				}
			}
			
			rs.close();
		} catch (Exception e){
			e.printStackTrace();
			System.out.println("something went wrong in database land");
		}
		
	}
	
	public static void main(String [] args){
	     System.out.println("This is how you print to the console");
	     System.out.println("Please hit enter to run");
	    //this is how you read from the console
	     try{
	     String s=(new BufferedReader(new InputStreamReader(System.in))).readLine();
	     }catch (IOException E){}
		connect f = new connect();
		f.setSize(200,200);
		f.doIt();
		f.show();
	}
}