f00b31546a30001d14bca828f5ee0475

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

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;
import java.sql.*;
import javax.swing.table.*;
public class BuyProduct extends JPanel implements ActionListener{

	/**
	 * @param args
	 */
	private DefaultTableModel dtm=new DefaultTableModel();
	private JTable  table=new JTable(dtm);
	private JScrollPane jscrollPane1=new JScrollPane(table);
	private JLabel lbNum=new JLabel("设置库存最低容量：");
	private JTextField tfNum=new JTextField("",10);
	private JButton btnQuery=new JButton("查询需要采购货物名单");
	private JButton btnSure=new JButton("确定采购");
	private JButton btnCancle=new JButton("取消采购");
	private  ConToDB DB;
	private Color rgb;
	public BuyProduct()
	{
		
		this.init();
		this.setVisible(true);
		
	}
	public void init()
	{
		JPanel ptop=new JPanel();
		ptop.add(lbNum);
		ptop.add(tfNum);
		ptop.add(btnQuery);
		btnQuery.addActionListener(this);
		
		dtm.addColumn("零件编号");
		dtm.addColumn("零件名称");
		dtm.addColumn("零件价格");
		dtm.addColumn("现有库存数量");
		dtm.addColumn("设置需要采购数量");
		
		JPanel pMid=new JPanel();
		pMid.add(jscrollPane1);
		
		JPanel pbuttom=new JPanel();
	    pbuttom.add(btnSure);
	    pbuttom.add(btnCancle);
	    btnSure.addActionListener(this);
	    btnCancle.addActionListener(this);
	    
	    JPanel pAll=new JPanel();
	    pAll.setLayout(new BorderLayout());
	    pAll.add(ptop,"North");
	    pAll.add(pMid,"Center");
	    pAll.add(pbuttom,"South");
	    
	    this.add(pAll);
	    
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==btnQuery)
		{
			dealBtnQuery();
		}
		else if(e.getSource()==btnSure)
		{
			dealBtnSure();
		}
		else if(e.getSource()==btnCancle)
		{
			dealBtnCancle();
		}
	}
	public void dealBtnQuery()
	{
		choosecolor();
		try
		{
			int Num=Integer.parseInt(tfNum.getText());
			String sql="select * from Part where partNum < ?";
			 DB=new ConToDB();
			 DB.LinkDB();
			 PreparedStatement st=DB.con.prepareStatement(sql);
			 st.setInt(1, Num);
			 ResultSet rs=st.executeQuery();
			 while(rs.next())
			 {
				 String ID=rs.getString(1);
				 String Name=rs.getString(2);
				 float Price=rs.getFloat(3);
				
				 int num=rs.getInt(4);
				 String sPrice=new String(""+Price);
				 String sNum=new String(""+num);
				 
				 String [] obj={ID,Name,sPrice,sNum,""};
				 dtm.addRow(obj);
			
			 }
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void choosecolor()
	{
		//rgb=JColorChooser.showDialog(BuyProduct.this, "选择颜色", rgb);
		
		
		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);
 		partnameColumnRenderer.setToolTipText("该列为零件名称");
 		partnameColumn.setCellRenderer(partnameColumnRenderer);
 		
 		

 		TableColumn partpriceColumn=table.getColumn("零件价格");
 		DefaultTableCellRenderer partpriceColumnRenderer=new DefaultTableCellRenderer();
 		partpriceColumnRenderer.setBackground(Color.blue);
 		partpriceColumnRenderer.setToolTipText("该列为零件价格");
 		partpriceColumn.setCellRenderer(partpriceColumnRenderer);
 		
 		

 		TableColumn partnumColumn=table.getColumn("现有库存数量");
 		DefaultTableCellRenderer partnumColumnRenderer=new DefaultTableCellRenderer();
 		partnumColumnRenderer.setBackground(Color.red);
 		partnumColumnRenderer.setToolTipText("该列为零件价格");
 		partnumColumn.setCellRenderer(partnumColumnRenderer);
 		
 		TableColumn partbuynumColumn=table.getColumn("设置需要采购数量");
 		DefaultTableCellRenderer partbuynumColumnRenderer=new DefaultTableCellRenderer();
 		partbuynumColumnRenderer.setBackground(Color.white);
 		partbuynumColumnRenderer.setToolTipText("该列设置需要采购数量");
 		partbuynumColumn.setCellRenderer(partbuynumColumnRenderer);
 		
 		
 		
	}
	public void dealBtnSure()
	{
			try
			{
				int Num=Integer.parseInt(tfNum.getText());
				String sql="select * from Part where partNum < Num";
				 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);
					
					 int num=rs.getInt(4);
					 String sPrice=new String(""+Price);
					 String sNum=new String(""+num);
					 
					 String [] obj={ID,Name,sPrice,sNum,""};
					 dtm.addRow(obj);
				
				 }
				
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
	}
	public void dealBtnCancle()
	{

		try
		{
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
		// TODO 自动生成方法存根
           new BuyProduct();
	}

}