vipfrm.java

java编写小型超市管理系统+数据库.用于小型超市简单的货品进存销

package com.wish;
import java.util.Vector;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.*;

//VIP界面
public class Vipfrm extends JFrame implements ActionListener{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JTable table=null;
	DefaultTableModel dtm=new DefaultTableModel();
	JScrollPane jsp=null;
	
	JTextField txt[]=new JTextField[5];
	JButton btnModify=new JButton("修改");
	JPanel a=new JPanel();
	
	JLabel alt=new JLabel();
	JButton btnAdd=new JButton("增加用户");
	JButton btnDel=new JButton("删除用户");
	JButton btnUpdate=new JButton("刷新用户表");
	JPanel b=new JPanel();
	JPanel c=new JPanel();
	public Vipfrm()
	{	
		txt[0]=new JTextField(5);
		txt[1]=new JTextField(5);
		txt[2]=new JTextField(5);
		txt[3]=new JTextField(5);
		txt[4]=new JTextField(5);
		for(int i=0;i<5;i++)
		a.add(txt[i]);
		a.add(btnModify);
		
		b.add(btnAdd);
		b.add(btnDel);
		b.add(btnUpdate);
		b.add(alt);
		
		c.setLayout(new GridLayout(2,1));
		c.add(a);
		c.add(b);
		//事件注册
		btnAdd.addActionListener(this);
		btnDel.addActionListener(this);
		btnUpdate.addActionListener(this);
		btnModify.addActionListener(this);
		inTable();
		jsp=new JScrollPane(table);
		
		this.setLayout(new BorderLayout());
		this.getContentPane().add(c,BorderLayout.SOUTH);
		this.getContentPane().add(jsp);
		queryAll();   //加载时刷新列表
		this.setSize(400,350);
		setsonframe.set(this);
		txt[0].setEnabled(false);
		table.addMouseListener(new MouseAdapter(){
			public void mouseClicked(MouseEvent e)
			{
					int row=table.getSelectedRow();
					
					for(int i=0;i<5;i++)
					txt[i].setText((String) table.getValueAt(row,i));

			}
		});
	}//修改事件
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==btnModify)
		{
			User user=new User();
			user.setUser_id(txt[0].getText());
			user.setUser_name(txt[1].getText());
			user.setUser_date(txt[2].getText());
			user.setUser_buy(txt[3].getText());
			user.setUser_pay(txt[4].getText());
			
			new VipManager().updateUser(user);
			queryAll();
		}
		//增加事件
		else if(e.getSource()==btnAdd)
			new VipAdd("增加VIP");
		
		//删除事件
		else if(e.getSource()==btnDel)
		{
			int row=table.getSelectedRow();
			String user_id=(String) table.getValueAt(row,0);
			
			if(row<0)
				JOptionPane.showMessageDialog(this,"删除出错");
			else if (row>0)
			{
				@SuppressWarnings("unused") boolean flag=new VipManager().delUser(user_id);
				queryAll();

				for(int i=0;i<5;i++)
					txt[i].setText("");
			}
			else if(row==0)
				JOptionPane.showMessageDialog(this,"不能删除临时用户！");
				
		}
		else if(e.getSource()==btnUpdate)
			queryAll();
	}
	private void inTable()
	{
		table = new JTable(dtm);
		dtm.addColumn("ID");
		dtm.addColumn("名字");
		dtm.addColumn("创建日期");
		dtm.addColumn("共消费");
		dtm.addColumn("折扣率");
	}
	public void queryAll()
	{	
		DefaultTableModel dtm=new DefaultTableModel();
		dtm.addColumn("ID");
		dtm.addColumn("名字");
		dtm.addColumn("创建日期");
		dtm.addColumn("共消费");
		dtm.addColumn("折扣率");
		
		VipManager VM=new VipManager();
		Vector v=VM.getUser();
		//返回数据库类型，需修改
		for(int i=0;i<v.size();i++)
		 {
			 User user = (User) v.get(i);
			 Object[]data = new Object[5];//表示一条记录
			 data[0] = user.getUser_id();
			 data[1] = user.getUser_name();
			 data[2] = user.getUser_date();
			 data[3] = user.getUser_buy();
			 data[4] = user.getUser_pay();
			 
			 dtm.addRow(data);
		 }
		table.setModel(dtm);
	}
}