searchstu.java~4~

自己写的学生选课系统,多多关照.以后共同学习

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JRadioButton;
import javax.swing.ButtonGroup;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JOptionPane;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
public class SearchStu extends JFrame {
    String searchType = "";
    public SearchStu() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setText("选择你要查询的类型：");
        jLabel1.setBounds(new Rectangle(19, 32, 145, 23));
        jRadioButton1.setText("按专业");
        jRadioButton1.setBounds(new Rectangle(175, 97, 63, 24));
        jRadioButton1.addActionListener(new
                                        SearchStu_jRadioButton1_actionAdapter(this));
        jRadioButton2.setText("按学号");
        jRadioButton2.setBounds(new Rectangle(24, 102, 62, 21));
        jRadioButton2.addActionListener(new
                                        SearchStu_jRadioButton2_actionAdapter(this));
        jRadioButton3.setText("按名字");
        jRadioButton3.setBounds(new Rectangle(100, 98, 64, 26));
        jRadioButton3.addActionListener(new
                                        SearchStu_jRadioButton3_actionAdapter(this));
        jTextField1.setEnabled(false);
        jTextField1.setBounds(new Rectangle(17, 64, 214, 23));
        jButton1.addActionListener(new SearchStu_jButton1_actionAdapter(this));
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jRadioButton3);
        this.getContentPane().add(jRadioButton2);
        this.getContentPane().add(jRadioButton1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        jButton1.setBounds(new Rectangle(262, 35, 60, 27));
        jButton1.setText("确定");
        jButton2.setBounds(new Rectangle(264, 75, 59, 28));
        jButton2.setText("退出");
        buttonGroup1.add(jRadioButton2);
        buttonGroup1.add(jRadioButton3);
        buttonGroup1.add(jRadioButton1);
    }

    JLabel jLabel1 = new JLabel();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    JRadioButton jRadioButton1 = new JRadioButton();
    JRadioButton jRadioButton2 = new JRadioButton();
    JRadioButton jRadioButton3 = new JRadioButton();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();

    //设置查找的类型
    public void setType(String type) {
        searchType = type;
    }

    //单选框的方法
    public void jRadioButton2_actionPerformed(ActionEvent e) {
        jLabel1.setText("请输入要查询学生的学号：");
        jTextField1.setEnabled(true);
        setType("Num");
    }

    //单选框的方法
    public void jRadioButton3_actionPerformed(ActionEvent e) {
        jLabel1.setText("请输入要查询学生的姓名：");
        jTextField1.setEnabled(true);
        setType("Name");
    }

    //单选框的方法
    public void jRadioButton1_actionPerformed(ActionEvent e) {
        jLabel1.setText("请输入要查询学生的专业：");
        jTextField1.setEnabled(true);
        setType("Dept");
    }

    public void jButton1_actionPerformed(ActionEvent e) {

        if (jTextField1.getText().trim().equals("")) {
            JOptionPane.showMessageDialog(this, "查询值不能为空!");
        }
        String sql = "select *form Student ";
        if (searchType == "Num") {
            sql = sql + "where  Sno='" + jTextField1.getText().trim() +
                  "'";

        } else if (searchType == "Name") {
            sql = sql + "where  Sname='" +
                  jTextField1.getText().trim() + "'";

        } else if (searchType == "Dept") {
            sql = sql + "where SDept='" + jTextField1.getText().trim() +
                  "'";
        }
        System.out.println(sql);
        ResultSet rs = DBManager.getResult(sql);

        ShowStuResult ssr = new ShowStuResult();
        ssr.resultShow(rs);//调用ShowStuResult显示方法

    }
}


class SearchStu_jButton1_actionAdapter implements ActionListener {
    private SearchStu adaptee;
    SearchStu_jButton1_actionAdapter(SearchStu adaptee) {
        this.adaptee = adaptee;
    }

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


class SearchStu_jRadioButton1_actionAdapter implements ActionListener {
    private SearchStu adaptee;
    SearchStu_jRadioButton1_actionAdapter(SearchStu adaptee) {
        this.adaptee = adaptee;
    }

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


class SearchStu_jRadioButton3_actionAdapter implements ActionListener {
    private SearchStu adaptee;
    SearchStu_jRadioButton3_actionAdapter(SearchStu adaptee) {
        this.adaptee = adaptee;
    }

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


class SearchStu_jRadioButton2_actionAdapter implements ActionListener {
    private SearchStu adaptee;
    SearchStu_jRadioButton2_actionAdapter(SearchStu adaptee) {
        this.adaptee = adaptee;
    }

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