modcourse.java~13~

来自「自己写的学生选课系统,多多关照.以后共同学习」· JAVA~13~ 代码 · 共 70 行

package student;

import javax.swing.JComboBox;
import java.awt.Rectangle;
import java.sql.*;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;

public class ModCourse extends CourseInput {
    public ModCourse() {

        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        jComboBoxSearch.setBounds(new Rectangle(18, 42, 95, 23));
        jComboBoxSearch.addItemListener(new
                                        ModCourse_jComboBoxSearch_itemAdapter(this));
        this.getContentPane().add(jComboBoxSearch);
        jLabel1.setText("课程修改");
        jComboBoxSearch.addItem("");
        String sql = "select Cname from course"; //查询course表里面所包含的课程

        ResultSet rs = DBManager.getResult(sql); //返回结果集

        try {
            while (rs.next()) {
                String str = new String();
                str = rs.getString("Cname");//取结果集中的元素
                jComboBoxSearch.addItem(str);//添加到jComboBoxSearch
            }
      
              } catch (Exception ex) {
      
              }
    }
      

    JComboBox jComboBoxSearch = new JComboBox();
    public void jComboBoxSearch_itemStateChanged(ItemEvent e) {

        String sql = " select *  from course where Cname = '" +
                     jComboBoxSearch.getSelectedItem().toString().trim() + "'";
        System.out.println(sql);//在控制台输出sql语句 以便调试
        ResultSet rs = DBManager.getResult(sql);
        rs.next();
        
        
    }


}


/***********************下面为监听类*******************************/
class ModCourse_jComboBoxSearch_itemAdapter implements ItemListener {
    private ModCourse adaptee;
    ModCourse_jComboBoxSearch_itemAdapter(ModCourse adaptee) {
        this.adaptee = adaptee;
    }

    public void itemStateChanged(ItemEvent e) {
        adaptee.jComboBoxSearch_itemStateChanged(e);
    }
}