package xiangmu;

import java.awt.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.border.EtchedBorder;
import javax.swing.border.Border;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Connection;

/**
 * <p>Title: 第四學習小組-教學管理系統</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class StudentQ extends JFrame {
    String cols[] = {"班級編號", "  學 號", "  姓 名", "  性 別", " 身份證", "出生日期", "家庭住址",
                    "聯系方式", "畢業學校", "  學 歷", "入學學期", "入學日期", "  證 書", "  狀 態",
                    "  備 注"};
    DefaultTableModel bg = new DefaultTableModel(cols, 0);
    public StudentQ() {
        try {
            jbInit();
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection conn = DriverManager.getConnection(
                        "jdbc:odbc:xiangmu");
                PreparedStatement sql = conn.prepareStatement(
                        "select ClassNo,StudentNo from StudentInfo");
                ResultSet i = sql.executeQuery();
                while (i.next()) {
                    this.cmbClassNo.addItem(i.getString(1));
                    this.cmbStudentNo.addItem(i.getString(2));
                }
            } catch (Exception ex) {

            }

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

    private void jbInit() throws Exception {
        this.setResizable(false);
        getContentPane().setLayout(null);
        btnQuery.setBounds(new Rectangle(475, 7, 90, 33));
        btnQuery.setFont(new java.awt.Font("宋體", Font.BOLD, 12));
        btnQuery.setText("查  詢");
        btnQuery.addActionListener(new StudentQ_jButton1_actionAdapter(this));
        cmbClassNo.setBounds(new Rectangle(212, 7, 90, 33));
        jLabel2.setFont(new java.awt.Font("宋體", Font.BOLD, 12));
        jLabel2.setText("所屬班級：");
        jLabel2.setBounds(new Rectangle(150, 18, 67, 15));
        jScrollPane1.setBorder(border1);
        jScrollPane1.setBounds(new Rectangle(8, 46, 790, 402));
        jLabel1.setFont(new java.awt.Font("宋體", Font.BOLD, 12));
        jLabel1.setText("學員編號：");
        jLabel1.setBounds(new Rectangle(309, 12, 76, 22));
        cmbStudentNo.setBounds(new Rectangle(374, 7, 91, 33));
        jButton2.addActionListener(new StudentQ_jButton2_actionAdapter(this));
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(cmbClassNo);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(btnQuery);
        this.getContentPane().add(cmbStudentNo);
        this.getContentPane().add(jLabel1);
        jScrollPane1.getViewport().add(jTable1);
        jButton2.setBounds(new Rectangle(573, 7, 90, 33));
        jButton2.setFont(new java.awt.Font("宋體", Font.BOLD, 12));
        jButton2.setText("退  出");
        jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
                                                VERTICAL_SCROLLBAR_ALWAYS);
        setTitle("教學管理系統-學生信息查詢");
    }

    JButton btnQuery = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel2 = new JLabel();
    String classno[] = {""};
    JComboBox cmbClassNo = new JComboBox(classno);
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable(bg);
    Border border1 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(170, 170, 170));
    JLabel jLabel1 = new JLabel();
    String student[] = {""};
    JComboBox cmbStudentNo = new JComboBox(student);
    public void jButton2_actionPerformed(ActionEvent e) {
        if (JOptionPane.showConfirmDialog(this, "是否確定退出學生信息查詢", "溫馨提示",
                                          JOptionPane.OK_CANCEL_OPTION) ==
            JOptionPane.OK_OPTION) {
            Dimension screenSize = Toolkit.getDefaultToolkit().
                                   getScreenSize();
            this.dispose();
        }

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try {
            String sql = "select * from StudentInfo where 1=1 ";
            if (!this.cmbStudentNo.getSelectedItem().toString().equals("")) {
                sql += " and StudentNo ='" +
                        this.cmbStudentNo.getSelectedItem().toString() + "'";
            }
            if (!this.cmbClassNo.getSelectedItem().toString().equals("")) {
                sql += " and ClassNo ='" +
                        this.cmbClassNo.getSelectedItem().toString() + "'";
            }
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");
            PreparedStatement ps = conn.prepareStatement(sql);
            ResultSet rs = ps.executeQuery();
            bg.setRowCount(0);
            while (rs.next()) {
                Object val[] = {rs.getString(1), rs.getString(2),
                               rs.getString(3), rs.getString(4), rs.getString(5),
                               rs.getString(6),
                               rs.getString(7), rs.getString(8), rs.getString(9),
                               rs.getString(10), rs.getString(11),
                               rs.getString(12), rs.getString(13),
                               rs.getString(14), rs.getString(15)};
                bg.addRow(val);
            }
            jTable1.updateUI();
            rs.close();
            ps.close();
            conn.close();
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(this, "查詢失敗！");
        }

    }
}


class StudentQ_jButton1_actionAdapter implements ActionListener {
    private StudentQ adaptee;
    StudentQ_jButton1_actionAdapter(StudentQ adaptee) {
        this.adaptee = adaptee;
    }

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


class StudentQ_jButton2_actionAdapter implements ActionListener {
    private StudentQ adaptee;
    StudentQ_jButton2_actionAdapter(StudentQ adaptee) {
        this.adaptee = adaptee;
    }

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