package?com.xaccp.dao;

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

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

public?class?baseDao?{
	protected?Connection?con?=?null;
	protected?PreparedStatement?ps?=?null;
	protected?ResultSet?rs?=?null;
	//打開連接
	protected?void?open（）{
		/*try?{
			Context?ctx?=?new?InitialContext（）;
			DataSource?ds?=?（DataSource）ctx.lookup（“java:comp/env/easybuy“）;
			con?=?ds.getConnection（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}*/
		try?{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;
		}?catch?（ClassNotFoundException?e）?{
			System.out.println（“加載驅動發生異常“）;
			e.printStackTrace（）;
		}	
		try?{
			//localhost:1521:orcl
			con=DriverManager.getConnection（“jdbc:oracle:thin:@192.168.0.49:1521:orcl““system““nicai“）;
		}?catch（SQLException?e）?{
			System.out.println（“連接發生異常“）;
			e.printStackTrace（）;
		}
	}
	//關閉連接
	protected?void?close（）{
		try?{
			if（rs?!=?null）{
				rs.close（）;
			}
			if（ps?!=?null）{
				ps.close（）;
			}
			if（con?!=?null）{
				con.close（）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
	}
}

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

?????文件????????673??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.classpath

?????文件????????319??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.mymetadata

?????文件???????1625??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.project

?????文件????????500??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.settings\.jsdtscope

?????文件???????1040??2012-07-23?12:40??finaly完整項目\DaoJie_EasyBuys\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????159??2012-07-14?12:23??finaly完整項目\DaoJie_EasyBuys\.settings\org.eclipse.core.resources.prefs

?????文件????????395??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.settings\org.eclipse.jdt.core.prefs

?????文件????????483??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.settings\org.eclipse.wst.common.component

?????文件????????252??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-08-12?20:44??finaly完整項目\DaoJie_EasyBuys\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1320??2010-07-26?11:18??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\baseDao.java

?????文件???????1093??2012-07-25?14:46??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\CategoryDao.java

?????文件????????534??2012-07-25?14:40??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\CommentDao.java

?????文件???????7109??2012-07-25?14:46??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\impl\CategoryDaoImpl.java

?????文件???????4012??2012-07-25?14:51??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\impl\CommentDaoImpl.java

?????文件???????3732??2012-07-25?14:48??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\impl\NewsDaoImpl.java

?????文件???????6623??2012-07-25?14:51??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\impl\OrderDaoImpl.java

?????文件???????2427??2012-07-25?14:49??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\impl\OrderDetailDaoImpl.java

?????文件???????6804??2012-07-25?16:50??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\impl\ProductDaoImpl.java

?????文件???????6834??2010-07-26?10:51??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\impl\UserInfoDaoImpl.java

?????文件????????483??2012-07-25?14:41??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\NewsDao.java

?????文件????????699??2012-07-25?14:42??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\OrderDao.java

?????文件????????390??2012-07-25?14:49??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\OrderDetailDao.java

?????文件????????722??2012-07-25?14:44??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\ProductDao.java

?????文件????????815??2010-07-26?10:47??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\dao\UserInfoDao.java

?????文件????????585??2012-07-22?09:40??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\entity\Category.java

?????文件???????1112??2012-07-14?11:12??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\entity\Comment.java

?????文件????????703??2012-07-14?11:10??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\entity\News.java

?????文件???????1318??2012-07-17?14:14??finaly完整項目\DaoJie_EasyBuys\src\com\xaccp\entity\Order.java

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