chpswd.java

实现JSP开发的BBS源码

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

//修改密码功能
public class chpswd 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 oldpasswd=null;
	private String newpasswd=null;
	private String reEnterpasswd=null;
	private String getpswd=null;
	boolean flag=true;
	
	private JLabel userCardNumLabel=new JLabel("用户卡号:");
 	private JTextField userCardNum=new JTextField(18);
	private JLabel oldpswdLabel=new JLabel("原 密 码 :");
	private JPasswordField oldpswd=new JPasswordField(8);
	private JLabel newpswdLabel=new JLabel("新 密 码 :");
	private JPasswordField newpswd=new JPasswordField(8);
	private JLabel reEnterpswdLabel=new JLabel("确认密码:");
	private JPasswordField reEnterpswd=new JPasswordField(8);
	private JButton confirm=new JButton("确定");
	private JButton clear=new JButton("清除");
	
	//无参构造方法
	public chpswd(){
		setup();    //初始化面板
	}
	
	public chpswd(String card,String pswd){
		cardNum=card;
		setup();   //初始化面板
	}
	
	//初始化面板方法  
	public void setup(){
		setTitle("修改密码");
		setSize(400,300);
		setLocation(300,400);
		setResizable(false);
		Container c=getContentPane();
		c.setLayout(null);
		
		c.add(userCardNumLabel);
		userCardNumLabel.setBounds(30,30,60,30);
		c.add(userCardNum);
		userCardNum.setBounds(100,30,200,30);
		c.add(oldpswdLabel);
		oldpswdLabel.setBounds(30,70,60,30);
		c.add(oldpswd);
		oldpswd.setBounds(100,70,200,30);
		c.add(newpswdLabel);
		newpswdLabel.setBounds(30,110,60,30);
		c.add(newpswd);
		newpswd.setBounds(100,110,200,30);
		c.add(reEnterpswdLabel);
		reEnterpswdLabel.setBounds(30,150,60,30);
		c.add(reEnterpswd);
		reEnterpswd.setBounds(100,150,200,30);
		c.add(confirm);
		confirm.setBounds(100,200,80,40);
		c.add(clear);
		clear.setBounds(190,200,80,40);
		confirm.addActionListener(this);
		clear.addActionListener(this);
		show();
	}
    
    //事件监听
	public void actionPerformed(ActionEvent ae){
		if((ae.getSource())==confirm){ //确定按钮监听
			flag=true;
			if((userCardNum.getText().trim()).equals("")==true){
				JOptionPane.showMessageDialog(null,"请输入卡号和密码");
				return;
			}
		    else{
			    cardNum=userCardNum.getText().trim();
			    oldpasswd=oldpswd.getText().trim();
			    newpasswd=newpswd.getText().trim();
			    reEnterpasswd=reEnterpswd.getText().trim();
			    if(newpasswd.equals(reEnterpasswd)==false){
				   JOptionPane.showMessageDialog(null,"新输入两次密码不一致!");
				   flag=false;
				   return;
			    }			
		    }		
		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()){
				getpswd=rs.getString("code").trim();
				if(getpswd.equals(oldpasswd)==false){
				   JOptionPane.showMessageDialog(null,"卡号密码不一致!");
				   flag=false;
				}
			}
			else{
				JOptionPane.showMessageDialog(null,"卡号不存在!");
				flag=false;
			}
		}catch(SQLException ex){
			while(ex!=null){
					JOptionPane.showMessageDialog(null,ex);
					ex.getNextException();
					return;					
				}
		}
		try{
			command="update cardTable set code='"+newpasswd+"' where userCardNum='"+cardNum+"'";
			if(flag){			
			   st.executeUpdate(command);
			   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){  //清除按钮监听
			userCardNum.setText("");
			oldpswd.setText("");
			newpswd.setText("");
			reEnterpswd.setText("");
			flag=true;			
		}
	}
	public static void main(String args[]){
		chpswd changepswd=new chpswd();
	}
}