package?com.hp.books.dao;

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

import?javax.naming.Context;
import?javax.naming.InitialContext;
import?javax.naming.NamingException;
import?javax.sql.DataSource;


//基類：數據庫操作通用類
public?class?baseDao?{
	protected?Connection?conn;
	protected?PreparedStatement?ps;
	protected?Statement?stmt;
	protected?ResultSet?rs;

	//?獲取數據庫連接
	public?boolean?getConnection（）{

		try?{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;
			conn=DriverManager.getConnection（“jdbc:oracle:thin:@localhost:1521:oracl““scott““tiger“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?false;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			return?false;
		}
		return?true;
	}
	//?獲取數據庫連接
		public?Connection?getConnection2（）?{
			try?{
				//初始化上下文
				Context?cxt=new?InitialContext（）;
				//獲取與邏輯名相關聯的數據源對象
				DataSource?ds=（DataSource）cxt.lookup（“java:comp/env/jdbc/news“）;
				conn=ds.getConnection（）;
			}?catch?（NamingException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
			return?conn;
		}

	//?增刪改?
	public?int?executeUpdate（String?sql?object[]?params）?{
		int?updateRows?=?0;
		getConnection（）;
		try?{
			ps=conn.prepareStatement（sql）;
			//填充占位符
			for（int?i=0;i				ps.setobject（i+1?params[i]）;
			}
			updateRows=ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?updateRows;
	}

	//?查詢
	public?ResultSet?executeSQL（String?sqlobject[]?params）?{
		getConnection（）;
		try?{
			ps=conn.prepareStatement（sql）;
			//填充占位符
			for（int?i=0;i				ps.setobject（i+1?params[i]）;
			}
			rs=ps.executeQuery（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?rs;
	}

	//?關閉資源
	public?boolean?closeResource（）?{
		if（rs!=null）{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				return?false;
			}
		}
		if（ps!=null）{
			try?{
				ps.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				return?false;
			}
		}
		if（stmt!=null）{
			try?{
				stmt.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				return?false;
			}
		}
		if（conn!=null）{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				return?false;
			}
		}
		return?true;
	}

}

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

?????文件???????1221??2014-08-22?11:31??JBEshop\.classpath

?????文件???????1040??2014-08-22?11:04??JBEshop\.project

?????文件????????503??2014-08-22?11:04??JBEshop\.settings\.jsdtscope

?????文件????????364??2014-08-22?11:04??JBEshop\.settings\org.eclipse.jdt.core.prefs

?????文件????????473??2014-08-22?11:04??JBEshop\.settings\org.eclipse.wst.common.component

?????文件????????345??2014-08-22?11:04??JBEshop\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-08-22?11:04??JBEshop\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-08-22?11:04??JBEshop\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3175??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\dao\baseDao.class

?????文件????????499??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\dao\BooksDao.class

?????文件????????393??2014-08-27?20:24??JBEshop\build\classes\com\hp\books\dao\ItemsDao.class

?????文件????????442??2014-08-27?15:49??JBEshop\build\classes\com\hp\books\dao\OrdersDao.class

?????文件????????410??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\dao\UsersDao.class

?????文件???????5050??2014-08-26?19:27??JBEshop\build\classes\com\hp\books\impl\BooksDaoImpl.class

?????文件???????4127??2014-08-27?20:27??JBEshop\build\classes\com\hp\books\impl\ItemDaoImpl.class

?????文件???????3164??2014-08-27?16:59??JBEshop\build\classes\com\hp\books\impl\OrdersDaoImpl.class

?????文件???????2756??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\impl\UsersDaoImpl.class

?????文件????????511??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\service\BooksService.class

?????文件???????1667??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\service\BooksServiceImpl.class

?????文件????????405??2014-08-27?20:28??JBEshop\build\classes\com\hp\books\service\ItemsService.class

?????文件???????1506??2014-08-27?20:29??JBEshop\build\classes\com\hp\books\service\ItemsServiceImpl.class

?????文件????????454??2014-08-27?15:50??JBEshop\build\classes\com\hp\books\service\OrdersService.class

?????文件???????1567??2014-08-27?15:51??JBEshop\build\classes\com\hp\books\service\OrdersServiceImpl.class

?????文件????????422??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\service\UsersService.class

?????文件???????1426??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\service\UsersServiceImpl.class

?????文件???????1521??2014-08-26?19:42??JBEshop\build\classes\com\hp\books\util\Book.class

?????文件???????1331??2014-08-25?20:32??JBEshop\build\classes\com\hp\books\util\ConfigManager.class

?????文件????????173??2014-08-20?10:44??JBEshop\build\classes\com\hp\books\util\database.properties

?????文件???????2060??2014-08-27?19:53??JBEshop\build\classes\com\hp\books\util\Item.class

?????文件????????762??2014-08-27?10:10??JBEshop\build\classes\com\hp\books\util\Order.class

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