desposit.java

实现JSP开发的BBS源码

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

//存款功能
public class desposit extends JFrame implements ActionListener{
	private Statement st=null;
	private Connection con=null;
	private ResultSet rs=null;
	private String command=null;
	private boolean flag=true;
	private String getCardNum=null;
	private String getpswd=null;
	private String getMoney=null;
	private String money=null;	//
	private String moneyValue=null;
	private JLabel cardNumLabel=new JLabel("卡 号:");
	private JTextField cardNum=new JTextField(18);
	private JLabel cardpswdLabel=new JLabel("口 令:");
	private JPasswordField cardpswd=new JPasswordField(8);
	private JLabel inputMoneyLabel=new JLabel("请输入要存款金额(10~1000000)");
	private JTextField inputMoney=new JTextField(6);
	private JButton despositButton=new JButton("存款");
	private JButton close=new JButton("关闭");
	private JLabel resultLabel=new JLabel("操作结果");
	private JTextArea resultArea=new JTextArea(8,40);
	
	//无参构造方法
	public desposit(){
		setup();    //初始化面板
	}
	
	//有参构造方法
	public desposit(String card,String pswd){
		setup();    //初始化面板
		cardNum.setText(card);
		cardpswd.setText(pswd);
	}
	
	////初始化面板方法
	public void setup(){
		setTitle("存   款");
		setSize(350,400);
		setLocation(300,400);
		setResizable(false);
		resultArea.setEditable(false);
		resultArea.setLineWrap(true);
		Container c=getContentPane();
		c.setLayout(null);
		c.add(cardNumLabel);
		cardNumLabel.setBounds(20,20,75,30);
		c.add(cardNum);
		cardNum.setBounds(70,20,240,30);
		c.add(cardpswdLabel);
		cardpswdLabel.setBounds(20,60,75,30);
		c.add(cardpswd);
		cardpswd.setBounds(70,60,240,30);
		c.add(inputMoneyLabel);
		inputMoneyLabel.setBounds(90,95,250,30);
		c.add(inputMoney);
		inputMoney.setBounds(70,130,240,30);
		c.add(despositButton);
		despositButton.setBounds(100,180,60,40);
		c.add(close);
		close.setBounds(180,180,60,40);
		c.add(resultLabel);
		resultLabel.setBounds(120,210,60,50);
		JScrollPane scrollPane=new JScrollPane(resultArea);
		c.add(scrollPane);
		scrollPane.setBounds(20,250,300,80);
		despositButton.addActionListener(this);
		close.addActionListener(this);
		//st=connectDB.conDB();  //连接数据库
		show();
	}
	
	//事件监听
	public void actionPerformed(ActionEvent ae){
		if(ae.getSource()==close){  //关闭按钮监听
			confirmDialog endDesposit=new confirmDialog(this,"结束操作","真的要结束存款吗?");
			if(endDesposit.isOkay){
			   hide();
			}
		}
		else if(ae.getSource()==despositButton){//取款按钮监听
		    flag=true;
			getCardNum=cardNum.getText().trim();
			getpswd=cardpswd.getText().trim();
			getMoney=inputMoney.getText().trim();
			if(getCardNum.equals("")==true&&getpswd.equals("")==true){
				JOptionPane.showMessageDialog(null,"请输入卡号和密码!");
			}
			else if(getMoney.equals("")==true){
				JOptionPane.showMessageDialog(null,"请输入要存入的金额!");
			}
			try{
				st=connectDB.conDB();//连接数据库
				con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
				command="select * from cardTable where userCardNum='"+getCardNum+"'";
				rs=st.executeQuery(command);
				if(rs.next()){
			    	String pswdValue=rs.getString("code").trim();
				   	if(pswdValue.equals(getpswd)==true){
			    		if(flag){
			    			moneyValue=rs.getString("balance").trim();
				           	int moneyInCardValue=Integer.parseInt(moneyValue);
				       		int getMoneyValue=Integer.parseInt(getMoney);
				           	int sum=moneyInCardValue+getMoneyValue;
				       	    money=Integer.toString(sum);
	     		  			command="update cardTable set balance='"+money+"' where userCardNum='"+getCardNum+"'";
		    	    		try{
			    				st.executeUpdate(command);
				    			JOptionPane.showMessageDialog(null,"存款成功!");
					   			resultArea.append("卡号:"+getCardNum+"\n");
					 			resultArea.append("存入:"+getMoney+"\n"+"操作成功完成!\n");
					    		resultArea.append("当前余额:"+money+"\n");									
			     			}catch(SQLException ex){
		    	   				while(ex!=null){
					   				JOptionPane.showMessageDialog(null,ex);
					   				ex.getNextException();
					    			return;
						    	}
					    	}
					   	}
					   }
			    	else{
				    	JOptionPane.showMessageDialog(null,"卡号和密码不一致!");
					   	flag=false;
    					confirmDialog reEnter=new confirmDialog(this,"重新输入","重新输入卡号和密码?");
	    				if(reEnter.isOkay){
		    				flag=true;
			     		}
				    	else{
					   		desposit.this.hide();
					   	}
			    	}
				}
				else{
					JOptionPane.showMessageDialog(null,"卡号不存在!");
					flag=false;
					confirmDialog reEnter=new confirmDialog(this,"重新输入","重新输入卡号和密码?");
					if(reEnter.isOkay){
						flag=true;
					}
					else{
						desposit.this.hide();
					}
				}
			}catch(Exception ex){
				while(ex!=null){
					JOptionPane.showMessageDialog(null,ex);
					resultArea.append(ex+"\n");
				}
			}
		closeDB.closeDB(st,con);
		}
	}
	public static void main(String args[]){
		desposit despositMoney=new desposit();
	}
  	
	
}