91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 2.73MB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2024-01-27
  • 語言: 其他
  • 標簽: webservlet??c3p0??

資源簡介

網上商城項目中前臺完成用戶登錄注冊的校驗,采用郵箱激活方式、商品的瀏覽,購物車添加,訂單的提交與跟蹤;后臺完成商品的增刪該查。

資源截圖

代碼片段和文件信息

package?cn.product.dao;

import?java.sql.Connection;
import?java.sql.SQLException;
import?java.util.List;

import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanHandler;
import?org.apache.commons.dbutils.handlers.BeanListHandler;
import?org.apache.commons.dbutils.handlers.ScalarHandler;

import?cn.product.domain.Product;
import?cn.product.utils.JDBCUtils;


public?class?ProductDao?{

public?List?findAll()?throws?SQLException?{
QueryRunner?queryRunner?=?new?QueryRunner(JDBCUtils.getDataSource());
String?sql=“select?*?from?product??order?by?pdate?desc“;
List?list?=?queryRunner.query(sql?new?BeanListHandler(Product.class));

return?list;
}

public?void?addProduct(Product?product)?throws?SQLException?{
QueryRunner?queryRunner?=?new?QueryRunner(JDBCUtils.getDataSource());
String?sql?=?“insert?into?product(pidpnamemarket_priceshop_pricepdateis_hotpdescpflag)?values(????????)“;
queryRunner.update(sql?product.getPid()product.getPname()product.getMarket_price()product.getShop_price()product.getPdate()product.getIs_hot()product.getPdesc()product.getPflag());


}

public?void?deleteProduct(String?productID)?throws?SQLException?{
QueryRunner?queryRunner?=?new?QueryRunner(JDBCUtils.getDataSource());
String?sql?=?“delete?from?product?where?pid?=??“;
queryRunner.update(sql?productID);
}

public?Product?findProductById(String?productID)?throws?SQLException?{
QueryRunner?queryRunner?=?new?QueryRunner(JDBCUtils.getDataSource());
String?sql?=?“select?*?from?product?where?pid?=??“;
Product?product?=?queryRunner.query(sql??new?BeanHandler(Product.class)productID);
return?product;
}

public?void?updateProduct(Product?product)?throws?SQLException?{

QueryRunner?queryRunner?=?new?QueryRunner(JDBCUtils.getDataSource());
String?sql?=?“update?product?set?pname=?market_price=?shop_price=?pdate=?is_hot=?pdesc=?pflag=??where?pid=?“;
queryRunner.update(sqlproduct.getPname()product.getMarket_price()product.getShop_price()product.getPdate()product.getIs_hot()product.getPdesc()product.getPflag()product.getPid());

}

public?List?selectByProudctName(String?pname)?throws?SQLException?{
QueryRunner?queryRunner?=?new?QueryRunner(JDBCUtils.getDataSource());

String?sql?=?“select?*?from?product?where?pname?like??“;
List?list?=?queryRunner.query(sql?new?BeanListHandler(Product.class)“%“+pname+“%“);


return?list;
}

public?void?deleteAllProduct(Connection?conn?String?pid)?throws?SQLException?{
QueryRunner?queryRunner?=?new?QueryRunner();
String?sql?=?“delete?from?product?where?pid?=??“;

queryRunner.update(connsqlpid);
}

public?List?findByPage(String?pageNo)?throws?NumberFormatException?SQLException?{
QueryRunner?queryRunner?=?new?QueryRunner(JDBCUtils.getDataSource());
String

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????661??2017-11-11?14:02??web_product\.classpath

?????文件???????1044??2017-11-11?14:02??web_product\.project

?????文件????????567??2017-11-11?14:02??web_product\.settings\.jsdtscope

?????文件????????539??2017-11-11?14:02??web_product\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2017-11-11?14:02??web_product\.settings\org.eclipse.jdt.core.prefs

?????文件????????485??2017-11-11?14:02??web_product\.settings\org.eclipse.wst.common.component

?????文件????????345??2017-11-11?14:02??web_product\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-11-11?14:02??web_product\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-11-11?14:02??web_product\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????461??2017-11-11?14:02??web_product\build\classes\c3p0-config.xml

?????文件???????4641??2017-11-11?14:02??web_product\build\classes\cn\product\dao\ProductDao.class

?????文件???????1616??2017-11-11?14:02??web_product\build\classes\cn\product\domain\PageBean.class

?????文件???????2181??2017-11-11?14:02??web_product\build\classes\cn\product\domain\Product.class

?????文件???????3517??2017-11-11?14:02??web_product\build\classes\cn\product\service\ProductService.class

?????文件???????2894??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductAddServlet.class

?????文件???????1763??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductDeleteAllServlet.class

?????文件???????1670??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductDeleteServlet.class

?????文件???????1721??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductfindAllServlet.class

?????文件???????1870??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductfindByPageServlet.class

?????文件???????2862??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductToUpdateServlet.class

?????文件???????1763??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\ProductUpdateServlet.class

?????文件???????1921??2017-11-11?14:02??web_product\build\classes\cn\product\servlet\SelectByProudctNameServlet.class

?????文件????????738??2017-11-11?14:02??web_product\build\classes\cn\product\utils\JDBCUtils.class

?????文件????????634??2017-11-11?14:02??web_product\build\classes\cn\product\utils\UUIDUtils.class

?????文件????????461??2017-11-11?14:02??web_product\src\c3p0-config.xml

?????文件???????3521??2017-11-11?14:02??web_product\src\cn\product\dao\ProductDao.java

?????文件???????1052??2017-11-11?14:02??web_product\src\cn\product\domain\PageBean.java

?????文件???????1435??2017-11-11?14:02??web_product\src\cn\product\domain\Product.java

?????文件???????2599??2017-11-11?14:02??web_product\src\cn\product\service\ProductService.java

?????文件???????2392??2017-11-11?14:02??web_product\src\cn\product\servlet\ProductAddServlet.java

............此處省略131個文件信息

評論

共有 條評論