⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 allselect.java~5~

📁 java语言做的教务管理系统
💻 JAVA~5~
字号:
package java_教务管理系统;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.table.JTableHeader;
import javax.swing.table.DefaultTableModel;
import java.awt.Font;
import javax.swing.BorderFactory;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class allselect extends JPanel {
    public allselect() {
        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();
                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);
        tballselect.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        tballselect.setBounds(new Rectangle(6, 71, 858, 144));
        tballselect.addMouseListener(new allselect_tballselect_mouseAdapter(this));
        jTableHeader1.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
        jTableHeader1.setBounds(new Rectangle(5, 30, 858, 32));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel1.setText("学    号:");
        jLabel1.setBounds(new Rectangle(148, 224, 100, 24));
        txtstuno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtstuno.setBounds(new Rectangle(253, 221, 121, 29));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel2.setText("姓    名:");
        jLabel2.setBounds(new Rectangle(379, 224, 100, 24));
        txtstuname.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtstuname.setBounds(new Rectangle(484, 221, 121, 29));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel3.setText("班级编号:");
        jLabel3.setBounds(new Rectangle(147, 265, 100, 24));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel4.setText("考试科目:");
        jLabel4.setBounds(new Rectangle(614, 266, 100, 24));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel5.setText("考试次数:");
        jLabel5.setBounds(new Rectangle(145, 307, 100, 24));
        txtexaminationnumber.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtexaminationnumber.setBounds(new Rectangle(250, 305, 121, 29));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel6.setText("成    绩:");
        jLabel6.setBounds(new Rectangle(377, 306, 100, 24));
        txtremark.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtremark.setBounds(new Rectangle(482, 304, 121, 29));
        cboclassno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboclassno.setBounds(new Rectangle(252, 261, 64, 32));
        txtremakno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        txtremakno.setBounds(new Rectangle(719, 264, 121, 29));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel7.setText("班级年级:");
        jLabel7.setBounds(new Rectangle(392, 267, 100, 24));
        cboclassSemester.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cboclassSemester.setBounds(new Rectangle(484, 261, 64, 32));
        btnallselect.setBounds(new Rectangle(357, 383, 113, 33));
        btnallselect.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        btnallselect.setText("搜    索");
        btnallselect.addActionListener(new allselect_btnallselect_actionAdapter(this));
        btnexit.setBounds(new Rectangle(475, 383, 113, 33));
        btnexit.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        btnexit.setText("退出搜索");
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel8.setText("性    别:");
        jLabel8.setBounds(new Rectangle(612, 224, 109, 24));
        cbostusex.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        cbostusex.setBounds(new Rectangle(719, 221, 64, 32));
        this.add(jTableHeader1);
        this.add(txtstuno);
        this.add(jLabel1);
        this.add(jLabel2);
        this.add(txtstuname);
        this.add(btnexit);
        this.add(btnallselect);
        this.add(jLabel8);
        this.add(jLabel3);
        this.add(cboclassno);
        this.add(jLabel7);
        this.add(cboclassSemester);
        this.add(txtremakno);
        this.add(jLabel4);
        this.add(cbostusex);
        this.add(jLabel5);
        this.add(txtexaminationnumber);
        this.add(txtremark);
        this.add(jLabel6);
        this.add(tballselect);
    }

    String head[] = {"学号", "姓名", "班级编号","班级年级", "考试科目", "考试次数", "成绩"};
    DefaultTableModel mod = new DefaultTableModel(head, 0);
    JTable tballselect = new JTable(mod);
    JTableHeader jTableHeader1 = tballselect.getTableHeader();
    JLabel jLabel1 = new JLabel();
    JTextField txtstuno = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField txtstuname = new JTextField();
    JLabel jLabel3 = new JLabel();
    JComboBox cboclassno = new JComboBox();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField txtexaminationnumber = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField txtremark = new JTextField();
    JTextField txtremakno = new JTextField();
    JLabel jLabel7 = new JLabel();
    String Semester[] = {"", "S1", "S2", "Y2"};
    JComboBox cboclassSemester = new JComboBox(Semester);
    JButton btnallselect = new JButton();
    JButton btnexit = new JButton();
    JLabel jLabel8 = new JLabel();
    String sex[] = {"", "男", "女"};
    JComboBox cbostusex = new JComboBox(sex);
    public void btnallselect_actionPerformed(ActionEvent e) {
        try {
            String daima = "select stu.stuno,stu.stuname,stu.stusex,class.classno,class.classSemester,result.resultclassno,result.examinationnumber,result.result from stu join class on stu.stuclassno = class.classno join result on stu.stuno=result.resultstuno where 1=1";
            if (!this.txtstuno.getText().equals("")) {
                daima += " and stu.stuno = '" + this.txtstuno.getText() + "'";
            }
            if (!this.txtstuname.getText().equals("")) {
                daima += " and stu.stuname like '%" + this.txtstuname.getText() +
                        "%'";
            }
            if (!this.cbostusex.getSelectedItem().toString().equals("")) {
                daima += " and stu.stusex = '" +
                        this.cbostusex.getSelectedItem().toString() + "'";
            }
            if (!this.cboclassno.getSelectedItem().toString().equals("")) {
                daima += " and class.classno ='" +
                        this.cboclassno.getSelectedItem().toString() + "'";
            }
            if (!this.txtremakno.getText().equals("")) {
                daima += " and result.resultclassno = '" +
                        this.txtremakno.getText() + "'";
            }
            if (!this.txtexaminationnumber.getText().equals("")) {
                daima += " and result.examinationnumber = '" +
                        this.txtexaminationnumber.getText() + "'";
            }
            if (!this.txtremark.getText().equals("")) {
                daima += " and result.result = '" + this.txtremark.getText() +
                        "'";
            }
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection nod = DriverManager.getConnection("jdbc:odbc:studer");
            PreparedStatement sql = nod.prepareStatement(daima);
            ResultSet i = sql.executeQuery();
            mod.setNumRows(0);
            while (i.next()) {
                Object j[] = {i.getString(1), i.getString(2), i.getString(3),
                             i.getString(4), i.getString(5), i.getString(6),
                             i.getString(7),i.getString(8)};
                mod.addRow(j);
            }
            tballselect.updateUI();
            i.close();
            sql.close();
            nod.close();

        } catch (Exception ex) {

        }
    }

    public void tballselect_mouseClicked(MouseEvent e) {
        int row = this.tballselect.getSelectedRow();
        if (row > -1) {
            this.txtstuno.setText(this.tballselect.getValueAt(row, 0).toString());
            this.txtstuname.setText(this.tballselect.getValueAt(row, 1).
                                            toString());
            this.cbostusex.setSelectedItem(this.tballselect.getValueAt(row,
                    2).
                                                  toString());
            this.cboclassno.setSelectedItem(this.tballselect.getValueAt(row,
                    3).toString());
            this.cboclassSemester.setSelectedItem(this.tballselect.getValueAt(row,4).toString());
            this.txtremakno.setText(this.tballselect.getValueAt(row, 5).
                                         toString());
            this.txtexaminationnumber.setText(this.tballselect.getValueAt(row,6).toString());
            this.txtremark.setText(this.tballselect.getValueAt(row,7).toString());
        }
    }
}


class allselect_tballselect_mouseAdapter extends MouseAdapter {
    private allselect adaptee;
    allselect_tballselect_mouseAdapter(allselect adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.tballselect_mouseClicked(e);
    }
}


class allselect_btnallselect_actionAdapter implements ActionListener {
    private allselect adaptee;
    allselect_btnallselect_actionAdapter(allselect adaptee) {
        this.adaptee = adaptee;
    }

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

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -