studentq.java~9~

S1项目本需求规格说明描述了北大青鸟ACCP教学管理系统项目的要求

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();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        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);
    }

    JButton btnQuery = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel2 = new JLabel();
     String classno[]={"","T64","T65","T58"};
    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[]={"","0801","0802","0803","0804","0805","0806"};
    JComboBox cmbStudentNo = new JComboBox(student);
    public void jButton2_actionPerformed(ActionEvent e) {
      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);
    }
}