package studentinfo;
import java.lang.*;
import java.lang.Object.*;
import java.sql.*;
import java.util.*;
import javax.swing.event.*;
import javax.swing.table.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;


/**
 * <p>Title: StudentINFO</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author 楊一寧
 * @version 1.0
 */


public class Frame1 extends JFrame
{
  JPanel contentPane;
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();
  JTextField jTextField4 = new JTextField();

  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();

  String stu_info[] = {"學號","姓名","所屬學院","所屬班級"};    // 二維表列名
  Connection connection = null; // 聲明Connection接口對象connection
  ResultSet rSet = null; // 定義數據庫查詢的結果集
  Statement statement = null; // 定義查詢數據庫的Statement對象
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenu1 = new JMenu();
  JMenu jMenuhelp = new JMenu();
  JMenuItem jMenuabout = new JMenuItem();
  JMenuItem jMenuexit = new JMenuItem();
  JTextPane jTextPane1 = new JTextPane();
  JLabel jLabel5 = new JLabel();
  JTextField jTextField5 = new JTextField();
  JButton jButton5 = new JButton();
  int 查詢記錄;


  //Construct the frame
  public Frame1()
  {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try
    {
      jbInit();
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }
  }

  //Component initialization
  private void jbInit() throws Exception
  {
    contentPane = (JPanel) this.getContentPane();
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setForeground(Color.black);
    jLabel1.setDebugGraphicsOptions(0);
    jLabel1.setToolTipText("");
    jLabel1.setVerifyInputWhenFocusTarget(true);
    jLabel1.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel1.setIconTextGap(4);
    jLabel1.setText("學號");
    jLabel1.setBounds(new Rectangle(47, 98, 47, 23));
    contentPane.setLayout(null);
    this.setSize(new Dimension(400, 341));
    this.setState(Frame.NORMAL);
    this.setTitle("學生基本信息表");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setToolTipText("");
    jLabel2.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel2.setText("姓名");
    jLabel2.setBounds(new Rectangle(40, 137, 56, 25));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3.setToolTipText("");
    jLabel3.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel3.setText("所屬學院");
    jLabel3.setBounds(new Rectangle(34, 173, 63, 27));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel4.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel4.setText("所屬班級");
    jLabel4.setBounds(new Rectangle(28, 215, 71, 29));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(106, 95, 95, 27));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(107, 136, 93, 28));
    jTextField3.setText("");
    jTextField3.setBounds(new Rectangle(108, 174, 91, 25));
    jTextField4.setText("");
    jTextField4.setBounds(new Rectangle(108, 212, 91, 26));


    jButton1.setBounds(new Rectangle(250, 95, 73, 31));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton1.setToolTipText("");
    jButton1.setText("修改");
    jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(250, 146, 74, 34));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton2.setToolTipText("");
    jButton2.setVerifyInputWhenFocusTarget(true);
    jButton2.setText("添加");
    jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
    jButton3.setBounds(new Rectangle(213, 250, 75, 28));
    jButton3.setFont(new java.awt.Font("Monospaced", 1, 15));
    jButton3.setToolTipText("");
    jButton3.setText("刪除");
    jButton3.addActionListener(new Frame1_jButton3_actionAdapter(this));
    jButton4.setBounds(new Rectangle(253, 201, 73, 36));
    jButton4.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton4.setToolTipText("");
    jButton4.setText("取消");
    jButton4.addActionListener(new Frame1_jButton4_actionAdapter(this));

    jMenu1.setActionCommand("文件");
    jMenu1.setText("文件");
    jMenuhelp.setAction(null);
    jMenuhelp.setActionCommand("幫助");
    jMenuhelp.setText("幫助");
    jMenuabout.setPreferredSize(new Dimension(55, 21));
    jMenuabout.setToolTipText("");
    jMenuabout.setActionCommand("關于");
    jMenuabout.setSelected(false);
    jMenuabout.setText("關于");
    jMenuexit.setActionCommand("退出");
    jMenuexit.setText("退出");
    jTextPane1.setBackground(SystemColor.control);
    jTextPane1.setFont(new java.awt.Font("Dialog", 0, 14));
    jTextPane1.setBorder(BorderFactory.createLoweredBevelBorder());
    jTextPane1.setEditable(false);
    jTextPane1.setText("");
    jTextPane1.setBounds(new Rectangle(40, 1, 316, 86));
    jLabel5.setFont(new java.awt.Font("Monospaced", 1, 15));
    jLabel5.setOpaque(true);
    jLabel5.setPreferredSize(new Dimension(94, 22));
    jLabel5.setRequestFocusEnabled(false);
    jLabel5.setToolTipText("");
    jLabel5.setHorizontalAlignment(SwingConstants.RIGHT);
    jLabel5.setHorizontalTextPosition(SwingConstants.TRAILING);
    jLabel5.setIconTextGap(4);
    jLabel5.setText("請輸入學號： ");
    jLabel5.setVerticalAlignment(SwingConstants.CENTER);
    jLabel5.setVerticalTextPosition(SwingConstants.CENTER);
    jLabel5.setBounds(new Rectangle(5, 245, 109, 38));
    jTextField5.setFont(new java.awt.Font("Dialog", 0, 15));
    jTextField5.setCaretPosition(0);
    jTextField5.setText("");
    jTextField5.setColumns(0);
    jTextField5.setBounds(new Rectangle(107, 251, 94, 28));
    jButton5.setBounds(new Rectangle(315, 249, 75, 30));
    jButton5.setFont(new java.awt.Font("Monospaced", 1, 15));
    jButton5.setToolTipText("");
    jButton5.setText("查詢");
    jButton5.addActionListener(new Frame1_jButton5_actionAdapter(this));
    contentPane.add(jTextPane1, null);
    contentPane.add(jTextField5, null);
    contentPane.add(jButton5, null);
    contentPane.add(jButton3, null);
    contentPane.add(jTextField4, null);
    contentPane.add(jTextField3, null);
    contentPane.add(jTextField2, null);
    contentPane.add(jTextField1, null);
    contentPane.add(jLabel4, null);
    contentPane.add(jLabel5, null);
    contentPane.add(jLabel3, null);
    contentPane.add(jLabel2, null);
    contentPane.add(jLabel1, null);
    contentPane.add(jButton4, null);
    contentPane.add(jButton2, null);
    contentPane.add(jButton1, null);
    jMenuBar1.add(jMenu1);
    jMenu1.addSeparator();
    jMenu1.add(jMenuexit);
    jMenuBar1.add(jMenuhelp);
    jMenuhelp.add(jMenuabout);
    this.setJMenuBar(jMenuBar1);
  }


  //File | Exit action performed
 public void jMenuexit_ActionPerformed(ActionEvent e)
 {
   System.exit(0);
 }

 //Help | About action performed
 public void jMenuabout_ActionPerformed(ActionEvent e)
 {
   Frame1_AboutBox dlg = new Frame1_AboutBox(this);
   Dimension dlgSize = dlg.getPreferredSize();
   Dimension frmSize = getSize();
   Point loc = getLocation();
   dlg.setLocation( 132 + loc.x,
                    122 + loc.y);
   dlg.setModal(true);
   dlg.pack();
   dlg.show();
 }

  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e)
  {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING)
    {
      System.exit(0);
    }
  }

  class Frame1_jMenuabout_ActionAdapter implements ActionListener
  {
    Frame1 adaptee;

    Frame1_jMenuabout_ActionAdapter(Frame1 adaptee)
    {
      this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e)
    {
      adaptee.jMenuabout_ActionPerformed(e);
    }
  }


    void jButton1_actionPerformed(ActionEvent e)                    // 處理修改按鈕的ActionEvent
    {
      try
      {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");               // 實例化JDBC-ODBC橋的驅動
        connection = DriverManager.getConnection("jdbc:odbc:local","sa","hunterd");  // 連接數據庫
        // 創建Statement接口對象
        statement = connection.createStatement();
        if (jTextField1.getText().length() == 0)
        {
          jTextPane1.setText("不能修改，請先輸入學號！");
        }
        else {
          if (jTextField2.getText().length() != 0)
            statement.executeUpdate("update stu_info set 姓名='" +
                                    jTextField2.getText() + "' where 學號='" +
                                    jTextField1.getText() + "'"); // 更新stu_info表中學號相關的記錄
          if (jTextField3.getText().length() != 0)
            statement.executeUpdate("update stu_info set 所屬學院='" +
                                    jTextField3.getText() + "' where 學號='" +
                                    jTextField1.getText() + "'"); // 更新stu_info表中學號相關的記錄
          if (jTextField4.getText().length() != 0)
            statement.executeUpdate("update stu_info set 所屬班級='" +
                                    jTextField4.getText() + "' where 學號='" +
                                    jTextField1.getText() + "'"); // 更新stu_info表中輸入學號的記錄
          if (jTextField2.getText().length() == 0 &
              jTextField3.getText().length() == 0 &
              jTextField4.getText().length() == 0) {
            jTextPane1.setText("修改不成功,請重新輸入！");
          }
          else {
            jTextPane1.setText("記錄修改成功!");
          }
        }
        // 清空信息框
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
      }
      catch(SQLException ex)                                    // 捕捉異常
      {
        jTextPane1.setText(ex.getMessage());
        System.out.println("\nERROR:----- SQLException -----\n");
        while (ex != null)
        {
          System.out.println("Message:   " + ex.getMessage());
          System.out.println("SQLState:  " + ex.getSQLState());
          System.out.println("ErrorCode: " + ex.getErrorCode());
          ex = ex.getNextException();
        }
      }