import javax.swing.*;//GUI
import javax.swing.JOptionPane;
import java.awt.*;

import java.awt.event.*;

import java.sql.*;

import java.util.*;


 class Duty extends JFrame implements ActionListener{
	
	JPanel p1 = new JPanel();
	JPanel p2 = new JPanel();
	JPanel p3 = new JPanel();
		
	JButton go=new JButton("查詢房號");
	JButton not=new JButton("取消");
	JButton sear=new JButton("查詢管理員");
	
	JLabel lnum=new JLabel("房號");
	JLabel lname=new JLabel("管理員姓名");
	
	JTextField fnum=new JTextField();
	JTextField fname=new JTextField();
	
	JScrollPane jsp=new JScrollPane();
    JTextArea anum=new JTextArea();

    JMenuBar bar = new JMenuBar();
    JMenu m1 = new JMenu("鏈接");
    JMenuItem ni1 = new JMenuItem("管理員信息表info");
    JMenuItem ni2 = new JMenuItem("房客登記表hotel");


    Connection con=null;Statement Stmt=null;

  Duty() {
  	  	
    try {  
    
    setLayout(new GridLayout(2,0));

    setLocale(java.util.Locale.getDefault());
    setJMenuBar(bar);
    
    bar.add(m1);
    m1.add(ni1);
    m1.addSeparator();
    m1.add(ni2);
    
	p1.setLayout(new GridLayout(2,2));
    p1.add(lnum);p1.add(fnum);p1.add(lname);p1.add(fname);
   
//	p2.setLayout(new GridLayout(1,2));
    p2.add(go);p2.add(not);p2.add(sear);

    p3.setLayout(new GridLayout(3,0));
    p3.add(p1); p3.add(p2);
    
    add(p3);
    
    anum.setText("房號列表");
//    jsp.setLocation(100,400);jsp.setSize(500,200);
    add(jsp);
    jsp.getViewport().add(anum);

    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
    catch(ClassNotFoundException e){}

    try{
	    con=DriverManager.getConnection("jdbc:odbc:hotel","sa","");
           Stmt=con.createStatement();
        }
    catch(SQLException ee) {}

    setVisible(false);
    setBounds(0,0,400,450);
    validate();

    go.addActionListener(this);
    not.addActionListener(this);
    sear.addActionListener(this);
    ni1.addActionListener(this);
    ni2.addActionListener(this);
 
    
    }
    catch(Exception e) { e.printStackTrace(); }
  }
    

//按鈕事件
  public void actionPerformed(ActionEvent e)
   {
     if(e.getSource()==go)
       {   
        try {
            if ( !fname.getText().equals( "" ) ) {
                Statement statement =con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
                String query="SELECT * FROM duty WHERE yname = '" + fname.getText() + "'";
                ResultSet rs = statement.executeQuery( query );
                display( rs );
                anum.append( "\n查詢成功\n" );
                statement.close();
                }
             else
                anum.setText( "請輸入要查找的管理員姓名" );
               }
            catch ( SQLException sqlex ) {
                sqlex.printStackTrace();
               }

             }

     else if(e.getSource()==sear)
       {
        try {
            if ( !fnum.getText().equals( "" ) ) {
                Statement statement =con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
                String query="SELECT * FROM duty WHERE fnum = '" + fnum.getText() + "'";
                ResultSet rs = statement.executeQuery( query );
                show( rs );
                anum.append( "\n查詢成功\n" );
                statement.close();
                }
             else
                anum.setText( "請輸入要查找的房號" );
               }
            catch ( SQLException sqlex ) {
                sqlex.printStackTrace();
               }
        
       }

     else if(e.getSource()==not)
       {
         fnum.setText( "" );
         fname.setText( "" );
       }
     else if(e.getSource()==ni1)
       {
        setVisible(false);
        Manager mana=new Manager();
        mana.setVisible(true);
       }

     else if(e.getSource()==ni2)
       {
        setVisible(false);
        Hotel ho=new Hotel();
        ho.setVisible(true);
       }
 }      

public void display( ResultSet rs )
   {
      try {
            boolean morerows=false;//是否該管理員不只負責一個房間

           if (rs.next() ) {

                 fnum.setText( rs.getString(2) );
                 if(rs.next())  morerows=true;
              }
            else  anum.append( "\n沒找到記錄\n" );
                 
           if(morerows)
          {    
              int m=0;
               rs.beforeFirst();
               rs.next();
               String p=rs.getString(2);
               while(rs.next())
               {
                 p=p + " " + rs.getString(2);
                 if(++m%5==0) p=p+"\n";

               }
               
               anum.setText(p);
           }
      }
 
      catch ( SQLException sqlex ) {
         sqlex.printStackTrace();
      }
      
  }//display()結束

public void show( ResultSet rs )
   {
      try {

           if (rs.next() ) {  fname.setText( rs.getString(1) ); }
           else  anum.append( "\n沒找到記錄\n" );
                 
           } 
      catch ( SQLException sqlex ) {
         sqlex.printStackTrace();
      }
      
  }//show()結束

}
  	
/*public static void main(String[] args){
	Duty d = new Duty();
	}  		

*/