package sfms;

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

public class delFI{
  static String input;
  public delFI(){
    input = JOptionPane.showInputDialog(null, "請輸入需要刪除學生的學生號");
    System.out.println("選擇"+JOptionPane.OK_CANCEL_OPTION );
    if (JOptionPane.OK_CANCEL_OPTION == 2) {
      Object[] options = {
          "OK", "CANCEL"};
      JOptionPane.showOptionDialog(null, "Click OK to continue", "Warning",
                                   JOptionPane.DEFAULT_OPTION,
                                   JOptionPane.WARNING_MESSAGE, null,
                                   options, options[0]);
      del();
    }
    else {
      System.exit(0);
    }
  }
    private void del(){
      try{
        Class.forName("oracle.jdbc.OracleDriver").newInstance();
        String url = "jdbc:oracle:thin:@localhost:1521:SFMS";
        Connection conn = DriverManager.getConnection(url, "df", "1234");
        String sql = "DELETE FROM DF.FILEINFO WHERE STNO=?";
        PreparedStatement ps = conn.prepareStatement(sql);
        System.out.println("input="+input);
        ps.setString(1, input);
        ps.executeUpdate();
        conn.close();
       JOptionPane.showMessageDialog(null,"刪除成功!");
     }
     catch(SQLException e){
         System.out.println("E Code"+ e.getErrorCode());
         System.out.println("E M="+e.getMessage());
    }
    catch(Exception e){
        e.printStackTrace();
      }

  }
  public static void main(String args[]){
    delFI delfi=new delFI();
  }
}