xuankeframe1.java

Java学生管理系统学生及成绩记录的查询删除修改

package student;

import java.awt.BorderLayout;

import javax.swing.*;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.JComboBox;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class xuankeFrame1 extends JFrame {
    public xuankeFrame1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel1.setText("学号");
        jLabel1.setBounds(new Rectangle(12, 31, 65, 26));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel2.setText("选择课程");
        kc.addItem("java");
        kc.addItem("C语言");
        kc.addItem("英语");
        jLabel2.setBounds(new Rectangle(11, 73, 68, 29));
        xh.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        xh.setBounds(new Rectangle(80, 32, 85, 24));
        xh.addActionListener(new xuankeFrame1_xh_actionAdapter(this));
        kc.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        kc.setBounds(new Rectangle(80, 75, 85, 26));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel3.setText("姓名");
        jLabel3.setBounds(new Rectangle(189, 31, 68, 27));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel4.setText("课程编码");
        jLabel4.setBounds(new Rectangle(186, 74, 76, 31));
        xm.setText("");
        xm.setBounds(new Rectangle(258, 33, 97, 30));
        bm.setText("");
        bm.setBounds(new Rectangle(258, 78, 101, 29));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel5.setText("授课老师");
        jLabel5.setBounds(new Rectangle(9, 124, 62, 28));
        ls.setText("");
        ls.setBounds(new Rectangle(66, 128, 99, 29));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel6.setText("授课地点");
        jLabel6.setBounds(new Rectangle(183, 126, 66, 29));
        dd.setText("");
        dd.setBounds(new Rectangle(258, 127, 100, 29));
        jButton1.setBounds(new Rectangle(67, 194, 115, 36));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton1.setText("选课");
        jButton1.addActionListener(new xuankeFrame1_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(208, 195, 114, 35));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton2.setText("取消");
        jButton2.addActionListener(new xuankeFrame1_jButton2_actionAdapter(this));
        this.getContentPane().setBackground(Color.white);
        jLabel7.setText("jLabel7");
        jLabel7.setBounds(new Rectangle(10, 10, 401, 302));
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(xh);
        this.getContentPane().add(kc);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(xm);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(ls);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(dd);
        this.getContentPane().add(bm);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jLabel7);
        jButton1.setIcon(new ImageIcon("an086.gif"));
        jButton2.setIcon(new ImageIcon("an088.gif"));
        jLabel7.setIcon(new ImageIcon("11.jpg"));
        try{
            Connectionsql c=new Connectionsql();
            Connection con=c.getConnection();
            Statement pstmt=con.createStatement();
            String sql="select num from student ";
            ResultSet rs=pstmt.executeQuery(sql);
            while (rs.next()){
             xh.addItem(rs.getString(1));
            }
        }catch(Exception sx){
            sx.printStackTrace();
        }


    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JComboBox xh = new JComboBox();
    JComboBox kc = new JComboBox();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField xm = new JTextField();
    JTextField bm = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField ls = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField dd = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel7 = new JLabel();

    public void xh_actionPerformed(ActionEvent e) {

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        String XM=xm.getText();
        String KC;
        String XH;
        String DM;
        DM=bm.getText();
        String LS=ls.getText();
        String DD=dd.getText();
        XH=xh.getSelectedItem().toString();
        KC=kc.getSelectedItem().toString();
        if(XH.equals("")){
            JOptionPane.showMessageDialog(null,"请选择学号","信息",JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        if(XM.equals(""))
        {
            JOptionPane.showMessageDialog(null,"请输入姓名","消息",JOptionPane.INFORMATION_MESSAGE);
            return;
        }if(LS.equals("")){
            JOptionPane.showMessageDialog(null,"请输入老师姓名","消息",JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        if(DM.equals("")){
            JOptionPane.showMessageDialog(null,"请输入课程编码","消息",JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        Connectionsql ss=new Connectionsql();
        try{
            Connection con=ss.getConnection();
            Statement stmt=con.createStatement();
            String sql="insert into kechengxinxi(kechengbm1,kechengmc,laoshi,shangkedd,kechenglb) values ('"+DM+"','"+KC+"','"+LS+"','"+DD+"','"+LS+"')";
            stmt.executeUpdate(sql);
            JOptionPane.showMessageDialog(null,"选课成功");
        }catch(Exception ce){
            ce.printStackTrace();
        }


    }

    public void jButton2_actionPerformed(ActionEvent e) {
this.dispose();
    }
}


class xuankeFrame1_jButton2_actionAdapter implements ActionListener {
    private xuankeFrame1 adaptee;
    xuankeFrame1_jButton2_actionAdapter(xuankeFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class xuankeFrame1_jButton1_actionAdapter implements ActionListener {
    private xuankeFrame1 adaptee;
    xuankeFrame1_jButton1_actionAdapter(xuankeFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class xuankeFrame1_xh_actionAdapter implements ActionListener {
    private xuankeFrame1 adaptee;
    xuankeFrame1_xh_actionAdapter(xuankeFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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