stuselect.java~26~

java语言做的教务管理系统

package java_教务管理系统;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.JTableHeader;
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;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.Font;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class stuselect extends JPanel {
    public stuselect() {
        try {
            jbInit();
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection conn = DriverManager.getConnection(
                        "jdbc:odbc:studer");
                PreparedStatement sql = conn.prepareStatement(
                        "select classno from class");
                ResultSet i = sql.executeQuery();
                this.cboclassno.addItem("");
                while (i.next()) {
                    this.cboclassno.addItem(i.getString(1));
                }
            } catch (Exception ex) {

            }

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

    private void jbInit() throws Exception {
        this.setLayout(null);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel1.setText("月");
        jLabel1.setBounds(new Rectangle(642, 301, 20, 21));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel2.setText("家庭地址：");
        jLabel2.setBounds(new Rectangle(70, 368, 102, 29));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel3.setText("性别：");
        jLabel3.setBounds(new Rectangle(658, 264, 71, 27));
        cbostubirthdaymonth.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        cbostubirthdaymonth.setBounds(new Rectangle(562, 298, 75, 29));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel4.setText("状态：");
        jLabel4.setBounds(new Rectangle(497, 438, 63, 32));
        cbostubirthdaydate.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        cbostubirthdaydate.setBounds(new Rectangle(665, 298, 58, 29));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel5.setText("出生日期：");
        jLabel5.setBounds(new Rectangle(360, 306, 82, 20));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel6.setText("身份证号码：");
        jLabel6.setBounds(new Rectangle(251, 334, 111, 33));
        txtstuno.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        txtstuno.setBounds(new Rectangle(155, 264, 165, 27));
        txtstuname.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        txtstuname.setBounds(new Rectangle(446, 263, 140, 27));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel7.setText("学号：");
        jLabel7.setBounds(new Rectangle(98, 267, 67, 27));
        txtstuphoto.setBounds(new Rectangle(155, 403, 192, 28));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel8.setText("联系电话：");
        jLabel8.setBounds(new Rectangle(73, 402, 102, 33));
        txtstuidcard.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        txtstuidcard.setBounds(new Rectangle(346, 335, 269, 28));
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel9.setText("日");
        jLabel9.setBounds(new Rectangle(735, 296, 20, 31));
        tbstu.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        tbstu.setBounds(new Rectangle(1, 112, 860, 147));
        tbstu.addMouseListener(new stuselect_tbstu_mouseAdapter(this));
        cbostubirthdayyear.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        cbostubirthdayyear.setBounds(new Rectangle(449, 299, 76, 28));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel10.setText("姓名：");
        jLabel10.setBounds(new Rectangle(388, 261, 68, 30));
        jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel11.setText("班级编号：");
        jLabel11.setBounds(new Rectangle(69, 303, 87, 28));
        txasturemarks.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txasturemarks.setBounds(new Rectangle(155, 469, 648, 71));
        txtstuschool.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        txtstuschool.setBounds(new Rectangle(551, 403, 252, 28));
        cbostubackground.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        cbostubackground.setBounds(new Rectangle(155, 437, 114, 28));
        cbostusex.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        cbostusex.setBounds(new Rectangle(716, 263, 87, 27));
        txtstuaddress.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        txtstuaddress.setBounds(new Rectangle(155, 369, 648, 28));
        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel12.setText("备注：");
        jLabel12.setBounds(new Rectangle(103, 470, 73, 34));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel13.setText("最高学历：");
        jLabel13.setBounds(new Rectangle(74, 441, 100, 27));
        cbostuappearance.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        cbostuappearance.setBounds(new Rectangle(551, 437, 86, 28));
        jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel14.setText("年");
        jLabel14.setBounds(new Rectangle(535, 299, 29, 25));
        jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jLabel15.setText("毕业学校：");
        jLabel15.setBounds(new Rectangle(467, 406, 93, 25));
        btnstuselect.setBounds(new Rectangle(234, 550, 140, 41));
        btnstuselect.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        btnstuselect.setText("查询学生");
        btnstuselect.addActionListener(new stuselect_btnstuselect_actionAdapter(this));
        jTableHeader1.setBounds(new Rectangle(0, 89, 861, 22));
        btnexit.setBounds(new Rectangle(476, 550, 140, 41));
        btnexit.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        btnexit.setText("退出查询");
        jLabel16.setFont(new java.awt.Font("华文彩云", Font.PLAIN, 50));
        jLabel16.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel16.setText("查询学生信息");
        jLabel16.setBounds(new Rectangle(3, 4, 791, 90));
        cboclassno.setBounds(new Rectangle(155, 300, 163, 27));
        this.add(jLabel16);
        this.add(jTableHeader1);
        this.add(tbstu);
        this.add(cbostubirthdaymonth);
        this.add(jLabel9);
        this.add(cbostubirthdaydate);
        this.add(jLabel1);
        this.add(jLabel14);
        this.add(cbostubirthdayyear);
        this.add(jLabel10);
        this.add(txtstuname);
        this.add(jLabel3);
        this.add(cbostusex);
        this.add(jLabel7);
        this.add(jLabel11);
        this.add(jLabel5);
        this.add(txtstuno);
        this.add(txtstuidcard);
        this.add(jLabel6);
        this.add(txtstuaddress);
        this.add(jLabel2);
        this.add(txtstuphoto);
        this.add(jLabel15);
        this.add(jLabel8);
        this.add(jLabel13);
        this.add(cbostubackground);
        this.add(jLabel4);
        this.add(txtstuschool);
        this.add(jLabel12);
        this.add(txasturemarks);
        this.add(btnexit);
        this.add(btnstuselect);
        this.add(cbostuappearance);
        this.add(cboclassno);
    }

    //性别
    String stusex[] = {"", "男", "女"};
    //出生时间（年）
    String stubirthdayyear[] = {"", "1981", "1982", "1983", "1984", "1985",
                               "1986", "1987", "1988", "1989", "1990", "1991",
                               "1992", "1993"};
//出生时间（月）
    String stubirthdaymonth[] = {"", "01", "02", "03", "04", "05", "06", "07",
                                "08",
                                "09",
                                "10", "11", "12"};
//出生时间（日）
    String stubirthdaydate[] = {"", "01", "02", "03", "04", "05", "06", "07",
                               "08",
                               "09",
                               "10", "11", "12", "13", "14", "15", "16", "17",