60e7ff238530001d14bca828f5ee0475

来自「这个一个用j2se实现的汽车销售管理系统」· 代码 · 共 106 行

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

import java.sql.*;
public class SaleQuery extends JPanel implements ActionListener {

	private DefaultTableModel dtm=new DefaultTableModel();
	private JTable table=new JTable(dtm);
	private JScrollPane jscrollpane1=new JScrollPane(table);
	private JButton btnQuery=new JButton("从维修清单中查询零部件的销售");
	
	public SaleQuery()
	{
		
		this.init();
		this.setBackground(Color.green);
		this.setVisible(true);
	}
	public void  init()
	{
		JPanel ptop=new JPanel();
		ptop.add(btnQuery);
		ptop.setBackground(new Color(23,2,2))
		btnQuery.addActionListener(this);
		
		dtm.addColumn("零件名称");
		dtm.addColumn("零件销售价格");
		dtm.addColumn("零件销售数量");
		dtm.addColumn("在修理哪个车辆时所售");
		JPanel pMid=new JPanel();
		pMid.add(jscrollpane1);
		
		JPanel pAll=new JPanel();
		pAll.setLayout(new BorderLayout());
		pAll.add(ptop,"North");
		pAll.add(pMid,"Center");
		
		this.add(pAll);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==btnQuery)
		{
			dealBtnQuery();
		}
	}
	public void dealBtnQuery()
	{
		chooseColor();
		try
		{
			String sql="select * from CarInfo";
			ConToDB DB=new ConToDB();
			DB.LinkDB();
			PreparedStatement st=DB.con.prepareStatement(sql);
			ResultSet rs=st.executeQuery();
			while(rs.next())
			{
				String ID=rs.getString(1);
				String Name=rs.getString(4);
				String Price=rs.getString(5);
				String Num=rs.getString(6);
				String [] str={Name,Price,Num,ID};
			    dtm.addRow(str);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void chooseColor()
	{
		TableColumn NameColumn=table.getColumn("零件名称");
		DefaultTableCellRenderer NameColumnRenderer=new DefaultTableCellRenderer();
		NameColumnRenderer.setBackground(Color.yellow);
		NameColumnRenderer.setToolTipText("该列为零件名称");
		NameColumn.setCellRenderer(NameColumnRenderer);
		
		
		TableColumn PriceColumn=table.getColumn("零件销售价格");
		DefaultTableCellRenderer PriceColumnRenderer=new DefaultTableCellRenderer();
		PriceColumnRenderer.setBackground(Color.yellow);
		PriceColumnRenderer.setToolTipText("该列为零件销售价格");
		PriceColumn.setCellRenderer(PriceColumnRenderer);
		
		TableColumn NumColumn=table.getColumn("零件销售数量");
		DefaultTableCellRenderer NumColumnRenderer=new DefaultTableCellRenderer();
		NumColumnRenderer.setBackground(Color.yellow);
		NumColumnRenderer.setToolTipText("该列为零件销售价格");
		NumColumn.setCellRenderer(NumColumnRenderer);
		
		TableColumn CarNumColumn=table.getColumn("在修理哪个车辆时所售");
		DefaultTableCellRenderer CarNumColumnRenderer=new DefaultTableCellRenderer();
		CarNumColumnRenderer.setBackground(Color.yellow);
		CarNumColumnRenderer.setToolTipText("该列为零件销售价格");
		CarNumColumn.setCellRenderer(CarNumColumnRenderer);
		
	}
	
}