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

/**
 * <p>Title: 碩卓學籍管理系統</p>
 * <p>Description: 課程設計項目</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: 碩卓軟件公司</p>
 * @author 盛守卓
 * @version 1.0
 */

public class SearchInf
    extends JFrame
    implements ActionListener {

  String strurl;
  Connection conn;
  Statement stmt;
  ResultSet rs;
  Label label1 = new Label();
  TextField textField1 = new TextField();
  Label label2 = new Label();
  TextField textField2 = new TextField();
  Label label3 = new Label();
  Choice choice1 = new Choice();
  Label label4 = new Label();
  TextField textField3 = new TextField();
  Label label5 = new Label();
  Choice choice2 = new Choice();
  Label label6 = new Label();
  TextField textField4 = new TextField();
  Label label7 = new Label();
  Choice choice3 = new Choice();
  Label label8 = new Label();
  TextField textField5 = new TextField();
  Label label9 = new Label();
  TextArea textArea1 = new TextArea();
  Button button1 = new Button();
  TextField textField6 = new TextField();
  Button button2 = new Button();
  Label label10 = new Label();
  Label label12 = new Label();
  Label label13 = new Label();
  TextField textField7 = new TextField();

  public SearchInf() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    label1.setText("學        號:");
    label1.setVisible(false);
    label1.setBounds(new Rectangle(30, 11, 51, 33));
    this.getContentPane().setLayout(null);
    textField1.setText("");
    textField1.setVisible(false);
    textField1.setBounds(new Rectangle(86, 16, 74, 22));
    label2.setBounds(new Rectangle(162, 11, 28, 33));
    label2.setText("姓名:");
    label2.setVisible(false);
    textField2.setText("");
    textField2.setVisible(false);
    textField2.setBounds(new Rectangle(192, 16, 44, 22));
    label3.setText("性別:");
    label3.setVisible(false);
    label3.setBounds(new Rectangle(241, 11, 28, 33));
    choice1.setEnabled(true);
    choice1.setFont(new java.awt.Font("Dialog", 0, 12));
    choice1.setForeground(Color.black);
    choice1.setLocale(java.util.Locale.getDefault());
    choice1.setVisible(false);
    choice1.setBounds(new Rectangle(275, 15, 50, 25));
    choice1.addItem("男");
    choice1.addItem("女");
    this.setDefaultCloseOperation(HIDE_ON_CLOSE);
    this.setEnabled(true);
    this.setResizable(false);
    this.setTitle("查詢學生信息");
    label4.setBounds(new Rectangle(31, 53, 49, 33));
    label4.setText("出生日期:");
    label4.setVisible(false);
    textField3.setBounds(new Rectangle(86, 58, 74, 22));
    textField3.setLocale(java.util.Locale.getDefault());
    textField3.setText("");
    textField3.setVisible(false);
    label5.setText("政治面貌:");
    label5.setVisible(false);
    label5.setBounds(new Rectangle(241, 53, 47, 33));
    choice2.setBounds(new Rectangle(296, 57, 72, 25));
    choice2.setLocale(java.util.Locale.getDefault());
    choice2.setVisible(false);
    choice2.setForeground(Color.black);
    choice2.setFont(new java.awt.Font("Dialog", 0, 12));
    choice2.setEnabled(true);
    label6.setText("籍貫:");
    label6.setVisible(false);
    label6.setBounds(new Rectangle(163, 53, 26, 33));
    textField4.setBounds(new Rectangle(191, 58, 44, 22));
    textField4.setText("");
    textField4.setVisible(false);
    label7.setBounds(new Rectangle(30, 94, 50, 33));
    label7.setText("系        別:");
    label7.setVisible(false);
    choice3.setEnabled(true);
    choice3.setFont(new java.awt.Font("Dialog", 0, 12));
    choice3.setForeground(Color.black);
    choice3.setLocale(java.util.Locale.getDefault());
    choice3.setVisible(false);
    choice3.setBounds(new Rectangle(86, 98, 75, 25));
    label8.setBounds(new Rectangle(163, 94, 26, 33));
    label8.setText("專業:");
    label8.setVisible(false);
    textField5.setText("");
    textField5.setVisible(false);
    textField5.setBounds(new Rectangle(190, 99, 178, 22));
    label9.setText("備        注:");
    label9.setVisible(false);
    label9.setBounds(new Rectangle(27, 132, 50, 33));
    textArea1.setVisible(false);
    textArea1.setBounds(new Rectangle(84, 139, 285, 95));
    button1.setLabel("下一條");
    button1.setVisible(false);
    button1.setBounds(new Rectangle(153, 242, 94, 22));
    button1.addActionListener(this);
    textField6.setText("");
    textField6.setBounds(new Rectangle(177, 83, 83, 22));
    button2.setBounds(new Rectangle(164, 177, 73, 22));
    button2.setLabel("確定");
    button2.setVisible(true);
    button2.addActionListener(this);
    label10.setBounds(new Rectangle(124, 86, 28, 16));
    label10.setText("學號:");
    label12.setBounds(new Rectangle(144, 36, 114, 30));
    label12.setText("請選擇查詢條件");
    label12.setFont(new java.awt.Font("Dialog", 1, 15));
    label13.setText("姓名:");
    label13.setBounds(new Rectangle(124, 130, 28, 16));
    textField7.setBounds(new Rectangle(178, 127, 83, 22));
    textField7.setText("");
    this.getContentPane().add(label3, null);
    this.getContentPane().add(label1, null);
    this.getContentPane().add(textField1, null);
    this.getContentPane().add(label2, null);
    this.getContentPane().add(textField2, null);
    this.getContentPane().add(choice1, null);
    this.getContentPane().add(label4, null);
    this.getContentPane().add(textField3, null);
    this.getContentPane().add(label6, null);
    this.getContentPane().add(textField4, null);
    this.getContentPane().add(label5, null);
    this.getContentPane().add(choice2, null);
    this.getContentPane().add(label7, null);
    this.getContentPane().add(choice3, null);
    this.getContentPane().add(label8, null);
    this.getContentPane().add(textField5, null);
    this.getContentPane().add(label9, null);
    this.getContentPane().add(textArea1, null);
    this.getContentPane().add(label13, null);
    this.getContentPane().add(label10, null);
    this.getContentPane().add(label12, null);
    this.getContentPane().add(button1, null);
    this.getContentPane().add(textField7, null);
    this.getContentPane().add(textField6, null);
    this.getContentPane().add(button2, null);
    choice2.addItem("團員");
    choice2.addItem("黨員");
    choice2.addItem("其他");
    choice3.addItem("計算機");
    choice3.addItem("電子");
    choice3.addItem("生化");
    choice3.addItem("藝術");
    strurl =
        "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/student.mdb";
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    conn = DriverManager.getConnection(strurl);
    stmt = conn.createStatement();
  }

  public void actionPerformed(ActionEvent e) {
    try {
      if (e.getSource() == button2) {
        if (textField6.getText().trim().equals("")||
            textField7.getText().trim().equals(""))
          rs = stmt.executeQuery("SELECT * FROM BaseInf where 學號='" +
                                 textField6.getText() + "' OR 姓名='"
                                 + textField7.getText() + "'");
        else if (textField6.getText().trim().equals("")&&
                 textField7.getText().trim().equals(""))
          JOptionPane.showMessageDialog(null, "請至少輸入一個條件", "警告",
                                        JOptionPane.WARNING_MESSAGE);
        else
          rs = stmt.executeQuery("SELECT * FROM BaseInf where 學號='" +
                                 textField6.getText() + "' AND 姓名='"
                                 + textField7.getText() + "'");
        if (rs.next()) {
          textField6.setVisible(false);
          textField7.setVisible(false);
          button2.setVisible(false);
          label10.setVisible(false);
          label12.setVisible(false);
          label13.setVisible(false);
          label1.setVisible(true);
          label2.setVisible(true);
          label3.setVisible(true);
          label4.setVisible(true);
          label5.setVisible(true);
          label6.setVisible(true);
          label7.setVisible(true);
          label8.setVisible(true);
          label9.setVisible(true);
          textArea1.setVisible(true);
          textArea1.setText(rs.getString("備注"));
          textField1.setVisible(true);
          textField1.enable(false);
          textField1.setText(rs.getString("學號"));
          textField2.setVisible(true);
          textField2.setText(rs.getString("姓名"));
          textField3.setVisible(true);
          textField3.setText(rs.getString("出年日期"));
          textField4.setVisible(true);
          textField4.setText(rs.getString("籍貫"));
          textField5.setVisible(true);
          textField5.setText(rs.getString("專業"));
          choice1.setVisible(true);
          choice1.select(rs.getString("性別"));
          choice2.setVisible(true);
          choice2.select(rs.getString("政治面貌"));
          choice3.setVisible(true);
          choice3.select(rs.getString("系別"));
          button1.setVisible(true);
          if (!rs.next())
            button1.setEnabled(false);
        }
        else
          JOptionPane.showMessageDialog(null, "無此條件對應信息", "警告",
                                        JOptionPane.WARNING_MESSAGE);
      }
      else if (e.getSource() == button1) {
        textArea1.setText(rs.getString("備注"));
        textField1.setText(rs.getString("學號"));
        textField2.setText(rs.getString("姓名"));
        textField3.setText(rs.getString("出年日期"));
        textField4.setText(rs.getString("籍貫"));
        textField5.setText(rs.getString("專業"));
        choice1.select(rs.getString("性別"));
        choice2.select(rs.getString("政治面貌"));
        choice3.select(rs.getString("系別"));
        if (!rs.next())
          button1.setEnabled(false);
      }

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