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;
	
	//連接數據庫，執行語句，返回得到的記錄項－－用于查詢
	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））;
	}
	
	//判斷記錄欺罔是否為空，若為空則調用函數　init（sql）
	public?Pageable?getRs（String?sql）?throws?Exception
	{
		if（rs==null）?
		{
			init（sql）;
		}
		return?rs;
	}
	
	//執行?添加、更新、刪除，無返回
	public?void?exeUpd（String?sql）?throws?Exception
	{
		Class.forName（driverName）;
		conn=DriverManager.getConnection（dbUrluserNameuserPwd）;
		st=conn.createStatement（）;
		st.executeUpdate（sql）;
	}
	
	//關閉　查詢　連接
	public?void?closeRs（）?throws?Exception
	{
		rs.close（）;
		st.close（）;
		conn.close（）;
	}
	
	//關閉　添加、更新、刪除　連接
	public?void?closeNoRs（）?throws?Exception
	{
		st.close（）;
		conn.close（）;
	}
}

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

?????文件????????473??2013-12-20?14:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\.classpath

?????文件????????853??2013-12-20?13:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\.project

?????文件????????330??2013-12-20?11:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\.settings\org.eclipse.jdt.core.prefs

?????文件????????217??2013-12-20?11:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\.settings\org.eclipse.jst.common.project.facet.core.prefs

?????文件????????404??2013-12-20?11:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\.settings\org.eclipse.wst.common.component

?????文件????????229??2013-12-20?11:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件???????1976??2013-12-20?17:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\build\classes\myPk\Conn.class

?????文件???????4350??2013-12-20?11:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\build\classes\myPk\FileUploadBean.class

?????文件???????7705??2013-12-20?11:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\build\classes\myPk\Md5.class

?????文件????????403??2013-12-20?16:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\build\classes\myPk\Pageable.class

?????文件??????18053??2013-12-20?15:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\build\classes\myPk\PageableResultSet2.class

?????文件???????1302??2013-12-20?14:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\Conn.java

?????文件???????4703??2013-12-20?09:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\FileUploadBean.java

?????文件??????14853??2013-12-20?19:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\Md5.java

?????文件???????1786??2013-12-20?19:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\myPk\Conn.class

?????文件???????6559??2013-12-20?16:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\myPk\Md5.class

?????文件????????403??2013-12-20?19:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\myPk\Pageable.class

?????文件??????12877??2013-12-20?14:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\myPk\PageableResultSet2.class

?????文件????????695??2013-12-20?16:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\Pageable.java

?????文件??????18382??2013-12-20?12:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\src\myPk\PageableResultSet2.java

?????文件???????7616??2013-12-20?14:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\admin-book-add.jsp

?????文件???????8043??2013-12-20?15:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\admin-book.jsp

?????文件???????1856??2013-12-20?15:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\admin-pwd.jsp

?????文件???????8968??2013-12-20?15:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\admin-user.jsp

?????文件???????4984??2013-12-20?16:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\blue.css

?????文件??????10920??2013-12-20?15:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\book-information.jsp

?????文件???????4739??2013-12-20?19:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\book-list.jsp

?????文件???????2087??2013-12-20?16:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\bottom.jsp

?????文件????????345??2013-12-20?14:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\clearSession.jsp

?????文件?????104166??2013-12-20?12:01??基于jsp網上書店（源代碼+論文）\基于jsp網上書店（源代碼+論文）\bookShop\WebContent\data\book.jpg

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