myjtable.java

trainticket 运行平台 Windows XP

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

public class MyJTable extends JTable 
{
	private DefaultTableModel data=new DefaultTableModel();
	private ResultSet rs=null;
	private ResultSetMetaData rsmd=null;
	public MyJTable()
	{
		this.setModel(data);
	}
	public MyJTable(ResultSet rss)
	{
		try
		{
			this.rs=rss;
			this.setModel(data);
			rsmd=rs.getMetaData();	
			createDataColumns();
			createSampleData();
		}
		catch(Exception e)
		{
			e.printStackTrace();	
		}
	}
	public void getResultSet(ResultSet rss)
	{
		try
		{
			this.rs=rss;
			rsmd=rs.getMetaData();	
			createDataColumns();
			createSampleData();
		}
		catch(Exception e)
		{
			e.printStackTrace();	
		}	
	}
	public void refresh(ResultSet rss)
	{
		try
		{
			this.rs=rss;
			rsmd=rs.getMetaData();
			data.setRowCount(0);
			data.setColumnCount(0);
			createDataColumns();
			createSampleData();
		}
		catch(Exception e)
		{
			e.printStackTrace();	
		}
	}
	public void createDataColumns()
	{
		/*create columns with appropriate headers*/	
		try
		{
			for(int i=1;i<=rsmd.getColumnCount();i++)
			{
				data.addColumn(rsmd.getColumnName(i));	
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	private void createSampleData()
	{
		/*create some sample data*/	
		try
		{
			rs.first();
			//rs.next();
			do
			{
				Vector v=new Vector();
				for(int i=1;i<=rsmd.getColumnCount();i++)
				{
					v.addElement(rs.getString(i));	
				}
				data.addRow(v);
			}while(rs.next());
		}
		catch(Exception e)
		{
			e.printStackTrace();	
		}
	}
}