addnewcard.java

实现JSP开发的BBS源码

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

public class addNewCard 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 newpasswd=null;
	private String reEnterpasswd=null;
	private String getMoney=null;
	private int money; 
	boolean flag=true;
	
	private JLabel newCardNumLabel=new JLabel("新卡卡号:");
	private JTextField newCardNum=new JTextField(18);
	private JLabel newCardpswdLabel=new JLabel("新卡密码:");
	private JPasswordField newCardpswd=new JPasswordField(8);
	private JLabel reEnterpswdLabel=new JLabel("确认密码:");
	private JPasswordField reEnterpswd=new JPasswordField(8);
	private JLabel inputMoneyLabel=new JLabel("开户金额:");
	private JTextField inputMoney=new JTextField(8); 
	private JButton submit=new JButton("确定");
	private JButton clear=new JButton("清除");
	
	//构造方法
	public addNewCard(){
		super("添加新卡");
		setSize(350,320);
		setLocation(400,300);
		setResizable(false);
		Container c=getContentPane();
		c.setLayout(null);
		
		c.add(newCardNumLabel);
		newCardNumLabel.setBounds(25,30,60,30);
		c.add(newCardNum);
		newCardNum.setBounds(90,30,200,30);
		
		c.add(newCardpswdLabel);
		newCardpswdLabel.setBounds(25,80,60,30);
		c.add(newCardpswd);
		newCardpswd.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(inputMoneyLabel);
		inputMoneyLabel.setBounds(25,160,60,30);
		c.add(inputMoney);
		inputMoney.setBounds(90,160,200,30);
		
		c.add(submit);
		submit.setBounds(100,220,60,40);
		c.add(clear);
		clear.setBounds(170,220,60,40);
		submit.addActionListener(this);
		clear.addActionListener(this);
		show();
	}
	
	//事件监听
	public void actionPerformed(ActionEvent ae){
		if(ae.getSource()==submit){
			flag=true;
			if((newCardNum.getText().trim()).equals("")==true||((newCardpswd.getText().trim()).equals(""))==true){
				JOptionPane.showMessageDialog(null,"请输入卡号和密码");
				flag=false;
				confirmDialog reEnter=new confirmDialog(this,"重新添加","重新添加新卡?");
					if(reEnter.isOkay){
						flag=true;
				}
				return;
			}
		    else{
			    cardNum=newCardNum.getText().trim();
			    newpasswd=newCardpswd.getText().trim();
			    reEnterpasswd=reEnterpswd.getText().trim();
			    getMoney=inputMoney.getText().trim();
			    money=Integer.parseInt(getMoney);
			    if(newpasswd.equals(reEnterpasswd)==false){
				   JOptionPane.showMessageDialog(null,"两次密码不一致!");
				   flag=false;
				   confirmDialog reEnter=new confirmDialog(this,"重新添加","重新添加新卡?");
					if(reEnter.isOkay){
						flag=true;
					}
				   return;
			    }
			    else if(getMoney.equals("")==true){
			    	JOptionPane.showMessageDialog(null,"请输入开户金额！");
			    	flag=false;
			    	confirmDialog reEnter=new confirmDialog(this,"重新添加","重新添加新卡?");
					if(reEnter.isOkay){
						flag=true;
					}
					return;
			    }
			    else if(money<=0){
			    	JOptionPane.showMessageDialog(null,"开户金额不能为0");
			    	flag=false;
			    }			
		    }		
	    	command="select * from cardTable where userCardNum='"+cardNum+"'";
	    	try{
	    		st=connectDB.conDB();//连接数据库
 		    	con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
    			rs=st.executeQuery(command);
    			if(rs.next()){
		    		JOptionPane.showMessageDialog(null,"卡号已存在!");
		    		flag=false;
		    		confirmDialog reEnter=new confirmDialog(this,"重新添加","重新添加新卡?");
					if(reEnter.isOkay){
						return;
			    	}
	    		}
    		}catch(SQLException ex){
	    		while(ex!=null){
					JOptionPane.showMessageDialog(null,ex);
					ex.getNextException();
					return;					
				}
	    	}
    		try{
	    		command="insert into cardTable(userCardNum,balance,code) values('"+cardNum+"','"+getMoney+"','"+newpasswd+"')";
	    		if(flag){			
	    		   st.executeUpdate(command);
	    		   JOptionPane.showMessageDialog(null,"添加新卡成功!");
	    		   confirmDialog reEnter=new confirmDialog(this,"输入用户信息","继续添加用户信息吗?");
				   if(reEnter.isOkay){
					  addNewUser adduserInfo=new addNewUser(cardNum);
			       }
			       else{
			       	  flag=true;
			       }
	    		}
			
			   
    		}catch(SQLException ex){
    			while(ex!=null){
	    			JOptionPane.showMessageDialog(null,ex);
		    		ex.getNextException();
			    	return;
	    		}
    		}
		closeDB.closeDB(st,con);//关闭数据库
		}
		else if(ae.getSource()==clear){
			newCardNum.setText("");
			newCardpswd.setText("");
			reEnterpswd.setText("");
			inputMoney.setText("");
			flag=true;
		}
		//closeDB();
	}
	public static void main(String args[]){
		addNewCard newCard=new addNewCard();
	}
}