grade_insert.java

这是一个教学管理代码

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


public class Grade_insert extends JFrame implements ActionListener
{
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();

    public Grade_insert()
    {
        Container c=this.getContentPane();
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }


    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 21));
        jLabel1.setText("请输入学号 ");
        jLabel1.setBounds(new Rectangle(31, 31, 126, 30));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel5.setText("课程号");
        jLabel5.setBounds(new Rectangle(24, 189, 74, 28));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel6.setText("1");
        jLabel6.setBounds(new Rectangle(28, 216, 36, 21));
        jLabel7.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel7.setText("2");
        jLabel7.setBounds(new Rectangle(28, 232, 35, 21));
        jLabel8.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel8.setText("3");
        jLabel8.setBounds(new Rectangle(28, 250, 36, 21));
        jLabel9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel9.setText("4");
        jLabel9.setBounds(new Rectangle(28, 271, 34, 16));
        jLabel10.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel10.setText("课程名称");
        jLabel10.setBounds(new Rectangle(153, 195, 66, 16));
        jLabel11.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel11.setText("操作系统  ");
        jLabel11.setBounds(new Rectangle(151, 218, 69, 16));
        jLabel12.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel12.setText("计算机网络");
        jLabel12.setBounds(new Rectangle(151, 234, 66, 16));
        jLabel13.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel13.setText("数据库原理");
        jLabel13.setBounds(new Rectangle(151, 252, 82, 16));
        jLabel14.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel14.setText("编译原理 ");
        jLabel14.setBounds(new Rectangle(151, 271, 60, 16));
        jButton1.setBounds(new Rectangle(264, 178, 87, 39));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 21));
        jButton1.setText("插入");
        jButton2.setBounds(new Rectangle(266, 243, 86, 39));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton2.setText("重置");
        this.getContentPane().add(jLabel1);
        jLabel4.setText("温馨提示： ");
        jLabel4.setBounds(new Rectangle(31, 157, 97, 31));
        jTextField3.setText("");
        jTextField3.setBounds(new Rectangle(220, 114, 133, 33));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 21));
        jLabel3.setText("该门课程的分数");
        jLabel3.setBounds(new Rectangle(28, 114, 155, 33));
        this.getContentPane().setBackground(new Color(201, 201, 208));
        this.setForeground(SystemColor.menu);
        jTextField2.setText("");
        jTextField2.setBounds(new Rectangle(220, 74, 131, 31));
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(220, 32, 131, 31));
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel12);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel10);
        this.getContentPane().add(jLabel11);
        this.getContentPane().add(jLabel13);
        this.getContentPane().add(jLabel14);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel9);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 21));
        jLabel2.setText("请输入课程号");
        jLabel2.setBounds(new Rectangle(29, 76, 155, 31));

        jButton1.addActionListener(this);
        jButton2.addActionListener(this);

        setTitle("成绩插入");
        setSize(380,350);
        show();

    }

    public void actionPerformed(ActionEvent e)
    {
        if(e.getSource()==jButton1)
        {
            try
            {
                connection c=new connection();
                Connection con = c.createConnection();
                String sql = "insert into SC values(?,?,?)";
                PreparedStatement ptmt = con.prepareStatement(sql);
                ptmt.setString(1,jTextField1.getText());
                ptmt.setString(2,jTextField2.getText());
                ptmt.setString(3,jTextField3.getText());
               boolean i=ptmt.execute();
                JOptionPane.showMessageDialog(null,"插入成功","成绩插入",JOptionPane.INFORMATION_MESSAGE);
                if(i==false)
                    JOptionPane.showMessageDialog(null,"插入不成功","成绩插入",JOptionPane.INFORMATION_MESSAGE);
                c.close(ptmt,con);
            }catch (Exception ee){}

        }
        else if(e.getSource()==jButton2)
        {
            jTextField1.setText("");
            jTextField2.setText("");
            jTextField3.setText("");
        }
    }



}