framekccx.java~4~

班级管理系统

package myproject;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class Framekccx extends JFrame {
    public Framekccx() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setToolTipText("");
        jLabel1.setText("请输入课程编号");
        jLabel1.setBounds(new Rectangle(51, 30, 87, 21));
        jTextField1.setBounds(new Rectangle(161, 27, 154, 23));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel2.setToolTipText("");
        jLabel2.setText("教员");
        jLabel2.setBounds(new Rectangle(53, 94, 52, 20));
        jTextField2.setBounds(new Rectangle(100, 96, 72, 21));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel3.setToolTipText("");
        jLabel3.setText("课时");
        jLabel3.setBounds(new Rectangle(50, 191, 76, 24));
        jTextField3.setToolTipText("");
        jTextField3.setBounds(new Rectangle(255, 98, 74, 21));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel4.setToolTipText("");
        jLabel4.setText("课程");
        jLabel4.setBounds(new Rectangle(197, 91, 50, 24));
        jTextField4.setBounds(new Rectangle(103, 191, 72, 21));
        jButton1.setBounds(new Rectangle(66, 249, 58, 25));
        jButton1.setToolTipText("");
        jButton1.setText("查询");
        jButton1.addActionListener(new Framekccx_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(222, 248, 59, 25));
        jButton2.setToolTipText("");
        jButton2.setText("重置");
        jTextField5.setToolTipText("");
        jTextField5.setBounds(new Rectangle(258, 190, 72, 21));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel5.setToolTipText("");
        jLabel5.setText("编号");
        jLabel5.setBounds(new Rectangle(196, 185, 42, 24));
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jTextField5);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jLabel5);
    }

    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField jTextField4 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel5 = new JLabel();
    public void jButton1_actionPerformed(ActionEvent e) {
        DB db = new DB();
        String strobj1 = jTextField1.getText();
        String strobj2 = jTextField2.getText();
        String strobj3 = jTextField3.getText();
        String strobj4 = jTextField4.getText();
        String strobj5 = jTextField5.getText();
        Vector vc = new Vector(100);
        String str = "select * from kecheng where kechengbianhao='" + strobj1 + "'";
        ResultSet rs = db.Select(str);
        ResultSetMetaData rsmd = null;
   try {
       rsmd = rs.getMetaData();
       int count=rsmd.getColumnCount();
       while(rs.next())
           for(int i=1;i<=count;i++)
           {
               vc.add(rs.getObject(i));
           }
       if(strobj1.length()==0)
       {
           JOptionPane.showMessageDialog(this,"请输入课程编号","消息",JOptionPane.INFORMATION_MESSAGE);
       }
       else if(vc.contains(strobj1))
       {
           this.jTextField2.setText(vc.elementAt(0).toString());
           this.jTextField3.setText(vc.elementAt(1).toString());
           this.jTextField4.setText(vc.elementAt(2).toString());
           this.jTextField5.setText(vc.elementAt(3).toString());
       }
       else
       {
           JOptionPane.showMessageDialog(this,"查无该课程号","消息",JOptionPane.INFORMATION_MESSAGE);
       }
   } catch (SQLException ex) {
   }

    }
}


class Framekccx_jButton1_actionAdapter implements ActionListener {
    private Framekccx adaptee;
    Framekccx_jButton1_actionAdapter(Framekccx adaptee) {
        this.adaptee = adaptee;
    }

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