package?com.accp.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?com.accp.entity.BankBean;

/**
?*?創建數據訪問類
?*?@author?Administrator
?*
?*/
public?class?BankDAO
{
	/**
	?*?根據用戶ID查詢帳戶信息
	?*?@param?userID
	?*?@return
	?*/
	public?BankBean?findByUserID（String?userID）
	{
		BankBean?rt?=?null;
		
		try
		{
			//加載數據庫驅動
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
			//創建連接對象
			Connection?conn?=?DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;databasename=bank“?“sa“?“rvnvfhphal“）;
			//創建預處理器對象
			PreparedStatement?pstmt?=?conn.prepareStatement（“select?*?from?userInfo?where?userID=?“）;
			
			pstmt.setString（1?userID）;
			//數據集對象
			ResultSet?rs?=?pstmt.executeQuery（）;
			
			if（rs.next（））
			{
				rt?=?new?BankBean（）;
				
				rt.setUserID（rs.getString（1））;
				rt.setUserName（rs.getString（2））;
				rt.setBalance（rs.getFloat（3））;

			}
			//關閉對象
			rs.close（）;
			pstmt.close（）;
			conn.close（）;
		}?catch?（ClassNotFoundException?e）
		{
			//?TODO?自動生成?catch?塊
			e.printStackTrace（）;
		}?catch?（SQLException?e）
		{
			//?TODO?自動生成?catch?塊
			e.printStackTrace（）;
		}
		//返回實體
		return?rt;
	}
	
	
}

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

?????文件?????195072??2009-07-03?10:59??S2機試\0809機試網上銀行系統\0809機試.doc

?????文件????????410??2008-09-21?13:47??S2機試\0809機試網上銀行系統\Bank\.classpath

?????文件????????285??2009-07-10?17:11??S2機試\0809機試網上銀行系統\Bank\.mymetadata

?????文件???????1222??2008-09-21?14:10??S2機試\0809機試網上銀行系統\Bank\.project

?????文件????2097152??2009-07-10?17:12??S2機試\0809機試網上銀行系統\Bank\database\bank.mdf

?????文件????4194304??2009-07-10?17:12??S2機試\0809機試網上銀行系統\Bank\database\bank_log.ldf

?????文件???????1386??2009-07-10?17:17??S2機試\0809機試網上銀行系統\Bank\src\com\accp\dao\BankDAO.java

?????文件????????807??2008-10-08?16:54??S2機試\0809機試網上銀行系統\Bank\src\com\accp\entity\BankBean.java

?????文件???????1610??2008-11-23?17:07??S2機試\0809機試網上銀行系統\Bank\WebRoot\balance.jsp

?????文件????????357??2008-09-21?13:55??S2機試\0809機試網上銀行系統\Bank\WebRoot\css\style.css

?????文件????????657??2008-09-21?14:10??S2機試\0809機試網上銀行系統\Bank\WebRoot\dept.jsp

?????文件???????1351??2008-09-21?14:10??S2機試\0809機試網上銀行系統\Bank\WebRoot\index.jsp

?????文件?????????39??2008-09-21?13:47??S2機試\0809機試網上銀行系統\Bank\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1920??2009-07-10?17:17??S2機試\0809機試網上銀行系統\Bank\WebRoot\WEB-INF\classes\com\accp\dao\BankDAO.class

?????文件???????1108??2009-07-10?17:11??S2機試\0809機試網上銀行系統\Bank\WebRoot\WEB-INF\classes\com\accp\entity\BankBean.class

?????文件?????231949??2008-09-21?13:47??S2機試\0809機試網上銀行系統\Bank\WebRoot\WEB-INF\lib\sqljdbc.jar

?????文件????????284??2008-09-21?13:47??S2機試\0809機試網上銀行系統\Bank\WebRoot\WEB-INF\web.xml

?????文件????1015808??2008-12-23?03:55??S2機試\0809機試網上銀行系統\網上銀行系統.doc

?????文件????1394176??2009-01-16?04:11??S2機試\09-01\090111S2機試題.doc

?????文件????????410??2009-07-15?12:07??S2機試\09-01\address\.classpath

?????文件????????294??2009-07-15?12:06??S2機試\09-01\address\.mymetadata

?????文件???????1225??2009-07-15?12:57??S2機試\09-01\address\.project

?????文件????????334??2009-07-15?12:06??S2機試\09-01\address\.settings\org.eclipse.jdt.core.prefs

?????文件???????1355??2009-07-15?14:16??S2機試\09-01\address\src\dao\addressDao.java

?????文件???????2029??2009-07-15?14:17??S2機試\09-01\address\src\dao\baseDao.java

?????文件????????833??2009-07-15?12:09??S2機試\09-01\address\src\entity\address.java

?????文件???????3346??2009-07-15?18:38??S2機試\09-01\address\WebRoot\Addaddress.jsp

?????文件????????873??2009-07-15?14:01??S2機試\09-01\address\WebRoot\doAddaddress.jsp

?????文件????????991??2009-07-15?13:29??S2機試\09-01\address\WebRoot\index.jsp

?????文件?????????39??2009-07-15?12:06??S2機試\09-01\address\WebRoot\meta-INF\MANIFEST.MF

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