lessoninfocheck.java~75~

Tt s a good book ,if you want to learn java good

package sos;

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

public class LessonInfoCheck extends JDialog implements ActionListener {
    String[] columnName = {"课程编号", "课程名称", "课程性质", "课程学分"};
    String[][] lessonInfo;
    JLabel jLabel_Info = new JLabel();
    JTextField jTextField_Search = new JTextField();
    JLabel jLabel_Search = new JLabel();
    JLabel jLabel_MainTable = new JLabel();
    JScrollPane jScrollPane_TablePane = new JScrollPane();
    JButton jButton_Search = new JButton();
    JButton jButton_OK = new JButton();
    JTable jTable_LessonInfo;
    JButton jButton_All = new JButton();
    JButton jButton_Reset = new JButton();
    JButton jButton_ResetTable = new JButton();
    public LessonInfoCheck(Frame frame, boolean modal) {
        super(frame, modal);
        setTitle("课程信息查询");
        setSize(675, 400);
        setResizable(false);
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = getSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        setLocation((screenSize.width - frameSize.width) / 2,
                    (screenSize.height - frameSize.height) / 2);
        setVisible(true);
    }

    public void showDetail() {
        String tempLessonNumber = jTextField_Search.getText().trim();
        boolean haveFound = false;
        try {
            if (tempLessonNumber.equals("")) {
                JOptionPane.showMessageDialog(this,
                                              "注意！课程号不能为空！",
                                              "注意！", 2);

                throw new Exception();
            }
            Statement stmt;
            ResultSet rs;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU",
                    "",
                    "");
            stmt = con.createStatement();
            rs = stmt.executeQuery("select * from LessonInfo");
            while (rs.next()) {
                String temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8,
                        temp9;
                temp1 = rs.getString(2);
                temp2 = rs.getString(3);
                temp3 = rs.getString(4);
                temp4 = rs.getString(5);
                temp5 = rs.getString(6);
                temp6 = rs.getString(7);
                temp7 = rs.getString(8);
                temp8 = rs.getString(9);
                temp9 = rs.getString(10);
                if (temp1.equals(tempLessonNumber)) {
                    JOptionPane.showMessageDialog(this,
                                                  "课程编号：" + temp1 +
                                                  "；课程名称：" + temp2 +
                                                  "；课程性质：" + temp3 +
                                                  "；课程学分：" + temp4 +
                                                  "；\n上课地点：" + temp5 +
                                                  "；授课教师：" + temp6 +
                                                  "；课程学时：" + temp7 +
                                                  "；考试类型：" + temp8 +
                                                  "；实验：" + temp9 +
                                                  "。",
                                                  "课程详细信息", 2);
                    haveFound = true;
                    break;
                }
            }
            if (!haveFound) {
                JOptionPane.showMessageDialog(this,
                                              "抱歉，没找到课程号为“" + tempLessonNumber +
                                              "”的课程记录。请检查您输入的课程号是否正确！如有其它问题请与管理员联系。",
                                              "注意！", 2);
                haveFound = false;
            }
            stmt.close();
            con.close();
        } catch (Exception e) {}
    }

    public void getAll() {
        int numberOfLessons = 0, row = 0;
        try {
            Statement stmt;
            ResultSet rs;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU",
                    "",
                    "");
            stmt = con.createStatement();
            rs = stmt.executeQuery("select 学期 from LessonInfo");
            while (rs.next()) {
                numberOfLessons++;
            }
            lessonInfo = new String[numberOfLessons][4];
            rs = stmt.executeQuery("select * from LessonInfo");
            while (rs.next()) {
                for (int column = 1; column <= 4; column++) {
                    lessonInfo[row][column - 1] = rs.getString(column + 1);
                }
                row++;
            }
            row = 0;
            stmt.close();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        jTable_LessonInfo = new JTable(lessonInfo, columnName);
        jTable_LessonInfo.setCellSelectionEnabled(false);
        jScrollPane_TablePane.getViewport().add(jTable_LessonInfo);
        jTable_LessonInfo.setVisible(true); //###########################
    }

    public void actionPerformed(ActionEvent e) {
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        jLabel_Info.setFont(new java.awt.Font("隶书", Font.BOLD | Font.ITALIC, 25));
        jLabel_Info.setForeground(Color.blue);
        jLabel_Info.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel_Info.setText("正在进行课程信息查询");
        jLabel_Info.setBounds(new Rectangle(3, 1, 664, 30));
        jTextField_Search.setHorizontalAlignment(SwingConstants.CENTER);
        jTextField_Search.setBounds(new Rectangle(134, 34, 123, 29));
        jTextField_Search.addActionListener(new
                                            LessonInfoCheck_jTextField_Search_actionAdapter(this));
        jLabel_Search.setBackground(UIManager.getColor(
                "ColorChooser.background"));
        jLabel_Search.setFont(new java.awt.Font("华文新魏", Font.PLAIN, 15));
        jLabel_Search.setToolTipText("");
        jLabel_Search.setText("输入查询课程号：");
        jLabel_Search.setBounds(new Rectangle(8, 36, 126, 28));
        this.getContentPane().setBackground(SystemColor.control);
        jLabel_MainTable.setFont(new java.awt.Font("隶书", Font.PLAIN, 20));
        jLabel_MainTable.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel_MainTable.setText("课程信息汇总表");
        jLabel_MainTable.setBounds(new Rectangle(2, 65, 665, 32));
        jScrollPane_TablePane.setHorizontalScrollBarPolicy(JScrollPane.
                HORIZONTAL_SCROLLBAR_ALWAYS);
        jScrollPane_TablePane.setVerticalScrollBarPolicy(JScrollPane.
                VERTICAL_SCROLLBAR_ALWAYS);
        jScrollPane_TablePane.setBounds(new Rectangle(5, 101, 657, 222));
        jButton_Search.setBounds(new Rectangle(262, 34, 130, 29));
        jButton_Search.setFont(new java.awt.Font("华文行楷", Font.PLAIN, 15));
        jButton_Search.setText(" 输入课程查询");
        jButton_Search.addActionListener(new
                                         LessonInfoCheck_jButton_Search_actionAdapter(this));
        jButton_OK.setBounds(new Rectangle(369, 332, 136, 31));
        jButton_OK.setFont(new java.awt.Font("华文新魏", Font.PLAIN, 15));
        jButton_OK.setText("确定");
        jButton_OK.addActionListener(new LessonInfoCheck_jButton1_actionAdapter(this));
        jButton_All.setBounds(new Rectangle(530, 34, 130, 29));
        jButton_All.setFont(new java.awt.Font("华文行楷", Font.PLAIN, 15));
        jButton_All.setText(" 课程信息汇总");
        jButton_All.addActionListener(new
                                      LessonInfoCheck_jButton_All_actionAdapter(this));
        jButton_Reset.setBounds(new Rectangle(396, 34, 130, 29));
        jButton_Reset.setFont(new java.awt.Font("华文行楷", Font.PLAIN, 15));
        jButton_Reset.setText(" 重置查询课程");
        jButton_Reset.addActionListener(new
                                        LessonInfoCheck_jButton_Reset_actionAdapter(this));
        jButton_ResetTable.setBounds(new Rectangle(156, 332, 136, 31));
        jButton_ResetTable.setFont(new java.awt.Font("华文新魏", Font.PLAIN, 15));
        jButton_ResetTable.setText("重置");
        jButton_ResetTable.addActionListener(new
                                             LessonInfoCheck_jButton_ResetTable_actionAdapter(this));
        this.getContentPane().add(jLabel_Info);
        this.getContentPane().add(jLabel_Search);
        this.getContentPane().add(jTextField_Search);
        this.getContentPane().add(jButton_Search);
        this.getContentPane().add(jLabel_MainTable);
        this.getContentPane().add(jButton_Reset);
        this.getContentPane().add(jButton_All);
        this.getContentPane().add(jButton_OK);
        this.getContentPane().add(jButton_ResetTable);
        this.getContentPane().add(jScrollPane_TablePane);
    }

    public static void main(String[] args) {
        new LessonInfoCheck(new AFrame(), true);
    }

    public void jButton_All_actionPerformed(ActionEvent e) {
        getAll();
    }

    public void jButton_Search_actionPerformed(ActionEvent e) {
        showDetail();
    }

    public void jTextField_Search_actionPerformed(ActionEvent e) {
        showDetail();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        dispose();
    }

    public void jButton_Reset_actionPerformed(ActionEvent e) {
        jTextField_Search.setText("");
    }

    public void jButton_ResetTable_actionPerformed(ActionEvent e) {
        if (jTable_LessonInfo != null) {
            jTable_LessonInfo.setVisible(false);
        }
    }
}


class LessonInfoCheck_jButton_ResetTable_actionAdapter implements
        ActionListener {
    private LessonInfoCheck adaptee;
    LessonInfoCheck_jButton_ResetTable_actionAdapter(LessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class LessonInfoCheck_jButton_Reset_actionAdapter implements ActionListener {
    private LessonInfoCheck adaptee;
    LessonInfoCheck_jButton_Reset_actionAdapter(LessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class LessonInfoCheck_jButton1_actionAdapter implements ActionListener {
    private LessonInfoCheck adaptee;
    LessonInfoCheck_jButton1_actionAdapter(LessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class LessonInfoCheck_jTextField_Search_actionAdapter implements ActionListener {
    private LessonInfoCheck adaptee;
    LessonInfoCheck_jTextField_Search_actionAdapter(LessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class LessonInfoCheck_jButton_Search_actionAdapter implements ActionListener {
    private LessonInfoCheck adaptee;
    LessonInfoCheck_jButton_Search_actionAdapter(LessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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


class LessonInfoCheck_jButton_All_actionAdapter implements ActionListener {
    private LessonInfoCheck adaptee;
    LessonInfoCheck_jButton_All_actionAdapter(LessonInfoCheck adaptee) {
        this.adaptee = adaptee;
    }

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