delolduser.java

实现JSP开发的BBS源码

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

public class delOldUser extends JFrame implements ActionListener{
	private Connection con=null;
	private Statement st=null;
	private ResultSet rs=null;
	private String command=null;
	private boolean flag=true;
	private String getUserID=null;
	private String getUserCardNum=null;
	private JLabel userIDLabel=new JLabel("客户ID :");
	private JTextField userID=new JTextField(8);
	private JButton logout=new JButton("注销");
	private JButton clear=new JButton("清除");
	
	//无参构造方法
	public delOldUser(){
		setup();   //初始化面板
		
	}
	
		//有参构造方法
	public delOldUser(String userId){
		setup();   //初始化面板
		userID.setText(userId);
		
	}
	
	//初始化面板方法
	public void setup(){
		setTitle("注销用户");
		setSize(300,200);
		setLocation(400,300);
		setResizable(false);
		Container c=getContentPane();
		c.setLayout(null);
		
		c.add(userIDLabel);
		userIDLabel.setBounds(25,40,60,30);
		c.add(userID);
		userID.setBounds(70,40,200,30);
		
		c.add(logout);
		logout.setBounds(80,80,60,40);
		c.add(clear);
		clear.setBounds(150,80,60,40);
		logout.addActionListener(this);
		clear.addActionListener(this);
		show();
	}
	
	
	//删除前查询余额
	public  void checkBalance(String card){
		command="select * from cardTable where userCardNum='"+card+"'";
		try{
			rs=st.executeQuery(command);
			if(rs.next()){
				String getMoneyValue=rs.getString("balance").trim();
				int money=Integer.parseInt(getMoneyValue);
				if(money>0){
					JOptionPane.showMessageDialog(null,"卡上余额不为0,不能删除");
					flag=false;
				}
			}
		}catch(SQLException ex){
			while(ex!=null){
				JOptionPane.showMessageDialog(null,ex);
				return;
			}
		}
	//return flag;
	}
	
	
    //事件监听
	public void actionPerformed(ActionEvent ae){
		if(ae.getSource()==logout){
			if((userID.getText().trim()).equals("")==true){
				JOptionPane.showMessageDialog(null,"请输入要注销的userID!");
			}
			else{
				getUserID=userID.getText().trim();
				command="select * from userTable where userID='"+getUserID+"'";
				try{
					st=connectDB.conDB();//连接数据库
					con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
					rs=st.executeQuery(command);
					if(rs.next()){
					   getUserCardNum=rs.getString("userCardNum").trim();
					   checkBalance(getUserCardNum);
					   command="delete from userTable where userID='"+getUserID+"'";
					   if(flag){
					   	  st.executeUpdate(command);
					      JOptionPane.showMessageDialog(null,"注销旧用户成功!");
					      confirmDialog delcard=new confirmDialog(this,"删除卡号","继续删除卡号信息码?");
					      if(delcard.isOkay){
					   	      delOldCard delOldCard=new delOldCard(getUserCardNum);
					      }
					      else{
					   	     flag=true;
					   	     return;
					      }
					   }
					}
					else{
						 JOptionPane.showMessageDialog(null,"用户不存在!");
					}
				}catch(SQLException ex){
						while(ex!=null){
							JOptionPane.showMessageDialog(null,ex);
							ex.getNextException();
							return;
				}
				}
			}
			closeDB.closeDB(st,con);		
		}
		else if(ae.getSource()==clear){
			userID.setText("");
		}
	}
	public static void main(String args[]){
		delOldUser delolduser=new delOldUser();
	}
}