資源簡介
本人的結課設計,包括數據庫文件和源代碼,主題為基于JSP的在線鮮花商場系統設計,系統實現了商城的基本功能,如分類展示商品信息、搜索商品信息、用戶注冊登錄、添加商品到購物車、提交訂單、個人中心查看訂單、留言板留言等,管理員登錄后臺后可以查看管理用戶信息、商品分類信息、商品信息、新聞信息、留言信息、訂單信息等。

代碼片段和文件信息
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?{
Class.forName(“com.mysql.jdbc.Driver“);
}?catch?(ClassNotFoundException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
public?static?Connection?getconn(){
Connection?conn=null;
?try?{
conn=DriverManager.getConnection(“jdbc:mysql://localhost:3306/db_flower_shop?useUnicode=true&characterEncoding=UTF-8““root“““);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
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?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;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????10051??2020-06-03?00:01??jsp+mysql實現的在線鮮花商城源碼\數據庫文件\db_flower_shop.sql
?????文件??????17486??2018-12-20?09:12??jsp+mysql實現的在線鮮花商城源碼\運行截圖\0.png
?????文件?????566183??2018-12-19?16:38??jsp+mysql實現的在線鮮花商城源碼\運行截圖\1.png
?????文件??????81148??2018-12-19?16:42??jsp+mysql實現的在線鮮花商城源碼\運行截圖\10.png
?????文件?????173595??2018-12-19?16:42??jsp+mysql實現的在線鮮花商城源碼\運行截圖\11.png
?????文件??????50013??2018-12-19?16:43??jsp+mysql實現的在線鮮花商城源碼\運行截圖\12.png
?????文件??????49778??2018-12-19?16:43??jsp+mysql實現的在線鮮花商城源碼\運行截圖\13.png
?????文件?????163962??2018-12-19?16:43??jsp+mysql實現的在線鮮花商城源碼\運行截圖\14.png
?????文件??????61206??2018-12-19?16:43??jsp+mysql實現的在線鮮花商城源碼\運行截圖\15.png
?????文件??????66039??2018-12-19?16:43??jsp+mysql實現的在線鮮花商城源碼\運行截圖\16.png
?????文件??????49743??2018-12-19?16:38??jsp+mysql實現的在線鮮花商城源碼\運行截圖\2.png
?????文件??????60181??2018-12-19?16:38??jsp+mysql實現的在線鮮花商城源碼\運行截圖\3.png
?????文件?????314989??2018-12-19?16:40??jsp+mysql實現的在線鮮花商城源碼\運行截圖\4.png
?????文件?????153810??2018-12-19?16:40??jsp+mysql實現的在線鮮花商城源碼\運行截圖\5.png
?????文件?????154798??2018-12-19?16:40??jsp+mysql實現的在線鮮花商城源碼\運行截圖\6.png
?????文件?????197584??2018-12-19?16:41??jsp+mysql實現的在線鮮花商城源碼\運行截圖\7.png
?????文件??????81047??2018-12-19?16:41??jsp+mysql實現的在線鮮花商城源碼\運行截圖\8.png
?????文件??????51309??2018-12-19?16:42??jsp+mysql實現的在線鮮花商城源碼\運行截圖\9.png
?????文件????????482??2018-12-26?20:04??jsp+mysql實現的在線鮮花商城源碼\運行環境.txt
?????文件????????842??2018-12-19?09:08??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.classpath
?????文件???????1043??2018-12-19?09:08??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.project
?????文件????????503??2018-12-19?09:08??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.settings\.jsdtscope
?????文件????????224??2018-12-19?16:00??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.settings\org.eclipse.core.resources.prefs
?????文件????????364??2018-12-19?09:08??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.settings\org.eclipse.jdt.core.prefs
?????文件????????482??2018-12-19?09:08??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.settings\org.eclipse.wst.common.component
?????文件????????345??2018-12-19?09:08??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2018-12-19?09:08??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2018-12-19?09:08??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????2288??2018-12-19?09:12??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\build\classes\com\hr\dao\ba
?????文件???????7360??2018-12-19?09:10??jsp+mysql實現的在線鮮花商城源碼\項目源碼\FlowerShop\build\classes\com\hr\dao\EASYBUY_COMMENTDao.class
............此處省略372個文件信息
評論
共有 條評論