package?dao;

import?java.math.BigDecimal;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.text.SimpleDateFormat;
import?java.util.Date;

import?model.account;
import?util.StringUtil;

/**
?*?用戶工具類
?*?@author?lenovo
?*
?*/
public?class?accountDao?{
	/**
	?*?預(yù)置賬號列表
	?*?@param?con
	?*?@param?accoun
	?*?@return
	?*?@throws?Exception
	?*/
	public?ResultSet?list（Connection?conaccount?accoun）throws?Exception{
		StringBuffer?sb=new?StringBuffer（“select?*?from?account“）;
		PreparedStatement?pstmt=con.prepareStatement（sb.toString（））;
		return?pstmt.executeQuery（）;
	}
	/**
	?*?實現(xiàn)提款
	?*?@param?con
	?*?@param?i
	?*?@param?name
	?*?@throws?Exception
	?*/
	public?void?outmoney（Connection?con?BigDecimal?iString?name）throws?Exception?{
		//?TODO?Auto-generated?method?stub
		String?sql=“update?account?set?money=money-???where?username=?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setBigDecimal（1i）;
		pstmt.setString（2?name）;
		pstmt.executeUpdate（）;
	}
	/**
	?*?對比余額，判斷是否還有足夠錢提出
	?*?@param?con
	?*?@param?i
	?*?@param?name
	?*?@return
	?*?@throws?Exception
	?*/
	public?boolean?Comparemoney（Connection?conBigDecimal?iString?name）throws?Exception{
		boolean?result=true;
		StringBuffer?sql=new?StringBuffer（“select?money?from?account“）;
		if（StringUtil.isNotEmpty（name））
		{
			sql.append（“?where?username?like?‘%“+name+“%‘“）;
		}
		PreparedStatement?pstmt=con.prepareStatement（sql.toString（））;
		ResultSet?rs=pstmt.executeQuery（）;
		while（rs.next（））{
			BigDecimal?itsmoney=rs.getBigDecimal（“money“）;
			if（itsmoney.compareTo（i）>=0）{
				result=true;
			}
			else{
				result=false;
			}
		}
		return?result;
	}
	/**
	?*?用戶存錢
	?*?@param?con
	?*?@param?i
	?*?@param?name
	?*?@throws?Exception
	?*/
	public?void?income（Connection?con?BigDecimal?i?String?name）throws?Exception?{
		//?TODO?Auto-generated?method?stub
		String?sql=“update?account?set?money=money+???where?username=?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setBigDecimal（1i）;
		pstmt.setString（2?name）;
		pstmt.executeUpdate（）;
	}
	/**
	?*?校驗修改密碼時原密碼的輸入
	?*?@param?con
	?*?@param?name
	?*?@return
	?*?@throws?Exception
	?*/
	public?String?S_oldpassword（Connection?con?String?name）?throws?Exception?{
		//?TODO?Auto-generated?method?stub
		String?password=null;
		StringBuffer?sql=new?StringBuffer（“select?password?from?account“）;
		if（StringUtil.isNotEmpty（name））{
			sql.append（“?where?username?like?‘%“+name+“%‘“）;
		}
		PreparedStatement?pstmt=con.prepareStatement（sql.toString（））;
		ResultSet?rs=pstmt.executeQuery（）;
		while（rs.next（））{
			password=rs.getString（“password“）;
		}
		return?password;
	}
	/**
	?*?修改密碼
	?*?@param?con
	?*?@param?newpassword
	?*?@param?name
	?*?@throws?Exception
	?*/
	public?void?modifyPassword（Connection?con?String?newpassword?String?name）?throws?Exception?{
		//?TODO?Auto-gener

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-12-11?16:18??ATMmachine\
?????文件?????????380??2017-12-11?16:18??ATMmachine\.classpath
?????文件?????????386??2017-12-11?16:16??ATMmachine\.project
?????目錄???????????0??2017-12-11?16:16??ATMmachine\.settings\
?????文件?????????598??2017-12-11?16:16??ATMmachine\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-10-29?19:29??ATMmachine\bin\
?????目錄???????????0??2018-10-29?19:29??ATMmachine\bin\dao\
?????文件????????5481??2018-10-29?19:29??ATMmachine\bin\dao\accountDao.class
?????目錄???????????0??2018-10-29?19:29??ATMmachine\bin\model\
?????文件????????1333??2018-10-29?19:29??ATMmachine\bin\model\account.class
?????目錄???????????0??2018-10-29?19:29??ATMmachine\bin\util\
?????文件????????1011??2018-10-29?19:29??ATMmachine\bin\util\DateUtil.class
?????文件????????1648??2018-10-29?19:29??ATMmachine\bin\util\DbUtil.class
?????文件?????????653??2018-10-29?19:29??ATMmachine\bin\util\StringUtil.class
?????目錄???????????0??2018-10-29?19:29??ATMmachine\bin\view\
?????文件?????????846??2018-10-29?19:29??ATMmachine\bin\view\HistoryJframe$1.class
?????文件????????8690??2018-10-29?19:29??ATMmachine\bin\view\HistoryJframe.class
?????文件????????7814??2018-10-29?19:29??ATMmachine\bin\view\IncomeJframe.class
?????文件?????????722??2018-10-29?19:29??ATMmachine\bin\view\LoginJframe$1.class
?????文件????????8640??2018-10-29?19:29??ATMmachine\bin\view\LoginJframe.class
?????文件????????6736??2018-10-29?19:29??ATMmachine\bin\view\MainJframe.class
?????文件????????8168??2018-10-29?19:29??ATMmachine\bin\view\ModifyPasswordJframe.class
?????文件????????8080??2018-10-29?19:29??ATMmachine\bin\view\OtherOutMoneyJframe.class
?????文件????????9674??2018-10-29?19:29??ATMmachine\bin\view\OutComeJframe.class
?????文件????????8024??2018-10-29?19:29??ATMmachine\bin\view\OutMoneyJframe.class
?????文件????????6748??2018-10-29?19:29??ATMmachine\bin\view\SelectRemainMoneyJframe.class
?????目錄???????????0??2017-12-11?16:18??ATMmachine\jdbc\
?????文件??????999635??2017-12-09?14:46??ATMmachine\jdbc\mysql-connector-java-5.1.44-bin.jar
?????目錄???????????0??2017-12-14?19:42??ATMmachine\src\
?????目錄???????????0??2017-12-18?20:50??ATMmachine\src\dao\
?????文件????????6262??2017-12-19?19:30??ATMmachine\src\dao\accountDao.java
............此處省略16個文件信息