deleteuser.java

一个个人信息管理系统

package soft1;

import java.awt.*;

import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.Font;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.dataset.Column;
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import soft1Method.*;
import com.borland.dx.dataset.MetaDataUpdate;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DeleteUser extends JDialog {
    JPanel panel1 = new JPanel();
    XYLayout xYLayout1 = new XYLayout();
    JLabel jLabel1 = new JLabel();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    JButton jButton1 = new JButton();
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    Column column1 = new Column();
    GetValue gv=new GetValue();
    Column column2 = new Column();
    public DeleteUser(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public DeleteUser() {
        this(new Frame(), "DeleteUser", true);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(xYLayout1);
        setSize(new Dimension(400, 350));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel1.setText("当前所有用户");
        jButton1.setText("删除");
        jButton1.addActionListener(new DeleteUser_jButton1_actionAdapter(this));
        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:PersonalDB",
                "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME +
                                        MetaDataUpdate.PRECISION +
                                        MetaDataUpdate.SCALE +
                                        MetaDataUpdate.SEARCHABLE);
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "SELECT Name AS 用户名,Password AS 密码 ,ID From User", null, true,
                Load.ALL));
        column1.setColumnName("ID");
        column1.setDataType(com.borland.dx.dataset.Variant.INT);
        column1.setRowId(false);
        column1.setTableName("User");
        column1.setServerColumnName("ID");
        column1.setSqlType(4);
        jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable1.setDataSet(queryDataSet1);
        column2.setColumnName("用户名");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPrecision(50);
        column2.setRowId(true);
        column2.setTableName("User");
        column2.setServerColumnName("Name");
        column2.setSqlType(12);
        panel1.add(jLabel1, new XYConstraints(140, 17, 93, 35));
        panel1.add(tableScrollPane1, new XYConstraints(0, 45, 400, 238));
        panel1.add(jButton1, new XYConstraints(140, 295, 116, 35));
        tableScrollPane1.getViewport().add(jdbTable1);

        this.getContentPane().add(panel1, java.awt.BorderLayout.CENTER);
        queryDataSet1.setColumns(new Column[] {column2, column1});
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        int a=JOptionPane.showConfirmDialog(this,"您确定要删除吗？","提示",JOptionPane.YES_NO_OPTION);
        if (a==0){
          if(queryDataSet1.getString("用户名").equals("mufen1816")){
               JOptionPane.showMessageDialog(this,"该用户为管理员级，不能删除！","提示",JOptionPane.ERROR_MESSAGE);
              }
              else{
                  queryDataSet1.deleteRow();
                  queryDataSet1.post();
                  queryDataSet1.saveChanges();
                  queryDataSet1.refresh();
                  JOptionPane.showMessageDialog(this,"删除成功！","提示",JOptionPane.PLAIN_MESSAGE);
                  queryDataSet1.refresh();}}
}}


class DeleteUser_jButton1_actionAdapter implements ActionListener {
    private DeleteUser adaptee;
    DeleteUser_jButton1_actionAdapter(DeleteUser adaptee) {
        this.adaptee = adaptee;
    }

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