package com.botao.dao.impl;
import com.botao.dao.ProductDao;
import com.botao.pojo.Product;
import com.botao.utils.BaseDao;
import com.botao.utils.Helper;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class ProductDaoImpl implements ProductDao {
@Override
public int add(Connection connection, Product product) throws SQLException {
product.setId(Helper.getUUID());
product.setCreated(Helper.getSqlDate());
String id = product.getId();
String name = product.getName();
String desc = product.getDesc();
double price = product.getPrice();
Integer stock = product.getStock();
String img = product.getImg();
Date created = product.getCreated();
Date deleted = product.getDeleted();
PreparedStatement preparedStatement = connection.prepareStatement("insert into product value (?,?,?,?,?,?,?,?)");
preparedStatement.setString(1, id);
preparedStatement.setString(2, name);
preparedStatement.setString(3, desc);
preparedStatement.setDouble(4, price);
preparedStatement.setInt(5, stock);
preparedStatement.setString(6, img);
preparedStatement.setDate(7, created);
preparedStatement.setDate(8, deleted);
int i = preparedStatement.executeUpdate();
preparedStatement.close();
return i;
}
@Override
public int remove(Connection connection, String id) throws SQLException {
Statement statement = connection.createStatement();
int i = statement.executeUpdate("update product set deleted = now() where id='" + id + "'");
statement.close();
return i;
}
@Override
public Product getProductById(Connection connection, String id) throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select * from product where id = '" + id + "'");
Product product = null;
while (resultSet.next()) {
String id1 = resultSet.getString("id");
String name = resultSet.getString("name");
String desc = resultSet.getString("desc");
double price = resultSet.getDouble("price");
int stock = resultSet.getInt("stock");
String img = resultSet.getString("img");
Date created = resultSet.getDate("created");
Date deleted = resultSet.getDate("deleted");
product = new Product(id1, name, desc, price, stock, img, created, deleted);
}
resultSet.close();
statement.close();
return product;
}
@Override
public List<Product> getAllProducts(Connection connection) throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select * from product");
ArrayList<Product> products = new ArrayList<>();
while (resultSet.next()) {
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String desc = resultSet.getString("desc");
double price = resultSet.getDouble("price");
int stock = resultSet.getInt("stock");
String img = resultSet.getString("img");
Date created = resultSet.getDate("created");
Date deleted = resultSet.getDate("deleted");
products.add(new Product(id, name, desc, price, stock, img, created, deleted));
}
resultSet.close();
statement.close();
return products;
}
@Override
public List<Product> getAllProductsExceptDeleted(Connection connection) throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select * from product where deleted IS NULL");
ArrayList<Product> products = new ArrayList<>();
while (resultSet.next()) {
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String desc = resultSet.getString("desc");
double price = resultSet.getDouble("price");
int stock = resultSet.getInt("stock");
String img = resultSet.getString("img");
Date created = resultSet.getDate("created");
Date deleted = resultSet.getDate("deleted");
products.add(new Product(id, name, desc, price, stock, img, created, deleted));
}
resultSet.close();
statement.close();
return products;
}
@Override
public List<Product> searchProducts(Connection connection, String keyWords) throws SQLException {
Connection connection1 = BaseDao.getConnection();
Statement statement = connection.createStatement();
String sql = "select * from product where name like '%" + keyWords + "%' or `desc` like '%" + keyWords + "%'";
System.out.println(sql);
ResultSet resultSet = statement.executeQuery(sql);
List<Product> products = new ArrayList<>();
while (resultSet.next()) {
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String desc = resultSet.getString("desc");
double price = resultSet.getDouble("price");
int stock = resultSet.getInt("stock");
String img = resultSet.getString("img");
Date created = resultSet.getDate("created");
Date deleted = resultSet.getDate("deleted");
products.add(new Product(id, name, desc, price, stock, img, created, deleted));
}
resultSet.close();
statement.close();
return products;
}
@Override
public Product searchProductsById(Connection connection, String id) throws SQLException {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select * from product where id='" + id + "'");
Product product=null;
while (resultSet.next()) {
String id1 = resultSet.getString("id");
String name = resultSet.getString("name");
String desc = resultSet.getString("desc");
double price = resultSet.getDouble("price");
int stock = resultSet.getInt("stock");
String img = resultSet.getString("img");
Date created = resultSet.getDate("created");
Date deleted = resultSet.getDate("deleted");
product = new Product(id1, name, desc, price, stock, img, created, deleted);
}
resultSet.close();
statement.close();
return product;
}
@Override
public int updateProductById(Connection connection, Product product) throws SQLException {
Statement statement = connection.createStatement();
String id = product.getId();
String name = product.getName();
String desc = product.getDesc();
double price = product.getPrice();
Integer stock = product.getStock();
String img = product.getImg();
int i = statement.executeUpdate("update product set name='" + name + "',`desc`='" + desc + "',price='" + price + "',stock='" + stock + "',img='" + img + "' where id='" + id + "'");
statement.close();
return i;
}
@Override
public int reducedById(Connection connection, String id,int num) throws SQLException {
Statement statement = connection.createStatement();
int i = statement.executeUpdate("update product set stock=stock-"+num+" where id='" + id + "'");
return i;
}
}
javaweb课程设计，基于Servlet+Jsp的在线购物商城系统 （715个子文件） 
OrderServlet.class 9KB OrderServlet.class 9KB ProductDaoImpl.class 7KB ProductDaoImpl.class 7KB OrderDaoImpl.class 7KB OrderDaoImpl.class 7KB ProductServlet.class 6KB ProductServlet.class 6KB UserDaoImpl.class 5KB UserDaoImpl.class 5KB LoginServlet.class 5KB LoginServlet.class 5KB CartServlet.class 4KB CartServlet.class 4KB UploadServlet.class 4KB UploadServlet.class 4KB OrderServlet.class 4KB OrderServlet.class 4KB ProductServlet.class 4KB ProductServlet.class 4KB ClientServlet.class 4KB ClientServlet.class 4KB CartDaoImpl.class 4KB CartDaoImpl.class 4KB OrderServiceImpl.class 3KB OrderServiceImpl.class 3KB CommentDaoImpl.class 3KB CommentDaoImpl.class 3KB UserServiceImpl.class 3KB UserServiceImpl.class 3KB CartServiceImpl.class 3KB CartServiceImpl.class 3KB Helper.class 3KB Helper.class 3KB ProductServiceImpl.class 3KB ProductServiceImpl.class 3KB CommentServlet.class 3KB CommentServlet.class 3KB User.class 3KB User.class 3KB ManagerDaoImpl.class 2KB ManagerDaoImpl.class 2KB Order.class 2KB Order.class 2KB Product.class 2KB Product.class 2KB S.class 2KB CommentServiceImpl.class 2KB CommentServiceImpl.class 2KB SearchServlet.class 2KB SearchServlet.class 2KB BaseDao.class 2KB BaseDao.class 2KB UserServlet.class 2KB UserServlet.class 2KB Comment.class 2KB Comment.class 2KB Manager.class 2KB Manager.class 2KB Cart.class 2KB Cart.class 2KB AdminLoginFilter.class 2KB AdminLoginFilter.class 2KB UserLoginFilter.class 2KB UserLoginFilter.class 2KB ManagerServiceImpl.class 1KB ManagerServiceImpl.class 1KB OrderDao.class 1KB OrderDao.class 1KB CharacterEncodingFilter.class 1KB CharacterEncodingFilter.class 1KB LogoutServlet.class 1KB LogoutServlet.class 1KB ProductDao.class 970B ProductDao.class 970B ProductService.class 784B ProductService.class 784B UserService.class 770B UserService.class 770B OrderService.class 684B OrderService.class 684B CartDao.class 593B CartDao.class 593B UserDao.class 554B UserDao.class 554B CommentDao.class 510B CommentDao.class 510B CommentService.class 445B CommentService.class 445B CartService.class 426B CartService.class 426B ManagerDao.class 297B ManagerDao.class 297B ManagerService.class 263B ManagerService.class 263B .classpath 2KB bootstrap.css 193KB bootstrap.css 193KB layui.css 68KB layui.css 68KB共 715 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
桥桥婷2023-07-06没有项目设计说明书文档，是maven项目，不适合大学生用基础框架做毕设使用
可可鸭~
- 粉丝: 793
- 资源: 40
最新资源
- DLT 1265-2013 电力行业焊工培训机构基本能力要求.pdf
- DLT 5070-1997 水轮机金属蜗壳安装焊接工艺导则.pdf
- DLT 1317-2014 火力发电厂焊接接头超声衍射时差检测技术规程.pdf
- DR马口铁在焊接制罐中出现的问题及处理.pdf
- DY30焊剂在船舶制造高效焊接技术中的应用 - .pdf
- EPR核电机组蒸发器异种钢焊接工艺研究 - .pdf
- EH36钢的焊接工艺.pdf
- EPR蒸汽发生器上部水平支承焊接.pdf
- EPR核电站安全壳内部换料水池天花板的焊接 - .pdf
- FW-420T／H型循环流化床锅炉焊接技术.pdf
- FZ 92065-2006 不锈钢焊接式烘筒.pdf
- 布匹检测装置（坏点检测）sw17全套技术开发资料100%好用.zip
- 玻璃检测机sw17可编辑全套技术开发资料100%好用.zip
- 基于 SVM 和 TF-IDF 算法的中文文本分类和情感分析系统详细文档+全部资料+优秀项目.zip
- 基于Chinese-CLIP的图文检索系统视、觉课程设计详细文档+全部资料+优秀项目.zip
- 基于Fasttext的自然语言识别子系统详细文档+全部资料+优秀项目.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
