205395dd0a30001d17a39fa8a118b5a5

这个一个用j2se实现的汽车销售管理系统

//零件库存查询
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 PartQuery extends JPanel implements ActionListener{

	/**
	 * @param args
	 */
	private DefaultTableModel dtm=new DefaultTableModel();
	private JTable table=new JTable(dtm);
	private JScrollPane jscrollpane1=new JScrollPane(table);
	private JButton btnQuery=new JButton("零件库存查询");
	private JButton btnCancle=new JButton("清空");
	private 	ConToDB DB;
	public PartQuery()
	{
		
		this.init();
		this.setVisible(true);
		this.setBackground(Color.blue);
	}
	public void init()
	{
		JPanel ptop=new JPanel();
		ptop.add(btnQuery);
		ptop.add(btnCancle);
		btnCancle.addActionListener(this);
		Color color=new Color(21,123,41);
		ptop.setBackground(color);
		btnQuery.addActionListener(this);
		
		
		//dtm.addColumn("零件编号");
		//dtm.addColumn("零件名称");
		//dtm.addColumn("零件价格");
		//dtm.addColumn("零件数量");
		JPanel pMid=new JPanel();
		pMid.add(jscrollpane1);
		jscrollpane1.setBackground(new Color(21,123,41));
		table.setBackground(new Color(21,123,41));
		
		
		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();
		}
		else if(e.getSource()==btnCancle)
		{
		   int row=table.getRowCount();
		   System.out.println(row);
			
		}
	}
	public void dealBtnQuery()
	{

		dtm.addColumn("零件编号");
		dtm.addColumn("零件名称");
		dtm.addColumn("零件价格");
		dtm.addColumn("零件数量");
		setColor();
		
		try
		{
			String sql="select * from Product ";
			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(2);
				float Price=rs.getFloat(3);
				String sPrice=new String(Price+"");
				int Num=rs.getInt(4);
				String sNum=new String(Num+"");
				String [] str={ID,Name,sPrice,sNum};
				dtm.addRow(str);
			}
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	public void setColor()
	{

		TableColumn partIDColumn=table.getColumn("零件编号");
		DefaultTableCellRenderer partIDColumnRenderer=new DefaultTableCellRenderer();
		partIDColumnRenderer.setBackground(Color.yellow);
		partIDColumnRenderer.setToolTipText("该列为零件编号");
		partIDColumn.setCellRenderer(partIDColumnRenderer);
		
		
		TableColumn partNameColumn=table.getColumn("零件名称");
		DefaultTableCellRenderer partNameColumnRenderer=new DefaultTableCellRenderer();
		partNameColumnRenderer.setBackground(Color.green);
		partIDColumnRenderer.setToolTipText("该列为零件名称");
		partNameColumn.setCellRenderer(partNameColumnRenderer);
		
		TableColumn partPriceColumn=table.getColumn("零件价格");
		DefaultTableCellRenderer partPriceColumnRenderer=new DefaultTableCellRenderer();
		partPriceColumnRenderer.setBackground(Color.red);
		partPriceColumnRenderer.setToolTipText("该列为零件价格");
		partPriceColumn.setCellRenderer(partPriceColumnRenderer);
		
		
		TableColumn partNumColumn=table.getColumn("零件数量");
		DefaultTableCellRenderer partNumColumnRenderer=new DefaultTableCellRenderer();
		partNumColumnRenderer.setBackground(Color.yellow);
		partNumColumnRenderer.setToolTipText("该列为零件数量");
		partNumColumn.setCellRenderer(partNumColumnRenderer);
		
	}
	public static void main(String[] args) {
		// TODO 自动生成方法存根
         new PartQuery();
	}

}