frame_find.java~72~

学生成绩管理系统

package teamwork;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import java.awt.Color;
import javax.swing.JButton;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JTable;
import com.borland.dx.sql.dataset.Database;
import com.borland.dbswing.JdbTable;
import javax.swing.JLabel;
import javax.swing.JComboBox;
import javax.swing.JTextField;
import javax.swing.JTabbedPane;
import javax.swing.JScrollPane;

/**
 * <p>Title: teamwork</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author yeliang
 * @version 1.0
 */
public class Frame_find extends JFrame {

    studentDA s = new studentDA();

    JButton jButton_back = new JButton();
    JLabel jLabel1 = new JLabel();
    JComboBox jComboBox1 = new JComboBox();
    JLabel jLabel_findinput = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton_OK = new JButton();
    JLabel nofound = new JLabel();
    JLabel jLabel_inf_title = new JLabel();
    JLabel jLabel_inf1 = new JLabel();
    JLabel jLabel_inf2 = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable(50,3);
    public Frame_find() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.getContentPane().setBackground(new Color(100, 180, 255));
        jButton_back.setBackground(new Color(100, 180, 255));
        jButton_back.setBounds(new Rectangle(8, 420, 480, 40));
        jButton_back.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jButton_back.setForeground(Color.orange);
        jButton_back.setText("返 回 主 界 面");
        jButton_back.addActionListener(new
                                       Frame_find_jButton_back_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel1.setText("请选择查询方式：");
        jLabel1.setBounds(new Rectangle(29, 21, 104, 16));
        jComboBox1.setBounds(new Rectangle(28, 41, 110, 20));
        jComboBox1.addActionListener(new Frame_find_jComboBox1_actionAdapter(this));
        jComboBox1.addItem("按学生姓名查找");
        jComboBox1.addItem("按学生学号查找");
        jLabel_findinput.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel_findinput.setText("请输入姓名：");
        jLabel_findinput.setBounds(new Rectangle(144, 44, 80, 16));
        jTextField1.setEnabled(true);
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(231, 40, 134, 21));

        jButton_OK.setBounds(new Rectangle(379, 38, 71, 25));
        jButton_OK.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jButton_OK.setText("确定");
        jButton_OK.addActionListener(new Frame_find_jButton_OK_actionAdapter(this));

        nofound.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        nofound.setText("没找到，请重新输入");
        nofound.setBounds(new Rectangle(28, 72, 162, 16));
        nofound.setVisible(false);
        jLabel_inf_title.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel_inf_title.setText("学生基本信息：");
        jLabel_inf_title.setBounds(new Rectangle(28, 96, 94, 16));
        jLabel_inf_title.setVisible(false);
        jLabel_inf1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel_inf1.setText("");
        jLabel_inf1.setBounds(new Rectangle(27, 118, 423, 16));
        jLabel_inf1.setVisible(false);
        jLabel_inf2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel_inf2.setText("学生成绩信息：");
        jLabel_inf2.setBounds(new Rectangle(28, 139, 92, 16));
        jScrollPane1.getViewport().setBackground(new Color(100, 180, 255));
        jScrollPane1.setBounds(new Rectangle(27, 163, 431, 232));
        jTable1.setBackground(new Color(100, 180, 255));

        this.getContentPane().add(jButton_back, null);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jLabel_findinput);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton_OK);
        this.getContentPane().add(nofound);
        this.getContentPane().add(jLabel_inf_title);
        this.getContentPane().add(jLabel_inf2);
        this.getContentPane().add(jLabel_inf1);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        jTable1.getColumnModel().getColumn(0).setHeaderValue("学期");
        jTable1.getColumnModel().getColumn(1).setHeaderValue("课程名称");
        jTable1.getColumnModel().getColumn(2).setHeaderValue("分数");
        jScrollPane1.setVisible(false);

        //jScrollPane1.
        //jTable1.setValueAt("学期",0,0);
        //jTable1.setValueAt("课程",0,1);
        //jTable1.setValueAt("分数",0,2);


    }

    public static void main(String[] args) {
        //new Frame_find();
    }

    public void jButton_back_actionPerformed(ActionEvent e) {
        this.dispose();
        new Frame1().setVisible(true);
    }

    public void jComboBox1_actionPerformed(ActionEvent e) {
        if(jComboBox1.getSelectedIndex() == 0)
            jLabel_findinput.setText("请输入姓名：");
        else if(jComboBox1.getSelectedIndex() == 1)
            jLabel_findinput.setText("请输入学号：");
    }

    public void jButton_OK_actionPerformed(ActionEvent e) {

        s.readdata();
        jButton_OK.setEnabled(false);
        /*for(int i=0;i<s.num_student;i++)
            System.out.print(
                s.students[i].name + " " + s.students[i].inf_tearm[2].sub[0] + " " + s.students[i].inf_tearm[2].sub_mark[0]);*/
        String key;
        key = jTextField1.getText();
        boolean found=false;
        int n=0;//被查找到的学生
        if(jComboBox1.getSelectedIndex()==0)
            for(int i=0;i<s.num_student;i++)
                if(key.equals(s.students[i].name)){
                    found = true;
                    n = i;
                    //print_inf(s.students[i]);
                    break;
                }
        if(jComboBox1.getSelectedIndex()==1)
            for(int j=0;j<s.num_student;j++)
                if(key.equals(s.students[j].id)){
                    found = true;
                    n = j;
                    //print_inf(s.student[j]);
                    break;
                }
        if(found){
            nofound.setVisible(false);
            jLabel_inf_title.setVisible(true);
            jLabel_inf1.setVisible(true);
            jLabel_inf1.setText("姓名：" + s.students[n].name + "  性别："
                                + s.students[n].sex + "   班级：" + s.students[n].classNo + "  学号：" + s.students[n].id);
            this.setSize(500, 500);
            jButton_back.setBounds(new Rectangle(8, 420, 480, 40));
            jScrollPane1.setVisible(true);

            int lines = 0;
            int num = 0;//各学期课程数
            for(int tearm=0;tearm<4;tearm++)
                //while(s.students[n].inf_tearm[tearm].sub[num]!=null)
                for(num=0;num<s.students[n].inf_tearm[tearm].num;num++){
                    jTable1.setValueAt("第"+(tearm+1)+"学期",lines,0);
                    jTable1.setValueAt(s.students[n].inf_tearm[tearm].sub[num],lines,1);
                    jTable1.setValueAt(new Integer(s.students[n].inf_tearm[tearm].sub_mark[num]),lines,2);
                    lines++;
                    System.out.print(tearm + " " + lines +"\n");
                    //num++;
                }
            s.writedata();
        }
        else {
            nofound.setVisible(true);
            jLabel_inf_title.setVisible(false);
            jLabel_inf1.setVisible(false);
            this.setSize(500,200);
            jButton_back.setBounds(new Rectangle(8, 120, 480, 40));
        }
    }
}


class Frame_find_jButton_OK_actionAdapter implements ActionListener {
    private Frame_find adaptee;
    Frame_find_jButton_OK_actionAdapter(Frame_find adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame_find_jComboBox1_actionAdapter implements ActionListener {
    private Frame_find adaptee;
    Frame_find_jComboBox1_actionAdapter(Frame_find adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame_find_jButton_back_actionAdapter implements ActionListener {
    private Frame_find adaptee;
    Frame_find_jButton_back_actionAdapter(Frame_find adaptee) {
        this.adaptee = adaptee;
    }

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