package?myPk;
import?java.sql.*;

public?class?Conn?{
	private?String?driverName=“sun.jdbc.odbc.JdbcOdbcDriver“;
	private?String?dbUrl=“jdbc:odbc:bookShop“;
	private?String?userName=““;
	private?String?userPwd=““;
	private?Connection?conn;
	private?Statement?st;
	private?Pageable?rs;
	
	//連接數(shù)據(jù)庫，執(zhí)行語句，返回得到的記錄項－－用于查詢
	public?void?init（String?sql）?throws?Exception
	{
		Class.forName（driverName）;
		conn=DriverManager.getConnection（dbUrl?userNameuserPwd）;
		st=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_UPDATABLE）;
		rs=new?PageableResultSet2（st.executeQuery（sql））;
	}
	
	//判斷記錄欺罔是否為空，若為空則調(diào)用函數(shù)　init（sql）
	public?Pageable?getRs（String?sql）?throws?Exception
	{
		if（rs==null）?
		{
			init（sql）;
		}
		return?rs;
	}
	
	//執(zhí)行?添加、更新、刪除，無返回
	public?void?exeUpd（String?sql）?throws?Exception
	{
		Class.forName（driverName）;
		conn=DriverManager.getConnection（dbUrluserNameuserPwd）;
		st=conn.createStatement（）;
		st.executeUpdate（sql）;
	}
	
	//關(guān)閉　查詢　連接
	public?void?closeRs（）?throws?Exception
	{
		rs.close（）;
		st.close（）;
		conn.close（）;
	}
	
	//關(guān)閉　添加、更新、刪除　連接
	public?void?closeNoRs（）?throws?Exception
	{
		st.close（）;
		conn.close（）;
	}
}

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

?????文件????????473??2007-01-14?11:01??fd\網(wǎng)上書店\bookShop\.classpath

?????文件????????853??2007-01-07?22:16??fd\網(wǎng)上書店\bookShop\.project

?????文件????????330??2007-01-07?22:16??fd\網(wǎng)上書店\bookShop\.settings\org.eclipse.jdt.core.prefs

?????文件????????217??2007-01-07?22:17??fd\網(wǎng)上書店\bookShop\.settings\org.eclipse.jst.common.project.facet.core.prefs

?????文件????????404??2007-01-07?22:17??fd\網(wǎng)上書店\bookShop\.settings\org.eclipse.wst.common.component

?????文件????????229??2007-01-07?22:17??fd\網(wǎng)上書店\bookShop\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件???????1976??2007-01-21?23:41??fd\網(wǎng)上書店\bookShop\build\classes\myPk\Conn.class

?????文件???????4350??2007-01-21?23:41??fd\網(wǎng)上書店\bookShop\build\classes\myPk\FileUploadBean.class

?????文件???????7705??2007-01-21?23:41??fd\網(wǎng)上書店\bookShop\build\classes\myPk\Md5.class

?????文件????????403??2007-01-21?23:41??fd\網(wǎng)上書店\bookShop\build\classes\myPk\Pageable.class

?????文件??????18053??2007-01-21?23:41??fd\網(wǎng)上書店\bookShop\build\classes\myPk\PageableResultSet2.class

?????文件???????1302??2007-01-18?14:10??fd\網(wǎng)上書店\bookShop\src\myPk\Conn.java

?????文件???????4703??2007-01-16?09:37??fd\網(wǎng)上書店\bookShop\src\myPk\FileUploadBean.java

?????文件??????14851??2007-01-13?11:12??fd\網(wǎng)上書店\bookShop\src\myPk\Md5.java

?????文件????????695??2007-01-07?22:19??fd\網(wǎng)上書店\bookShop\src\myPk\Pageable.java

?????文件??????18382??2007-01-07?22:20??fd\網(wǎng)上書店\bookShop\src\myPk\PageableResultSet2.java

?????文件???????7616??2007-01-20?01:33??fd\網(wǎng)上書店\bookShop\WebContent\admin-book-add.jsp

?????文件???????8043??2007-01-22?00:18??fd\網(wǎng)上書店\bookShop\WebContent\admin-book.jsp

?????文件???????1856??2007-01-21?22:21??fd\網(wǎng)上書店\bookShop\WebContent\admin-pwd.jsp

?????文件???????8968??2007-01-21?16:23??fd\網(wǎng)上書店\bookShop\WebContent\admin-user.jsp

?????文件???????4984??2007-01-21?23:55??fd\網(wǎng)上書店\bookShop\WebContent\blue.css

?????文件??????10920??2007-01-22?02:00??fd\網(wǎng)上書店\bookShop\WebContent\book-information.jsp

?????文件???????4739??2007-01-21?02:30??fd\網(wǎng)上書店\bookShop\WebContent\book-list.jsp

?????文件???????2087??2007-01-18?17:08??fd\網(wǎng)上書店\bookShop\WebContent\bottom.jsp

?????文件????????345??2007-01-15?22:19??fd\網(wǎng)上書店\bookShop\WebContent\clearSession.jsp

?????文件?????104166??2007-01-15?23:08??fd\網(wǎng)上書店\bookShop\WebContent\data\book.jpg

?????文件???????4096??2007-01-22?02:32??fd\網(wǎng)上書店\bookShop\WebContent\data\bookShop.ldb

?????文件?????626688??2007-01-22?02:27??fd\網(wǎng)上書店\bookShop\WebContent\data\bookShop.mdb

?????文件??????82406??2007-01-15?23:09??fd\網(wǎng)上書店\bookShop\WebContent\data\campaign.jpg

?????文件??????78682??2007-01-21?03:10??fd\網(wǎng)上書店\bookShop\WebContent\data\follow.jpg

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