customerupdateaction.java

存款、取款、账户明细、系统备份、修改密码

package customer.services.action;

import java.sql.ResultSet;
import java.sql.SQLException;

import DBManager.SQLserver2000;

public class CustomerUpdateAction {
	//更新密码
	public boolean changePassword(String oldPassword , String IDcard , String newPassword , String type){
		if("普通用户".equals(type)){
		StringBuffer changeBuffer = new StringBuffer("update customer set password = '");
		changeBuffer.append(newPassword);
		changeBuffer.append("' where password = '");
		changeBuffer.append(oldPassword);
		changeBuffer.append("' and IDcard = '");
		changeBuffer.append(IDcard);
		changeBuffer.append("' select   @@rowcount as change");
		String changeSQL = changeBuffer.toString();
		//System.out.println(changeSQL);
		ResultSet RS = SQLserver2000.getRS(changeSQL);
		if(RS!=null){
			try {
				if(!RS.getString("change").equals("0")){
					return true;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				return false;
			}
			
		}
	}else{
		StringBuffer changeBuffer = new StringBuffer("update admin set password = '");
		changeBuffer.append(newPassword);
		changeBuffer.append("' where password = '");
		changeBuffer.append(oldPassword);
		changeBuffer.append("' and IDcard = '");
		changeBuffer.append(IDcard);
		changeBuffer.append("' select   @@rowcount as change");
		String changeSQL = changeBuffer.toString();
		System.out.println(changeSQL);
		ResultSet RS = SQLserver2000.getRS(changeSQL);
		if(RS!=null){
			try {
				if(!RS.getString("change").equals("0")){
					return true;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				return false;
			}
			
		}
	}
		return false;
	}
	
	//用户注销
	public boolean removeCustomer(String IDcard , String type){
		String deleteCustomer = "delete from ";
		if("管理员".equals(type)){
			deleteCustomer +="admin";
		}
		if("普通用户".equals(type)){
			deleteCustomer +="Customer";
		}
		deleteCustomer += " where IDcard = '"+IDcard+"'";
		System.out.println(deleteCustomer);
		
		String deleteLog = "delete from moneyLog where IDcard = '"+IDcard+"'";
		System.out.println(deleteLog);
		
		String deleteMoneyMessage = "delete from moneyMessage where IDcard = '"+IDcard+"'";
		System.out.println(deleteMoneyMessage);
		
		boolean result = false ;
		result = new SQLserver2000().excuteSQL(deleteCustomer);
		if(result == false){
			System.out.println("insertAdminSQL这里rollback了");
		}
		
		result = new SQLserver2000().excuteSQL(deleteLog);
		if(result == false){
			new SQLserver2000().excuteSQL("rollback");
			System.out.println("deleteLog这里rollback了");
		}
		
		result = new SQLserver2000().excuteSQL(deleteMoneyMessage);
		if(result == false){
			new SQLserver2000().excuteSQL("rollback");
			System.out.println("deleteMoneyMessage这里rollback了");
		}
		return result;
	}
}