delete.java~3~

从CSDN 上花了60个点购买的考勤管理系统,代码写的很细,非常值得推荐

package studentmessage;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Delete
{
  JFrame delframe;
  JPanel panel,panelup,paneldown;
  JLabel lblCustID,lblxm,lblbs;
  JTextField txtCustID,txtxm;
  JButton btndel,btnback;
  GridLayout gl;
  GridBagLayout g;
  GridBagConstraints c;
  public Delete()
  {
    delframe=new JFrame("删除");
    panel=new JPanel();
    panelup=new JPanel();
    paneldown=new JPanel();
    lblCustID=new JLabel("学号");
    lblxm=new JLabel("姓名");
    lblbs=new JLabel("请输入学生学号或姓名");
    txtCustID=new JTextField(10);
    txtxm=new JTextField(10);
    btndel=new JButton("删除");
    btnback=new JButton("返回");
    gl = new GridLayout(1, 2);
    g = new GridBagLayout();
    c = new GridBagConstraints();
    panelup.setLayout(g);
    paneldown.setLayout(gl);
    paneldown.add(btndel);
    paneldown.add(btnback);
    c.anchor = GridBagConstraints.WEST;
    c.gridx = 0;
    c.gridy = 1;
    g.setConstraints(lblbs, c);
    panelup.add(lblbs);

    c.anchor = GridBagConstraints.WEST;
    c.gridx = 0;
    c.gridy = 2;
    g.setConstraints(lblCustID, c);
    panelup.add(lblCustID);

    c.anchor = GridBagConstraints.WEST;
    c.gridx = 1;
    c.gridy = 2;
    g.setConstraints(txtCustID, c);
    panelup.add(txtCustID);

    c.anchor = GridBagConstraints.WEST;
    c.gridx = 0;
    c.gridy = 3;
    g.setConstraints(lblxm, c);
    panelup.add(lblxm);

    c.anchor = GridBagConstraints.WEST;
    c.gridx = 1;
    c.gridy = 3;
    g.setConstraints(txtxm, c);
    panelup.add(txtxm);
    panel.add(panelup);
    panel.add(paneldown);
    delframe.getContentPane().add(panel);

    Del d =new Del();
    btndel.addActionListener(d);
    btnback.addActionListener(d);
      }
      class Del implements ActionListener
    {
      public void actionPerformed(ActionEvent evt)
        {
          Object obj = evt.getSource();
          if (obj == btndel)
          {
            try {
              String strCustID = txtCustID.getText().trim();
              String strxm = txtxm.getText().trim();
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              Connection con = DriverManager.getConnection("jdbc:odbc:SDB");
              String str = "delete from Tabel where 学号=? or 姓名=?";
              PreparedStatement stmt = con.prepareStatement(str);
              stmt.setString(1, strCustID);
              stmt.setString(2, strxm);
              int i = stmt.executeUpdate();
              if (i != 0) {
                JOptionPane.showMessageDialog(delframe, "成功删除信息！");
                txtCustID.setText("");
                txtxm.setText("");
                con.close();
              }
              else {
                JOptionPane.showMessageDialog(delframe, "删除信息失败！");
                txtCustID.setText("");
                txtxm.setText("");
              }
            }
            catch (ClassNotFoundException e1) {
              JOptionPane.showMessageDialog(delframe, e1.getMessage());
            }
            catch (SQLException e2) {
              JOptionPane.showMessageDialog(delframe, e2.getMessage());
            }
          }
          if(obj==btnback)
          {
            IndexInt index = new IndexInt();
            index.inframe.setVisible(true);
            index.inframe.setSize(500, 400);
            index.inframe.show();
            delframe.setVisible(true);
          }
        }
    }
  }