kexiuframe2.java

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

package student;

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(300,300);
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel1.setText("课   程   修   改");
        jLabel1.setBounds(new Rectangle(94, 7, 159, 37));
        jButton1.setBounds(new Rectangle(58, 222, 75, 32));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton1.setText("确定");
        jButton1.addActionListener(new kexiuFrame2_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(205, 221, 74, 34));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton2.setText("取消");
        jButton2.addActionListener(new kexiuFrame2_jButton2_actionAdapter(this));
        jiaoshi1.setText("");
        jiaoshi1.setBounds(new Rectangle(145, 97, 134, 35));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel4.setText("课  程  教  室");
        jLabel4.setBounds(new Rectangle(22, 141, 96, 31));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel5.setText("课  程  类  型");
        jLabel5.setBounds(new Rectangle(22, 180, 96, 30));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel3.setText("课  程  教  师");
        jLabel3.setBounds(new Rectangle(22, 102, 90, 31));
        bianhao.setBounds(new Rectangle(145, 57, 134, 35));
        jiaoshi2.setBounds(new Rectangle(145, 136, 134, 35));
        leixing.setBounds(new Rectangle(145, 177, 134, 35));
        this.getContentPane().setBackground(Color.pink);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(leixing);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(bianhao);
        this.getContentPane().add(jiaoshi1);
        this.getContentPane().add(jiaoshi2);
        this.getContentPane().add(jButton2);
        jLabel2.setText("课  程  编  号");
        jLabel2.setBounds(new Rectangle(22, 60, 93, 31));
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JTextField jiaoshi1 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JTextField bianhao = new JTextField();
    JTextField jiaoshi2 = new JTextField();
    JTextField leixing = new JTextField();
    public void jButton2_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        if(bianhao.getText().equals("")){
            JOptionPane.showMessageDialog(null,"编号不能为空!");
            return;
        }
        if(jiaoshi1.getText().equals("")){
            JOptionPane.showMessageDialog(null,"教室不能为空!");
            return;
        }
        if(jiaoshi2.getText().equals("")){
            JOptionPane.showMessageDialog(null,"教师不能为空!");
            return;
        }
        if(leixing.getText().equals("")){
            JOptionPane.showMessageDialog(null,"类型不能为空!");
            return;
        }

        Connectionsql ss=new Connectionsql();
        try{
            String BH= bianhao.getText();
            String JS1=jiaoshi1.getText();
            String JS2=jiaoshi2.getText();
            String LX=leixing.getText();
            Connection con=ss.getConnection();
            Statement stmt=con.createStatement();
            String sql="update kechengxinxi set shangkedd='"+JS1+"',laoshi='"+JS2+"',kechenglb='"+LX+"' where kechengbm1='"+BH+"'";
           stmt.executeUpdate(sql);
            JOptionPane.showMessageDialog(null,"修改成功");
        }catch(Exception ce){
            ce.printStackTrace();
        }

    }
}


class kexiuFrame2_jButton1_actionAdapter implements ActionListener {
    private kexiuFrame2 adaptee;
    kexiuFrame2_jButton1_actionAdapter(kexiuFrame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class kexiuFrame2_jButton2_actionAdapter implements ActionListener {
    private kexiuFrame2 adaptee;
    kexiuFrame2_jButton2_actionAdapter(kexiuFrame2 adaptee) {
        this.adaptee = adaptee;
    }

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