超市管理系统设计代码

import java.awt.*;

import java.awt.event.*;

import javax.swing.table.*;

import javax.swing.event.*;

import javax.swing.*;

import java.sql.*;

import java.util.*;

import java.io.*;

class Myframe1 extends JFrame //设置主界面{

JFrame f=new JFrame();

JLabel L1,L2;

JButton btn1,btn2,btn3,btn4;

public Myframe1()

{

f=new JFrame("主界面");

L1=new JLabel("超市商品管理系统欢迎您");

L1.setFont(new Font("TimesRoman",Font.BOLD,18));

L2=new JLabel("您辛苦了~~~~");

L2.setFont(new Font("TimesRoman",Font.BOLD,18));

btn1=new JButton("进货管理系统");

btn2=new JButton("售货管理系统");

btn3=new JButton("商品信息管理");

btn4=new JButton("管理系统帮助");

Container container=this.getContentPane();

container.setLayout(new GridLayout(9,3,0,50));

for(int i=0;i<3;i++)

container.add(new JLabel());

container.add(new JLabel()); container.add(L1);

container.add(new JLabel());

container.add(new JLabel()); container.add(btn1);

container.add(new JLabel());

container.add(new JLabel()); container.add(btn2);

container.add(new JLabel());

container.add(new JLabel()); container.add(btn3);

container.add(new JLabel());

container.add(new JLabel()); container.add(btn4);

container.add(new JLabel());

container.add(new JLabel()); container.add(L2);

container.add(new JLabel());

container.setBackground(Color.cyan);

f.add(container);

f.setLocation(60,60);

f.setSize(750,650);

f.setVisible(true);

Montior bn=new Montior();

btn1.addActionListener(bn);

btn2.addActionListener(bn);

btn3.addActionListener(bn);

btn4.addActionListener(bn);

}

class Montior implements ActionListener

{

public void actionPerformed(ActionEvent e1) {

if(e1.getSource()==btn1)

{

new Myframe2();

}

if(e1.getSource()==btn2)

{

new Myframe3();

}

if(e1.getSource()==btn3)

{

new Myframe4();

}

if(e1.getSource()==btn4)

{

new bangzhu();

}

}

}

}

class bangzhu extends JFrame

{

JTextPane ta=new JTextPane();

JScrollPane sp=new JScrollPane(ta);

public bangzhu()

{

super("管理系统帮助");

ta.setFont(new Font("TimesRoaman",Font.BOLD+Font.PLAIN,20));

ta.setText(" 1.初次进入登录系统，系统中没有售货员信息，可以进入系统但是为了以后能够使用方便\n"+

" 还是增加售货员信息，以便下次登录。"+

" 2.通过编号和密码验证后，进入系统主界面，但是为了能方便的进行操作，要在添加商品信息"+

" 3.添加了商品信息和售货员信息，即可根据信息进行填写别的表操作。");

ta.setEditable(false);

Container container=this.getContentPane();

container.setLayout(new BorderLayout());

container.add(new JLabel(),BorderLayout.NORTH);

container.add(new JLabel(),BorderLayout.WEST);

container.add(new JLabel(),BorderLayout.EAST);

container.add(new JLabel(),BorderLayout.SOUTH);

container.add(sp,BorderLayout.CENTER);

this.setSize(400,330);

this.setVisible(true);

}

}

class Myframe2 extends JFrame //设置进货系统的界面

{

Pstock stock=new Pstock();

Ptrademan trademan=new Ptrademan();

JTabbedPane pane;

Myframe2()

{

super("进货管理系统");

pane=new JTabbedPane(JTabbedPane.TOP);

pane.add("进货单信息",stock);

pane.add("进货商信息",trademan);

this.add(pane);

this.setSize(700,550);

this.setLocation(100,100);

this.setVisible(true);

}

class Pstock extends JPanel implements ActionListener //添加进货单管理的组件 {

private database db=new database();

ResultSet rs;

Panel p;

Panel p1;

JTextArea t;

JButton btn1,btn2,btn3,btn4,btn5,btn6;

JLabel L1,L2;

//表格设置

JTable table;

JScrollPane scrollpane;

Vector vector;

AbstractTableModel tm;

String title[]={"条形码","供应商名","进货价","进货日期","进货量"}; Pstock()

{

create();

p=new Panel();

p1=new Panel();

btn1=new JButton("填写新的进货单");

btn2=new JButton("解除购买某商品");

btn3=new JButton("修改进货单信息");

btn4=new JButton("查询进货单信息");

btn5=new JButton("显示进货单所有信息");

btn6=new JButton("进货商品的总金额");

L1=new JLabel("进货单的信息显示栏",JLabel.CENTER);

L1.setFont(new Font("TimesRoman",Font.BOLD,16));

L2=new JLabel("进货单信息管理",JLabel.CENTER);

L2.setFont(new Font("TimesRoman",Font.BOLD,16));

p.setLayout(new GridLayout(9,1,20,20));

p.add(L2);

p.add(btn1);

p.add(btn2);

p.add(btn3);

p.add(btn4);

p.add(btn6);

p.add(btn5);

p.add(new JLabel());

p.add(new JLabel());

p1.setLayout(new BorderLayout());

p1.add(L1,BorderLayout.NORTH);

p1.add(scrollpane,BorderLayout.CENTER);

this.setLayout(new BorderLayout());

this.add(p1,BorderLayout.CENTER);

this.add(p,BorderLayout.EAST);

btn1.addActionListener(this);

btn2.addActionListener(this);

btn3.addActionListener(this);

btn4.addActionListener(this);

btn5.addActionListener(this);

btn6.addActionListener(this);

}

public void actionPerformed(ActionEvent e2) {

if(e2.getSource()==btn1)

{

new tianxie();

}

if(e2.getSource()==btn2)

{

new shanchu();

}

if(e2.getSource()==btn3)

{

new xiugai();

}

if(e2.getSource()==btn4)

{

new chaxun();

}

if(e2.getSource()==btn5) //数据库区显示进货单所有信息 { int flag=0;

try

{

rs=db.select("select * from stocklist");

vector.removeAllElements();

while(rs.next())

{

flag=1;

Vector rec_vector=new Vector();

rec_vector.addElement(rs.getString(1));

rec_vector.addElement(rs.getString(2));

rec_vector.addElement(rs.getString(3));

rec_vector.addElement(rs.getString(4));

rec_vector.addElement(rs.getString(5));

vector.addElement(rec_vector);

}

tm.fireTableStructureChanged();

if(flag==0)

{

JOptionPane.showMessageDialog(null,"还没有进货单信息");

}

}catch(SQLException ee){ee.printStackTrace();}

}

if(e2.getSource()==btn6)

{

new jine();

}

}

void create()

{

vector = new Vector();

tm = new AbstractTableModel()

{

public int getColumnCount()

{

return title.length; //取得表格列数

}

public int getRowCount()

{

return vector.size(); //取得表格行数

}

public Object getValueAt(int row,int column)

{

if(!vector.isEmpty()) //取得单元格中的属性值

return ((Vector)vector.elementAt(row)).elementAt(column); else

return null;

}

public String getColumnName(int column)

{

return title[column]; //设置表格列名

}

public void setValueAt(Object value,int row,int column)

{

//数据模型不可编辑，该方法设置为空

}

public Class getColumnClass(int c)

{

return getValueAt(0,c).getClass(); //取得列所属对象类

}

public boolean isCellEditable(int row,int column)

{

return false;//设置单元格不可编辑，为缺省实现

}

};

table=new JTable(tm);

table.setToolTipText("显示内容");

table.setAutoResizeMode(table.AUTO_RESIZE_OFF);

table.setCellSelectionEnabled(false);

table.setShowHorizontalLines(true);

table.setShowVerticalLines(true);

scrollpane=new JScrollPane(table);

}

}

class Ptrademan extends JPanel implements ActionListener //进货商管理信息 {

private database db=new database();

ResultSet rs;

Panel p;

Panel p1;

JButton btn1,btn2,btn3,btn4,btn5;

JLabel L1,L2;

//表格设置

JTable table;

JScrollPane scrollpane;

Vector vector;

AbstractTableModel tm;

String title[]={"供应商名","电话","条形码","进货价"};

Ptrademan()

{

create();

p=new Panel();

p1=new Panel();

btn1=new JButton("填写新的进货商");

btn2=new JButton("删除进货商信息");

btn3=new JButton("修改进货商信息");

btn4=new JButton("查询进货商信息");

btn5=new JButton("显示进货商所有信息");

L1=new JLabel("进货商信息显示栏",JLabel.CENTER);

L1.setFont(new Font("TimesRoman",Font.BOLD,16));

L2=new JLabel("进货商信息管理",JLabel.CENTER);

L2.setFont(new Font("TimesRoman",Font.BOLD,16));

p.setLayout(new GridLayout(9,1,20,20));

p.add(L2);

p.add(btn1);

p.add(btn2);

p.add(btn3);

p.add(btn4);

p.add(new JLabel());

p.add(btn5);

p.add(new JLabel());

p.add(new JLabel());

p1.setLayout(new BorderLayout());

p1.add(L1,BorderLayout.NORTH);

p1.add(scrollpane,BorderLayout.CENTER);

this.setLayout(new BorderLayout());

this.add(p1,BorderLayout.CENTER);

this.add(p,BorderLayout.WEST);

btn1.addActionListener(this);

btn2.addActionListener(this);

btn3.addActionListener(this);

btn4.addActionListener(this);

btn5.addActionListener(this);

}

void create()

{

vector = new Vector();

tm = new AbstractTableModel(){

public int getColumnCount(){

return title.length; //取得表格列数

}

public int getRowCount(){

return vector.size(); //取得表格行数

}

public Object getValueAt(int row,int column){

if(!vector.isEmpty()) //取得单元格中的属性值

return ((Vector)vector.elementAt(row)).elementAt(column); else

return null;

}

public String getColumnName(int column){

return title[column]; //设置表格列名

}

public void setValueAt(Object value,int row,int column){

//数据模型不可编辑，该方法设置为空

}

public Class getColumnClass(int c){

return getValueAt(0,c).getClass(); //取得列所属对象类

}

public boolean isCellEditable(int row,int column){

return false;//设置单元格不可编辑，为缺省实现

}

};

table=new JTable(tm);

table.setToolTipText("显示内容");

table.setAutoResizeMode(table.AUTO_RESIZE_OFF);

table.setCellSelectionEnabled(false);

table.setShowHorizontalLines(true);

table.setShowVerticalLines(true);

scrollpane=new JScrollPane(table);

}

public void actionPerformed(ActionEvent e2)

{

if(e2.getSource()==btn1)

{

new tianxieshang();

}

if(e2.getSource()==btn2)

{

new shanchushang();

}

if(e2.getSource()==btn3)

{

new xiugaishang();

}

if(e2.getSource()==btn4)

{

new chaxunshang();

}

if(e2.getSource()==btn5) //完成数据库区显示进货商所有信息 {

try

{

int flag=0;

rs=db.select("select * from tradesman");

vector.removeAllElements();

while(rs.next())

{

flag=1;

Vector rec_vector=new Vector();

rec_vector.addElement(rs.getString(1));

rec_vector.addElement(rs.getString(2));

rec_vector.addElement(rs.getString(3));

rec_vector.addElement(rs.getString(4));

vector.addElement(rec_vector);

}

tm.fireTableStructureChanged();

if(flag==0)

{

JOptionPane.showMessageDialog(null,"还没有任何进货商信息");

}

}catch(SQLException ee){ee.printStackTrace();}

}

}

}

}

class Myframe3 extends JFrame //设置售货系统的界面{

Plist list=new Plist();

Psalesman salesman=new Psalesman();

JTabbedPane pane;

Myframe3()

{

super("售货管理系统");

pane=new JTabbedPane(JTabbedPane.TOP);

pane.add("收银清单信息",list);

pane.add("售货员信息",salesman);

this.add(pane);

this.setSize(700,550);

this.setLocation(100,100);

this.setVisible(true);

}

class Plist extends JPanel implements ActionListener //添加收银清单的组件 {

private database db=new database();

ResultSet rs;

JPanel p1=new JPanel();

JPanel p2=new JPanel();

JButton btn1,btn2,btn3,btn4,btn5;

JLabel L=new JLabel("显示信息栏",JLabel.CENTER);

//表格设置

JTable table;

JScrollPane scrollpane;

Vector vector;

AbstractTableModel tm;

String title[]={"条形码","零售价","售货员编号","售出量"};

Plist()

{

create();

btn1=new JButton("填写新的清单");

btn2=new JButton("删除清单");

btn3=new JButton("修改清单");

btn4=new JButton("收银清单金额");

btn5=new JButton("全部清单信息");

p1.setLayout(new GridLayout(1,4,20,20));

p1.add(btn1); p1.add(btn2); p1.add(btn3); p1.add(btn4); p1.add(btn5);

p2.setLayout(new BorderLayout());

p2.add(L,BorderLayout.NORTH);

p2.add(scrollpane,BorderLayout.CENTER);

this.setLayout(new BorderLayout());

this.add(p1,BorderLayout.NORTH);

this.add(p2,BorderLayout.CENTER);

this.setVisible(true);

btn1.addActionListener(this);

btn2.addActionListener(this);

btn3.addActionListener(this);

btn4.addActionListener(this);

btn5.addActionListener(this);

}

void create()

{

vector = new Vector();

tm = new AbstractTableModel(){

public int getColumnCount(){

return title.length; //取得表格列数

}

public int getRowCount(){

return vector.size(); //取得表格行数

}

public Object getValueAt(int row,int column){

if(!vector.isEmpty()) //取得单元格中的属性值

return ((Vector)vector.elementAt(row)).elementAt(column); else

return null;

}

public String getColumnName(int column){

return title[column]; //设置表格列名

}

public void setValueAt(Object value,int row,int column){

//数据模型不可编辑，该方法设置为空

}

public Class getColumnClass(int c){

return getValueAt(0,c).getClass(); //取得列所属对象类

}

public boolean isCellEditable(int row,int column){

return false;//设置单元格不可编辑，为缺省实现

}

};

table=new JTable(tm);

table.setToolTipText("显示内容");

table.setAutoResizeMode(table.AUTO_RESIZE_OFF);

table.setCellSelectionEnabled(false);

table.setShowHorizontalLines(true);

table.setShowVerticalLines(true);

scrollpane=new JScrollPane(table);

}

public void actionPerformed(ActionEvent e)

{

if(e.getSource()==btn1)

{

new addlist();

}

if(e.getSource()==btn2)

{

new deletelist();

}

if(e.getSource()==btn3)

{

new updatelist();

}

if(e.getSource()==btn4)

{

new tongji();

}

if(e.getSource()==btn5) //完成查询所有收银清单信息的功能

{

int flag=0;

try

{

rs=db.select("select * from list");

vector.removeAllElements();

while(rs.next()==true)

{

flag=1;

Vector rec_vector=new Vector();

rec_vector.addElement(rs.getString(1));

rec_vector.addElement(rs.getString(2));

rec_vector.addElement(rs.getString(3));

rec_vector.addElement(rs.getString(4));

vector.addElement(rec_vector);

}

tm.fireTableStructureChanged();

if(flag==0)

{

JOptionPane.showMessageDialog(null,"系统还没有任何收银清单信息");

}

}catch(SQLException ee){ee.printStackTrace();}

}

}

}

class Psalesman extends JPanel implements ActionListener //售货员信息管理 {

private database db=new database();

ResultSet rs;

JButton btn1,btn2,btn3,btn4,btn5;

JLabel L;

JPanel p1=new JPanel();

JPanel p2=new JPanel();

//表格设置

JTable table;

JScrollPane scrollpane;

Vector vector;

AbstractTableModel tm;

String title[]={"售货员姓名","售货员编号","密码","所在机号"};

Psalesman()

{

create();

btn1=new JButton("增加售货员");

btn2=new JButton("删除售货员");

btn3=new JButton("查询售货员");

btn4=new JButton("售货员业绩");

btn5=new JButton("全部售货员信息");

L=new JLabel("显示信息栏",JLabel.CENTER);

p1.setLayout(new GridLayout(1,5,20,20));

p1.add(btn1);

p1.add(btn2);

p1.add(btn3);

p1.add(btn4);

p1.add(btn5);

p2.setLayout(new BorderLayout());

p2.add(L,BorderLayout.NORTH);

p2.add(scrollpane,BorderLayout.CENTER);

this.setLayout(new BorderLayout());

this.add(p1,BorderLayout.NORTH);

this.add(p2,BorderLayout.CENTER);

this.setVisible(true);

btn1.addActionListener(this);

btn2.addActionListener(this);

btn3.addActionListener(this);

btn4.addActionListener(this);

btn5.addActionListener(this);

}

void create()

{

vector = new Vector();

tm = new AbstractTableModel(){

public int getColumnCount(){

return title.length; //取得表格列数

}

public int getRowCount(){

return vector.size(); //取得表格行数

}

public Object getValueAt(int row,int column){

if(!vector.isEmpty()) //取得单元格中的属性值

return ((Vector)vector.elementAt(row)).elementAt(column); else

return null;

}

public String getColumnName(int column){

return title[column]; //设置表格列名

}

public void setValueAt(Object value,int row,int column){

//数据模型不可编辑，该方法设置为空

}

public Class getColumnClass(int c){

return getValueAt(0,c).getClass(); //取得列所属对象类

}

public boolean isCellEditable(int row,int column){

return false;//设置单元格不可编辑，为缺省实现

}

};

table=new JTable(tm);

table.setToolTipText("显示内容");

table.setAutoResizeMode(table.AUTO_RESIZE_OFF);

table.setCellSelectionEnabled(false);

table.setShowHorizontalLines(true);

table.setShowVerticalLines(true);

scrollpane=new JScrollPane(table);

}

public void actionPerformed(ActionEvent e)

{

if(e.getSource()==btn1)