www.pudn.com > safsafas.rar > MainFrame.java
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
class MainFrame extends JFrame
{
private Dimension Size;
private JLabel index;
private int Height,Width;
private Container contentPane;
private JPanel panel1,panel2;
private JMenuBar jmb;
private JMenu Normalmode,Vipmode;
private JMenuItem Enter,quit,shouzhi,biaojia,tuichu;
private GridBagLayout layout;
private GridBagConstraints gbc;
private JLabel cardNum,goodNum,gid,gname,gNum,gcost,gprice,index1,index2,index3,gid1,gprice1,gid2,shouru,zhichu;
private JTextField t_cardNum,t_goodNum,t_gid,t_gname,t_gNum,t_gcost,t_gprice,t_gresult,t_gid1,t_gprice1,t_gid2,t_shouru,t_zhichu;
private JTextArea result;
private JButton accept,cancel,chkout,add1,delete1,modify,search,save,search1;
private String url="jdbc:odbc:good";
private Connection conn;
private Statement stmt;
private ResultSet rs;
private Vector total;
private String sql1,temp;
private PreparedStatement pstmt;
private float[] total1;
private Listener lis1;
public MainFrame()
{
init();
this.setTitle("超市管理系统V1.0");
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
// this.setSize(400,400);
this.show();
}
public void init()
{
Toolkit kit=this.getToolkit();
Size=kit.getScreenSize();
Width=Size.width;
Height=Size.height;
this.setSize(2*Width/3,2*Height/3);
this.setLocation(Width/6,Height/6);
lis1=new Listener();
total=new Vector();
layout=new GridBagLayout();
gbc=new GridBagConstraints();
index=new JLabel("超市管理系统V1.0");
index.setFont(new Font("Test",Font.PLAIN,15));
contentPane=this.getContentPane();
panel1=new JPanel();
contentPane.add(panel1,BorderLayout.CENTER);
panel1.add(index);
jmb=new JMenuBar();
Normalmode=new JMenu("服务模式");
Vipmode=new JMenu("管理模式");
Enter=new JMenuItem("进入系统");
Enter.addActionListener(lis1);
quit=new JMenuItem("退出");
quit.addActionListener(lis1);
shouzhi=new JMenuItem("收支管理");
shouzhi.addActionListener(lis1);
biaojia=new JMenuItem("货品管理");
biaojia.addActionListener(lis1);
tuichu=new JMenuItem("退出管理");
tuichu.addActionListener(lis1);
Normalmode.add(Enter);
Normalmode.add(quit);
Vipmode.add(shouzhi);
Vipmode.add(biaojia);
Vipmode.add(tuichu);
jmb.add(Normalmode);
jmb.add(Vipmode);
this.setJMenuBar(jmb);
}
void service()
{
panel1.removeAll();
panel1.setLayout(layout);
result=new JTextArea(12,40);
result.setEditable(false);
result.setText(" 商品编号 商品名称 价格 \n");
cardNum=new JLabel("会员卡号 : ");
goodNum=new JLabel("商品编号 : ");
t_cardNum=new JTextField(6);
t_cardNum.setText("#");
t_goodNum=new JTextField(6);
t_goodNum.setText("#");
accept=new JButton("提交");
accept.addActionListener(lis1);
cancel=new JButton("取消");
cancel.addActionListener(lis1);
chkout=new JButton("结算");
chkout.addActionListener(lis1);
addTo(result,gbc,0,0,4,4);
addTo(cardNum,gbc,0,4,1,1);
addTo(t_cardNum,gbc,1,4,1,1);
addTo(goodNum,gbc,2,4,1,1);
addTo(t_goodNum,gbc,3,4,1,1);
addTo(accept,gbc,0,5,1,1);
addTo(cancel,gbc,1,5,1,1);
addTo(chkout,gbc,2,5,1,1);
panel1.repaint();
this.show();
}
void listx()
{
String card=t_cardNum.getText();
String good=t_goodNum.getText();
if(good.equals("#"))
JOptionPane.showMessageDialog(this,"请输入商品编号!");
else
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(url,"","");
stmt=conn.createStatement();
String sql="select * from good where gid='"+good+"'";
String sql1="update good set gNum=gNum-1 where gid='"+good+"'";
stmt.execute(sql1);
rs=stmt.executeQuery(sql);
while(rs.next())
{
String price=rs.getString(5);
result.append(" "+rs.getString(1)+" "+rs.getString(2)+" "+price+"元\n");
total.addElement(price);
}
total1=new float[total.size()+1];
for (int j=0;j