package?s2jsp.bysj.dao;

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

//導入用于輸出日志信息的類
import?org.apache.log4j.Logger;

public?class?baseDao?{???
	//注冊驅動的字符串
????public?final?static?String?DRIVER?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;????????????????
????//連接數據庫的URL字符串
????public?final?static?String?URL????=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=company“;???
????//?數據庫用戶名
????public?final?static?String?DBNAME?=?“sa“;??????????????????????????????????????????????????????????
????//?數據庫用戶密碼
????public?final?static?String?DBPASS?=?“sa“;??????????????????????????????????????????????????????????
????
????/**用于輸出日志信息的對象**/
????public?static?Logger?logger?=?Logger.getLogger（baseDao.class.getName（））;
????
????/**
?????*?得到數據庫連接
?????*?@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?）?{
????	try{
????		/**如果結合集rs不空，關閉rs*/
????		if（rs?!=?null）
????		{
????			rs.close（）;
????		}
????	}
????	catch（SQLException?ex）
????	{
????????	//輸出產生錯誤的日志信息
????????	logger.error（ex.getMessage（））;?
????	}
????	finally
????	{
????		try{
????	????????/**如果pstmt不空，關閉pstmt??*/
????	????????if（pstmt?!=?null）{
????	????????	pstmt.close（）;
????	????????}
????		}
????		catch（SQLException?ex）
????		{
????			//輸出產生錯誤的日志信息
????????????	logger.error（ex.getMessage（））;?
????		}
????		finally
????		{
????			try{
????				/**如果conn不空并且沒有關閉則關閉pstmt??*/
????				if（conn?!=?null?&&?（!conn.isClosed（）））
????				{
????					conn.close（）;
????				}
????			}
????			catch（SQLException?ex）
????			{
????				//輸出產生錯誤的日志信息
????????????????	logger.error（ex.getMessage（））;?
????			}
????		}
????	}
????}
????
????/**
?????*?執行SQL語句，可以進行增、刪、改的操作，不能執行查詢
?????*?@param?sql??預編譯的?SQL?語句
?????*?@param?param??預編譯的?SQL?語句中的‘？’參數的字符串數組
?????*?@return?影響的條數
?????*/
????public?int?executeSQL（String?preparedSqlString[]?param）?{
????	//Connection對象
????????Connection????????conn??=?null;
????????//PreparedStatement對象
????????PreparedStatement?pstmt?=?null;
????????//表示操作數據返回受影響的行數
????????int???????????????num???=?0;
????????
???????//*??處理SQL執行SQL??*/
????????try?{
????????	//?得到數據庫連接
????????????conn?=?getConn（）;??????????????????????????????
????????????//?得到PreparedStatement對象
????????????pstmt?=?conn.prepareStatement（p

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

?????文件??????10917??2007-10-25?14:32??database\company.sql

?????文件????1835008??2009-05-27?10:41??database\company_Data.MDF

?????文件????1048576??2009-05-27?10:41??database\company_Log.LDF

?????文件????????490??2009-05-16?18:05??company\.classpath

?????文件????????294??2009-05-22?12:07??company\.mymetadata

?????文件???????1413??2009-05-16?18:05??company\.project

?????文件????????500??2009-05-16?18:05??company\.settings\.jsdtscope

?????文件????????168??2009-05-16?18:05??company\.settings\org.eclipse.core.resources.prefs

?????文件?????????49??2009-05-16?18:05??company\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2009-05-16?18:05??company\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1657??2009-05-20?14:16??company\accp.log

?????文件???????4044??2009-05-21?14:40??company\src\s2jsp\bysj\dao\baseDao.java

?????文件???????4237??2009-05-20?14:33??company\src\s2jsp\bysj\dao\MessageDao.java

?????文件???????7260??2009-05-20?14:33??company\src\s2jsp\bysj\dao\NewsDao.java

?????文件???????7813??2009-05-20?14:34??company\src\s2jsp\bysj\dao\ProductDao.java

?????文件???????2560??2009-05-20?14:34??company\src\s2jsp\bysj\dao\RevertDao.java

?????文件???????4595??2009-05-22?11:00??company\src\s2jsp\bysj\dao\UserDao.java

?????文件????????507??2009-05-20?14:26??company\src\s2jsp\bysj\entity\log4j.properties

?????文件???????1347??2009-05-16?18:05??company\src\s2jsp\bysj\entity\Message.java

?????文件????????992??2009-05-16?18:05??company\src\s2jsp\bysj\entity\News.java

?????文件???????1973??2009-05-16?18:05??company\src\s2jsp\bysj\entity\Product.java

?????文件???????1368??2009-05-16?18:05??company\src\s2jsp\bysj\entity\Revert.java

?????文件???????1423??2009-05-18?16:21??company\src\s2jsp\bysj\entity\Users.java

?????文件???????2417??2009-05-17?00:08??company\WebRoot\about.jsp

?????文件???????6745??2009-05-22?16:45??company\WebRoot\admin\addManager.jsp

?????文件???????3279??2009-05-22?13:45??company\WebRoot\admin\addNews.jsp

?????文件???????4566??2009-05-20?16:09??company\WebRoot\admin\addProduct.jsp

?????文件???????1744??2009-05-20?14:11??company\WebRoot\admin\adminLoginManage.jsp

?????文件????????211??2009-05-16?18:05??company\WebRoot\admin\adminOut.jsp

?????文件????????401??2009-05-16?18:05??company\WebRoot\admin\checkSession.jsp

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