import javax.swing.*;
import java.awt.*;
import java.sql.*;
import javax.swing.event.*;
import java.awt.event.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;

public class EditCourse
    extends JFrame {
  private String CouName;
  public EditCourse() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }

  }

  private void jbInit() throws Exception {
    this.setResizable(false);
    this.setTitle("管理員在線修改數(shù)據(jù)庫(kù)數(shù)據(jù)");
    this.setSize(420, 450);
    this.setVisible(false);
    this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    this.getContentPane().setLayout(null);
    int count = 1;
    Object[] columnNames = {
        "課程名", "學(xué)分", "授課老師", "上課地點(diǎn)", "上課時(shí)間"};
    Object[][] rowData = new Object[20][5];
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection("jdbc:odbc:srs");
      String sql = "select * from course";
      PreparedStatement ptm = con.prepareStatement(sql);
      ResultSet rs = ptm.executeQuery();
      while (rs.next()) {
        //rowData[count][0] = String.valueOf(count);
        rowData[count][0] = rs.getString("coursename");
        rowData[count][1] = Integer.toString(rs.getInt("xuefen"));
        rowData[count][2] = rs.getString("professor");
        rowData[count][3] = rs.getString("address");
        rowData[count][4] = rs.getString("ctime");
        count++;
      }
    }
    catch (Exception ex) {
      JOptionPane.showMessageDialog(null, "出現(xiàn)錯(cuò)誤!", "ERROR",
                                    JOptionPane.ERROR_MESSAGE);
      //ex.printStackTrace();
      System.exit(1);

    }
    jLxfen.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jLxfen.setText("學(xué)分");
    jLxfen.setBounds(new Rectangle(27, 69, 40, 16));
    jLpro.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jLpro.setText("授課老師");
    jLpro.setBounds(new Rectangle(25, 101, 57, 16));
    jLaddress.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jLaddress.setText("上課地點(diǎn)");
    jLaddress.setBounds(new Rectangle(24, 133, 52, 16));
    jLtime.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jLtime.setText(" 上課時(shí)間");
    jLtime.setBounds(new Rectangle(18, 163, 68, 16));
    jLtitle.setFont(new java.awt.Font("宋體", Font.PLAIN, 15));
    jLtitle.setForeground(SystemColor.activeCaption);
    jLtitle.setText("添加課程");
    jLtitle.setBounds(new Rectangle(78, 10, 70, 16));
    jLcname.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jLcname.setText("課程名");
    jLcname.setBounds(new Rectangle(26, 37, 53, 16));
    jTname.setBounds(new Rectangle(91, 35, 94, 21));
    jTxuefen.setBounds(new Rectangle(91, 66, 94, 21));
    jTpro.setBounds(new Rectangle(91, 99, 94, 21));
    jTaddress.setBounds(new Rectangle(90, 130, 95, 21));
    jTtime.setBounds(new Rectangle(91, 161, 94, 21));
    jBadd.setBounds(new Rectangle(21, 195, 71, 25));
    jBadd.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jBadd.setText("添加");
    jBadd.addActionListener(new EditCourse_jBadd_actionAdapter(this));
    jBcls.setBounds(new Rectangle(117, 195, 71, 25));
    jBcls.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jBcls.setText("重填");
    jBcls.addActionListener(new EditCourse_jBcls_actionAdapter(this));
    jPanel2.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel2.setBounds(new Rectangle(218, 254, 194, 153));
    jPanel2.setLayout(null);
    jLdelcourse.setFont(new java.awt.Font("宋體", Font.PLAIN, 15));
    jLdelcourse.setForeground(SystemColor.activeCaption);
    jLdelcourse.setText("刪除課程");
    jLdelcourse.setBounds(new Rectangle(77, 12, 60, 16));
    jLdel.setFont(new java.awt.Font("宋體", Font.PLAIN, 15));
    jLdel.setText("刪除");
    jLdel.setBounds(new Rectangle(35, 44, 35, 19));
    jChose.setBounds(new Rectangle(86, 42, 98, 20));
    for (int i = 1; i < count; i++) {
      jChose.addItem(rowData[i][0]);
    }
    jChose.addItemListener(new EditCourse_jChose_itemAdapter(this));
    jBdel.setBounds(new Rectangle(14, 102, 90, 25));
    jBdel.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jBdel.setText("確認(rèn)刪除");
    jBdel.addActionListener(new EditCourse_jBdel_actionAdapter(this));
    jBlogout.setBounds(new Rectangle(125, 102, 62, 25));
    jBlogout.setFont(new java.awt.Font("宋體", Font.PLAIN, 13));
    jBlogout.setText("登出");
    jBlogout.addActionListener(new EditCourse_jBlogout_actionAdapter(this));
    jPanel3.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel3.setBounds(new Rectangle(6, 20, 207, 325));
    jPanel3.setLayout(null);
    jPanel4.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel4.setBounds(new Rectangle(6, 350, 207, 57));
    jPanel4.setLayout(null);
    jBref.setBounds(new Rectangle(51, 14, 94, 25));
    jBref.setFont(new java.awt.Font("宋體", Font.PLAIN, 15));
    jBref.setText("刷新列表");
    jBref.addActionListener(new EditCourse_jBref_actionAdapter(this));
    jScrollPane1.setBounds(new Rectangle(0, 7, 191, 317));
    jPanel1.add(jLtitle);
    jPanel1.add(jBadd);
    jPanel1.add(jTname);
    jPanel1.add(jTxuefen);
    jPanel1.add(jTpro);
    jPanel1.add(jTtime);
    jPanel1.add(jTaddress);
    jPanel1.add(jBcls);
    jPanel1.add(jLcname);
    jPanel1.add(jLxfen);
    jPanel1.add(jLpro);
    jPanel1.add(jLaddress);
    jPanel1.add(jLtime);
    this.getContentPane().add(jPanel1);
    this.getContentPane().add(jPanel2);
    this.getContentPane().add(jPanel3);
    JTable jTable1 = new JTable(rowData, columnNames);
    jPanel3.add(jScrollPane1);
    jScrollPane1.getViewport().add(jTable1);
    this.getContentPane().add(jPanel4);
    jPanel4.add(jBref);
    jPanel2.add(jLdelcourse);
    jPanel2.add(jChose);
    jPanel2.add(jBdel);
    jPanel2.add(jLdel);
    jPanel2.add(jBlogout);
    jPanel1.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel1.setBounds(new Rectangle(217, 21, 196, 228));
    jPanel1.setLayout(null);
  }

  JPanel jPanel1 = new JPanel();
  JLabel jLtitle = new JLabel();
  JLabel jLcname = new JLabel();
  JLabel jLxfen = new JLabel();
  JLabel jLpro = new JLabel();
  JLabel jLaddress = new JLabel();
  JLabel jLtime = new JLabel();
  JTextField jTname = new JTextField();
  JTextField jTxuefen = new JTextField();
  JTextField jTpro = new JTextField();
  JTextField jTaddress = new JTextField();
  JTextField jTtime = new JTextField();
  JButton jBadd = new JButton();
  JButton jBcls = new JButton();
  JPanel jPanel2 = new JPanel();
  JLabel jLdelcourse = new JLabel();
  JLabel jLdel = new JLabel();
  JComboBox jChose = new JComboBox();
  JButton jBdel = new JButton();
  JButton jBlogout = new JButton();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  JButton jBref = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();
  public void jBadd_actionPerformed(ActionEvent e) {
    String coursename, professor, address, ctime;
    Double xuefen;
    coursename = jTname.getText();
    professor = jTpro.getText();
    address = jTaddress.getText();
    ctime = jTtime.getText();
    xuefen = Double.valueOf(jTxuefen.getText());
    System.out.println(coursename + "T" + professor + "T" + address + "T" +
                       ctime + "T" + xuefen);
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection("Jdbc.Odbc.srs");
      Statement stm = con.createStatement();
      String sql =
          "insert into course(coursename,xuefen,professor,as,cti" +
          coursename + "','" + xuefen + "','" + professor + "','" + address +
          "','" + ctime + "')";
      stm.executeUpdate(sql);
      con.close();
   }
    catch (Exception ex) {
      JOptionPane.showMessageDialog(null, "連接數(shù)據(jù)庫(kù)現(xiàn)問(wèn)題、請(qǐng)稍后再試", "ERROR!",
                                    JOptionPane.ERROR_MESSAGE);
    }
    JOptionPane.showConfirmDialog(null, "成功添加課程、請(qǐng)刷新", "Message",
                                  JOptionPane.OK_OPTION);
  }

  public void jBcls_actionPerformed(ActionEvent e) {
    jTname.setText("");
    jTxuefen.setText("");
    jTpro.setText("");
    jTaddress.setText("");
    jTtime.setText("");
    this.validate();
  }

  public void jBdel_actionPerformed(ActionEvent e) {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection("Jdbc.Odbc.srs");
      Statement stm = con.createStatement();
      String sql = "delete from course where coursename='" + CouName + "'";
      stm.executeUpdate(sql);
      con.close();
    }
    catch (Exception ex) {
      JOptionPane.showMessageDialog(null, "刪除數(shù)據(jù)時(shí)出現(xiàn)錯(cuò)誤、請(qǐng)稍后重試", "ERROE",
                                    JOptionPane.ERROR_MESSAGE);

    }
    JOptionPane.showConfirmDialog(null, "刪除課程成功", "Success",
                                  JOptionPane.OK_OPTION);
  }

  public void jBlogout_actionPerformed(ActionEvent e) {
    this.dispose();
    ;
  }

  public void jChose_itemStateChanged(ItemEvent e) {
    int b;
    b = jChose.getSelectedIndex();
    Object s;
    s = jChose.getItemAt(b);
    CouName = s.toString();
  }

  public void jBref_actionPerformed(ActionEvent e) {
    int number = 1;
    Object[] columnNames = {
        "課程名", "學(xué)分", "授課老師", "上課地點(diǎn)", "上課時(shí)間"};
    Object[][] rowData = new Object[20][5];
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection("jdbc:odbc:srs");
      String sql = "select * from course";
      PreparedStatement ptm = con.prepareStatement(sql);
      ResultSet rs = ptm.executeQuery();
      while (rs.next()) {
        //rowData[count][0] = String.valueOf(count);
        rowData[number][0] = rs.getString("coursename");
        rowData[number][1] = Integer.toString(rs.getInt("xuefen"));
        rowData[number][2] = rs.getString("professor");
        rowData[number][3] = rs.getString("address");
        rowData[number][4] = rs.getString("ctime");
        number++;
      }
    }
    catch (Exception ex) {
      JOptionPane.showMessageDialog(null, "出現(xiàn)?錯(cuò)誤!", "ERROR",
                                    JOptionPane.ERROR_MESSAGE);
      //ex.printStackTrace();
      System.exit(1);

    }

  }
}

class EditCourse_jBref_actionAdapter
    implements ActionListener {
  private EditCourse adaptee;
  EditCourse_jBref_actionAdapter(EditCourse adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jBref_actionPerformed(e);
  }
}

class EditCourse_jChose_itemAdapter
    implements ItemListener {
  private EditCourse adaptee;
  EditCourse_jChose_itemAdapter(EditCourse adaptee) {
    this.adaptee = adaptee;
  }

  public void itemStateChanged(ItemEvent e) {
    adaptee.jChose_itemStateChanged(e);
  }
}

class EditCourse_jBlogout_actionAdapter
    implements ActionListener {
  private EditCourse adaptee;
  EditCourse_jBlogout_actionAdapter(EditCourse adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jBlogout_actionPerformed(e);
  }
}

class EditCourse_jBdel_actionAdapter
    implements ActionListener {
  private EditCourse adaptee;
  EditCourse_jBdel_actionAdapter(EditCourse adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jBdel_actionPerformed(e);
  }
}

class EditCourse_jBcls_actionAdapter
    implements ActionListener {
  private EditCourse adaptee;
  EditCourse_jBcls_actionAdapter(EditCourse adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jBcls_actionPerformed(e);
  }
}

class EditCourse_jBadd_actionAdapter
    implements ActionListener {
  private EditCourse adaptee;
  EditCourse_jBadd_actionAdapter(EditCourse adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jBadd_actionPerformed(e);
  }
}