traintable.java

trainticket 运行平台 Windows XP

/*实现显示班级信息的表格控件－－中间件*/
package Manager;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

import Manager.TrainManager;
import Manager.MyJTable;
import Manager.Train;

public class TrainTable extends MyJTable
{
	private int selectrow=0;
	//Statement stmt1=null;
	TrainManager bjm;
	public TrainTable()
	{
		bjm=new TrainManager();
		ResultSet rs=null;
		rs=bjm.QueryString("select * from chapiao");
		this.getResultSet(rs);
		this.addMouseListener(new MyMouseAdapter(this));
	}
	public TrainTable(String sql)
	{
		String s=sql;
		bjm=new TrainManager();
		ResultSet rs=null;
		rs=bjm.QueryString(s);
		this.getResultSet(rs);
		this.addMouseListener(new MyMouseAdapter(this));
	}
	/*public void refresh(TrainManager bjm)
	{
		ResultSet rs=null;
		rs=null;
		rs=bjm.QueryString("select * from chapiao");
		super.refresh(rs);
	}*/
	public void refresh(TrainManager bjm)
	{
		ResultSet rs=null;
		rs=null;
		rs=bjm.QueryString("select * from chapiao");
		super.refresh(rs);
	}
	public void refresh(String sql)
	{
		ResultSet rs=null;
		rs=null;
		//System.out.print(sql);
		//TrainManager bj2=new TrainManager();
		//System.out.print("c2"); 
		rs=bjm.QueryString(sql);
		//System.out.print("c3");
		super.refresh(rs);
		//System.out.print("c4");
	}
	private class MyMouseAdapter extends MouseAdapter
	{
		TrainTable table=null;
		public MyMouseAdapter(TrainTable table)
		{
			this.table=table;	
		}
		public void mouseClicked(MouseEvent me)
		{
			selectrow=table.getSelectedRow();
		}	
		public void mousePressed(MouseEvent me)
		{
			selectrow=table.getSelectedRow();
		}
	}
	public Train getSelectionItem()
	{
		try
		{
			Train bj=new Train();
			bj.setBh(this.getValueAt(selectrow,0).toString());
			bj.setName(this.getValueAt(selectrow,1).toString());
			bj.setSem(this.getValueAt(selectrow,2).toString());
			return(bj);
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return(null);	
		}
	}
}