package?com.yimaiwang.Dao;

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

public?class?baseDao?{

	private?String?driver?=?“com.mysql.jdbc.Driver“;
	private?String?url?=?“jdbc:mysql://localhost:3306/yimaiwang“;
	private?String?name?=?“root“;
	private?String?pwd?=?“123“;
	
	protected?Connection?con;
	protected?PreparedStatement?ps;
	protected?ResultSet?rs;
	
	/**
	?*?加載驅動
	?*/
	public?baseDao（）?{
		try?{
			Class.forName（driver）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?獲得鏈接對象
	?*?@return
	?*/
	public?Connection?getConnection（）{
		try?{
			if（con?==?null?||?con.isClosed（））{
				con?=?DriverManager.getConnection（url?name?pwd）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?con;
	}
	
	/**
	?*?關閉連接
	?*?@param?con
	?*?@param?ps
	?*?@param?rs
	?*/
	public?void?closeAll（Connection?conPreparedStatement?psResultSet?rs）{
		if（rs?!=?null）{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if（ps?!=?null）{
			try?{
				ps.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if（con?!=?null）{
			try?{
				con.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
	
	/**
	?*?通用增刪改
	?*?@param?sql
	?*?@param?obj
	?*?@return
	?*/
	public?int?Update（String?sqlobject[]?obj）{
		int?num?=?-1;//更新失敗
		con?=?getConnection（）;
		try?{
			ps?=?con.prepareStatement（sql）;
			if（obj?!=?null）{
				for?（int?i?=?0;?i?					ps.setobject（i+1?obj[i]）;
				}
			}
			num?=?ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			closeAll（con?ps?null）;
		}
		return?num;
	}
	
	/**
	?*?通用查詢
	?*?@param?sql
	?*?@param?obj
	?*?@return
	?*/
	public?ResultSet?Query（String?sqlobject[]?obj）{
		con?=?getConnection（）;
		try?{
			ps?=?con.prepareStatement（sql）;
			if（obj?!=?null）{
				for?（int?i?=?0;?i?					ps.setobject（i+1?obj[i]）;
				}
			}
			rs?=?ps.executeQuery（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?rs;
	}
}

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

?????文件???????1093??2018-04-27?15:41??易買網\JSP-YMW\.classpath

?????文件???????1332??2018-04-27?17:40??易買網\JSP-YMW\.project

?????文件????????522??2018-04-27?15:41??易買網\JSP-YMW\.settings\.jsdtscope

?????文件????????364??2018-04-27?15:41??易買網\JSP-YMW\.settings\org.eclipse.jdt.core.prefs

?????文件????????480??2018-04-27?15:41??易買網\JSP-YMW\.settings\org.eclipse.wst.common.component

?????文件????????414??2018-04-27?15:41??易買網\JSP-YMW\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-04-27?15:41??易買網\JSP-YMW\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-04-27?15:41??易買網\JSP-YMW\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2309??2018-04-27?17:26??易買網\JSP-YMW\src\com\yimaiwang\Dao\baseDao.java

?????文件???????4869??2018-05-08?19:58??易買網\JSP-YMW\src\com\yimaiwang\Dao\Impl\NewsDaoImpl.java

?????文件???????6360??2018-05-11?17:11??易買網\JSP-YMW\src\com\yimaiwang\Dao\Impl\OrderDaoImpl.java

?????文件????????841??2018-05-08?19:42??易買網\JSP-YMW\src\com\yimaiwang\Dao\Impl\Order_detailDaoImpl.java

?????文件???????9742??2018-05-09?19:24??易買網\JSP-YMW\src\com\yimaiwang\Dao\Impl\ProductDaoImpl.java

?????文件???????7013??2018-05-08?19:52??易買網\JSP-YMW\src\com\yimaiwang\Dao\Impl\Product_categoryDaoImpl.java

?????文件???????6411??2018-05-10?20:53??易買網\JSP-YMW\src\com\yimaiwang\Dao\Impl\UserDaoImpl.java

?????文件????????796??2018-05-08?19:58??易買網\JSP-YMW\src\com\yimaiwang\Dao\NewsDao.java

?????文件????????813??2018-05-11?17:04??易買網\JSP-YMW\src\com\yimaiwang\Dao\OrderDao.java

?????文件????????280??2018-05-08?19:38??易買網\JSP-YMW\src\com\yimaiwang\Dao\Order_detailDao.java

?????文件???????1234??2018-05-06?17:57??易買網\JSP-YMW\src\com\yimaiwang\Dao\ProductDao.java

?????文件???????1245??2018-05-03?22:33??易買網\JSP-YMW\src\com\yimaiwang\Dao\Product_categoryDao.java

?????文件????????904??2018-05-04?08:46??易買網\JSP-YMW\src\com\yimaiwang\Dao\UserDao.java

?????文件???????1668??2018-04-27?16:21??易買網\JSP-YMW\src\com\yimaiwang\Entity\Comment.java

?????文件???????1151??2018-04-27?16:45??易買網\JSP-YMW\src\com\yimaiwang\Entity\News.java

?????文件???????2716??2018-05-09?20:35??易買網\JSP-YMW\src\com\yimaiwang\Entity\Order.java

?????文件???????1294??2018-05-08?10:18??易買網\JSP-YMW\src\com\yimaiwang\Entity\Order_detail.java

?????文件???????2312??2018-04-27?17:11??易買網\JSP-YMW\src\com\yimaiwang\Entity\Page.java

?????文件???????1982??2018-05-03?09:25??易買網\JSP-YMW\src\com\yimaiwang\Entity\Product.java

?????文件???????1227??2018-04-27?17:12??易買網\JSP-YMW\src\com\yimaiwang\Entity\Product_category.java

?????文件????????617??2018-05-05?20:29??易買網\JSP-YMW\src\com\yimaiwang\Entity\ShopCar.java

?????文件???????2716??2018-04-27?17:20??易買網\JSP-YMW\src\com\yimaiwang\Entity\User.java

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