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

public class VipInputFrame extends JDialog 
{
	private Connection Insertconnection; 
   	private Statement Insertstatement; 
   	//private Statement InsertInputstatement; 
   	private ResultSet InsertresultSet; 
   	private ResultSetMetaData rsMetaData;
   
    
    //GUI變量定義
	private JLabel VipSerialLabel ;
	private JLabel VipJoinTimeLabel ;
	private JLabel VipNameLabel ;
	private JLabel VipAgeLabel ;
	private JLabel VipPositionLabel ;
	
   	private JTextField VipSerialField;
   	private JTextField VipJoinTimeField;
   	private JTextField VipNameField;
   	private JTextField VipAgeField;
   	private JTextField VipPositionField;
	
	private JButton SubmmitButton ;
	private JButton cancelButton ;
	private JFrame parent; 
    
    public VipInputFrame(JFrame parent, boolean modal) 
    {
        super(parent, modal);
        this.parent = parent;
        pack();
        
        initComponents(); 
        
    }
    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);
        //2
        VipJoinTimeField = new JTextField(); // needed below
        VipJoinTimeField.setPreferredSize(new Dimension(150, 25));
        VipJoinTimeLabel = new JLabel();
        VipJoinTimeLabel.setText("入會時間：(####-##-##)");
        VipJoinTimeLabel.setLabelFor(VipJoinTimeField);
        constraints.gridx = 0;
        constraints.gridy = 1;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipJoinTimeLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 1;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipJoinTimeField, constraints);
        //3
        VipNameField = new JTextField(); // needed below
        VipNameField.setPreferredSize(new Dimension(150, 25));
        VipNameLabel = new JLabel();
        VipNameLabel.setText("會 員 姓 名：        ");
        VipNameLabel.setLabelFor(VipNameField);
        constraints.gridx = 0;
        constraints.gridy = 2;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipNameLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 2;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipNameField, constraints);
        //4
        VipAgeField = new JTextField(); // needed below
        VipAgeField.setPreferredSize(new Dimension(150, 25));
        VipAgeLabel = new JLabel();
        VipAgeLabel.setText("會 員 年 齡：        ");
        VipAgeLabel.setLabelFor(VipAgeField);
        constraints.gridx = 0;
        constraints.gridy = 3;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipAgeLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 3;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipAgeField, constraints);
		//5
		VipPositionField = new JTextField(); // needed below
        VipPositionField.setPreferredSize(new Dimension(150, 25));
        VipPositionLabel = new JLabel();
        VipPositionLabel.setText("會 員 職 位：        ");
        VipPositionLabel.setLabelFor(VipPositionField);
        constraints.gridx = 0;
        constraints.gridy = 4;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        contents.add(VipPositionLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 4;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        contents.add(VipPositionField, constraints);    
        
        JPanel buttonPanel = createButtonPanel(); // sets global loginButton
        constraints.gridx = 0;
        constraints.gridy = 5;
        constraints.gridwidth = 3;
        constraints.gridheight = 2;
        contents.add(buttonPanel, constraints);
        
        setSize( 500, 300 );
      	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() 
        {
            public void actionPerformed(ActionEvent event) 
            {
                VipInfoInput();
            }
        });
        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 VipInfoInput()
    {
   	  if(
   		   VipSerialField.getText().equals( "" )||
   		   VipJoinTimeField.getText().equals( "" )||
   		   VipNameField.getText().equals( "" )||
   		   VipAgeField.getText().equals( "" )||
   		   VipPositionField.getText().equals( "" ))
   		{
   			JOptionPane.showMessageDialog( this,"請填好會員資料" ); 
         	//setTitle( "無記錄顯示" ); 
         	return; 	
   		}
   		
   		String url = "jdbc:odbc:VipQuery"; 
    	String username = ""; 
    	String password = ""; 
    	
    	
    	//加載驅動程序以連接數據庫
      	try 
      	{ 
        	Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
        	Insertconnection = 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 
      	}
      	
      	try 
      	{ 
      		 String InsertQuery = "select * from VIPID where VIP編號 = "+VipSerialField.getText()+"";
      		 String InsertInput = "insert into VIPID VALUES("
      		 					+ VipSerialField.getText()+",'"+VipJoinTimeField.getText()+"','"
      		 					+VipNameField.getText()+"',"+VipAgeField.getText()+",'"
      		 					+VipPositionField.getText()+"')";
      		
      		 Insertstatement = Insertconnection.createStatement();
         	 InsertresultSet = Insertstatement.executeQuery( InsertQuery );  
         	 
         	 boolean moreRecords = InsertresultSet.next();     
         	 
         	 if ( moreRecords ) 
      		 { 
         		JOptionPane.showMessageDialog( this,"對不起，此VIP號以被使用，請重新輸入" ); 
         		//setTitle( "無記錄顯示" );
         		Insertconnection.close(); 
         		return; 
      		 }  
      		 //InsertInputstatement =  Insertconnection.createStatement();
      		 int insert = Insertstatement.executeUpdate( InsertInput );//executeUpdate返回一個整型值
      		 
      		 if (insert == 1)
      		 {
      		 	JOptionPane.showMessageDialog( this,"會員注冊成功！" );
      		 	VipSerialField.setText("");
   		   		VipJoinTimeField.setText("");
   		   		VipNameField.setText("");
   		   		VipAgeField.setText("");
   		   		VipPositionField.setText("");
      		 } 
      	} 
      	catch ( SQLException sqlex ) 
      	{ 
        	sqlex.printStackTrace(); 
      	}  
        
   		    
    }
}