tabelpanel1.java

一个用java语言编写的基于数据库的系统

import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
public class TabelPanel1 extends JFrame{
	private Connection connection;
	private Statement statement;
	private ResultSet resultSet;
	private ResultSetMetaData rsMetaData;
	private JTable table = new JTable();
	public TabelPanel1(){
		table.setEnabled(false);
		try{
			String drive="sun.jdbc.odbc.JdbcOdbcDriver";
			Class.forName(drive);
			 connection = DriverManager.getConnection
			  ("jdbc:odbc:BusManage");
			   statement = connection.createStatement();
				}
				catch(Exception ex){
					System.out.println("连接数据库失败!");
				}
	JPanel topPanel = new JPanel();
	setLayout( new BorderLayout() );
	add( topPanel, BorderLayout.NORTH );
	add( table, BorderLayout.CENTER );
	setSize(600,300);
	}
   public void getTable(String begin,String end)
	{
		try {
			String query = "SELECT DISTINCT T_BusInfor.BusBrandMark, T_BusInfor.BusNumber, T_BusInfor.FirstTime, T_BusInfor.LastTime, T_BusInfor.Remark" +
          "FROM T_BusInfor  INNER JOIN T_SiteInfor ON T_BusInfor.BusNumber = T_SiteInfor.BusNumber" +
          "WHERE (((T_SiteInfor.BusNumber) In (select BusNumber from T_SiteInfor where T_SiteInfor.SiteName ='"+begin+"')) AND ((T_SiteInfor.SiteName)='"+end+"'))";
			
			statement = connection.createStatement();
			resultSet = statement.executeQuery( query );
			displayResultSet(resultSet);
			}
		catch ( SQLException sqlex ) {
			
		}
	}
  
 public void displayResultSet( ResultSet rs )throws SQLException	{
	boolean moreRecords = rs.next();
	if (!moreRecords) {
	JOptionPane.showMessageDialog( null, "结果集中无记录" );
	return;
	}
	Vector columnHeads = new Vector();
	Vector rows = new Vector();
	try {
		ResultSetMetaData rsmd = rs.getMetaData();
		for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
		columnHeads.addElement( rsmd.getColumnName( i ) );
		do {
			rows.addElement( getNextRow( rs, rsmd ) );
		} while ( rs.next() );
	table = new JTable( rows, columnHeads );
	JScrollPane scroller = new JScrollPane( table );
	Container c = getContentPane();
	c.remove(1);
	c.add( scroller, BorderLayout.CENTER );
	c.validate();
	}
	catch ( SQLException sqlex ) {
	sqlex.printStackTrace();
	}
 }
	public Vector getNextRow( ResultSet rs, ResultSetMetaData rsmd )throws SQLException
	{
	Vector currentRow = new Vector();
	for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
	currentRow.addElement( rs.getString( i ) );
	return currentRow;
	}
}