totalstore.java

这是一个超市管理系统

package file2;
import java.awt.*;

import javax.swing.*;

import java.sql.*;
public class TotalStore extends JPanel {
	private DBConnection con=null;
	private JLabel tip=new JLabel("所有商品库存情况");
	private JPanel tipPane=new JPanel();
	private JTable table=null;
	private JScrollPane tablePane=null;
	private String[][] dataForTable=null;
	private String[] titleForTable={"商品名称","库存量","最低库存量"};
	public TotalStore(){
		con=new DBConnection();
		tipPane.add(tip);
		String query="select Third_name,store_in,limit from Third_Catalog";
		ResultSet set=con.executeSelect1(query);
		int count=0;
		try{
			while(set.next()){
				count++;
			}
			set.beforeFirst();
			if(count==0){
				dataForTable=new String[1][3];
				dataForTable[0][0]="无";
				dataForTable[0][1]="0";
				dataForTable[0][2]="0";
			}else{
				dataForTable=new String[count][3];
				count=0;
				while(set.next()){
					dataForTable[count][0]=set.getString(1);
					dataForTable[count][1]=""+set.getInt(2);
					dataForTable[count][2]=""+set.getInt(3);
					count++;
				}
			}
			table=new JTable(dataForTable,titleForTable);
			tablePane=new JScrollPane(table);
			this.setLayout(new GridLayout(2,1));
			this.add(tipPane);
			this.add(tablePane);
		}catch(Exception e){
			e.printStackTrace();
		}
		
	}
}