deloldcard.java

实现JSP开发的BBS源码

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

public class delOldCard extends JFrame implements ActionListener{
	
	private Connection con=null;
	private Statement st=null;
	private ResultSet rs=null;	
	private String command=null;
	private String cardNum=null;
	private String passwd=null;
	private String reEnterpasswd=null;
	private String getpswd=null;
	private String getUserID=null;
	private boolean flag=true;
	private JLabel oldCardNumLabel=new JLabel("卡  号 :");
	private JTextField oldCardNum=new JTextField(18);
	private JLabel oldCardpswdLabel=new JLabel("输入密码:");
	private JPasswordField oldCardpswd=new JPasswordField(8);
	private JLabel reEnterpswdLabel=new JLabel("确认密码:");
	private JPasswordField reEnterpswd=new JPasswordField(8);
	private JButton submit=new JButton("确定");
	private JButton clear=new JButton("清除");
	
	//无参构造方法
	public  delOldCard(){
		setup();    //初始化面板
	}
	
	//有参构造方法
	public delOldCard(String card){
		setup();   //初始化面板
		oldCardNum.setText(card);
	}
	
	//初始化面板
	public void setup(){
		setTitle("注销旧卡");
		setSize(350,300);
		setLocation(400,300);
		setResizable(false);
		Container c=getContentPane();
		c.setLayout(null);
		
		c.add(oldCardNumLabel);
		oldCardNumLabel.setBounds(25,30,60,30);
		c.add(oldCardNum);
		oldCardNum.setBounds(90,30,200,30);
		
		c.add(oldCardpswdLabel);
		oldCardpswdLabel.setBounds(25,80,60,30);
		c.add(oldCardpswd);
		oldCardpswd.setBounds(90,80,200,30);
		
		c.add(reEnterpswdLabel);
		reEnterpswdLabel.setBounds(25,120,60,30);
		c.add(reEnterpswd);
		reEnterpswd.setBounds(90,120,200,30);
		
		c.add(submit);
		submit.setBounds(100,180,60,40);
		c.add(clear);
		clear.setBounds(170,180,60,40);
		submit.addActionListener(this);
		clear.addActionListener(this);
		show();
		st=connectDB.conDB();//连接数据库
	}
	
	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()==submit){
			flag=true;
			if((oldCardNum.getText().trim()).equals("")==true||(oldCardpswd.getText().trim()).equals("")==true||((reEnterpswd.getText()).trim().equals(""))==true){
				JOptionPane.showMessageDialog(null,"请输入卡号和密码");
				return;
			}
		    else{
			    cardNum=oldCardNum.getText().trim();
			    passwd=oldCardpswd.getText().trim();
			    reEnterpasswd=reEnterpswd.getText().trim();
			    if(passwd.equals(reEnterpasswd)==false){
				   JOptionPane.showMessageDialog(null,"输入两次密码不一致!");
				   return;
			    }			
		    }		
		command="select * from cardTable where userCardNum='"+cardNum+"'";
		try{
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
			rs=st.executeQuery(command);
			if(rs.next()){
				getpswd=rs.getString("code").trim();
				if(getpswd.equals(passwd)==false){
				   JOptionPane.showMessageDialog(null,"卡号密码不一致!");
				   flag=false;
				   confirmDialog reEnter=new confirmDialog(this,"重新输入","重新输入密码?");
					   if(reEnter.isOkay){
					   	return;
					   }
					   else{
					   	delOldCard.this.hide();
					   }
				}
			}
			else{
				JOptionPane.showMessageDialog(null,"卡号不存在!");
				flag=false;
			}
		}catch(SQLException ex){
			while(ex!=null){
					JOptionPane.showMessageDialog(null,ex);
					ex.getNextException();
					return;					
				}
		}
		try{
			checkBalance(cardNum);
			command="delete from cardTable  where userCardNum='"+cardNum+"'";
			if(flag){			
			   st.executeUpdate(command);
			   JOptionPane.showMessageDialog(null,"旧卡已成功注销!");
			   confirmDialog reEnter=new confirmDialog(this,"删除用户","继续删除用户信息码?");
				   if(reEnter.isOkay){
				   	    try{
        			   	   command="select * from usertable where userCardNum='"+cardNum+"'";
	        	       	   rs=st.executeQuery(command);
	        		   	   if(rs.next()){
	      		    	   	   getUserID=rs.getString("userID").trim();
	        		   	   }
			   	   
		           	    }catch(SQLException ex){
			            	   if(ex!=null){
			                       JOptionPane.showMessageDialog(null,ex);
		                   }
			            }
			            delOldUser delUser=new delOldUser(getUserID);				   
				   }
				   else{
				        flag=true;
				   	    return;
				   }
			}
			
			   
		}catch(SQLException ex){
			while(ex!=null){
				JOptionPane.showMessageDialog(null,ex);
				ex.getNextException();
				return;
			}
		}
		closeDB.closeDB(st,con);
	}
		else if(ae.getSource()==clear){
			oldCardNum.setText("");
			oldCardpswd.setText("");
			reEnterpswd.setText("");
			flag=true;
		}
	}
	public static void main(String args[]){
		delOldCard oldCard=new delOldCard();
	}
}