704aa1ba4e2f001d192bca9fb16e6793

这个一个用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 JFrame 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;
	public BuyProduct()
	{
		super("现有数量");
		this.setLocation(200,200);
		this.setSize(600,400);
		this.init();
		this.setVisible(true);
		this.pack();
	}
	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.getContentPane().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()
	{
	    boolean flag=false;
		try
		{
			String sql="select * from Part";
			 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);
				 float Num=rs.getFloat(4);
				 String sPrice=new String(""+Price);
				 String sNum=new String(""+Num);
				 
				 String [] obj={ID,Name,sPrice,sNum,""};
				 dtm.addRow(obj);
				 flag=true;
			 }
			 if(!flag)
			 {
				 JOptionPane.showMessageDialog(this, "购置零部件成功！");
			 }
			 else 
			 {
				 JOptionPane.showMessageDialog(this, "购置零部件失败！");
			 }
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	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();
	}

}