vipshoppingframe.java

java写的vip会员录入与查询

package vip;
import java.sql.*; 
import javax.swing.*; 
//import javax.swing.event.*;
import java.awt.*; 
import java.awt.event.*; 
import java.util.*; 
import java.lang.*; 

public class VipShoppingFrame extends JDialog 
{
	private Connection Shoppingconnection; 
   	private Statement Shoppingstatement; 
   	private Statement VIPNamestatement; 
   	private Statement InsertInputstatement; 
   	private ResultSet ShoppingresultSet; 
   	private ResultSet VIPNameresultSet; 
   	
   	private ResultSetMetaData rsMetaData;
   
    
    //GUI变量定义
	private JLabel VipSerialLabel ;
	private JLabel VipNameLabel ;
	private JLabel VipCommoditySerialLabel ;
	private JLabel VipCommodityNameLabel ;
	private JLabel VipCommodityPriceLabel ;
	private JLabel VipCommodityRealPriceLabel ;
	
   	private JTextField VipSerialField;
   	private JTextField VipNameField;
   	private JTextField VipCommoditySerialField;
   	private JTextField VipCommodityNameField;
   	private JTextField VipCommodityPriceField;
   	private JTextField VipCommodityRealPriceField;
	
	private JButton SubmmitButton ;
	private JButton cancelButton ;
	private JFrame parent; 
    
    public VipShoppingFrame(JFrame parent, boolean modal) 
    {
        super(parent, modal);
        this.parent = parent;
        pack();
        
        initComponents(); 
        DatabaseConnection();
    }
    private void initComponents() 
    {
    	GridBagLayout layout = new GridBagLayout();
        Container contents = getContentPane();
        contents.setLayout(layout);

        GridBagConstraints constraints = new GridBagConstraints();

        setTitle ("VIP购物信息录入窗口");
        addWindowListener(new WindowAdapter () 
        {
            public void windowClosing(WindowEvent event) 
            {
                setVisible(false);
        		dispose();
            }
        });
        
        VipSerialField = new JTextField(); // needed below
        VipSerialField.setPreferredSize(new Dimension(150, 25));
        VipSerialLabel = new JLabel();
        VipSerialLabel.setText("V  I  P   号：        ");
        VipSerialLabel.setLabelFor(VipSerialField);
        constraints.weightx = 100;
        constraints.weighty = 100;
        constraints.gridx = 0;
        constraints.gridy = 0;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipSerialLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 0;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipSerialField, constraints);
        
        VipSerialField.addKeyListener (new java.awt.event.KeyAdapter()
        {
            public void keyReleased(KeyEvent e) 
            {
                
                ShowVipName();
                
            }
        });
        //2
        VipNameField = new JTextField(); // needed below
        VipNameField.setPreferredSize(new Dimension(150, 25));
        VipNameField.setEditable(false);
        //VipNameField.setBorder(BorderFactory.createLoweredBevelBorder());
        VipNameLabel = new JLabel();
        VipNameLabel.setText("会 员 姓 名：        ");
        VipNameLabel.setLabelFor(VipNameField);
        constraints.gridx = 0;
        constraints.gridy = 1;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipNameLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 1;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipNameField, constraints);
        //3
        VipCommoditySerialField = new JTextField(); // needed below
        VipCommoditySerialField.setPreferredSize(new Dimension(150, 25));
        VipCommoditySerialLabel = new JLabel();
        VipCommoditySerialLabel.setText("商 品 标 号：        ");
        VipCommoditySerialLabel.setLabelFor(VipCommoditySerialField);
        constraints.gridx = 0;
        constraints.gridy = 2;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipCommoditySerialLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 2;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipCommoditySerialField, constraints);
       
        VipCommoditySerialField.addKeyListener (new java.awt.event.KeyAdapter()
        {
            public void keyReleased(KeyEvent e) 
            {
                
                ShowPrice();
                
            }
        });
        //4
        VipCommodityNameField = new JTextField(); // needed below
        VipCommodityNameField.setPreferredSize(new Dimension(150, 25));
        VipCommodityNameField.setEditable(false);
        VipCommodityNameLabel = new JLabel();
        VipCommodityNameLabel.setText("商 品 名 称：        ");
        VipCommodityNameLabel.setLabelFor(VipCommodityNameField);
        constraints.gridx = 0;
        constraints.gridy = 3;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipCommodityNameLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 3;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipCommodityNameField, constraints);   
		//5
		VipCommodityPriceField = new JTextField(); // needed below
        VipCommodityPriceField.setPreferredSize(new Dimension(150, 25));
        VipCommodityPriceField.setEditable(false);
        VipCommodityPriceLabel = new JLabel();
        VipCommodityPriceLabel.setText("商 品 价 格：        ");
        VipCommodityPriceLabel.setLabelFor(VipCommodityPriceField);
        constraints.gridx = 0;
        constraints.gridy = 4;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipCommodityPriceLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 4;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipCommodityPriceField, constraints);    
        //6
		VipCommodityRealPriceField = new JTextField(); // needed below
        VipCommodityRealPriceField.setPreferredSize(new Dimension(150, 25));
        VipCommodityRealPriceField.setEditable(false);
        VipCommodityRealPriceLabel = new JLabel();
        VipCommodityRealPriceLabel.setText("实 收 价 格：        ");
        VipCommodityRealPriceLabel.setLabelFor(VipCommodityRealPriceField);
        constraints.gridx = 0;
        constraints.gridy = 5;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipCommodityRealPriceLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 5;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipCommodityRealPriceField, constraints); 
        
        JPanel buttonPanel = createButtonPanel(); // sets global loginButton
        constraints.gridx = 0;
        constraints.gridy = 6;
        constraints.gridwidth = 3;
        constraints.gridheight = 2;
        contents.add(buttonPanel, constraints);
        
        setSize( 450, 280 );
      	setResizable(false);
      	setLocation(200,100);	
    }
    
     private JPanel createButtonPanel() {

        JPanel panel = new JPanel();
        panel.setLayout(new BoxLayout(panel, 0));
        //panel.setSize( 490, 40 );
        //panel.setBorder(BorderFactory.createEtchedBorder());

        // login button (global variable)
        SubmmitButton = new JButton();
        SubmmitButton.setText("确  定");
        
        SubmmitButton.addActionListener(new ActionListener() 
        {