updatecourse.java

一个教务管理系统

package teacherframe.course;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import jdbc.DbManager;

public class UpdateCourse extends JFrame {

     CourseMessage cc;
    public UpdateCourse(CourseMessage main)    //main接收传过来的窗体对象
    {
        cc=main;
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public void setData(String courseID,String courseName,String memo)   //setData() 方法
    {
     txt1.setText(courseID);      //txt1接收传过来的courseID
     txt2.setText(courseName);    //txt2接收传过来的courseName
     txt3.setText(memo);         //txt3接收传过来的memo
    }
    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        lab.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 20));
        lab.setToolTipText("");
        lab.setText("修 改 课 程 信 息");
        lab.setBounds(new Rectangle(97, 20, 195, 51));
        lab1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 13));
        lab1.setText("课程编号:");
        lab1.setBounds(new Rectangle(41, 70, 67, 34));
        lab2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 13));
        lab2.setText("课程名称:");
        lab2.setBounds(new Rectangle(43, 124, 65, 34));
        lab3.setFont(new java.awt.Font("新宋体", Font.PLAIN, 13));
        lab3.setToolTipText("");
        lab3.setText("课程备注:");
        lab3.setBounds(new Rectangle(41, 180, 65, 34));
        txt2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 13));
        txt2.setBounds(new Rectangle(112, 126, 184, 32));
        txt1.setEditable(false);
        txt1.setBackground(Color.white);
        txt1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 13));
        txt1.setForeground(Color.cyan);

        txt1.setBounds(new Rectangle(112, 73, 184, 32));
        jScrollPane1.setBounds(new Rectangle(110, 180, 230, 102));
        but3.setBounds(new Rectangle(289, 316, 76, 32));
        but3.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 13));
        but3.setText("重置");
        but3.addActionListener(new UpdateCourse_but3_actionAdapter(this));

        but1.setBounds(new Rectangle(100, 317, 76, 32));
        but1.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 13));
        but1.setText("确定");
        but1.addActionListener(new UpdateCourse_but1_actionAdapter(this));

        but2.setBounds(new Rectangle(192, 317, 76, 32));
        but2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 13));
        but2.setText("取消");
        but2.addActionListener(new UpdateCourse_but2_actionAdapter(this));
        this.setTitle("课程信息管理");
        txt3.setFont(new java.awt.Font("新宋体", Font.PLAIN, 14));

        this.getContentPane().add(lab);
        this.getContentPane().add(lab1);
        this.getContentPane().add(txt1);
        this.getContentPane().add(txt2);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(but1);
        this.getContentPane().add(but2);
        this.getContentPane().add(but3);
        this.getContentPane().add(lab2);
        this.getContentPane().add(lab3);
        jScrollPane1.getViewport().add(txt3);
    }

//    public static void main(String[] args) {
//        UpdateCourse u = new UpdateCourse();
//        u.setSize(450,400);
//        u.setLocation(200,110);
//        u.setVisible(true);
//        u.setResizable(false);
//    }

    JLabel lab = new JLabel();
    JLabel lab1 = new JLabel();
    JLabel lab2 = new JLabel();
    JLabel lab3 = new JLabel();
    JTextField txt2 = new JTextField();
    JTextField txt1 = new JTextField();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTextArea txt3 = new JTextArea();
    JButton but3 = new JButton();
    JButton but1 = new JButton();
    JButton but2 = new JButton();
    public void but3_actionPerformed(ActionEvent e) {

       txt2.setText("");
       txt3.setText("");
    }

    public void but2_actionPerformed(ActionEvent e) {
      this.setVisible(false);
    }

     DbManager db=new DbManager();
    public void but1_actionPerformed(ActionEvent e)
    {
        if(txt2.getText().trim().equals(""))
        {
         JOptionPane.showMessageDialog(this,"课程名称不能为空");
         return;
        }
     db.exec("update course set courseName='"+txt2.getText().trim()+"',memo='"+txt3.getText().trim()+"'where courseID='"+txt1.getText().trim()+"'");
     cc.refresh("select * from course");
     JOptionPane.showMessageDialog(this,"修改成功");
     this.setVisible(false);
    }
  }


class UpdateCourse_but1_actionAdapter implements ActionListener {
    private UpdateCourse adaptee;
    UpdateCourse_but1_actionAdapter(UpdateCourse adaptee) {
        this.adaptee = adaptee;
    }

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


class UpdateCourse_but2_actionAdapter implements ActionListener {
    private UpdateCourse adaptee;
    UpdateCourse_but2_actionAdapter(UpdateCourse adaptee) {
        this.adaptee = adaptee;
    }

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


class UpdateCourse_but3_actionAdapter implements ActionListener {
    private UpdateCourse adaptee;
    UpdateCourse_but3_actionAdapter(UpdateCourse adaptee) {
        this.adaptee = adaptee;
    }

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