package?com.java.bank.dao;

import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?com.java.bank.db.CreateConnection;
import?com.java.bank.model.Card;

public?class?CardDao?{
	
	CreateConnection?cc?=?new?CreateConnection（）;
	Connection?conn?=?cc.getConnection（）;
	
	//新增用戶信息
	public?void?create（Card?c）
	{
		
		
		String?insertSql?=?“insert?into?card?values?（‘“+c.getUserName（）+“‘“+c.getPassword（）+“‘“+c.getPassword（）+“‘“+c.getPassword（）+“‘）“;
		
		System.out.println（insertSql）;		
		try?{
			Statement?st?=?conn.createStatement（）;
			st.executeUpdate（insertSql）;
			st.close（）;
		}
		
		catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	
	//通過卡號查詢并獲取用戶信息
	
	public?Card?query（String?no）
	{
		Card?card?=?null;
		
		String?querySql?=?“select?*?from?card?where?id?=?‘“+no+“‘“;
		
		Statement?st;
		try?{
			st?=?conn.createStatement（）;
			
			ResultSet?rs?=?st.executeQuery（querySql）;
			
			if（rs.next（））
			{
				card?=?new?Card（）;
				String?cardNo=?rs.getString（“id“）;
				card.setCardNo（cardNo）;
				String?username?=?rs.getString（1）;
				card.setUserName（username）;
				String?password?=?rs.getString（2）;
				card.setPassword（password）;
				Double?money?=?rs.getDouble（4）;
				card.setMoney（money）;
				int?status=rs.getInt（“status“）;
				card.setStatus（status）;
				int?times?=?rs.getInt（6）;
				card.setTimes（times）;
				
			}
			
			st.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		return?card;
	}
	
	//修改賬戶金額信息
	
	public?void?update（Card?c）
	{
		try?{
			Statement?st?=?conn.createStatement（）;
			String?updateSql1?=?“update?card?set?money=‘“+c.getMoney（）+“‘?where?id=‘“+c.getCardNo（）+“‘“;			
			st.executeUpdate（updateSql1）;
			st.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
	}
	
	//三次輸入密碼錯誤，修改賬戶鎖定狀態
	public?void?updateStatus（Card?c）
	{
		try?{
			Statement?st?=?conn.createStatement（）;
			String?updateSql?=?“update?card?set?status=1?where?id=‘“+c.getCardNo（）+“‘“;			
			st.executeUpdate（updateSql）;			
//			System.out.println（“........“）;
			st.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}		
	}
	
	//退卡時重置登錄次數
	
	public?void?resetStatus（Card?c）
	{
		try?{
			Statement?st?=?conn.createStatement（）;
			String?updateSql?=?“update?card?set?status=0times=3?where?id=‘“+c.getCardNo（）+“‘“;			
			st.executeUpdate（updateSql）;			
//			System.out.println（“........“）;
			st.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}	
	}
	
	//標志輸入次數的修改
	public?void?updateTimes（Card?c）
	{
		try?{
			Statement?st?=?conn.createStatement（）;
			String?updateTimesSql?=“update?card?set?times=times-1?where?id?=‘“+c.getCardNo（）+“‘

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????504??2012-11-28?16:18??bankproject\.classpath

?????文件????????387??2012-11-28?11:09??bankproject\.project

?????文件????????629??2012-11-28?11:09??bankproject\.settings\org.eclipse.jdt.core.prefs

?????文件????????137??2012-11-28?11:16??bankproject\.settings\org.eclipse.ltk.core.refactoring.prefs

?????文件???????4401??2012-11-30?16:06??bankproject\bin\com\java\bank\dao\CardDao.class

?????文件???????1429??2012-11-29?08:55??bankproject\bin\com\java\bank\dao\DaoTest.class

?????文件???????3659??2012-11-30?13:39??bankproject\bin\com\java\bank\dao\OperationDao.class

?????文件???????1480??2012-11-28?16:18??bankproject\bin\com\java\bank\db\CreateConnection.class

?????文件???????1513??2012-11-29?16:25??bankproject\bin\com\java\bank\model\Card.class

?????文件???????1799??2012-11-30?13:28??bankproject\bin\com\java\bank\model\Operation.class

?????文件???????2753??2012-11-28?16:18??bankproject\bin\com\java\bank\test\ConnTest.class

?????文件????????750??2012-11-30?16:03??bankproject\bin\com\java\bank\ui\ATM$1.class

?????文件????????537??2012-11-30?16:03??bankproject\bin\com\java\bank\ui\ATM$2.class

?????文件???????5871??2012-11-30?16:03??bankproject\bin\com\java\bank\ui\ATM.class

?????文件???????5310??2012-11-30?16:03??bankproject\bin\com\java\bank\ui\ATM.form

?????文件????????827??2012-11-30?13:17??bankproject\bin\com\java\bank\ui\ChangePassword$1.class

?????文件????????827??2012-11-30?13:17??bankproject\bin\com\java\bank\ui\ChangePassword$2.class

?????文件???????7453??2012-11-30?13:39??bankproject\bin\com\java\bank\ui\ChangePassword.class

?????文件???????8372??2012-11-30?13:17??bankproject\bin\com\java\bank\ui\ChangePassword.form

?????文件????????785??2012-11-30?15:57??bankproject\bin\com\java\bank\ui\MainForm$1.class

?????文件????????785??2012-11-30?15:57??bankproject\bin\com\java\bank\ui\MainForm$2.class

?????文件????????785??2012-11-30?15:57??bankproject\bin\com\java\bank\ui\MainForm$3.class

?????文件????????785??2012-11-30?15:57??bankproject\bin\com\java\bank\ui\MainForm$4.class

?????文件????????785??2012-11-30?15:57??bankproject\bin\com\java\bank\ui\MainForm$5.class

?????文件????????785??2012-11-30?15:57??bankproject\bin\com\java\bank\ui\MainForm$6.class

?????文件???????8114??2012-11-30?15:57??bankproject\bin\com\java\bank\ui\MainForm.class

?????文件???????7775??2012-11-30?15:57??bankproject\bin\com\java\bank\ui\MainForm.form

?????文件????????792??2012-11-30?13:15??bankproject\bin\com\java\bank\ui\QueryForm$1.class

?????文件???????4901??2012-11-30?13:15??bankproject\bin\com\java\bank\ui\QueryForm.class

?????文件???????5293??2012-11-30?13:15??bankproject\bin\com\java\bank\ui\QueryForm.form

............此處省略83個文件信息