customeraction.java

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

package customer.services.action;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import customer.po.MoneyLog;
import DBManager.SQLserver2000;

public class CustomerAction {
	//查询余额
	public String getBalance(String IDcard){
		
		StringBuffer buffer = new StringBuffer("select moneyMessage from moneyMessage where idcard='");
		buffer.append(IDcard);
		buffer.append("'");
		String SQL = buffer.toString();
		ResultSet rs = SQLserver2000.getRS(SQL);
		try {
			return rs.getString("moneyMessage");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			return "0";
			//e.printStackTrace();
			
		}
	}
	//存款
	public void saveMoney(String money , String IDcard , String saveMoney){
		StringBuffer saveBuffer = new StringBuffer("update moneyMessage set moneymessage = '");
		saveBuffer.append(money);
		saveBuffer.append("'");
		saveBuffer.append("where IDcard ='");
		saveBuffer.append(IDcard);
		saveBuffer.append("'");
		String updateSQL = saveBuffer.toString();
		boolean result = false;
		result = new SQLserver2000().excuteSQL(updateSQL);
		System.out.println(result);
		if(result==true){
			String logDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
			
			StringBuffer logBuffer = new StringBuffer("insert into moneyLog (moneylog , logDate , IDcard ) values('存");
			logBuffer.append(saveMoney);
			logBuffer.append("','");
			logBuffer.append(logDate);
			logBuffer.append("','");
			logBuffer.append(IDcard);
			logBuffer.append("')");
			String logSQL = logBuffer.toString();
			new SQLserver2000().excuteSQL(logSQL);
			System.out.println(logSQL);
		}
	}
	//取款
	public void deleteMoney(String money , String IDcard , String deleteMoney){
			StringBuffer deleteBuffer = new StringBuffer("update moneyMessage set moneymessage = '");
			deleteBuffer.append(money);
			deleteBuffer.append("'");
			deleteBuffer.append("where IDcard ='");
			deleteBuffer.append(IDcard);
			deleteBuffer.append("'");
			String updateSQL = deleteBuffer.toString();
			boolean result = false;
			result = new SQLserver2000().excuteSQL(updateSQL);
			if(result == true){
				String logDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
				
				StringBuffer logBuffer = new StringBuffer("insert into moneyLog (moneylog , logDate , IDcard ) values('取");
				logBuffer.append(deleteMoney);
				logBuffer.append("','");
				logBuffer.append(logDate);
				logBuffer.append("','");
				logBuffer.append(IDcard);
				logBuffer.append("')");
				String logSQL = logBuffer.toString();
				new SQLserver2000().excuteSQL(logSQL);
			}
	}
	
	//存取记录
	public List<MoneyLog> getMoneyLog(String IDcard){
		List<MoneyLog> moneyLogList = new ArrayList<MoneyLog>();
		StringBuffer moneyLogBuffer = new StringBuffer("select * from moneylog where IDcard = '");
		moneyLogBuffer.append(IDcard);
		moneyLogBuffer.append("' order by logDate");
		String moneyLogSQL = moneyLogBuffer.toString();
		ResultSet RS = SQLserver2000.getRS(moneyLogSQL);
		System.out.println(RS);
		try {
			RS.beforeFirst();
			while(RS.next()){
				MoneyLog MLog = new MoneyLog();
				MLog.setMoneyLog(RS.getString("MoneyLog"));
				MLog.setLogDate(RS.getString("logDate"));
				MLog.setIDcard(RS.getString("IDcard"));
				moneyLogList.add(MLog);
			}
			return moneyLogList;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
}