超市商品管理系统源代码

                     import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class sale2  extends JFrame implements ActionListener  //销售界面

{

private JPanel sM=new JPanel();        //supermarket面板

JLabel label1,label2;

JTextField field1,field2;

JButton button1,button2;

String num=null,name=null,time=null,add=null,t1=null,t2=null,t3=null;

int price=0,countBG,n1;// 价格/商品的卖出数量

private JTextArea goodsShow=new JTextArea();        //文本区

private JScrollPane jsp=new JScrollPane(goodsShow);    //滚动区域 设定内容为 商品显示的文本区

private JButton[] pS={new JButton("销售界面"),

new JButton("销售管理"),

new JButton("商品管理"),

new JButton("用户管理")};            //personty 按钮

private JLabel[] CD={new JLabel("清单号",JLabel.CENTER),

new JLabel("编号",JLabel.CENTER),

new JLabel("名称",JLabel.CENTER),

new JLabel("价格",JLabel.CENTER),

new JLabel("生产日期",JLabel.CENTER),

new JLabel("产地",JLabel.CENTER),

new JLabel("数量",JLabel.CENTER)};        //帐单查询时的商品显示标签

public sale2()

{

label1=new JLabel("按编号查询",JLabel.CENTER);

label2=new JLabel("按帐单查询",JLabel.CENTER);

field1=new JTextField(30);

field2=new JTextField(30);

button1=new JButton("查询1");

button2=new JButton("查询2");

sM.setLayout(null);

field1.setBounds(100,120,150,22);

field2.setBounds(600,120,150,22);

label1.setBounds(100,90,150,30);

label2.setBounds(600,90,150,30);

button1.setBounds(260,120,80,22);

button2.setBounds(760,120,80,22);

button1.addActionListener(this);

button2.addActionListener(this);

sM.add(label1);

sM.add(label2);

sM.add(field1);

sM.add(field2);

sM.add(button1);

sM.add(button2);

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

{

pS[i].setBounds(550+i*110,50,100,22);

sM.add(pS[i]);

pS[i].addActionListener(this);

}

for(int i=0;i<7;i++)        //6个标签的绘制

{

CD[i].setBounds(100+i*115,160,115,20);

sM.add(CD[i]);

}

jsp.setBounds(100,180,800,500);

goodsShow.setLineWrap(true);

addWindowListener(new WindowAdapter() {

public void windowClosing(WindowEvent e) {

System.exit(0);

}

});

sM.add(jsp);

this.add(sM);

this.setTitle("销售窗口");

this.setResizable(false);

this.setBounds(0,0,1024,768);

this.setVisible(true);

}

public void actionPerformed(ActionEvent p)

{

Connection con,con1;

Statement sql,sql1;

String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\\\supermarket.mdb";

ResultSet rs,rs1;

if (p.getSource()==button1)

{

String num=field1.getText();

try    {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch (ClassNotFoundException f)

{

System.out.println(""+f);

}

try

{

con=DriverManager.getConnection(url);

sql=con.createStatement();

rs=sql.executeQuery("SELECT count(goodsnum) FROM information where goodsnum='"+num+"'");

while(rs.next())

{

countBG=rs.getInt(1);

System.out.println(countBG);

}

rs=sql.executeQuery("SELECT * FROM goods where num='"+num+"'");

while(rs.next())

{

name=rs.getString(2);

price=rs.getInt(3);

time=rs.getString(4);

add=rs.getString(5);

n1=1;

}

con.close();

}

catch (SQLException g)

{System.out.println(g);

}

if (n1==1)

{  goodsShow.append(" （物品销售量查询）              "+num+"                               "+name+"                              "+price+"                            "+time+"                         "+add+"                                 "+countBG+"\\n");

n1=0;

}

else 

{

//goodsShow.setText(" ");

num=null;name=null;price=0;time=null;add=null;

JOptionPane.showMessageDialog(this,"                  输入错误\\n                请重新输入","提示",JOptionPane.WARNING_MESSAGE);

}

}

if(p.getSource()==pS[0])

{

View2 frame=new View2();

dispose();

}

if(p.getSource()==pS[2])

{

Frm_Main frame=new Frm_Main();

dispose();

}

if(p.getSource()==pS[3])

{

View3 frame=new View3();

dispose();

}

if (p.getSource()==button2)

{

String numb=field2.getText();

int num=Integer.parseInt(numb);

try    {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch (ClassNotFoundException f)

{

System.out.println(""+f);

}

try

{

con=DriverManager.getConnection(url);

sql=con.createStatement();

rs=sql.executeQuery("SELECT goodsnum,count(goodsnum) FROM information where listnum="+num+" group by goodsnum");

while(rs.next())

{    con1=DriverManager.getConnection(url);

sql1=con1.createStatement();

String number=rs.getString(1); 

countBG=rs.getInt(2);

System.out.println(countBG+number+name+time+price+add);

rs1=sql1.executeQuery("SELECT * FROM goods where num='"+number+"'");

while (rs1.next())

{

name=rs1.getString(2);

price=rs1.getint(3);

time=rs1.getString(4);

add=rs1.getString(5);

goodsShow.append("                "+num+"                                 "+number+"                               "+name+"                              "+price+"                            "+time+"                         "+add+"                                 "+countBG+"\\n");

}  

con1.close();

}

con.close();

}

catch (SQLException g)

{System.out.println(g);

}

//{

//     goodsShow.setText(" ");

//     num=null;name=null;price=0;time=null;add=null;

//     JOptionPane.showMessageDialog(this,"                  

                     输入错误\\n                请重新输入","提示",JOptionPane.WARNING_MESSAGE);

// }

}

}

}    

public class View2 extends JFrame implements ActionListener  //销售界面

{

String num=null,name=null,time=null,add=null,t1=null,t2=null,t3=null;

int price=0;

int n1,n2,ap,n3;

private JPanel sM=new JPanel(); //supermarket面板

private JButton[] pS={new JButton("销售界面"),new JButton("销售管理"),

new JButton("商品管理"),new JButton("权限管理")};//personty 按钮

private JTextArea goodsShow=new JTextArea(), searchShow=new JTextArea();   //文本区

private JScrollPane jsp=new JScrollPane(goodsShow);    //滚动区域 设定内容为 商品显示的文本区

private JTextField numSearch=new JTextField(),showGoods=new JTextField();  //商品查询/显示商品

private JButton searchGoods=new JButton("搜索"),buyGoods=new JButton("购买"), 

clean=new JButton("清空"), ok=new JButton("提交"),print=new JButton("打印并提交");  //查询按钮

private JLabel[] goodsInformation={new JLabel("商品编码",JLabel.CENTER),new JLabel("商品名称",JLabel.CENTER),

new JLabel("商品价格",JLabel.CENTER),new JLabel("生产日期",JLabel.CENTER),new JLabel("生产地",JLabel.CENTER) };

private JLabel[] goodsI={new JLabel("商品编码",JLabel.CENTER),new JLabel("商品名称",JLabel.CENTER),

new JLabel("商品价格",JLabel.CENTER),new JLabel("生产日期",JLabel.CENTER),new JLabel("生产地",JLabel.CENTER) } ;              

private JLabel allPrice=new JLabel("商品总价：\\n  ",JLabel.LEFT),label1=new JLabel("商品信息  ",JLabel.RIGHT),label2=new JLabel("购物信息  ",JLabel.RIGHT);

public View2()

{

sM.setLayout(null);

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

{

pS[i].setBounds(550+i*110,50,100,22);

sM.add(pS[i]);

pS[i].addActionListener(this);

}

jsp.setBounds(100,180,800,500);

goodsShow.setLineWrap(true);

numSearch.setBounds(100,50,150,22);

searchGoods.setBounds(260,50,60,22);

searchGoods.addActionListener(this);

buyGoods.setBounds(330,50,60,22);

buyGoods.addActionListener(this);

showGoods.setBounds(100,120,800,22);

for (int b=0;b<5 ;b++ )

{

goodsInformation[b].setBounds(100+160*b,87,160,30);

sM.add(goodsInformation[b]);

}

for (int b=0;b<5 ;b++ )

{

goodsI[b].setBounds(100+160*b,150,160,30);

sM.add(goodsI[b]);

}

clean.setBounds(100,690,100,22);

clean.addActionListener(this);

ok.setBounds(690,690,100,22);

ok.addActionListener(this);

print.setBounds(800,690,100,22);

print.addActionListener(this);

allPrice.setBounds(900,480,100,50);

label1.setBounds(20,120,80,22);

label2.setBounds(20,180,80,22);

sM.add(label1);

sM.add(label2);

sM.add(allPrice);

sM.add(print);

sM.add(ok);

sM.add(showGoods);

sM.add(clean);

sM.add(numSearch

                     );

sM.add(searchGoods);

sM.add(buyGoods);

sM.add(jsp);

addWindowListener(new WindowAdapter() {

public void windowClosing(WindowEvent e) {

Connection con;

Statement sql;

ResultSet rs;

try

{

if (n3!=0)

{

int a1=0;

con=DriverManager.getConnection("jdbc:odbc:q","","");

sql=con.createStatement();

rs=sql.executeQuery("SELECT MAX(编号) from information");

while(rs.next())

{

a1=rs.getInt(1);}

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

{

sql.executeUpdate("delete from information where 编号="+(a1-i));

}

con.close();

ap=0;

num=null;name=null;price=0;time=null;add=null;n3=0;

goodsShow.setText(null);

}

}

catch (SQLException g)

{System.out.println(g);

}

System.exit(0);

}

});

this.add(sM);

this.setTitle("销售窗口");

this.setResizable(false);

this.setBounds(0,0,1024,768);

this.setVisible(true);

validate();    }

if(p.getSource()==buyGoods)  //购买按键 

{

try

{

if (num!=null)

{con=DriverManager.getConnection("jdbc:odbc:q","","");

sql=con.createStatement();

sql.executeUpdate("insert into information(listnum,goodsnum) values('"+n2+"','"+num+"')");

rs=sql.executeQuery("SELECT * FROM information where listnum="+n2);

n3++;//记录购买商品个数

con.close();

goodsShow.append("                       "+num+"                                       "+name+"                                                   "+price+"                                           "+time+"                                      "+add+"\\n"); }

else

{JOptionPane.showMessageDialog(this,"请选择商品","提示",JOptionPane.WARNING_MESSAGE);}

ap=ap+price;//总价

allPrice.setText("商品总价：\\n"+ap);

}

catch (SQLException g)

{System.out.println(g);

}

}

if(p.getSource()==ok)

{

try

{

if (n3!=0)

{

con=DriverManager.getConnection("jdbc:odbc:q","","");

sql=con.createStatement();

sql.executeUpdate("insert into information(listnum,allprice) values('"+n2+"','"+ap+"')");

rs=sql.executeQuery("SELECT * FROM information where listnum="+n2);

con.close();

ap=0;

num=null;name=null;price=0;time=null;add=null;n3=0;

goodsShow.setText(null);

n2++;//帐单号

}

else

{JOptionPane.showMessageDialog(this,"请购买商品","提示",JOptionPane.WARNING_MESSAGE);}

}

catch (SQLException g)

{System.out.println(g);

}

}

if(p.getSource()==print)

{

try

{

if (n3!=0)

{

con=DriverManager.getConnection("jdbc:odbc:q","","");

sql=con.createStatement();

sql.executeUpdate("insert into information(listnum,allprice) values('"+n2+"','"+ap+"')");

rs=sql.executeQuery("SELECT * FROM information

                     where listnum="+n2);

con.close();

ap=0;

num=null;name=null;price=0;time=null;add=null;n3=0;

goodsShow.setText(null);

n2++;//帐单号

}

else

{JOptionPane.showMessageDialog(this,"请购买商品","提示",JOptionPane.WARNING_MESSAGE);}

}

catch (SQLException g)

{System.out.println(g);

}

}

if(p.getSource()==clean)

{ try

{ if (n3!=0)

{ int a1=0;

con=DriverManager.getConnection("jdbc:odbc:q","","");

sql=con.createStatement();

rs=sql.executeQuery("SELECT MAX(编号) from information");

while(rs.next()) {

a1=rs.getInt(1);}

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

{ sql.executeUpdate("delete from information where 编号="+(a1-i)); }

con.close();

ap=0;

num=null;name=null;price=0;time=null;add=null;n3=0;

goodsShow.setText(null);}    }

catch (SQLException g)

{System.out.println(g);} }

public class Login extends Frame implements ActionListener,WindowListener //登陆界面

{

public int screanWidth,screanHeight;

String idin=null;

String keyin=null;

String passwordD=null;

public static String persontyD=null;

MenuBar menubar;

Menu menu;

MenuItem quet,help;

Label id,key;

TextField idtf,keytf;

Box boxV1,boxV2,boxV3,baseBox,boxx;

Button enterB;

Login()

{  setTitle("超市管理系统登陆界面");

Toolkit tool=getToolkit();

Dimension dim=tool.getScreenSize();

screanWidth=dim.width;

screanHeight=dim.height;

setBounds(dim.width/3,dim.height/3,320,215);

menubar=new MenuBar();

menu=new Menu("功能");

help=new MenuItem("帮助");

quet=new MenuItem("退出");

quet.setShortcut(new MenuShortcut(KeyEvent.VK_E));

quet.addActionListener(new ActionListener()          //匿名类实例控制

{

public void actionPerformed(ActionEvent p){

System.exit(0);

}} );

menu.add(help);

menu.add(quet);

menubar.add(menu);

setMenuBar(menubar);

id=new Label("请输入帐号：",Label.RIGHT);

key=new Label("请输入密码：",Label.RIGHT);

idtf=new TextField(10);

keytf=new TextField(10);

keytf.setEchoChar('*');

enterB=new Button("登陆");

boxV1=Box.createVerticalBox();

boxV1.add(Box.createVerticalStrut(35));

boxV1.add(id);

boxV1.add(Box.createVerticalStrut(15));

boxV1.add(key);

boxV1.add(Box.createVerticalStrut(15));

boxV2=Box.createVerticalBox();

boxV2.add(Box.createVerticalStrut(35));

boxV2.add(idtf);

boxV2.add(Box.createVerticalStrut(15));

boxV2.add(keytf);

boxV2.add(Box.createVerticalStrut(15));

baseBox=Box.createHorizontalBox();

baseBox.add(Box.createHorizontalStrut(25));

baseBox.add(boxV1);

baseBox.add(Box.createHorizontalStrut(5));

baseBox.add(boxV2);

baseBox.add(Box.createHorizontalStrut(70));

boxV3=Box.createHorizontalBox();

boxV3.add(Box.createHorizontalStrut(125));

boxV3.add(enterB);

boxV3.add(Box.createHorizontalStrut(125));

boxx=Box.createVerticalBox();

boxx.add(baseBox);

boxx.add(Box

                     .createVerticalStrut(15));

boxx.add(boxV3);

boxx.add(Box.createVerticalStrut(70));

add(boxx);

enterB.addActionListener(this);

addWindowListener(this);

setResizable(false);

setVisible(true);

}

public void actionPerformed(ActionEvent e)

{    Connection con;

Statement sql;

ResultSet rs;

if (e.getSource()==enterB)

{    idin=idtf.getText();

keyin=keytf.getText();

try    {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    }

catch (ClassNotFoundException f)

{System.out.println(""+f);}

try

{con=DriverManager.getConnection("jdbc:odbc:q","","");

sql=con.createStatement();

rs=sql.executeQuery("SELECT * FROM password where ID='"+idin+"'");

while(rs.next()){

passwordD=rs.getString(2);

persontyD=rs.getString(3);}

con.close();}

catch (SQLException g)

{System.out.println(g);}

if (keyin.equals(passwordD))

{View2 frame=new View2();

this.setVisible(false); }

else {JOptionPane.showMessageDialog(this,"            帐户或密码错误\\n                请重新输入","提示",JOptionPane.WARNING_MESSAGE); }    }    }

public void windowActivated(WindowEvent o)

{validate();}

public void windowDeactivated(WindowEvent o)

{setBounds(screanWidth/3,screanHeight/3,320,215);

validate();}

public void windowClosing(WindowEvent o)

{dispose();}

public void windowClosed(WindowEvent o)

{System.exit(0);}

public void windowIconified(WindowEvent o)

{}

public void windowDeiconified(WindowEvent o)

{setBounds(screanWidth/3,screanHeight/3,320,215);

validate();}

public void windowOpened(WindowEvent o){}

}