import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import java.sql.*;
import java.util.*;

public class DBManager extends JFrame implements ListSelectionListener
{
	JList jl=new JList();
	JScrollPane jspz=new JScrollPane(jl);
	JTable jt=new JTable();
	JScrollPane jspy=new JScrollPane(jt);	
	JSplitPane jsp=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,jspz,jspy);
	
	Connection con;
	Statement st;
	
	public DBManager()
	{
		this.setTitle("數(shù)據(jù)庫查看器");
		this.add(jsp);
		jsp.setDividerLocation(200);
		jsp.setDividerSize(4);
		
		this.initDB();
		this.initJList();
		
		this.setBounds(100,100,600,400);
		this.setVisible(true);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}
	
	public void initDB()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:stu","","");
			st=con.createStatement();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public void initJList()
	{
		try
		{
			DatabaseMetaData dmd=con.getMetaData();
			ResultSet rs=dmd.getTables(null,null,null,new String[]{"TABLE"});
			Vector v=new Vector();
			while(rs.next())
			{
				v.add(rs.getString(3));
			}
			jl.setListData(v);
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}	
		
		jl.addListSelectionListener(this);	
	}
	
	public void valueChanged(ListSelectionEvent e)
	{
		try
		{
			String tn=(String)jl.getSelectedValue();
			String sql="select * from "+tn;
			ResultSet rs=st.executeQuery(sql);
			ResultSetMetaData rsmd=rs.getMetaData();
			Vector vcn=new Vector();
			int cc=rsmd.getColumnCount();
			for(int i=1;i<=cc;i++)
			{
				vcn.add(rsmd.getColumnName(i));
			}
			Vector vdata=new Vector();
			while(rs.next())
			{
				Vector vtemp=new Vector();
				for(int i=1;i<=cc;i++)
				{
					vtemp.add(rs.getString(i));
				}
				vdata.add(vtemp);
			}
			jt.setModel(new DefaultTableModel(vdata,vcn));
		}
		catch(Exception ea)
		{
			ea.printStackTrace();
		}		
	}
	
	public static void main(String args[])
	{
		new DBManager();
	}
}