資源簡介
易買網前后臺素材+源碼請放心下載還有數據庫腳本,為期20天的項目。
代碼片段和文件信息
package?cn.buy.dao;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
public?class?baseDao?{
//?定義四個靜態常量,保存數據連接信息
private?static?final?String?driver?=?“com.mysql.jdbc.Driver“;
private?static?final?String?url?=?“jdbc:mysql:///Orange_buy“;
//private?static?final?String?url?=?“jdbc:mysql://192.168.19.72/Orange_buy“;
private?static?final?String?username?=?“root“;
private?static?final?String?pwd?=?“root“;
//?三個接口
private?Connection?con;
private?PreparedStatement?ps;
private?ResultSet?rs;
//?1.寫一個返回連接的方法
public?Connection?getConnection()?throws?Exception?{
Class.forName(driver);
if?(con?==?null?||?con.isClosed())?{
con?=?DriverManager.getConnection(url?username?pwd);
}
return?con;
}
//?2.修改操作
public?int?executeUpdate(String?sql?object...?object)?{
int?count?=?0;
try?{
getConnection();
ps?=?con.prepareStatement(sql);
for?(int?i?=?0;?i?ject.length;?i++)?{
ps.setobject(i?+?1?object[i]);
}
count?=?ps.executeUpdate();
}?catch?(Exception?e)?{
e.printStackTrace();
}
return?count;
}
//?3.查詢操作
public?ResultSet?executeQuery(String?sql?object...?object)?throws?Exception?{
getConnection();
ps?=?con.prepareStatement(sql);
for?(int?i?=?0;?i?ject.length;?i++)?{
ps.setobject(i?+?1?object[i]);
}
rs?=?ps.executeQuery();
return?rs;
}
//?4.寫一個回收資源的方法
public?void?closeResource()?{
try?{
if?(rs?!=?null)?{
rs.close();
}
if?(ps?!=?null)?{
ps.close();
}
if?(con?!=?null)?{
con.close();
}
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1753??2018-09-08?09:15??楊常帥組\Orange_buy?_95?(3)\.classpath
?????文件????????910??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\.project
?????文件????????567??2018-09-04?14:35??楊常帥組\Orange_buy?_95?(3)\.settings\.jsdtscope
?????文件????????193??2018-09-08?20:10??楊常帥組\Orange_buy?_95?(3)\.settings\org.eclipse.core.resources.prefs
?????文件????????364??2018-09-04?14:35??楊常帥組\Orange_buy?_95?(3)\.settings\org.eclipse.jdt.core.prefs
?????文件????????482??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\.settings\org.eclipse.wst.common.component
?????文件????????345??2018-09-04?14:35??楊常帥組\Orange_buy?_95?(3)\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2018-09-04?14:35??楊常帥組\Orange_buy?_95?(3)\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2018-09-04?14:35??楊常帥組\Orange_buy?_95?(3)\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????2348??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\ba
?????文件????????280??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\IcategoryDao.class
?????文件????????705??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\IcommentDao.class
?????文件????????743??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\IConditionDao.class
?????文件????????488??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\IintroductionDao.class
?????文件???????1687??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\impl\IcategoryDaoImpl.class
?????文件???????4213??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\impl\IcommentImpl.class
?????文件???????4025??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\impl\IConditiondaoImpl.class
?????文件???????3781??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\impl\IintrodutionImpl.class
?????文件???????6509??2018-09-09?09:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\impl\IoederdaoImpl.class
?????文件???????6444??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\impl\IProductDaoimpl.class
?????文件???????4210??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\impl\IsearchImpl.class
?????文件???????4917??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\impl\IUserDaoImpl.class
?????文件????????962??2018-09-09?09:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\IorderDao.class
?????文件????????656??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\IProductDao.class
?????文件????????730??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\IsearchDao.class
?????文件????????556??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\dao\IUserDao.class
?????文件????????978??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\entity\CartItems.class
?????文件???????2017??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\entity\Category.class
?????文件???????2778??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\entity\DtArea.class
?????文件???????1621??2018-09-09?08:56??楊常帥組\Orange_buy?_95?(3)\build\classes\cn\buy\entity\EasybuyComment.class
............此處省略1814個文件信息
- 上一篇:美賽模型代碼和注釋
- 下一篇:2776款emoji表情包素材 矢量免摳PNG.zip
評論
共有 條評論