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.mysql.jdbc.Driver“;?????????????????//?數(shù)據(jù)庫驅(qū)動(dòng)
????public?final?static?String?URL????=?“jdbc:mysql://localhost:3306/company“;???//?url
????public?final?static?String?DBNAME?=?“root“;???????????????????????????????????????????????????????????//?數(shù)據(jù)庫用戶名
????public?final?static?String?DBPASS?=?“root“;???????????????????????????????????????????????????????????//?數(shù)據(jù)庫密碼
????
????/**
?????*?得到數(shù)據(jù)庫連接
?????*?@throws?ClassNotFoundException
?????*?@throws?SQLException
?????*?@return?數(shù)據(jù)庫連接
?????*/
????public?Connection?getConn（）?throws?ClassNotFoundException?SQLException{
????????Class.forName（DRIVER）;????????????????????????????????????????????????????//注冊驅(qū)動(dòng)
????????Connection?conn?=?DriverManager.getConnection（URLDBNAMEDBPASS）;????????//獲得數(shù)據(jù)庫連接
????????return?conn?;????????????????????????????????????????????????????????????//返回連接
????}
????
????/**
?????*?釋放資源
?????*?@param?conn?數(shù)據(jù)庫連接
?????*?@param?pstmt?PreparedStatement對象
?????*?@param?rs?結(jié)果集
?????*/
????public?void?closeAll（?Connection?conn?PreparedStatement?pstmt?ResultSet?rs?）?{
????????/*??如果rs不空，關(guān)閉rs??*/
????????if（rs?!=?null）{
????????????try?{?rs.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????????/*??如果pstmt不空，關(guān)閉pstmt??*/
????????if（pstmt?!=?null）{
????????????try?{?pstmt.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????????/*??如果conn不空，關(guān)閉conn??*/
????????if（conn?!=?null）{
????????????try?{?conn.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
????????}
????}
????
????/**
?????*?執(zhí)行SQL語句，可以進(jìn)行增、刪、改的操作，不能執(zhí)行查詢
?????*?@param?sql??預(yù)編譯的?SQL?語句
?????*?@param?param??預(yù)編譯的?SQL?語句中的‘？’參數(shù)的字符串?dāng)?shù)組
?????*?@return?影響的條數(shù)
?????*/
????public?int?executeSQL（String?preparedSqlString[]?param）?{
????????Connection????????conn??=?null;
????????PreparedStatement?pstmt?=?null;
????????int???????????????num???=?0;
????????
????????/*??處理SQL執(zhí)行SQL??*/
????????try?{
????????????conn?=?getConn（）;??????????????????????????????//?得到數(shù)據(jù)庫連接
????????????pstmt?=?conn.prepareStatement（preparedSql）;????//?得到PreparedStatement對象
????????????if（?param?!=?null?）?{
????????????????for（?int?i?=?0;?i?????????????????????pstmt.setString（i+1?param[i]）;?????????//?為預(yù)編譯sql設(shè)置參數(shù)
????????????????}
????????????}
????????????num?=?pstmt.executeUpdate（）;????????????????????//?執(zhí)行SQL語句
????????}?catch?（ClassNotFoundException?e）?{
????????????e.printStackTrace（）;????????????????????????????//?處理ClassNotFoundException異常
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;????????????????????????????//?處理SQLException異常
????????}?finally?{
????????????closeAll（connpstmtnull）;?????????????????????//?釋放資源
????????}
????????return?num;
????}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-06-28?03:03??company\
?????文件????????1286??2013-06-28?02:34??company\.classpath
?????目錄???????????0??2013-06-17?15:12??company\.myeclipse\
?????文件?????????294??2011-02-18?14:58??company\.mymetadata
?????文件????????1750??2013-06-26?20:25??company\.project
?????目錄???????????0??2013-06-26?20:31??company\.settings\
?????文件?????????522??2013-06-25?11:27??company\.settings\.jsdtscope
?????文件?????????216??2013-06-25?11:27??company\.settings\com.genuitec.eclipse.migration.prefs
?????文件?????????136??2013-06-28?02:11??company\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2013-06-25?11:27??company\.settings\org.eclipse.jdt.core.prefs
?????文件?????????483??2013-06-25?11:27??company\.settings\org.eclipse.wst.common.component
?????文件?????????362??2013-06-25?11:27??company\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2013-06-25?11:27??company\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-06-25?11:27??company\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2013-06-28?02:22??company\src\
?????目錄???????????0??2013-06-26?20:31??company\src\s2jsp\
?????目錄???????????0??2013-06-26?20:31??company\src\s2jsp\bysj\
?????目錄???????????0??2013-06-26?20:31??company\src\s2jsp\bysj\dao\
?????文件????????3171??2013-06-25?16:57??company\src\s2jsp\bysj\dao\baseDao.java
?????文件????????2512??2013-06-26?00:00??company\src\s2jsp\bysj\dao\MessageDao.java
?????文件????????4655??2013-06-25?22:31??company\src\s2jsp\bysj\dao\NewsDao.java
?????文件????????5123??2013-06-26?11:50??company\src\s2jsp\bysj\dao\ProductDao.java
?????文件????????1447??2013-06-25?23:58??company\src\s2jsp\bysj\dao\RevertDao.java
?????文件????????2986??2013-06-25?22:24??company\src\s2jsp\bysj\dao\UserDao.java
?????目錄???????????0??2013-06-27?20:52??company\src\s2jsp\bysj\entity\
?????文件????????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??2013-06-26?20:36??company\WebRoot\
............此處省略278個(gè)文件信息