vipshoppingframe.java

java写的vip会员录入与查询

            public void actionPerformed(ActionEvent event) 
            {
                VipShoppingInfoInput();
            }
        });
        panel.add(SubmmitButton);

        // space
        panel.add(Box.createRigidArea(new Dimension(200,0)));

        // cancel button
        JButton cancelButton = new JButton();
        cancelButton.setText("返  回");
        
        cancelButton.addActionListener(new ActionListener() 
        {
            public void actionPerformed(ActionEvent event) 
            {
                dispose();
            }
        });
        panel.add(cancelButton);

        // space
        

        Vector buttons = new Vector(2);
        buttons.add(SubmmitButton);
        buttons.add(cancelButton);
        equalizeComponentSizes(buttons);
        buttons.removeAllElements(); // simplify gc
        return panel;
    } // createButtonPanel()


    private void equalizeComponentSizes(java.util.List components) {

        // Get the largest width and height
        int i = 0;
        Dimension maxPreferred = new Dimension(0,0);
        JComponent oneComponent = null;
        Dimension thisPreferred = null;
        for (i = 0; i < components.size(); ++i) {
            oneComponent = (JComponent)components.get(i);
            thisPreferred = oneComponent.getPreferredSize();
            maxPreferred.width =
                Math.max(maxPreferred.width, (int)thisPreferred.getWidth());
            maxPreferred.height =
                Math.max(maxPreferred.height, (int)thisPreferred.getHeight());
        }

        // reset preferred and maximum size since BoxLayout takes both
        // into account
        for (i = 0; i < components.size(); ++i) {
            oneComponent = (JComponent)components.get(i);
            oneComponent.setPreferredSize((Dimension)maxPreferred.clone());
            oneComponent.setMaximumSize((Dimension)maxPreferred.clone());
        }
    } // equalizeComponentSizes()
    
    private void ShowPrice()
    {
    	if(VipCommoditySerialField.getText().equals(""))
    	{
			return ;
		}    	
    	try
    	{
    		String CommodityQuery = "select 商品名称,商品价格,商品折扣 from COMMODITY_ID where 商品编号 = "+VipCommoditySerialField.getText()+"";
    		String CommodityName;
    		String CommodityPrice;
        	String CommodityDiscount;
      		String CommodityRealPrice;
      		
      		float  price;
      		float  discount;
      		float  realprice;
    		Shoppingstatement = Shoppingconnection.createStatement();
    		ShoppingresultSet = Shoppingstatement.executeQuery( CommodityQuery ); 
    	
    		boolean moreRecords = ShoppingresultSet.next();  
    		if ( !moreRecords ) 
      		{ 
         		JOptionPane.showMessageDialog( this,"对不起，无此商品号，请重新输入" ); 
         		//setTitle( "无记录显示" );
         		//VipCommoditySerialField.setText("");
         		VipCommodityNameField.setText("");
      			VipCommodityPriceField.setText("");
      			VipCommodityRealPriceField.setText("");
           		return; 
      		}  
      		CommodityName = ShoppingresultSet.getString( 1 );
      		CommodityPrice = ShoppingresultSet.getString( 2 );
      		CommodityDiscount = ShoppingresultSet.getString( 3 );
      		 
      		price = Float.parseFloat(CommodityPrice);
      		discount = Float.parseFloat(CommodityDiscount);
      		realprice = price*discount;
      		CommodityRealPrice = Float.toString(realprice);
      		
      		VipCommodityNameField.setText(CommodityName);
      		VipCommodityPriceField.setText(CommodityPrice);
      		VipCommodityRealPriceField.setText(CommodityRealPrice);
    	}
    	catch ( SQLException sqlex ) 
      	{ 
        	sqlex.printStackTrace(); 
      	}  
    }
    private void ShowVipName()
    {
    	if(VipSerialField.getText().equals(""))
    	{
			return ;
		}    	
    	
    	String VipNameQuery = "select 姓名 from VIPID where VIP编号 = "+VipSerialField.getText()+"";      		
      	String VipName;
      
      	try
      	{
      		VIPNamestatement  = Shoppingconnection.createStatement();
        	VIPNameresultSet  = VIPNamestatement.executeQuery( VipNameQuery ); 
        
        	boolean moreRecords1 = VIPNameresultSet.next(); 
         	 
      		if ( !moreRecords1 ) 
      		{ 
        	 	JOptionPane.showMessageDialog( this,"对不起，无此会员号，请重新输入" ); 
        	 		//setTitle( "无记录显示" );
        	 	//VipSerialField.setText("");
        	 	VipNameField.setText("");
        	 	return; 
      		}  
      		VipName = VIPNameresultSet.getString( 1 );
      		VipNameField.setText(VipName);
      	}
        catch ( SQLException sqlex ) 
      	{ 
        	sqlex.printStackTrace(); 
      	}  
    }
    private void VipShoppingInfoInput()
    {
    	if(
   		   VipSerialField.getText().equals( "" )||
   		   VipNameField.getText().equals("")||
   		   VipCommoditySerialField.getText().equals( "" )||
   		   VipCommodityNameField.getText().equals( "" )||
   		   VipCommodityPriceField.getText().equals( "" )||
   		   VipCommodityRealPriceField.getText().equals( "" ))
   		{
   			JOptionPane.showMessageDialog( this,"请填会员购物资料" ); 
         	//setTitle( "无记录显示" ); 
         	return; 	
   		}
   		
      	try 
      	{ 
      		 String ShoppingInput = "insert into CONSUME VALUES("
      		 					+VipSerialField.getText()+",'"+VipNameField.getText()+"',"
      		 					+VipCommoditySerialField.getText()+",'"+VipCommodityNameField.getText()+"',"
      		 					+VipCommodityPriceField.getText()+","+VipCommodityRealPriceField.getText()+")";
      		 Shoppingstatement = Shoppingconnection.createStatement();
      		 int insert = Shoppingstatement.executeUpdate( ShoppingInput );//executeUpdate返回一个整型值
      		 
      		 if (insert == 1)
      		 {
      		 	JOptionPane.showMessageDialog( this,"VIP用户购物信息登记成功！" );
      		 	VipSerialField.setText("");
   		   		VipNameField.setText("");
   		   		VipCommoditySerialField.setText("");
   		   		VipCommodityNameField.setText("");
   		   		VipCommodityPriceField.setText("");
   		   		VipCommodityRealPriceField.setText("");
   		   	
    		 } 
      	} 
      	catch ( SQLException sqlex ) 
      	{ 
        	sqlex.printStackTrace(); 
      	}  
        
   		    
    }
     private void DatabaseConnection()
     {
     	String url = "jdbc:odbc:VipQuery"; 
    	String username = ""; 
    	String password = ""; 
    	
    	
    	//加载驱动程序以连接数据库
      	try 
      	{ 
        	Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
        	Shoppingconnection = DriverManager.getConnection( url, username, password ); 
      	} 
      	//捕获加载驱动程序异常
      	catch ( ClassNotFoundException cnfex ) 
      	{ 
        	System.err.println("装载 JDBC/ODBC 驱动程序失败。" ); 
        	cnfex.printStackTrace(); 
         	System.exit( 1 );  // terminate program 
      	} 
      	//捕获连接数据库异常
      	catch ( SQLException sqlex ) 
      	{ 
         	System.err.println( "无法连接数据库" ); 
         	sqlex.printStackTrace(); 
         	System.exit( 1 );  // terminate program 
      	}
     }
}