insertcourse.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 InsertCourse extends JFrame {

       CourseMessage cc;
    public InsertCourse(CourseMessage main)   //main接收传过来的窗体
    {
        cc=main;      //将窗体的作用域扩大
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        lab.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 20));
        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.setFont(new java.awt.Font("新宋体", Font.PLAIN, 13));
        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 InsertCourse_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 InsertCourse_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 InsertCourse_but2_actionAdapter(this));
        shuoming.setFont(new java.awt.Font("新宋体", Font.PLAIN, 13));
        shuoming.setForeground(Color.blue);
        shuoming.setText("格式: C001");
        shuoming.setBounds(new Rectangle(304, 73, 86, 33));
        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);
        this.getContentPane().add(shuoming);
        jScrollPane1.getViewport().add(txt3);
    }

//    public static void main(String[] args) {
//        InsertCourse i = new InsertCourse();
//        i.setSize(450,400);
//        i.setLocation(200,110);
//        i.setVisible(true);
//        i.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) {
       txt1.setText("");
       txt2.setText("");
       txt3.setText("");
    }

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

     DbManager db=new DbManager();
    JLabel shuoming = new JLabel();
    public void but1_actionPerformed(ActionEvent e)
    {

      if(txt1.getText().trim().equals(""))
      {
       JOptionPane.showMessageDialog(this,"课程编号不能为空");
       return;                    //返回，不再执行其它的if语句
      }
      if(txt2.getText().trim().equals(""))
      {
      JOptionPane.showMessageDialog(this,"课程名称不能为空");
      return ;                   //返回，不再执行其它的if语句
      }
      if(txt3.getText().trim().equals(""))
      {
       JOptionPane.showMessageDialog(this,"课程备注不能为空");
       return ;                   //返回，不再执行其它的if语句
      }

      ResultSet rs=db.query("select * from course where courseID='"+txt1.getText().trim()+"'");
    try {
        if (rs.next())
        {
         JOptionPane.showMessageDialog(this,"课程编号已经存在，请从新添加");
         txt1.setText("");
        }else
        {
            int n=db.exec("insert into course values('"+txt1.getText().trim()+"','"+txt2.getText().trim()+"','"+txt3.getText().trim()+"')");
             if(n==1)
             {
              cc.refresh("select * from course");
              JOptionPane.showMessageDialog(this,"添加成功");
              this.setVisible(false);
             }else
             {
              JOptionPane.showMessageDialog(this,"课程编号格式有误，请从新添加");
              txt1.setText("");
             }

         }   //end if-else
    } catch (SQLException ex)
    {
     System.out.println(ex.getMessage());
    }

    }
}


class InsertCourse_but3_actionAdapter implements ActionListener {
    private InsertCourse adaptee;
    InsertCourse_but3_actionAdapter(InsertCourse adaptee) {
        this.adaptee = adaptee;
    }

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


class InsertCourse_but2_actionAdapter implements ActionListener {
    private InsertCourse adaptee;
    InsertCourse_but2_actionAdapter(InsertCourse adaptee) {
        this.adaptee = adaptee;
    }

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


class InsertCourse_but1_actionAdapter implements ActionListener {
    private InsertCourse adaptee;
    InsertCourse_but1_actionAdapter(InsertCourse adaptee) {
        this.adaptee = adaptee;
    }

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