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?{
	
	public?Connection?getCon（）?{
		Connection?con?=?null;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			con?=?DriverManager.getConnection（
					“jdbc:mysql://localhost:3306/hib?characterEncoding=UTF-8“?“root“
					“123456“）;

		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?con;

	}
	
	
	public?void?closeAll（PreparedStatement?psConnection?conResultSet?rs）
	{
		
		if（rs!=null）
		{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if（ps!=null）
		{
			try?{
				ps.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		if（con!=null）
		{
			try?{
				con.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
	}
	public?int?exceuteUpdate（String?preparedSql?object[]?param）?{
		PreparedStatement?pstmt?=?null;
		int?num?=?0;
		Connection?conn?=??getCon（）;?
		try?{
			pstmt?=?conn.prepareStatement（preparedSql）;
			if?（param?!=?null）?{
				for?（int?i?=?0;?i?					pstmt.setobject（i?+?1?param[i]）;?//???????sql???ò???
				}
			}
			num?=?pstmt.executeUpdate（）;?
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}?finally{
			closeAll（pstmt?conn?null）;
		}
		return?num;
	}

}

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

?????文件???????1123??2017-09-01?15:07??購物車\.classpath

?????文件????????288??2012-07-13?09:12??購物車\.mymetadata

?????文件???????1750??2017-09-01?15:08??購物車\.project

?????文件????????522??2016-09-05?11:02??購物車\.settings\.jsdtscope

?????文件?????????83??2018-08-28?17:15??購物車\.settings\com.genuitec.eclipse.core.prefs

?????文件???????1009??2017-09-01?15:08??購物車\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件????????382??2016-09-05?11:02??購物車\.settings\com.genuitec.eclipse.migration.prefs

?????文件????????103??2018-02-26?19:45??購物車\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2016-09-05?11:02??購物車\.settings\org.eclipse.jdt.core.prefs

?????文件????????547??2017-09-01?15:08??購物車\.settings\org.eclipse.wst.common.component

?????文件????????413??2016-09-05?11:02??購物車\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-09-05?11:02??購物車\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-09-05?11:02??購物車\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1623??2018-08-28?11:14??購物車\src\com\dao\baseDao.java

?????文件????????105??2016-09-05?15:56??購物車\src\com\dao\GoodDao.java

?????文件???????1463??2018-08-28?15:57??購物車\src\com\dao\GoodDaoImpl.java

?????文件????????484??2018-08-28?11:10??購物車\src\com\entity\Good.java

?????文件????????598??2018-08-29?09:44??購物車\src\com\entity\GoodItem.java

?????文件???????2116??2018-08-29?09:45??購物車\src\com\servlet\AddBookToCarServlet.java

?????文件???????1482??2018-08-29?10:16??購物車\src\com\servlet\DeleteBookServlet.java

?????文件???????1177??2018-08-29?10:09??購物車\src\com\servlet\ListAjaxServlet.java

?????文件????????873??2017-09-04?16:43??購物車\src\com\servlet\ListServlet.java

?????文件???????1180??2017-11-13?11:10??購物車\src\com\servlet\UpdateNum.java

?????文件???????1562??2018-08-29?09:33??購物車\src\com\servlet\UpdateNumAjaxServlet.java

?????文件????????857??2016-09-12?09:38??購物車\WebRoot\index.jsp

?????文件??????93637??2016-09-13?14:31??購物車\WebRoot\js\jquery-1.8.3.min.js

?????文件???????1871??2018-08-29?09:14??購物車\WebRoot\list.jsp

?????文件?????????39??2012-07-10?09:17??購物車\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1995??2012-07-10?10:08??購物車\WebRoot\order.html

?????文件???????1916??2017-11-14?15:23??購物車\WebRoot\showcar.jsp

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