hiretaxispanel.java

碟片出租系统,后台是SQL SERVER,联系编程时可以全部采用或者部分采用.

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

public class HireTaxisPanel extends JPanel
{
	private final Font font = new Font("华文新魏", Font.PLAIN, 20);
	private JLabel title;
	private JPanel centerPanel;
	private JTable table;
	private String query = "select filmID 编号, filmName 影片名, filmType"
		+ " 类型, CDNumber '片(集)数', players 主演, hireTimes 被租次数, country 国家,"
		+ " remark 备注 from films order by hireTimes desc";
	
	public HireTaxisPanel()
	{
		super();
		setLayout(new BorderLayout());
		title = new JLabel("出租排行榜", JLabel.CENTER);
		title.setFont(font);
		add(title, BorderLayout.NORTH);
		centerPanel = new JPanel();
		centerPanel.setLayout(new FlowLayout(FlowLayout.LEFT));
		try
		{
			FilmHireSystem.tableModel.setQuery(query);
		}
		catch(SQLException sql)
		{
			JOptionPane.showMessageDialog(HireTaxisPanel.this, sql.getMessage());
		}
		table = new JTable(FilmHireSystem.tableModel);
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		table.getTableHeader().setReorderingAllowed(false);
		add(new JScrollPane(table), BorderLayout.CENTER);
	}	
}