package sfms;

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


public class Find extends JFrame implements ActionListener{
  JTextField t1;
  String STNO,r1,r2,r3,r4,r5,r6;
  JButton b1,b2,b3;
  Find() {
    super("查詢檔案");
    Container c1=this.getContentPane();
    setBackground(new Color(215, 215, 215));
    c1.setLayout(new GridLayout(3,2));
    JPanel pp = new JPanel();
    pp.add(new Label("請您輸入要查詢的學生號"));
    c1.add(pp);
    JPanel p1 = new JPanel();
    t1=new JTextField(10);
    p1.add(new Label(""));
    p1.add(t1);
    c1.add(p1);
    JPanel p2 = new JPanel();
     b1 = new JButton("確定");
     b2 = new JButton("清除");
     b3 = new JButton("返回");
    b1.addActionListener(this);
    b2.addActionListener(this);
    b3.addActionListener(this);
    p2.add(b1);
    p2.add(b2);
    p2.add(b3);
    c1.add(p2);
    this.setVisible(true);
    this.setSize(400,300);
    this.addWindowListener(new WindowAdapter() {
      public void windowClosing(WindowEvent event) {
        shutDown();
      }
    }
    );
  }
  public void actionPerformed(ActionEvent e) {
    try {
      if (e.getSource() == b1) {
        try {
  STNO=t1.getText();
  Class.forName("oracle.jdbc.OracleDriver").newInstance();
  String url = "jdbc:oracle:thin:@thsspc0792:1521:SFMS";
  Connection cn = DriverManager.getConnection(url, "df", "1234");
  String str = "select * from DF.FILEINFO where STNO='" + STNO + "'";
  PreparedStatement ps = cn.prepareStatement(str);
  ResultSet rs = ps.executeQuery();
  System.out.println("STNO="+STNO);
  if(rs.next()) {
    r1=rs.getString("STNO");
    r2=rs.getString("SName");
    r3=rs.getString("Gender");
    r4=rs.getString("Department");
    r5=rs.getString("NativePlace");
    r6=rs.getString("TEL");
   System.out.println("r1="+r1);
    UpdateDialog ud = new UpdateDialog();
    ud.setVisible(true);

  }
  else {
    JOptionPane.showMessageDialog(null,"您輸入的學生號有誤,請重新輸入",
     "輸入錯誤",JOptionPane.YES_NO_OPTION);
  }
  cn.close();
}
catch (SQLException g) {
  System.out.println("Error Code: " + g.getErrorCode());
  System.out.println("Message=" + g.getMessage());
  }

catch (Exception f) {
  f.printStackTrace();
}

      }
      if (e.getSource() == b2) {
        t1.setText("");
        t1.repaint();
      }
      if (e.getSource() == b3) {
        shutDown();
      }
    }
    catch (NumberFormatException ex) {
      JOptionPane.showMessageDialog(null, "數據轉換錯誤!");
    }
  }
 public void shutDown(){
   System.exit(0);
 }
class UpdateDialog extends JFrame implements ActionListener {
   JTextField tt1, t2, t3, t4, t5, t6;
   JButton b4;
   UpdateDialog() {
     super("查詢學生檔案");
     Container c2 = this.getContentPane();
     setBackground(new Color(215, 215, 215));
     c2.setLayout(new GridLayout(3, 1));
     tt1 = new JTextField(r1);
     t2 = new JTextField(r2);
     t3 = new JTextField(r3);
     t4 = new JTextField(r4);
     t5 = new JTextField(r5);
     t6 = new JTextField(r6);
     tt1.setEditable(false);
     t2.setEditable(false);
     t3.setEditable(false);
     t4.setEditable(false);
     t5.setEditable(false);
     t6.setEditable(false);
     JPanel pp1 = new JPanel();
     pp1.add(new JLabel("學號為" + STNO + "學生的檔案"));
     c2.add(pp1);
     JPanel pp2 = new JPanel(new GridLayout(6, 2));
     pp2.add(new JLabel("學號"));
     tt1.setText(STNO);
     pp2.add(tt1,SwingConstants.LEFT);
     pp2.add(new JLabel("姓名"));
     pp2.add(t2,SwingConstants.LEFT);
     pp2.add(new JLabel("性別"));
     pp2.add(t3,SwingConstants.LEFT);
     pp2.add(new JLabel("系別"));
     pp2.add(t4,SwingConstants.LEFT);
     pp2.add(new JLabel("地址"));
     pp2.add(t5,SwingConstants.LEFT);
     pp2.add(new JLabel("電話"));
     pp2.add(t6,SwingConstants.LEFT);
     c2.add(pp2);
     JPanel pp3 = new JPanel(new FlowLayout());
     b4 = new JButton("返回");
     b4.addActionListener(this);
     pp3.add(b4);
     c2.add(pp3);
     this.setSize(400, 300);
     this.addWindowListener(new WindowAdapter() {
       public void windowClosing(WindowEvent event) {
         shutDown2();
       }
     }
     );

   }

   public void actionPerformed(ActionEvent f) {
     if (f.getSource() == b4) {
       shutDown2();
     }

   }
   public void shutDown2() {
     System.exit(0);
   }
 }
     public static void main(String[] args) {

         Find ff = new Find();
         ff.setVisible(true);
       }
 }