//import com.ms.wfc.data.*;
import java.sql.*;
import java.awt.*;
public class RapConnect extends Frame
{
	Panel P;
	TextArea area;
	public RapConnect(){
		//P = new Panel();
		//P.setLayout(new FlowLayout());
		//area = new TextArea("bob",3,10);
		//P.add(area);
		//P.show();
		area = new TextArea("Tuples:",40,100);
		add(area);
	}
	
	public void paint(Graphics g){
		area.paint(g);
	}
	
	/*public void processEvent(AWTEvent e){
		if (e.getID() == Event.WINDOW_DESTROY){
			System.exit(0);
		}
		super.processEvent(e);
	}
	*/
	public void doIt(){
		try {
			
			Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");

			java.sql.Connection c = DriverManager.getConnection("jdbc:odbc:[datasource name i sent you]","[login I sent you]","[password i sent you]");
			java.sql.Statement s= c.createStatement();
			java.sql.ResultSet rs;
			rs = s.executeQuery("Select * from [csepclab\\hongyu].Office");
			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) + " | ");
				}
			}
			//s.executeUpdate("Insert into Paper values(13,1999,'Interesting')");
			
			rs.close();
		} catch (Exception e){
			e.printStackTrace();
			System.out.println("something went wrong in database land");
		}
		
	}
	
	public static void main(String [] args){
		RapConnect f = new RapConnect();
		f.setSize(200,200);
		f.doIt();
		f.show();
	}
}