querybalance.java

实现JSP开发的BBS源码

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

//查询余额功能
public class queryBalance extends JFrame implements ActionListener{
	private Statement st=null;
	private Connection con=null;
	private ResultSet rs=null;
	private String getCardNum=null;
	private String getpswd=null;
	private String command=null;
	private boolean flag=true;
	//private boolean flag2=true;	
	private JLabel cardNumLabel=new JLabel("卡号:");
	private JTextField cardNum=new JTextField(18);
	private JLabel cardpswdLabel=new JLabel("口令:");
	private JPasswordField cardpswd=new JPasswordField(8);
	private JButton query=new JButton("查询");
	private JButton close=new JButton("关闭");
	private JLabel resultLabel=new JLabel("操作结果");
	private JTextArea resultArea=new JTextArea(8,40);
	
	//无参构造方法
	public queryBalance(){
		setup();//初始化面板
	}
	
	//有参构造方法
	public queryBalance(String card,String pswd){
		setup();//初始化面板
		cardNum.setText(card);
		cardpswd.setText(pswd);
	}
	
	//初始化面板方法
	public void setup(){
		setTitle("查询余额");
		setSize(300,300);
		setLocation(400,500);
		setResizable(false);
		resultArea.setEditable(false);
		resultArea.setLineWrap(true);
		Container c=getContentPane();
		c.setLayout(null);
		c.add(cardNumLabel);
		cardNumLabel.setBounds(20,20,60,30);
		c.add(cardNum);
		cardNum.setBounds(70,20,200,30);
		c.add(cardpswdLabel);
		cardpswdLabel.setBounds(20,60,60,30);
		c.add(cardpswd);
		cardpswd.setBounds(70,60,200,30);
		c.add(query);
		query.setBounds(90,110,60,40);
		c.add(close);
		close.setBounds(160,110,60,40);
		c.add(resultLabel);
		resultLabel.setBounds(120,140,60,50);
		JScrollPane scrollPane=new JScrollPane(resultArea);
		c.add(scrollPane);
		scrollPane.setBounds(20,180,260,80);
		query.addActionListener(this);
		close.addActionListener(this);
		show();
	}
		
	//事件监听
	public void actionPerformed(ActionEvent ae){
		if(ae.getSource()==close){    //关闭功能
			confirmDialog endquery=new confirmDialog(this,"结束操作","真的要结束查询余额吗?");
			if(endquery.isOkay){
			   hide();
			}
		}
		else if(ae.getSource()==query){  //查询功能
		        flag=true;
				getCardNum=cardNum.getText().trim();
				getpswd=cardpswd.getText().trim();
			if((getCardNum.equals(""))==true&&(getpswd.equals(""))==true){
				JOptionPane.showMessageDialog(null,"请输入卡号密码!");
				return;
			}
			else{
				command="select * from cardTable where userCardNum='"+getCardNum+"'";
				try{//判断卡号存在吗?
					st=connectDB.conDB();//连接数据库
		    		con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
					rs=st.executeQuery(command);
					if(rs.next()){ 
						String pswdValue=rs.getString("code").trim();
						if(pswdValue.equals(getpswd)==false){//判断卡号密码是否一致
							JOptionPane.showMessageDialog(null,"卡号和密码不一致!");
							flag=false;
							confirmDialog reEnter=new confirmDialog(this,"重新输入","重新输入卡号密码");
							if(reEnter.isOkay){
								flag=true;
							}
						}
						else{
							//取款成功,显示操作结果
							String balanceValue=rs.getString("balance");
							resultArea.append("卡号:"+getCardNum+"\n");
							resultArea.append("余额:"+balanceValue+"\n");
						}
					}
					else{//卡号不存在
						JOptionPane.showMessageDialog(null,"卡号不存在!");
						flag=false;
					}
				}catch(SQLException ex){
					while(ex!=null){
						JOptionPane.showMessageDialog(null,ex);
						ex.getNextException();
					}
				}
			}
		closeDB.closeDB(st,con);
		}
	}
	public static void main(String args[]){
		queryBalance qryBalance=new queryBalance();
	}
	
	
}