package?s2jsp.bysj.dao;

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

public?class?baseDao?{????
????public?final?static?String?DRIVER?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;?????????????????//?數據庫驅動
????public?final?static?String?URL????=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=company“;???//?url
????public?final?static?String?DBNAME?=?“sa“;???????????????????????????????????????????????????????????//?數據庫用戶名
????public?final?static?String?DBPASS?=?“120010“;???????????????????????????????????????????????????????????//?數據庫密碼
????
????/**
?????*?得到數據庫連接
?????*?@throws?ClassNotFoundException
?????*?@throws?SQLException
?????*?@return?數據庫連接
?????*/
????public?Connection?getConn（）?throws?ClassNotFoundException?SQLException{
????????Class.forName（DRIVER）;????????????????????????????????????????????????????//注冊驅動
????????Connection?conn?=?DriverManager.getConnection（URLDBNAMEDBPASS）;????????//獲得數據庫連接
????????return?conn?;????????????????????????????????????????????????????????????//返回連接
????}
????
????/**
?????*?釋放資源
?????*?@param?conn?數據庫連接
?????*?@param?pstmt?PreparedStatement對象
?????*?@param?rs?結果集
?????*/
????public?void?closeAll（?Connection?conn?PreparedStatement?pstmt?ResultSet?rs?）?{
????????/*??如果rs不空，關閉rs??*/
????????if（rs?!=?null）{
????????????try?{?rs.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????????/*??如果pstmt不空，關閉pstmt??*/
????????if（pstmt?!=?null）{
????????????try?{?pstmt.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????????/*??如果conn不空，關閉conn??*/
????????if（conn?!=?null）{
????????????try?{?conn.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????}
????
????/**
?????*?執行SQL語句，可以進行增、刪、改的操作，不能執行查詢
?????*?@param?sql??預編譯的?SQL?語句
?????*?@param?param??預編譯的?SQL?語句中的‘？’參數的字符串數組
?????*?@return?影響的條數
?????*/
????public?int?executeSQL（String?preparedSqlString[]?param）?{
????????Connection????????conn??=?null;
????????PreparedStatement?pstmt?=?null;
????????int???????????????num???=?0;
????????
????????/*??處理SQL執行SQL??*/
????????try?{
????????????conn?=?getConn（）;??????????????????????????????//?得到數據庫連接
????????????pstmt?=?conn.prepareStatement（preparedSql）;????//?得到PreparedStatement對象
????????????if（?param?!=?null?）?{
????????????????for（?int?i?=?0;?i?????????????????????pstmt.setString（i+1?param[i]）;?????????//?為預編譯sql設置參數
????????????????}
????????????}
????????????num?=?pstmt.executeUpdate（）;????????????????????//?執行SQL語句
????????}?catch?（ClassNotFoundException?e）?{
????????????e.printStackTrace（）;????????????????????????????//?處理ClassNotFoundException異常
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;????????????????????????????//?處理SQLException異常
????????}?finally?{
????????????closeAll（connpstmtnull）;?????????????????????//?釋放

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

?????文件????????490??2007-10-31?14:45??項目參考代碼\company\.classpath

?????目錄??????????0??2008-10-29?10:59??項目參考代碼\company\.myeclipse

?????文件????????294??2007-10-04?12:26??項目參考代碼\company\.mymetadata

?????文件???????1225??2007-10-01?10:17??項目參考代碼\company\.project

?????文件????????127??2007-10-06?22:50??項目參考代碼\company\.settings\org.eclipse.core.resources.prefs

?????目錄??????????0??2008-10-29?10:59??項目參考代碼\company\.settings

?????文件???????3221??2007-10-31?16:17??項目參考代碼\company\src\s2jsp\bysj\dao\baseDao.java

?????文件???????2506??2007-10-31?13:46??項目參考代碼\company\src\s2jsp\bysj\dao\MessageDao.java

?????文件???????4555??2007-10-07?13:37??項目參考代碼\company\src\s2jsp\bysj\dao\NewsDao.java

?????文件???????5022??2007-10-10?11:59??項目參考代碼\company\src\s2jsp\bysj\dao\ProductDao.java

?????文件???????1347??2007-10-08?13:27??項目參考代碼\company\src\s2jsp\bysj\dao\RevertDao.java

?????文件???????2981??2007-10-31?15:30??項目參考代碼\company\src\s2jsp\bysj\dao\UserDao.java

?????目錄??????????0??2008-10-29?10:59??項目參考代碼\company\src\s2jsp\bysj\dao

?????文件???????1456??2007-10-05?09:28??項目參考代碼\company\src\s2jsp\bysj\entity\Message.java

?????文件????????992??2007-10-01?09:20??項目參考代碼\company\src\s2jsp\bysj\entity\News.java

?????文件???????1961??2007-10-01?16:35??項目參考代碼\company\src\s2jsp\bysj\entity\Product.java

?????文件???????1368??2007-10-05?13:34??項目參考代碼\company\src\s2jsp\bysj\entity\Revert.java

?????文件????????984??2007-10-02?09:22??項目參考代碼\company\src\s2jsp\bysj\entity\Users.java

?????目錄??????????0??2008-10-29?10:59??項目參考代碼\company\src\s2jsp\bysj\entity

?????目錄??????????0??2008-10-29?10:59??項目參考代碼\company\src\s2jsp\bysj

?????目錄??????????0??2008-10-29?10:59??項目參考代碼\company\src\s2jsp

?????目錄??????????0??2008-10-29?10:59??項目參考代碼\company\src

?????文件???????2244??2007-10-10?15:09??項目參考代碼\company\WebRoot\about.jsp

?????文件???????2345??2007-10-12?15:13??項目參考代碼\company\WebRoot\admin\addManager.jsp

?????文件???????2492??2007-10-31?13:38??項目參考代碼\company\WebRoot\admin\addNews.jsp

?????文件???????4441??2007-10-31?14:33??項目參考代碼\company\WebRoot\admin\addProduct.jsp

?????文件????????942??2007-10-10?17:24??項目參考代碼\company\WebRoot\admin\adminLoginManage.jsp

?????文件????????124??2007-10-10?16:50??項目參考代碼\company\WebRoot\admin\adminOut.jsp

?????文件????????270??2007-10-10?13:25??項目參考代碼\company\WebRoot\admin\checkSession.jsp

?????文件???????1341??2007-10-10?08:35??項目參考代碼\company\WebRoot\admin\index.jsp

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