b0080dd90630001d17a39fa8a118b5a5

这个一个用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 	ConToDB DB;
	public PartQuery()
	{
		
		this.init();
		this.setVisible(true);
	}
	public void init()
	{
		JPanel ptop=new JPanel();
		ptop.add(btnQuery);
		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()
	{
		
		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 static void main(String[] args) {
		// TODO 自动生成方法存根
         new PartQuery();
	}

}