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项目，不适合大学生用基础框架做毕设使用
