package?com.dao;

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

public?class?baseDao?{
	/*
	?*?與數(shù)據(jù)庫(kù)建立連接
	?*/
	public?static?Connection?getConnection（）{
		Connection?con=null;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			con=DriverManager.getConnection
					（“jdbc:mysql://localhost:3306/easybuy?characterEncoding=utf-8“?“root“?“123456“）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?con;
	}
	/*
	?*?增、刪、改、通用方法
	?*/
	public?int?executeUpdate（String?sqlobject[]?obj）{
		int?n=0;
		Connection?con?=this.getConnection（）;
		PreparedStatement?ps=null;
		try?{
			ps=con.prepareStatement（sql）;
			if（obj!=null）{
				for（int?i=0;i					//循環(huán)遍歷向占位符賦值
					ps.setobject（i+1?obj[i]）;
				}
			}
			n=ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			this.closeAll（con?ps?null）;
		}
		return?n;?
	}
	/*
	?*?查詢通用方法
	?*/
	public?ResultSet?executeQuery（String?sqlobject[]?obj）{
		Connection?con?=this.getConnection（）;
		PreparedStatement?ps=null;
		ResultSet?rs=null;
		try?{
			ps=con.prepareStatement（sql）;
			if（obj!=null）{
				for（int?i=0;i					//循環(huán)遍歷向占位符賦值
					ps.setobject（i+1?obj[i]）;
				}
			}
			rs=ps.executeQuery（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?rs;
	}
	/*
	?*?釋放資源（關(guān)閉所有對(duì)象）
	?*/
	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（）;
			}
		}
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-10-29?10:55??easybuy\
?????文件????????9068??2018-09-30?10:54??easybuy\easybuy.sql
?????目錄???????????0??2018-10-29?10:54??easybuy\jsp_easybuy\
?????文件????????1418??2018-09-03?14:03??easybuy\jsp_easybuy\.classpath
?????文件????????1336??2018-09-03?17:02??easybuy\jsp_easybuy\.project
?????目錄???????????0??2018-10-29?10:54??easybuy\jsp_easybuy\.settings\
?????文件?????????522??2018-09-03?14:01??easybuy\jsp_easybuy\.settings\.jsdtscope
?????文件?????????135??2018-09-03?16:27??easybuy\jsp_easybuy\.settings\com.genuitec.eclipse.core.prefs
?????文件?????????197??2018-09-12?16:50??easybuy\jsp_easybuy\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2018-09-03?14:01??easybuy\jsp_easybuy\.settings\org.eclipse.jdt.core.prefs
?????文件?????????492??2018-09-03?14:01??easybuy\jsp_easybuy\.settings\org.eclipse.wst.common.component
?????文件?????????414??2018-09-03?14:01??easybuy\jsp_easybuy\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-09-03?14:01??easybuy\jsp_easybuy\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-09-03?14:01??easybuy\jsp_easybuy\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-10-29?10:54??easybuy\jsp_easybuy\src\
?????目錄???????????0??2018-10-29?10:54??easybuy\jsp_easybuy\src\com\
?????目錄???????????0??2018-10-29?10:54??easybuy\jsp_easybuy\src\com\dao\
?????文件????????2117??2018-09-03?17:04??easybuy\jsp_easybuy\src\com\dao\baseDao.java
?????文件?????????302??2018-09-13?09:51??easybuy\jsp_easybuy\src\com\dao\DetailDao.java
?????文件?????????406??2018-09-11?09:17??easybuy\jsp_easybuy\src\com\dao\GoodCDao.java
?????文件????????1576??2018-09-14?09:29??easybuy\jsp_easybuy\src\com\dao\GoodDao.java
?????目錄???????????0??2018-10-29?10:54??easybuy\jsp_easybuy\src\com\dao\impl\
?????文件????????1698??2018-09-13?16:24??easybuy\jsp_easybuy\src\com\dao\impl\DetailDaoImpl.java
?????文件????????1415??2018-09-11?09:17??easybuy\jsp_easybuy\src\com\dao\impl\GoodCDaoImpl.java
?????文件???????11006??2018-09-14?10:58??easybuy\jsp_easybuy\src\com\dao\impl\GoodDaoImpl.java
?????文件????????2199??2018-09-12?15:19??easybuy\jsp_easybuy\src\com\dao\impl\OrderDaoImpl.java
?????文件????????2075??2018-09-08?16:27??easybuy\jsp_easybuy\src\com\dao\impl\RecDaoImpl.java
?????文件????????1574??2018-09-05?19:13??easybuy\jsp_easybuy\src\com\dao\impl\UserDaoImpl.java
?????文件?????????556??2018-09-12?15:14??easybuy\jsp_easybuy\src\com\dao\OrderDao.java
?????文件?????????407??2018-09-07?14:28??easybuy\jsp_easybuy\src\com\dao\ReceinfoDao.java
?????文件?????????259??2018-09-05?19:08??easybuy\jsp_easybuy\src\com\dao\UserDao.java
............此處省略214個(gè)文件信息