package cg;

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

public class dingRoom extends JFrame 
{	
	public JButton btnInsert, btnDelete, btnUpdate, btnSelect,btnSelect1,btnSelect2,btnExit;
	public JComboBox jComboBox1,jComboBox2,jComboBox3,jComboBox4,jComboBox5,jComboBox6;
	public JTextField jTextField1,jTextField2,jTextField3;
	public JTextArea jTextArea1;
	public odbc dbo;
    public JTable tabShow;
    public Connection con;
    //private JComboBox cboChioce;
    //public MainFrame maf;
    //public dingRoom ding;
	
	public dingRoom()
	{
		//super(ma,true);
		//maf=ma;
        dbo = new odbc();
        
        tabShow = new JTable();
        
        Container me = getContentPane();
        me.setLayout(new BorderLayout());
        me.add(new JScrollPane(tabShow), BorderLayout.CENTER);
        me.add(new SouthPanel(), BorderLayout.SOUTH);
        
        this.addWindowListener(new WindowCloseEvent());
        this.setTitle("訂房信息主窗口");	
		this.setSize(600,500);
		this.setResizable(false);		
		this.setLocationRelativeTo(this);//居中顯示				
		this.setVisible(true);
		
	
	}
	
  
	
    private class SouthPanel extends JPanel implements ActionListener
    {
        public SouthPanel()
        {
            super(new FlowLayout());
            btnInsert = new JButton("開房");
            btnDelete = new JButton("退房");
            //btnUpdate = new JButton("修改");
            btnSelect = new JButton("查詢所有房");
            btnSelect1=new JButton("正使用房");
            btnSelect2=new JButton("空閑房");
            btnExit=new JButton("退出");
            
            this.add(btnInsert);
            this.add(btnDelete);
            //this.add(btnUpdate);
            this.add(btnSelect);
            this.add(btnSelect1);
            this.add(btnSelect2);
            this.add(btnExit);
            
            btnSelect.addActionListener(this);
            btnInsert.addActionListener(this);
            btnSelect1.addActionListener(this);
            btnSelect2.addActionListener(this);
            //btnUpdate.addActionListener(this);
            btnDelete.addActionListener(this);
            btnExit.addActionListener(this);
            
            btnSelect.setActionCommand("select");
            btnInsert.setActionCommand("insert");
            btnSelect1.setActionCommand("select1");
            btnSelect2.setActionCommand("select2");
            //btnUpdate.setActionCommand("update");
            btnDelete.setActionCommand("delete");
            btnExit.setActionCommand("exit");                       
       }
       
       public void actionPerformed(ActionEvent e){
       	String str=e.getActionCommand();
       	if(str.equals("select")){
       		DefaultTableModel dtm = new DefaultTableModel(dbo.getDataByTabname(),dbo.getColumnNamesByTabname());
            tabShow.setModel(dtm);
           }             	
       	if(str.equals("insert")){
       		new dingRoomFrame1();
        	}
       	if(str.equals("select1")){
       		DefaultTableModel dtm = new DefaultTableModel(dbo.getDataByTabname1(),dbo.getColumnNamesByTabname1());
           	tabShow.setModel(dtm);
       		}
       	if(str.equals("select2")){
       		DefaultTableModel dtm = new DefaultTableModel(dbo.getDataByTabname2(),dbo.getColumnNamesByTabname2());
           	tabShow.setModel(dtm);
       		}
       	/*if(str.equals("update")){
       		new dingRoomFrameUpdate();
       		}*/
       	if(str.equals("delete")){
       		new dingRoomFrameDelete();
       		}
       	if(str.equals("exit")){
       		super.setVisible(false);
       	    }
       }        
       
    }
    
    private class WindowCloseEvent extends WindowAdapter
    {
        public void windowClosing(WindowEvent e)
        {
            dbo.closeConnection();
        }
    }
    
    
	
}