kcpandian.java

基于Java——SQL2005 的java课程设计 仓库管理系统。主要功能

package windows;

import Login.*;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;

import javax.swing.DefaultCellEditor;
import javax.swing.JButton;
import javax.swing.JComponent;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import model.TbUserlist;
import sql.sql;
import Login.Login;

public class KCPanDian extends JInternalFrame {
	private final JTable table;
	private TbUserlist user = Login.getUser(); // 登录用户信息
	private final JTextField pdsj =new JTextField();//盘点时间
	private final JTextField KCZL = new JTextField("0"); // 库存种类
	private final JTextField KCSL = new JTextField("0"); // 库存数量
	private Date pdDate=new Date();
	private JTextField pdy = new JTextField(user.getUsername());// 盘点员user.getUsername()
	private JButton PDButton =new JButton("库存盘点");
	private long zl=0;
	private long sl=0;
	DefaultTableModel tableModel;
	public KCPanDian() {
		super();
		setMaximizable(true);
		setIconifiable(true);
		setClosable(true);
		getContentPane().setLayout(new GridBagLayout());
		setTitle("仓库管理之库存盘点");
		setBounds(20, 20,800,400);

		setupComponet(new JLabel("盘 点 员："), 0, 0, 1, 0, false);
		pdy.setFocusable(false);
		pdy.setPreferredSize(new Dimension(120, 21));
		setupComponet(pdy, 1, 0, 1, 10, true);

		setupComponet(new JLabel("盘点时间："), 2, 0, 1, 0, false);
		pdsj.setFocusable(false);
		pdsj.setText(pdDate.toLocaleString());

		setupComponet(pdsj, 3, 0, 1, 20, true);

		setupComponet(new JLabel("库存种类："), 4, 0, 1, 0, false);
		KCZL.setFocusable(false);
		//KCZL.setPreferredSize(new Dimension(80, 21));
		setupComponet(KCZL, 5, 0, 1, 80, true);
		
		setupComponet(new JLabel("库存数量："), 6, 0, 1, 0, false);
		KCSL.setFocusable(false);
		//KCSL.setPreferredSize(new Dimension(80, 21));
		setupComponet(KCSL, 7, 0, 1, 80, true);

		JPanel panel = new JPanel();
		JButton Exit =new JButton("退出");
		//panel.add(Exit);
		setupComponet(panel, 0, 3,  5 ,3, false);
		setupComponet(PDButton, 1, 4,  5 ,3, false);
		setupComponet(Exit, 2, 4,  5 ,3, false);
		
		
		table = new JTable();
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		initTable();

		JScrollPane scrollPanel = new JScrollPane(table);
		scrollPanel.setPreferredSize(new Dimension(700, 250));
		setupComponet(scrollPanel, 0, 2, 8, 1, true);
		
		
		
		//panel.add(PDButton);
		
		
		
		
		Exit.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				dispose();
			}
		});
		
		
		PDButton.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				int rowCount=tableModel.getRowCount();
				for(int i=0;i<rowCount;i++) {
					tableModel.removeRow(0);	
				}
				sl=0;
				zl=0;//继续点击库存盘点时，清空表格并且把数量和种类都清0
				String sqlyuju = "select * from tb_Stor";
				ResultSet set = sql.query(sqlyuju);
				try {
					for(;set.next();)
					{
						Object[] row = new Object[4];
						row[0]=set.getString(1);
						row[1]=set.getString(2);
						sl+=set.getInt(2);
						row[2]=set.getString(3);
						row[3]=set.getString(4);
						tableModel.addRow(row);
						zl++;				
					}
					KCZL.setText(zl+"");
					KCSL.setText(sl+"");
			
				}
				catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
				
			}			
		});
		
	}
	// 初始化表格
	private void initTable() {
		String[] columnNames = {"设备名称", "库存数量", "设备类型", "设备参数"};
		tableModel = (DefaultTableModel) table.getModel();		
		tableModel.setColumnIdentifiers(columnNames);
		final JTextField pdField = new JTextField(0);
		pdField.setEditable(false);		
		JTextField readOnlyField = new JTextField(0);
		readOnlyField.setEditable(false);
		DefaultCellEditor readOnlyEditor = new DefaultCellEditor(readOnlyField);
		TableColumn Column =null;
		Column =table.getColumnModel().getColumn(0);
		Column.setCellEditor(readOnlyEditor);
		Column.setPreferredWidth(190);
		Column =table.getColumnModel().getColumn(1);
		Column.setCellEditor(readOnlyEditor);
		Column.setPreferredWidth(130);
		Column =table.getColumnModel().getColumn(2);
		Column.setCellEditor(readOnlyEditor);
		Column.setPreferredWidth(200);
		Column =table.getColumnModel().getColumn(3);
		Column.setCellEditor(readOnlyEditor);
		Column.setPreferredWidth(200);
		//sql.update("UPDATE tb_Stor set");
		//sql.query("UPDATE tb_Stor");
		//sql.findForList("UPDATE tb_Stor");
		//PDButton.requestFocus();	
	}
	
	// 设置组件位置并添加到容器中
	private void setupComponet(JComponent component, int gridx, int gridy,
			int gridwidth, int ipadx, boolean fill) {
		final GridBagConstraints gridBagConstrains = new GridBagConstraints();
		gridBagConstrains.gridx = gridx;
		gridBagConstrains.gridy = gridy;
		if (gridwidth > 1)
			gridBagConstrains.gridwidth = gridwidth;
		if (ipadx > 0)
			gridBagConstrains.ipadx = ipadx;
		gridBagConstrains.insets = new Insets(5, 1, 3, 5);
		if (fill)
			gridBagConstrains.fill = GridBagConstraints.HORIZONTAL;
		getContentPane().add(component, gridBagConstrains);
	}
}