package?org.dao;??
??
import?java.sql.Connection;??
import?java.sql.DriverManager;??
import?java.sql.PreparedStatement;??
import?java.sql.ResultSet;??
import?java.sql.SQLException;??
import?java.util.List;??
??
??

public?class?baseDao?{??
??
????private?static?Connection?con?=?null;??
????private?static?String?driver?=?“com.mysql.jdbc.Driver“;??
????private?static?String??url?=?“jdbc:mysql://localhost:3306/facedb“;??
????private?static?String?user?=?“root“;??
????private?static?String?pwd??=?“1234“;??
????private?static?PreparedStatement?ps?=?null;??
????private?static?ResultSet??rs?=?null;??
??????
????????
????/**?
?????*??
????*?@Description:?該方法的主要作用：打開連接，連接數據庫?
????*?@title:?getConnection?
????*?@param??@return?
????*?@param??@throws?ClassNotFoundException?
????*?@param??@throws?SQLException?設定文件???
????*?@return??返回類型：Connection????
????*?@throws?
?????*/??
????public?static?Connection?getConnection（）?throws?ClassNotFoundException?SQLException{??
????????Class.forName（driver）;??
????????if（con==null）{??
????????????con?=?DriverManager.getConnection（urluserpwd）;??
????????}??
????????return?con;??
????}??
????/**?
?????*??
????*?@Description:?該方法的主要作用：增刪改通用的方法?
????*?@title:?executeUpdate?
????*?@param??@param?sql?
????*?@param??@param?prams?
????*?@param??@return?
????*?@param??@throws?ClassNotFoundException?
????*?@param??@throws?SQLException?設定文件???
????*?@return??返回類型：int????
????*?@throws?
?????*/???

????public?static?int?executeUpdate（String?sqlListject>?prams）?throws?ClassNotFoundException?SQLException{??
????????int?rel?=?0;??
?????????????con??=?getConnection（）;??
??????????????ps?=?con.prepareStatement（sql）;??
????????if（prams!=null）{??
????????????for?（int?i?=?0;?i?????????????????ps.setobject（i+1?prams.get（i））;??
????????????}??
????????}??
??????????????rel??=?ps.executeUpdate（）;???
????????return?rel;??
????}??
??????
????/**?
?????*??
????*?@Description:?該方法的主要作用：查詢的通用方法?
????*?@title:?executeQuery?
????*?@param??@param?sql?
????*?@param??@param?prams?
????*?@param??@return?設定文件???
????*?@return??返回類型：ResultSet????
????*?@throws?
?????*/???
????public?static?ResultSet?executeQuery（String?sqlListject>prams）?throws?ClassNotFoundException?SQLException{??
????????con?=?getConnection（）;??
????????ps?=?con.prepareStatement（sql）;??
????????if（prams!=null）{??
????????????for?（int?i?=?0;?i?????????????????ps.setobject（i+1?prams.get（i））;??
????????????}??
????????}??
????????rs?=?ps.executeQuery（）;??
????????return?rs;??
????}??
??????
???
????public?static?void?closeConnnection（）{??
????//關閉之前先判斷是否為null
????????if（rs!=null）{??
????????????try?{??
????????????????rs.close（）;??
????????????}?catch?（SQLException?e）?{??
????????????????//?TODO?Auto-generated?catch?block??
????????????????e.printStackTrace（）;??
????????????}??
????????}??
????????if（ps!=null）{??
????????????try?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-05-08?21:44??test_face_photo\
?????文件????????1832??2018-05-09?22:58??test_face_photo\.classpath
?????文件????????1256??2018-05-08?10:39??test_face_photo\.project
?????目錄???????????0??2018-05-08?21:44??test_face_photo\.settings\
?????文件?????????503??2018-05-08?10:39??test_face_photo\.settings\.jsdtscope
?????文件?????????128??2018-05-08?10:39??test_face_photo\.settings\com.genuitec.eclipse.migration.prefs
?????文件?????????331??2018-05-09?16:06??test_face_photo\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2018-05-08?10:39??test_face_photo\.settings\org.eclipse.jdt.core.prefs
?????文件?????????497??2018-05-08?10:39??test_face_photo\.settings\org.eclipse.wst.common.component
?????文件?????????415??2018-05-08?10:39??test_face_photo\.settings\org.eclipse.wst.common.project.facet.core?-?副本.xml
?????文件?????????172??2018-05-08?10:39??test_face_photo\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml
?????文件?????????393??2018-05-08?10:39??test_face_photo\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-05-08?10:39??test_face_photo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-05-08?10:39??test_face_photo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-05-08?21:44??test_face_photo\WebContent\
?????目錄???????????0??2018-05-08?21:44??test_face_photo\WebContent\meta-INF\
?????文件??????????39??2018-05-08?10:39??test_face_photo\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-05-08?21:44??test_face_photo\WebContent\WEB-INF\
?????目錄???????????0??2018-05-09?14:19??test_face_photo\WebContent\WEB-INF\lib\
?????文件???????69400??2018-05-09?09:53??test_face_photo\WebContent\WEB-INF\lib\aip-java-sdk-4.3.0.jar
?????文件??????443432??2018-05-08?10:39??test_face_photo\WebContent\WEB-INF\lib\antlr-2.7.6.jar
?????文件??????268720??2018-05-08?10:39??test_face_photo\WebContent\WEB-INF\lib\fastjson-1.2.2-sources.jar
?????文件??????409289??2018-05-08?10:39??test_face_photo\WebContent\WEB-INF\lib\fastjson-1.2.2.jar
?????文件???????54495??2018-05-08?10:39??test_face_photo\WebContent\WEB-INF\lib\json-20160810.jar
?????文件??????148490??2018-05-08?10:39??test_face_photo\WebContent\WEB-INF\lib\json-lib-2.2.3-jdk15.jar
?????文件??????489883??2018-05-08?10:39??test_face_photo\WebContent\WEB-INF\lib\log4j-1.2.17.jar
?????文件??????789885??2018-05-07?20:55??test_face_photo\WebContent\WEB-INF\lib\mysql-connector-java-5.1.18-bin.jar
?????文件?????????731??2018-05-08?10:39??test_face_photo\WebContent\WEB-INF\web.xml
?????文件????????2258??2018-05-08?10:39??test_face_photo\WebContent\index.jsp
?????目錄???????????0??2018-05-09?23:01??test_face_photo\WebContent\js\
?????文件????????2202??2018-05-08?10:39??test_face_photo\WebContent\js\index.js
............此處省略40個文件信息