adminfrm.java

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

	package com.wish;
import java.util.Vector;

	import javax.swing.*;
	import javax.swing.table.DefaultTableModel;

import java.awt.*;
import java.awt.event.*;
	
	public class Adminfrm extends JFrame implements ActionListener{
		/**
		 * 
		 */
		private static final long serialVersionUID = 1L;
		JTable table=null;
		DefaultTableModel dtm=new DefaultTableModel();
		JScrollPane jsp=null;
		JTextField txt[]=new JTextField[3];
		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 d=new JPanel();
		public Adminfrm(){	
			inTable();
			jsp=new JScrollPane(table);
			
			txt[0]=new JTextField(5);
			txt[1]=new JTextField(5);
			txt[2]=new JTextField(5);
			for(int i=0;i<3;i++)
			a.add(txt[i]);
			a.add(btnModify);
			
			b.add(btnAdd);
			b.add(btnDel);
			b.add(btnUpdate);
			b.add(alt);
			
			d.setLayout(new GridLayout(2,1));
			d.add(a);
			d.add(b);
			
			this.setLayout(new BorderLayout());
			this.getContentPane().add(jsp,BorderLayout.CENTER);
			this.getContentPane().add(d,BorderLayout.SOUTH);
			//事件监听
			btnAdd.addActionListener(this);
			btnDel.addActionListener(this);
			btnUpdate.addActionListener(this);
			btnModify.addActionListener(this);
			
			queryAll();
			this.setSize(470,200);
			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<3;i++)
						txt[i].setText((String) table.getValueAt(row,i));
				}
			});
		}
		public void actionPerformed(ActionEvent e) {
			//修改
			if(e.getSource()==btnModify)
			{	Admin admin=new Admin();
				admin.setAdmin_id(txt[0].getText());
				admin.setAdmin_name(txt[1].getText());
				admin.setAdmin_pwd(txt[2].getText());
				new AdminManager().updateAdmin(admin);
				
				queryAll();
				for(int i=0;i<3;i++)
				txt[i].setText("");
			}//增加
			else if(e.getSource()==btnAdd)
			{
				new AdminAdd("增加管理员");
			}
			//删除
			else if(e.getSource()==btnDel)
			{
				int row=table.getSelectedRow();
				String admin_id=(String) table.getValueAt(row,0);
				
				if(row<0)
					JOptionPane.showMessageDialog(this,"警告!删除出错!");
				else if (row>0&&txt[2].getText().equals("admin"))
				{JOptionPane.showMessageDialog(this,"不能删除管理员！");}
				else if (row>=0)
				{
					@SuppressWarnings("unused") boolean flag=new AdminManager().delAdmin(admin_id);
					queryAll();
					for(int i=0;i<3;i++)
						txt[i].setText("");
				}
			}
			else if(e.getSource()==btnUpdate)
			{
				queryAll();
			}
		}
		private void inTable()
		{
			table = new JTable(dtm);
			dtm.addColumn("ID");
			dtm.addColumn("名字");
			dtm.addColumn("密码");
		}
		public void queryAll()
		{	
			DefaultTableModel dtm=new DefaultTableModel();
			dtm.addColumn("ID");
			dtm.addColumn("名字");
			dtm.addColumn("密码");
			
			AdminManager AM=new AdminManager();
			Vector v=AM.getAdmin();
			//返回数据库类型
			for(int i=0;i<v.size();i++)
			 {
				Admin admin = (Admin) v.get(i);
				 Object[]data = new Object[3];//表示一条记录
				 data[0] = admin.getAdmin_id();
				 data[1] = admin.getAdmin_name();
				 data[2] = admin.getAdmin_pwd();
				 
				 dtm.addRow(data);
			 }
			table.setModel(dtm);
		}
	}