資源簡介
本資源運用Javaweb實現了網上家具商城的功能,能全方位的展現出網上商城的商品展出,收藏,加入購物車,購買,付款

代碼片段和文件信息
?package?com.yjjj.dao;
import?java.sql.*;
import?java.util.*;
import?com.yjjj.domain.AfficheForm;
import?com.yjjj.tool.JDBConnection;
//對公告信息的操作
public?class?AfficheDao?{
??private?Connection?connection?=?null;?//定義連接的對象
??private?PreparedStatement?ps?=?null;?//定義預準備的對象
??private?JDBConnection?jdbc?=?null;?//定義數據庫連接對象
??public?AfficheDao()?{
????jdbc?=?new?JDBConnection();
????connection?=?jdbc.connection;?//利用構造方法取得數據庫連接
??}
??//刪除的方法
??public?void?deleteAffiche(Integer?id)?{
????try?{
??????ps?=?connection.prepareStatement(“delete?from?tb_affiche?where?id=?“);
??????ps.setInt(1?id.intValue());
??????ps.executeUpdate();
??????ps.close();
????}
????catch?(SQLException?ex)?{
????}
??}
??//修改的方法
??public?void?updateAffiche(AfficheForm?form)?{
????try?{
??????ps?=?connection.prepareStatement(“update?tb_affiche?set?name=?content=??where?id=?“);
??????ps.setString(1?form.getName());
??????ps.setString(2?form.getContent());
??????ps.setInt(3?form.getId().intValue());
??????ps.executeUpdate();
??????ps.close();
????}
????catch?(SQLException?ex)?{
????}
??}
//添加的方法
??public?void?insertAffiche(AfficheForm?form)?{
????try?{
??????ps?=?connection.prepareStatement(“insert?into?tb_affiche?values?(??getDate())“);
??????ps.setString(1?form.getName());
??????ps.setString(2?form.getContent());
??????ps.executeUpdate();
??????ps.close();
????}
????catch?(SQLException?ex)?{
????}
??}
//以數據庫流水號為條件查詢信息
??public?AfficheForm?selectOneAffiche(Integer?id)?{
????AfficheForm?affiche?=?null;
????try?{
??????ps?=?connection.prepareStatement(“select?*?from?tb_affiche?where?id=?“);
??????ps.setInt(1?id.intValue());
??????ResultSet?rs?=?ps.executeQuery();
??????while?(rs.next())?{
????????affiche?=?new?AfficheForm();
????????affiche.setId(Integer.valueOf(rs.getString(1)));
????????affiche.setName(rs.getString(2));
????????affiche.setContent(rs.getString(3));
????????affiche.setIssueTime(rs.getString(4));
??????}
????}
????catch?(SQLException?ex)?{
????}
????return?affiche;
??}
//全部查詢的方法
??public?List?selectAffiche()?{
????List?list?=?new?ArrayList();
????AfficheForm?affiche?=?null;
????try?{
??????ps?=?connection.prepareStatement(“select?*?from?tb_affiche?order?by?id?DESC“);
??????ResultSet?rs?=?ps.executeQuery();
??????while?(rs.next())?{
????????affiche?=?new?AfficheForm();
????????affiche.setId(Integer.valueOf(rs.getString(1)));
????????affiche.setName(rs.getString(2));
????????affiche.setContent(rs.getString(3));
????????affiche.setIssueTime(rs.getString(4));
????????list.add(affiche);
??????}
????}
????catch?(SQLException?ex)?{
????}
????return?list;
??}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-12-24?18:28??B2CFurniture\
?????文件????????1125??2019-12-24?21:22??B2CFurniture\.classpath
?????目錄???????????0??2014-03-22?12:34??B2CFurniture\.myeclipse\
?????目錄???????????0??2019-12-24?18:28??B2CFurniture\.myeclipse\profiler\
?????文件?????????960??2014-03-22?12:34??B2CFurniture\.myeclipse\profiler\B2CFurniture?on?MyEclipse?Tomcat.xm
?????文件?????????906??2014-03-22?12:34??B2CFurniture\.myeclipse\profiler\SQLServerDriver.xm
?????文件????????7462??2014-03-22?12:34??B2CFurniture\.myeclipse\profiler\snapshot-1334060693242.nps
?????文件?????????302??2014-06-09?11:38??B2CFurniture\.myme
?????文件?????????240??2014-03-22?12:34??B2CFurniture\.mystrutsdata
?????文件????????1838??2014-03-22?12:34??B2CFurniture\.project
?????目錄???????????0??2019-12-24?18:28??B2CFurniture\.settings\
?????文件?????????580??2014-03-22?12:34??B2CFurniture\.settings\.jsdtscope
?????文件????????1040??2014-03-22?12:34??B2CFurniture\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????629??2014-06-09?12:19??B2CFurniture\.settings\org.eclipse.jdt.core.prefs
?????文件?????????137??2014-03-22?12:34??B2CFurniture\.settings\org.eclipse.ltk.core.refactoring.prefs
?????文件?????????458??2014-03-22?12:34??B2CFurniture\.settings\org.eclipse.wst.common.component
?????文件?????????252??2014-03-22?12:34??B2CFurniture\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2014-03-22?12:34??B2CFurniture\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-03-22?12:34??B2CFurniture\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-12-24?18:28??B2CFurniture\WebRoot\
?????目錄???????????0??2019-12-24?18:28??B2CFurniture\WebRoot\me
?????文件??????????39??2014-03-22?12:34??B2CFurniture\WebRoot\me
?????目錄???????????0??2019-12-24?18:28??B2CFurniture\WebRoot\WEB-INF\
?????文件???????14283??2014-03-22?12:34??B2CFurniture\WebRoot\WEB-INF\.struts-config.mex
?????目錄???????????0??2019-12-24?21:22??B2CFurniture\WebRoot\WEB-INF\classes\
?????文件??????????62??2014-03-22?12:34??B2CFurniture\WebRoot\WEB-INF\classes\ApplicationResources.properties
?????目錄???????????0??2019-12-24?21:22??B2CFurniture\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2019-12-24?21:22??B2CFurniture\WebRoot\WEB-INF\classes\com\yjjj\
?????目錄???????????0??2019-12-24?21:22??B2CFurniture\WebRoot\WEB-INF\classes\com\yjjj\dao\
?????文件????????3050??2019-12-24?21:22??B2CFurniture\WebRoot\WEB-INF\classes\com\yjjj\dao\AfficheDao.class
?????文件????????2639??2019-12-24?21:22??B2CFurniture\WebRoot\WEB-INF\classes\com\yjjj\dao\BigTypeDao.class
............此處省略215個文件信息
評論
共有 條評論