資源簡介
易買網(wǎng)購物網(wǎng)站的開發(fā)是北大青鳥課程學(xué)期的階段項(xiàng)目,所開發(fā)的是一個(gè)類似于淘寶網(wǎng)的購物網(wǎng)站,根據(jù)不同的購買需求進(jìn)入相應(yīng)的頁面。可以進(jìn)行搜索,并顯示最近瀏覽過的商品。
北大青鳥課程研發(fā)組在S2的課程中加入了易買網(wǎng)這個(gè)購物網(wǎng)站的開發(fā)項(xiàng)目,從某種程度上說明了北大青鳥的學(xué)生在學(xué)完第二學(xué)期之后就可以獨(dú)立開發(fā)出像與淘寶類似的購物網(wǎng)站。
IT技術(shù)最重要的就是時(shí)間,北大青鳥課程中貫穿的經(jīng)典的項(xiàng)目案例,幫助學(xué)生獲得最大限度的成長。

代碼片段和文件信息
package?cn.easybuy.dao;
import?java.sql.*;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;
import?org.apache.log4j.Logger;
import?cn.easybuy.entity.ProductCategory;
import?cn.easybuy.utils.EmptyUtils;
import?cn.easybuy.utils.Params;
/**
?*?基礎(chǔ)dao的實(shí)現(xiàn)類,實(shí)現(xiàn)最基本的增刪查改的方法
?*/
public?abstract??class?baseDaoImpl?implements?IbaseDao?{
protected?Connection?connection;
protected?PreparedStatement?pstm;
static?Logger?logger=Logger.getLogger(baseDaoImpl.class);
public?baseDaoImpl(Connection?connection)?{
this.connection?=?connection;
}
public?ResultSet?executeQuery(String?sqlobject[]?params){
ResultSet?rs=null;
try?{
pstm?=?connection.prepareStatement(sql);
for(int?i?=?0;?i? pstm.setobject(i+1?params[i]);
}
rs?=?pstm.executeQuery();
}?catch?(Exception?e)?{
e.printStackTrace();
}
return?rs;
}
//增刪改操作?delete?from?news_detail?where?id=??and?title=?
public?int?executeUpdate(String?sqlobject[]?params){
int?updateRows?=?0;
try?{
pstm?=?connection.prepareStatement(sql);
for(int?i?=?0;?i? pstm.setobject(i+1?params[i]);
}
updateRows?=?pstm.executeUpdate();
}?catch?(Exception?e)?{
e.printStackTrace();
updateRows?=?-1;
}
return?updateRows;
}
public?int?executeInsert(String?sqlobject[]?params){
Long?id?=?0L;
try?{
pstm?=?connection.prepareStatement(sqlStatement.RETURN_GENERATED_KEYS);
for(int?i?=?0;?i? pstm.setobject(i+1?params[i]);
}
pstm.executeUpdate();
ResultSet?rs?=?pstm.getGeneratedKeys();?
if?(rs.next())?{?
id?=?rs.getLong(1);
System.out.println(“數(shù)據(jù)主鍵:“?+?id);?
}?
}?catch?(Exception?e)?{
e.printStackTrace();
id?=null;
}
return?id.intValue();
}
//釋放資源
public?boolean?closeResource(){
if(pstm?!=?null){
try?{
pstm.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
return?false;
}
}
return?true;
}
public?boolean?closeResource(ResultSet?reSet){
if(reSet?!=?null){
try?{
reSet.close();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
return?false;
}
}
return?true;
}
/**
?*?需要重寫的方法
?*
?*?@param?rs
?*?@return
?*?@throws?Exception
?*/
public?abstract?object?tableToClass(ResultSet?rs)?throws?Exception;
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-11?16:24??EasyBuy\
?????文件????????1209??2017-06-10?09:36??EasyBuy\.classpath
?????目錄???????????0??2017-06-11?16:24??EasyBuy\.idea\
?????文件???????????7??2016-05-31?19:16??EasyBuy\.idea\.name
?????目錄???????????0??2017-06-11?16:24??EasyBuy\.idea\artifacts\
?????文件?????????327??2016-10-21?17:47??EasyBuy\.idea\artifacts\EasyBuy.xm
?????文件?????????709??2016-05-31?19:16??EasyBuy\.idea\compiler.xm
?????目錄???????????0??2017-06-11?16:24??EasyBuy\.idea\copyright\
?????文件??????????76??2016-05-31?19:16??EasyBuy\.idea\copyright\profiles_settings.xm
?????文件?????????164??2016-05-31?19:16??EasyBuy\.idea\encodings.xm
?????目錄???????????0??2017-06-11?16:24??EasyBuy\.idea\libraries\
?????文件?????????298??2016-05-31?19:54??EasyBuy\.idea\libraries\lib.xm
?????文件?????????463??2016-05-31?19:35??EasyBuy\.idea\misc.xm
?????文件?????????254??2016-05-31?19:16??EasyBuy\.idea\modules.xm
?????目錄???????????0??2017-06-11?16:24??EasyBuy\.idea\scopes\
?????文件?????????143??2016-05-31?19:16??EasyBuy\.idea\scopes\scope_settings.xm
?????文件????????8792??2016-05-31?20:02??EasyBuy\.idea\uiDesigner.xm
?????文件?????????164??2016-05-31?19:16??EasyBuy\.idea\vcs.xm
?????文件???????58076??2016-10-24?11:47??EasyBuy\.idea\workspace.xm
?????目錄???????????0??2017-09-22?10:42??EasyBuy\.myeclipse\
?????文件?????????294??2017-06-09?12:50??EasyBuy\.myme
?????文件????????1750??2016-05-31?09:04??EasyBuy\.project
?????目錄???????????0??2017-06-11?16:24??EasyBuy\.settings\
?????文件?????????500??2016-05-31?09:01??EasyBuy\.settings\.jsdtscope
?????文件?????????189??2017-07-10?15:14??EasyBuy\.settings\com.genuitec.eclipse.core.prefs
?????文件?????????247??2017-06-09?12:25??EasyBuy\.settings\com.genuitec.eclipse.migration.prefs
?????文件??????????57??2016-10-21?17:50??EasyBuy\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2016-05-31?09:01??EasyBuy\.settings\org.eclipse.jdt.core.prefs
?????文件?????????627??2017-06-09?12:25??EasyBuy\.settings\org.eclipse.wst.common.component
?????文件?????????361??2017-06-09?12:25??EasyBuy\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2016-05-31?09:01??EasyBuy\.settings\org.eclipse.wst.jsdt.ui.superType.container
............此處省略697個(gè)文件信息
評論
共有 條評論