package?dao;
import?java.sql.*;
public?class?baseDao?{
	
	Connection?conn=null;
????PreparedStatement?pstmt?=?null;
????
	
	public?Connection?getconn（）?throws?ClassNotFoundException?SQLException{
		Class.forName（“com.mysql.jdbc.Driver“）;
		conn?=?DriverManager.getConnection（
		“jdbc:mysql://localhost:3306/shop?user=root&password=&useUnicode=true&characterEncoding=utf8“）;
		return?conn;
	}
	
	??public?void?closeAll（?Connection?conn?PreparedStatement?pstmt?ResultSet?rs?）?{
	????????if（rs?!=?null）{
	????????????try?{?rs.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
	????????}
	????????if（pstmt?!=?null）{
	????????????try?{?pstmt.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
	????????}
	????????if（conn?!=?null）{
	????????????try?{?conn.close（）;}?catch?（SQLException?e）?{e.printStackTrace（）;}
	????????}
	????}
	??
	??public?int?executeSQL（String?preparedSqlString[]?param）?{
	????????Connection????????conn??=?null;
	????????PreparedStatement?pstmt?=?null;
	????????int???????????????num???=?0;
	????????
	????????try?{
	????????????conn?=?getconn（）;??????????????????????????????
	????????????pstmt?=?conn.prepareStatement（preparedSql）;??
	????????????if（?param?!=?null?）?{
	????????????????for（?int?i?=?0;?i?	????????????????????pstmt.setString（i+1?param[i]）;????????
	????????????????}
	????????????}
	????????????num?=?pstmt.executeUpdate（）;???????????????????
	????????}?catch?（ClassNotFoundException?e）?{
	????????????e.printStackTrace（）;???????????????????????????
	????????}?catch?（SQLException?e）?{
	????????????e.printStackTrace（）;??????????????????????????
	????????}?finally?{
	????????????closeAll（connpstmtnull）;????????????????????
	????????}
	????????return?num;
	????}
	
	
}

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

?????文件????????551??2011-12-13?12:52??網上鞋店\shop\.classpath

?????文件????????285??2011-12-16?12:45??網上鞋店\shop\.mymetadata

?????文件???????1277??2011-12-15?20:02??網上鞋店\shop\.project

?????文件????????330??2011-12-12?17:32??網上鞋店\shop\.settings\org.eclipse.jdt.core.prefs

?????文件???????1805??2012-04-24?21:25??網上鞋店\shop\src\dao\baseDao.java

?????文件???????5765??2012-05-09?14:43??網上鞋店\shop\src\dao\GoodsDao.java

?????文件???????3803??2011-12-30?23:20??網上鞋店\shop\src\dao\OrderDao.java

?????文件???????2423??2012-05-10?11:22??網上鞋店\shop\src\dao\QuestionDao.java

?????文件???????5983??2012-05-10?09:32??網上鞋店\shop\src\dao\UserDao.java

?????文件????????426??2012-05-10?15:50??網上鞋店\shop\src\entity\Carts.java

?????文件???????1473??2011-12-19?12:50??網上鞋店\shop\src\entity\Goods.java

?????文件???????1250??2011-12-21?12:29??網上鞋店\shop\src\entity\Order.java

?????文件????????729??2012-03-01?14:32??網上鞋店\shop\src\entity\Question.java

?????文件???????1576??2012-05-10?09:26??網上鞋店\shop\src\entity\User.java

?????文件????????679??2012-05-09?14:54??網上鞋店\shop\src\service\GoodsService.java

?????文件????????482??2011-12-30?00:17??網上鞋店\shop\src\service\OrderService.java

?????文件????????455??2012-05-10?11:21??網上鞋店\shop\src\service\QuestionService.java

?????文件????????874??2012-05-10?09:29??網上鞋店\shop\src\service\UserService.java

?????文件???????3070??2012-05-09?14:57??網上鞋店\shop\src\web\addGoodsServlet.java

?????文件???????1645??2012-03-01?14:40??網上鞋店\shop\src\web\anwserServlet.java

?????文件???????2970??2012-05-10?11:03??網上鞋店\shop\src\web\applyMoneyServlet.java

?????文件???????1712??2012-03-01?14:14??網上鞋店\shop\src\web\bupdateServlet.java

?????文件???????2827??2012-05-10?16:07??網上鞋店\shop\src\web\CartServlet.java

?????文件???????2526??2012-03-01?14:14??網上鞋店\shop\src\web\checkoutServlet.java

?????文件???????3369??2012-05-10?11:31??網上鞋店\shop\src\web\CheckServlet.java

?????文件???????2276??2012-03-01?14:14??網上鞋店\shop\src\web\dataServlet.java

?????文件???????1524??2012-05-10?11:23??網上鞋店\shop\src\web\deAnswerServlet.java

?????文件???????1958??2012-05-10?15:54??網上鞋店\shop\src\web\deCartServlet.java

?????文件???????1509??2012-03-01?14:15??網上鞋店\shop\src\web\deleteServlet.java

?????文件???????1491??2012-03-01?14:15??網上鞋店\shop\src\web\deorder2Servlet.java

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