資源簡介
S2機試15套!部分帶答案S2
代碼片段和文件信息
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\.myme
?????文件???????1222??2008-09-21?14:10??S2機試\0809機試網上銀行系統\Bank\.project
?????文件????2097152??2009-07-10?17:12??S2機試\0809機試網上銀行系統\Bank\databa
?????文件????4194304??2009-07-10?17:12??S2機試\0809機試網上銀行系統\Bank\databa
?????文件???????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\st
?????文件????????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\me
?????文件???????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.xm
?????文件????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\.myme
?????文件???????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\ba
?????文件????????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\me
............此處省略303個文件信息
評論
共有 條評論