package sfms;

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

public class Update extends JFrame implements ActionListener{
  JTextField t1;
  String STNO;
  JButton b1,b2,b3;
  Update() {
    super("更新檔案");
    Container c1=this.getContentPane();
    setBackground(new Color(215, 215, 215));
    c1.setLayout(new GridLayout(3,2));
    t1 = new JTextField(10);
    JPanel pp = new JPanel();
    JLabel label0=new JLabel("請您輸入學生號");
    label0.setFont(new Font("TRUE",Font.TRUETYPE_FONT,20));
    pp.add(label0);
    c1.add(pp);
    JPanel p1 = new JPanel();
 //   p3.setLayout(new GridLayout(0, 3, 0, 0));
    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) {
        UpdateDialog ud = new UpdateDialog();
        ud.setVisible(true);
      }
      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, b5, b6;
   UpdateDialog() {
     super("更新學生檔案");
     Container c2 = this.getContentPane();
     setBackground(new Color(215, 215, 215));
     c2.setLayout(new GridLayout(3, 1));
     tt1 = new JTextField(50);
     t2 = new JTextField(50);
     t3 = new JTextField(50);
     t4 = new JTextField(50);
     t5 = new JTextField(50);
     t6 = new JTextField(50);
     JPanel pp1 = new JPanel();
     STNO = t1.getText();
     JLabel label1=new JLabel("學號為" + STNO + "學生的檔案");
     label1.setFont(new Font("TRUE",Font.TRUETYPE_FONT,20));
     pp1.add(label1);
     c2.add(pp1);
     JPanel pp2 = new JPanel(new GridLayout(6, 2));
     pp2.add(new JLabel("學號"));
     tt1.setText(STNO);
     pp2.add(tt1);
     pp2.add(new JLabel("姓名"));
     pp2.add(t2);
     pp2.add(new JLabel("性別"));
     pp2.add(t3);
     pp2.add(new JLabel("系別"));
     pp2.add(t4);
     pp2.add(new JLabel("地址"));
     pp2.add(t5);
     pp2.add(new JLabel("電話"));
     pp2.add(t6);
     c2.add(pp2);
     JPanel pp3 = new JPanel(new FlowLayout());
     b4 = new JButton("確定");
     b5 = new JButton("清除");
     b6 = new JButton("退出");
     b4.addActionListener(this);
     b5.addActionListener(this);
     b6.addActionListener(this);
     pp3.add(b4);
     pp3.add(b5);
     pp3.add(b6);
     c2.add(pp3);
     this.setSize(400, 300);
     this.addWindowListener(new WindowAdapter() {
       public void windowClosing(WindowEvent event) {
         shutDown2();
       }
     }
     );
     try {
       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();
       if (rs.next() == false) {
         JOptionPane.showMessageDialog(null, "您輸入的學生號有誤,請重新輸入",
          "輸入錯誤",JOptionPane.YES_NO_OPTION);
       }
       else {
         t1.setText(rs.getString("STNO"));
         t2.setText(rs.getString("SName"));
         t3.setText(rs.getString("Gender"));
         t4.setText(rs.getString("Department"));
         t5.setText(rs.getString("NativePlace"));
         t6.setText(rs.getString("TEL"));
       }
       cn.close();
     }
     catch (SQLException e) {
       System.out.println("Error Code: " + e.getErrorCode());
       System.out.println("Message=" + e.getMessage());
     }
     catch (Exception e) {
       e.printStackTrace();
     }
   }

   public void actionPerformed(ActionEvent f) {
     if (f.getSource() == b4) {
       up();
     }
     if (f.getSource() == b5) {
       t1.setText("");
       t1.repaint();
       t2.setText("");
       t2.repaint();
       t3.setText("");
       t3.repaint();
       t4.setText("");
       t4.repaint();
       t5.setText("");
       t5.repaint();
       t6.setText("");
       t6.repaint();

     }
     if (f.getSource() == b6) {
       shutDown2();
     }

   }

   public void up() {
     String s1, s2, s3, s4, s5, s6;
     s1 = tt1.getText();
     s2 = t2.getText();
     s3 = t3.getText();
     s4 = t4.getText();
     s5 = t5.getText();
     s6 = t6.getText();
     if (s1.length() == 0) {
       JOptionPane.showMessageDialog(null, "沒有輸入學生號");
     }
     if (s2.length() == 0) {
       JOptionPane.showMessageDialog(null, "沒有輸入學生名");
     }
     if (s3.length() == 0) {
       JOptionPane.showMessageDialog(null, "沒有輸入學生性別");

     }
     if (s4.length() == 0) {
       JOptionPane.showMessageDialog(null, "沒有輸入學生系別");
     }
     if (s5.length() == 0) {
       JOptionPane.showMessageDialog(this, "沒有輸入學生地址");
     }
     if (s6.length() == 0) {
       JOptionPane.showMessageDialog(null, "沒有輸入學生電話");

     }
     else {
       try {
         Class.forName("oracle.jdbc.OracleDriver").newInstance();
         String url = "jdbc:oracle:thin:@localhost:1521:SFMS";
         Connection cn = DriverManager.getConnection(url, "df", "1234");
         String str = "update DF.FILEINFO SET SNAME='" + s2 + "'," +
             "GENDER='" + s3 + "',DEPARTMENT='" + s4 + "'," +
             "NATIVEPLACE='" + s5 + "',TEL='" + s6 + "'"+
             " WHERE STNO='" + s1 + "' ";
         PreparedStatement ps = cn.prepareStatement(str);
         ps.setString(1, s1);
         System.out.println("s1=" + s1);
         ps.setString(2, s2);
         ps.setString(3, s3);
         System.out.println("s2=" + s2);
         ps.setString(4, s4);
         ps.setString(5, s5);
         ps.setString(6, s6);
         ps.executeQuery(str);

         cn.close();
         JOptionPane.showMessageDialog(null, "更新成功!");
       }
       catch (SQLException e) {
         JOptionPane.showMessageDialog(null, "更新失敗!");
       }
       catch (Exception e) {
         e.printStackTrace();
       }
     }
   }

   public void shutDown2() {
     System.exit(0);
   }
 }
     public static void main(String[] args) {
      Update rr = new Update();
       rr.setVisible(true);
     }
 }