-
大小: 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.xm
?????文件?????????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.xm
?????文件???????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.xm
?????文件???????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個文件信息
- 上一篇:ARMCortex-M3權威指南(第二版)
- 下一篇:黑客與社會工程學.rar
評論
共有 條評論