delmemberpane.java

酒店管理系统·可用于一般旅社的营业操作。方便你的酒店管理

/*
 * To change this template, choose Tools | Templates
 * 文件名称  delMemberPane.java
 * 说明:
 * 删除会员信息
 */

package com.redingsoft.customerinfo;

import com.redingsoft.sql.SetSQL;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;

/**
 *
 * @author Administrator
 */
public class delMemberPane extends JDialog implements ActionListener {
  //声明一个标签
    private JLabel jl1;
  //声明一个文本框  
    private JTextField tf1;
  //声明一个按钮
    private JButton bt1;
  private JPanel  jp1; 
    //构造方法.
   public delMemberPane (){
    //实例化个组件
       jl1=new JLabel("请输入会员编号");
       tf1=new JTextField(15);
       bt1=new JButton("删除");
       jp1=new JPanel();
      //添加组件都面板
      jp1.add(jl1);
      jp1.add(tf1);
      jp1.add(bt1);
      //设置面板的参数
      jp1.setBorder(BorderFactory.createLineBorder(Color.DARK_GRAY, 1));
      jp1.setBorder(BorderFactory.createTitledBorder(BorderFactory.createLineBorder(Color.GRAY), "删除会员"));
      jp1.setPreferredSize(new Dimension(200,200));
      bt1.setContentAreaFilled(false); //透明按钮
      //添加按钮侦听
      bt1.addActionListener(this);
      
      //添加到主窗口
      
      this.add(jp1);
      this.setTitle("删除会员");
      this.setResizable(false);
      this.setBounds(1, 1, 200, 160);
    //  LocationUtil.setLocation(this);
      this.setDefaultCloseOperation(delMemberPane.DISPOSE_ON_CLOSE);
     // this.setVisible(true);
   }
   /*********************************************
   public static void main(String [] args){
   new delMemberPane ();
   }
  ************************************************/
    public void actionPerformed(ActionEvent e) {
      //  throw new UnsupportedOperationException("Not supported yet.");
       String id=tf1.getText().trim();
        deldata(id);
    }
  //侦听实现
    private void deldata(String id){
       String sql="delete from member where m_id='"+id+"'";
       String sqls="select m_name from member where m_id='"+id+"'";
      int i=AddMemberPane.checkrs(sqls);
        if(i!=0){
        SetSQL.executeUpdate(sql);
        AddMemberPane.WarnMsg("提示", "会员删除成功");
         tf1.setText(null);
        }else{
          AddMemberPane.WarnMsg("提示", "没有此会员的，请从新输入。");
          tf1.setText(null);
        }
    }
    
}