search.java

简单的小型超市管理

import java.awt.*;
import java.awt.event.*;

import javax.swing.*;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.table.DefaultTableModel;
import java.sql.*;

class SearchCargo extends JDialog implements ActionListener
{
	ConnectionSQL conSql;
	BuyCargoDlg BuyDlg;        //采购货物
	DefaultTableModel defaultModel = null;
	JTable table;
	JButton search, all, buy;
	JTextField text;
	String nameS;
	SearchCargo(JFrame f, String s, boolean b)
	{
		super(f,s,b);
		setDefaultCloseOperation(JDialog.HIDE_ON_CLOSE);
		Container con = getContentPane();
		text = new JTextField(10);
		search = new JButton("查找");
		all = new JButton("全部");
		buy = new JButton("采购");
		//buy.setEnabled(false);
		search.addActionListener(this);
		all.addActionListener(this);
		buy.addActionListener(this);
		
		JPanel pNorth = new JPanel(),
		   pCenter = new JPanel();
		pNorth.add(new JLabel("货物名称:"));
		pNorth.add(text);
		pNorth.add(search);
		pNorth.add(all);
		pNorth.add(buy);
		
		Object a[][] = new Object[0][0];
		Object n[] = {"编号","货物名称","库存量"};    //表格的列名
		defaultModel = new DefaultTableModel(a,n);
		table = new JTable(defaultModel);
		table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		ListSelectionModel rowSM = table.getSelectionModel();
		
		rowSM.addListSelectionListener(new ListSelectionListener()   //
		{
			public void valueChanged(ListSelectionEvent e)
			{
				if (e.getValueIsAdjusting())
					return;
				ListSelectionModel lsm = (ListSelectionModel)e.getSource();
				if (!lsm.isSelectionEmpty())
				{
					//buy.setEnabled(true);
					int selectedRow = lsm.getMinSelectionIndex();
					nameS = (String)defaultModel.getValueAt(selectedRow, 1);				
				}
			}
		});
		
		pCenter.add(new JScrollPane(table));
		
		con.add(pNorth, BorderLayout.NORTH);
		con.add(pCenter, BorderLayout.CENTER);
		setSize(600, 500);
	}
	public void actionPerformed(ActionEvent e) {
		// TODO 自动生成方法存根
		Object o[] = {"", "", ""};
		try {
			conSql = new ConnectionSQL();
			conSql.sql = conSql.con.createStatement();
		}
		catch(SQLException ee) {}
		
		if(e.getSource()==search)
		{
			if(text.getText().equals(""))
			{
				JOptionPane.showMessageDialog(this, "查询为空!", "警告", JOptionPane.WARNING_MESSAGE);
			}
			else
			{
				int row = defaultModel.getRowCount()-1;  //清空表格***********
				while(row>=0)
				{
					defaultModel.removeRow(row);
					defaultModel.setRowCount(row);
					row--;
				}   //*********************************
				try {
					conSql.rs = conSql.sql.executeQuery("select * from CARGO where 名称 = '"+text.getText()+"'");
					while(conSql.rs.next())
					{
						o[0] = conSql.rs.getString(1);
						o[1] = conSql.rs.getString(2);
						o[2] = conSql.rs.getString(3);
						defaultModel.addRow(o);    //增加一行
					}
					conSql.con.close();
				}
				catch(SQLException eee) {}
			}
		}
		else if(e.getSource()==all)
		{
			int row = defaultModel.getRowCount()-1;
			while(row>=0)
			{
				defaultModel.removeRow(row);
				defaultModel.setRowCount(row);
				row--;
			}
			try {
				conSql.rs = conSql.sql.executeQuery("select * from CARGO");
				while(conSql.rs.next())
				{
					o[0] = conSql.rs.getString(1);
					o[1] = conSql.rs.getString(2);
					o[2] = conSql.rs.getString(3);
					defaultModel.addRow(o);    //增加一行
				}
				conSql.con.close();
			}
			catch(SQLException eee) {}
		}
		else if(e.getSource()==buy)
		{
			BuyDlg = new BuyCargoDlg(null, "采购货物", true);
			BuyDlg.nameT.setText(nameS);
			BuyDlg.setLocationRelativeTo(null);
			BuyDlg.setVisible(true);
		}
	}
}

class Money extends JDialog
{
	ConnectionSQL conSql;
	JTextField inText, outText, sumText;
	Money(JFrame f, String s, boolean b)
	{
		super(f,s,b);
		setDefaultCloseOperation(JDialog.HIDE_ON_CLOSE);
		Container con = getContentPane();
		con.setLayout(new BorderLayout());
		
		inText = new JTextField(5);
		outText = new JTextField(5);
		sumText = new JTextField(5);
		
		Box box1, box2, box;
		box1 = Box.createVerticalBox();
		box1.add(new JLabel("销售总额:"));
		box1.add(Box.createVerticalStrut(30));
		box1.add(new JLabel("采买总额:"));
		box1.add(Box.createVerticalStrut(30));
		box1.add(new JLabel("收支金额:"));
		box2 = Box.createVerticalBox();
		box2.add(Box.createVerticalStrut(18));
		box2.add(inText);
		box2.add(Box.createVerticalStrut(18));
		box2.add(outText);
		box2.add(Box.createVerticalStrut(18));
		box2.add(sumText);
		box2.add(Box.createVerticalStrut(18));
		box = Box.createHorizontalBox();
		box.add(Box.createHorizontalStrut(18));
		box.add(box1);
		box.add(Box.createHorizontalStrut(18));
		box.add(box2);
		box.add(Box.createHorizontalStrut(18));
		con.add(box, BorderLayout.CENTER);
		
		try {
			float sumIn = 0, sumOut = 0;
			float price = 0;
			int count = 0;
			conSql = new ConnectionSQL();
			conSql.sql = conSql.con.createStatement();
			conSql.rs = conSql.sql.executeQuery("select 进价,进货量 from BUY");
			while(conSql.rs.next())
			{
				price = conSql.rs.getFloat(1);
				count = conSql.rs.getInt(2);
				sumOut = sumOut + price*count;
			}
			conSql.rs = conSql.sql.executeQuery("select 销价,销售量 from SALE");
			while(conSql.rs.next())
			{
				price = conSql.rs.getFloat(1);
				count = conSql.rs.getInt(2);
				sumIn = sumIn + price*count;
			}
			conSql.rs.close();
			outText.setText(sumOut+"");
			inText.setText(sumIn+"");
			sumText.setText((sumIn-sumOut)+"");
		}
		catch(SQLException ee) {}
		
		setSize(200, 200);
		validate();
	}
}
public class search {
	public static void main(String args[])
	{
		JFrame f;
		f = new JFrame("ss");
		f.setLocationRelativeTo(null);
		f.setVisible(true);
		Money U = new Money(f, "收支情况", true);
		U.setLocationRelativeTo(null);
		U.setVisible(true);
	}

}