sim_delete.java

这是一个教学管理代码

package sims;


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

public class SIM_delete extends JFrame implements ActionListener
 {

     JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();

    public SIM_delete()
    {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

    }



    private void jbInit() throws Exception
    {
        this.getContentPane().setLayout(null);
        this.getContentPane().setBackground(new Color(240, 170, 200));
        jLabel1.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 26));
        jLabel1.setForeground(Color.green);
        jLabel1.setText("学生信息删除");
        jLabel1.setBounds(new Rectangle(64, 16, 221, 46));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.BOLD, 16));
        jLabel2.setForeground(Color.blue);
        jLabel2.setText("请输入学号");
        jLabel2.setBounds(new Rectangle(26, 101, 142, 38));
        jTextField1.setBounds(new Rectangle(121, 104, 136, 28));
        jButton1.setBounds(new Rectangle(35, 170, 80, 35));
        jButton1.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 16));
        jButton1.setText("确定");
        jButton2.setBounds(new Rectangle(157, 169, 76, 35));
        jButton2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 16));
        jButton2.setText("取消");
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);

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

        setTitle("学生信息删除");
        setSize(300,300);
        show();
    }

    public void actionPerformed(ActionEvent e)
    {
        if(e.getSource()==jButton1)
        {
            try
            {
                connection c=new connection();
                Connection con = c.createConnection();
                String str = jTextField1.getText();
                String sql = "delete from Student where ID='" + str + "'";
                PreparedStatement ptmt = con.prepareStatement(sql);
                ptmt.executeUpdate();
                JOptionPane.showMessageDialog(null,"删除成功","信息删除",JOptionPane.INFORMATION_MESSAGE);
                c.close(ptmt,con);
            }catch (Exception ee){}
        }
        else if(e.getSource()==jButton2)
        {
            jTextField1.setText("");
        }
    }

}