package?com.dao;

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

/**
?*?baseDao類
?*?@author?Administrator
?*
?*/
public?class?baseDao?{
	private?static?final?String?DRIVER?=?“oracle.jdbc.driver.OracleDriver“;
	private?static?final?String?URL?=?“jdbc:oracle:thin:@127.0.0.1:1521:orcl“;
	private?static?final?String?UNAME?=?“accp“;
	private?static?final?String?UPASS?=?“accp“;
	/**
	?*?靜態塊加載驅動ing
	?*/
	static{
		try?{
			Class.forName（DRIVER）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	/**
	?*?獲得連接
	?*?@return
	?*/
	public?Connection?getConnection（）{
		Connection?conn?=?null;
		try?{
			conn?=?DriverManager.getConnection（URLUNAMEUPASS）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?conn;
	}
	/**
	?*?釋放資源--closeAll方法
	?*?@param?conn
	?*?@param?prep
	?*?@param?rs
	?*/
	public?void?closeAll（Connection?conn?PreparedStatement?prep?ResultSet?rs）{
		
		if（rs?!=?null）{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		
		if（prep?!=?null）{
			try?{
				prep.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		
		if（conn?!=?null）{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
	}
}

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

?????文件???????2488??2013-11-18?10:02??JSP模糊查詢\132456.sql

?????文件????????273??2013-11-18?10:55??JSP模糊查詢\789.sql

?????文件????????434??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\.classpath

?????文件????????300??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\.mymetadata

?????文件???????1415??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\.project

?????文件????????500??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\.settings\.jsdtscope

?????文件????????330??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1638??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\src\com\dao\baseDao.java

?????文件???????4574??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\src\com\dao\BookQueryDao.java

?????文件???????1604??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\src\com\entity\BookQuery.java

?????文件???????1027??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\src\com\servlet\BookInfoServlet.java

?????文件???????1375??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\src\com\servlet\ListServlet.java

?????文件???????1166??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\bookInfo.jsp

?????文件???????2819??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\index.jsp

?????文件?????????36??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1655??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com\dao\baseDao.class

?????文件???????3463??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com\dao\BookQueryDao.class

?????文件???????2005??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com\entity\BookQuery.class

?????文件???????1771??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com\servlet\BookInfoServlet.class

?????文件???????1949??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com\servlet\ListServlet.class

?????文件????1417089??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\lib\classes12.jar

?????文件????????925??2013-11-18?10:55??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2014-02-22?23:34??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com\dao

?????目錄??????????0??2014-02-22?23:34??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com\entity

?????目錄??????????0??2014-02-22?23:34??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com\servlet

?????目錄??????????0??2014-02-22?23:34??JSP模糊查詢\BOOKQUERY\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2014-02-22?23:34??JSP模糊查詢\BOOKQUERY\src\com\dao

?????目錄??????????0??2014-02-22?23:34??JSP模糊查詢\BOOKQUERY\src\com\entity

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