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

public class  UseManagerFrame extends JDialog 
{
	private Connection UseManagerconnection; 
   	private Statement UseManagerstatement; 
   	//private Statement InsertInputstatement; 
   	private ResultSet UseManagerresultSet; 
   	private ResultSetMetaData rsMetaData;
   
    
    //GUI變量定義
	private JLabel UseNameLabel ;
	private JLabel PasswordLabel ;
	
   	private JTextField UseNameField;
   	private JPasswordField PasswordField;
  
	private JButton AppendButton ;
	private JButton ChangeButton ;
	private JButton DeleteButton ;
	private JButton CancelButton ;
	
	private JTable  UseTable ;
	private JTable  table;
	private JPanel  TablePanel;
	
	private JFrame parent; 
	
	
    
    public  UseManagerFrame(JFrame parent, boolean modal) 
    {
        super(parent, modal);
        this.parent = parent;
        pack();
        
        Databaseconnection();
        initComponents(); 
        
    }
    private void initComponents() 
    {
    	
    	BorderLayout layout = new BorderLayout();
        Container contents = getContentPane();
        contents.setLayout(layout);
		
        setTitle ("用戶管理窗口");
        addWindowListener(new WindowAdapter () 
        {
            public void windowClosing(WindowEvent event) 
            {
                setVisible(false);
        		dispose();
            }
        });
        
        JPanel controlpanel = new JPanel();
        controlpanel.setLayout(new GridBagLayout());
        GridBagConstraints constraints = new GridBagConstraints();
        
        UseNameField = new JTextField(); // needed below
        UseNameField.setPreferredSize(new Dimension(150, 25));
        UseNameLabel = new JLabel();
        //UseNameLabel.setPreferredSize(new Dimension(100, 25));
        UseNameLabel.setText("              用戶名:");
        //UseNameLabel.setLabelFor(UseNameField);
        constraints.weightx = 0;
        constraints.weighty = 0;
        constraints.gridx = 0;
        constraints.gridy = 0;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        controlpanel.add(UseNameLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 0;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        controlpanel.add(UseNameField, constraints);
        //2
        PasswordField = new JPasswordField(); // needed below
        PasswordField.setPreferredSize(new Dimension(150, 25));
        PasswordLabel = new JLabel();
        //PasswordLabel.setPreferredSize(new Dimension(100, 25));
        PasswordLabel.setText("              口   令:");
        //PasswordLabel.setLabelFor(PasswordField);
        constraints.gridx = 0;
        constraints.gridy = 1;
        constraints.gridwidth = 1;
        constraints.gridheight = 1;
        controlpanel.add(PasswordLabel, constraints);
        constraints.gridx = 1;
        constraints.gridy = 1;
        constraints.gridwidth = 2;
        constraints.gridheight = 1;
        controlpanel.add(PasswordField, constraints);
           
        
        JPanel buttonPanel = createButtonPanel(); // sets global loginButton
        constraints.gridx = 0;
        constraints.gridy = 2;
        constraints.gridwidth = 3;
        constraints.gridheight = 2;
        controlpanel.add(buttonPanel, constraints);
        
        TablePanel = createTablePanel(); // sets global loginButton
        
        contents.add(controlpanel,BorderLayout.NORTH);
        contents.add(TablePanel,BorderLayout.CENTER);
        
        getTable();
        
        setSize( 400, 250 );
      	setResizable(false);
      	setLocation(200,100);	
    }
    
     private JPanel createButtonPanel() 
     {

        JPanel panel = new JPanel();
        panel.setLayout(new BoxLayout(panel, 0));
        
        
        AppendButton = new JButton();
        AppendButton.setText("添  加");
        
        AppendButton.addActionListener(new ActionListener() 
        {
            public void actionPerformed(ActionEvent event) 
            {
                UseInfoInput();
            }
        });
        panel.add(AppendButton);

        // space
        panel.add(Box.createRigidArea(new Dimension(5,0)));
        
        ChangeButton = new JButton();
        ChangeButton.setText("更改密碼");
        
        ChangeButton.addActionListener(new ActionListener() 
        {
            public void actionPerformed(ActionEvent event) 
            {
                UseInfoChange();
            }
        });
        panel.add(ChangeButton);

        // space
        panel.add(Box.createRigidArea(new Dimension(5,0)));
        
        DeleteButton = new JButton();
        DeleteButton.setText("刪  除");
        
        DeleteButton.addActionListener(new ActionListener() 
        {
            public void actionPerformed(ActionEvent event) 
            {
                UseInfoDelete();
            }
        });
        panel.add(DeleteButton);

       

        // space
        panel.add(Box.createRigidArea(new Dimension(5,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(4);
        buttons.add(AppendButton);
        buttons.add(ChangeButton);
        buttons.add(DeleteButton);
        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 JPanel createTablePanel() 
     {

        JPanel Tablepanel = new JPanel();
        Tablepanel.setLayout(new BorderLayout());
        UseTable = new JTable();
        	
		JScrollPane scroller = new JScrollPane(UseTable); 
		scroller.setPreferredSize(new Dimension(440, 95));
        
        //Databaseconnection();
        
		//Tablepanel.setLayout( new BorderLayout() );
		Tablepanel.setPreferredSize(new Dimension(450, 100));
		Tablepanel.setBorder(BorderFactory.createEtchedBorder());
 		Tablepanel.add( scroller ,BorderLayout.CENTER);