package?dao;

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

public?class?baseDao?{

	static?final?String?DRIVER?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	static?final?String?URL?=?“jdbc:sqlserver://localhost:1433;databaseName=ebook“;
	static?final?String?USER?=?“sa“;
	static?final?String?PWD?=?““;

	public?static?Connection?getConn（）?{
		Connection?conn?=?null;
		try?{
			Class.forName（DRIVER）;

			conn?=?DriverManager.getConnection（URL?USER?PWD）;

		}?catch?（Exception?e）?{

			e.printStackTrace（）;
		}
		return?conn;
	}

	public?static?void?closeAll（Connection?conn?PreparedStatement?ps
			ResultSet?rs）?{

		try?{
			if?（rs?!=?null）?{
				rs.close（）;
			}
			if?（ps?!=?null）?{
				ps.close（）;
			}
			if?（conn?!=?null）?{
				conn.close（）;
			}

		}?catch?（SQLException?e）?{

			e.printStackTrace（）;
		}

	}
}

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

?????文件???????1286??2012-08-14?20:59??bookfenye\bookfenye.html

?????文件????????410??2012-08-14?19:16??bookfenye\ebook\.classpath

?????文件????????288??2012-08-14?19:12??bookfenye\ebook\.mymetadata

?????文件???????1223??2012-08-14?20:23??bookfenye\ebook\.project

?????文件????????330??2012-08-14?19:39??bookfenye\ebook\.settings\org.eclipse.jdt.core.prefs

?????文件????????985??2012-08-14?19:31??bookfenye\ebook\src\dao\baseDao.java

?????文件????????964??2012-08-14?19:46??bookfenye\ebook\src\entity\BookInfo.java

?????文件???????1260??2012-08-14?20:49??bookfenye\ebook\src\entity\Page.java

?????文件???????2382??2012-08-14?20:31??bookfenye\ebook\src\operator\Operator.java

?????文件???????2461??2012-08-14?20:53??bookfenye\ebook\WebRoot\index.jsp

?????文件?????????39??2012-08-14?19:12??bookfenye\ebook\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1470??2012-08-14?19:39??bookfenye\ebook\WebRoot\WEB-INF\classes\dao\baseDao.class

?????文件???????1331??2012-08-14?19:46??bookfenye\ebook\WebRoot\WEB-INF\classes\entity\BookInfo.class

?????文件???????1707??2012-08-14?20:49??bookfenye\ebook\WebRoot\WEB-INF\classes\entity\Page.class

?????文件???????3129??2012-08-14?20:31??bookfenye\ebook\WebRoot\WEB-INF\classes\operator\Operator.class

?????文件?????583286??2012-08-14?19:16??bookfenye\ebook\WebRoot\WEB-INF\lib\sqljdbc.jar

?????文件????????375??2012-08-14?19:12??bookfenye\ebook\WebRoot\WEB-INF\web.xml

?????文件????3145728??2012-08-14?21:00??bookfenye\ebook.mdf

?????文件????1048576??2012-08-14?21:00??bookfenye\ebook_log.ldf

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\WebRoot\WEB-INF\classes\dao

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\WebRoot\WEB-INF\classes\entity

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\WebRoot\WEB-INF\classes\operator

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\WebRoot\WEB-INF\classes

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\WebRoot\WEB-INF\lib

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\src\dao

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\src\entity

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\src\operator

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\WebRoot\meta-INF

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\WebRoot\WEB-INF

?????目錄??????????0??2012-11-26?18:05??bookfenye\ebook\.myeclipse

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