package?com.hr.dao;

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


public?class?basedao?{
	static{
		try?{
			//注冊JDBC驅動器??JDBC驅動名
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	
	public?static?Connection?getconn（）{
		Connection?conn=null;
		?try?{
			?//數據庫URL
			conn=DriverManager.getConnection（“jdbc:mysql://localhost:3306/db_flower_shop?useUnicode=true&characterEncoding=UTF-8““root““123“）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			//?處理?JDBC?錯誤
			e.printStackTrace（）;
		}
		return?conn;
	}
	//?關閉資源的塊
	public?static?void?closeall（ResultSet?rsStatement?psConnection?conn）{
			try?{
				if（rs!=null）
				???rs.close（）;
				if（ps!=null）
					ps.close（）;
				if（conn!=null）
					conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		
	}
	
	public?static?int?exectuIUD（String?sqlobject[]?params）{
		int?count=0;
		??Connection?conn=basedao.getconn（）;
		??//PreparedStatement是預編譯的對于批量處理可以大大提高效率.?也叫JDBC存儲過程
		??PreparedStatement?ps=null;
		??try?{
			ps=conn.prepareStatement（sql）;
			if（params!=null）{
				for?（int?i?=?0;?i?					ps.setobject（i+1?params[i]）;
				}
			}
			count=ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		finally{
			basedao.closeall（null?ps?conn）;
		}
		return?count;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-08-04?11:51??1037java基于Web的花卉銷售商城\
?????目錄???????????0??2020-08-04?11:26??1037java基于Web的花卉銷售商城\FlowerShop\
?????文件?????????842??2020-02-24?18:24??1037java基于Web的花卉銷售商城\FlowerShop\.classpath
?????文件????????1043??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\.project
?????目錄???????????0??2020-08-04?11:26??1037java基于Web的花卉銷售商城\FlowerShop\.settings\
?????文件?????????503??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\.settings\.jsdtscope
?????文件?????????224??2018-12-19?16:00??1037java基于Web的花卉銷售商城\FlowerShop\.settings\org.eclipse.core.resources.prefs
?????文件?????????670??2020-02-24?18:25??1037java基于Web的花卉銷售商城\FlowerShop\.settings\org.eclipse.jdt.core.prefs
?????文件?????????106??2020-02-24?21:52??1037java基于Web的花卉銷售商城\FlowerShop\.settings\org.eclipse.ltk.core.refactoring.prefs
?????文件?????????482??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\.settings\org.eclipse.wst.common.component
?????文件?????????345??2020-02-24?18:24??1037java基于Web的花卉銷售商城\FlowerShop\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????87??2020-02-24?21:52??1037java基于Web的花卉銷售商城\FlowerShop\.settings\org.eclipse.wst.ws.service.policy.prefs
?????目錄???????????0??2020-08-04?11:26??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\
?????文件????????4760??2020-03-03?14:35??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\Dan.jsp
?????目錄???????????0??2020-08-04?11:26??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\meta-INF\
?????文件??????????39??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2020-08-04?11:26??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\WEB-INF\
?????目錄???????????0??2020-08-04?11:26??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\WEB-INF\lib\
?????文件?????1600198??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\WEB-INF\lib\classes12.jar
?????文件??????414240??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\WEB-INF\lib\jstl-1.2.jar
?????文件??????827942??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\WEB-INF\lib\mysql-connector-java-5.1.21.jar
?????文件??????143939??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\WEB-INF\lib\servlet-api.jar
?????文件???????13789??2018-12-19?09:08??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\WEB-INF\lib\smartupload.jar
?????文件???????15822??2018-12-19?09:09??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\WEB-INF\web.xml
?????文件????????1000??2020-03-03?14:27??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\chat-room.jsp
?????目錄???????????0??2020-08-04?11:26??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\css\
?????文件???????13529??2020-03-03?22:17??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\css\style.css
?????文件????????4997??2020-03-03?14:39??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\guestbook.jsp
?????目錄???????????0??2020-08-04?11:26??1037java基于Web的花卉銷售商城\FlowerShop\WebContent\images\
............此處省略227個文件信息