package cn.jbit.easybuy.biz.impl;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import cn.jbit.easybuy.biz.ProductService;
import cn.jbit.easybuy.dao.CommentDao;
import cn.jbit.easybuy.dao.ProductCategoryDao;
import cn.jbit.easybuy.dao.ProductDao;
import cn.jbit.easybuy.dao.impl.CommentDaoImpl;
import cn.jbit.easybuy.dao.impl.ProductCategoryDaoImpl;
import cn.jbit.easybuy.dao.impl.ProductDaoImpl;
import cn.jbit.easybuy.entity.Pager;
import cn.jbit.easybuy.entity.Product;
import cn.jbit.easybuy.entity.ProductCategory;
import cn.jbit.easybuy.util.DataSourceUtil;
import cn.jbit.easybuy.util.Validator;
public class ProductServiceImpl implements ProductService {
public void delete(String id) {
Connection connection = null;
try {
connection = DataSourceUtil.openConnection();
ProductDao productDao = new ProductDaoImpl(connection);
productDao.delete(Long.parseLong(id));
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
}
public void deleteCategory(String id) {
Connection connection = null;
try {
connection = DataSourceUtil.openConnection();
ProductCategoryDao productCategoryDao = new ProductCategoryDaoImpl(
connection);
productCategoryDao.delete(Long.parseLong(id));
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
}
public Product findById(String id) {
Connection connection = null;
Product product = null;
try {
connection = DataSourceUtil.openConnection();
ProductDao productDao = new ProductDaoImpl(connection);
product = productDao.findById(Long.parseLong(id));
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
return product;
}
public ProductCategory findCategoryById(String id) {
Connection connection = null;
ProductCategory productCategory = null;
try {
connection = DataSourceUtil.openConnection();
ProductCategoryDao productCategoryDao = new ProductCategoryDaoImpl(
connection);
productCategory = productCategoryDao.findById(Long.parseLong(id));
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
return productCategory;
}
public List<ProductCategory> getProductCategories(String parentId) {
Connection connection = null;
Long id = null;
if (!Validator.isEmpty(parentId))
id = Long.parseLong(parentId);
List<ProductCategory> rtn = new ArrayList<ProductCategory>();
try {
connection = DataSourceUtil.openConnection();
ProductCategoryDao productCategoryDao = new ProductCategoryDaoImpl(
connection);
rtn = productCategoryDao.getProductCategories(id);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
return rtn;
}
public List<Product> getProductsByCategory(String categoryId, Pager pager) {
Connection connection = null;
List<Product> rtn = new ArrayList<Product>();
try {
connection = DataSourceUtil.openConnection();
ProductDao productDao = new ProductDaoImpl(connection);
if (categoryId == null)
rtn = productDao.getProductsByCategoryLevelTwo(null, pager);
else
rtn = productDao.getProductsByCategoryLevelTwo(Long
.parseLong(categoryId), pager);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
return rtn;
}
public void save(Product product) {
Connection connection = null;
try {
connection = DataSourceUtil.openConnection();
ProductDao productDao = new ProductDaoImpl(connection);
productDao.save(product);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
}
public void saveCategory(ProductCategory productCategory) {
Connection connection = null;
try {
connection = DataSourceUtil.openConnection();
ProductCategoryDao productCategoryDao = new ProductCategoryDaoImpl(
connection);
productCategoryDao.save(productCategory);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
}
public void update(Product product) {
Connection connection = null;
try {
connection = DataSourceUtil.openConnection();
ProductDao productDao = new ProductDaoImpl(connection);
productDao.update(product);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
}
public void updateCategory(ProductCategory productCategory, String type) {
Connection connection = null;
try {
connection = DataSourceUtil.openConnection();
ProductCategoryDao productCategoryDao = new ProductCategoryDaoImpl(
connection);
ProductDao productDao = new ProductDaoImpl(connection);
String sql = null;
if (type.equals("ModifyParent")) {
sql = " UPDATE easybuy_product SET epc_id="
+ productCategory.getParentId()
+ " where epc_child_id=" + productCategory.getId();
} else {
sql = " UPDATE easybuy_product SET epc_child_id = null,epc_id="
+ productCategory.getId() + " where epc_child_id="
+ productCategory.getId();
}
connection.setAutoCommit(false);
try {
productCategoryDao.update(productCategory);
productDao.modifyCategoryOfProductBySql(sql);
connection.commit();
} catch (SQLException e) {
e.printStackTrace();
} finally {
connection.rollback();
connection.setAutoCommit(true);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
}
public List<ProductCategory> getRootCategories() {
Connection connection = null;
List<ProductCategory> rtn = new ArrayList<ProductCategory>();
try {
connection = DataSourceUtil.openConnection();
ProductCategoryDao productCategoryDao = new ProductCategoryDaoImpl(
connection);
rtn = productCategoryDao.getRootCategories();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
return rtn;
}
public void updateCategoryName(ProductCategory productCategory) {
Connection connection = null;
try {
connection = DataSourceUtil.openConnection();
ProductCategoryDao productCategoryDao = new ProductCategoryDaoImpl(
connection);
productCategoryDao.update(productCategory);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
}
public long getProductRowCount(String categoryId) {
Connection connection = null;
long rtn = 0;
try {
connection = DataSourceUtil.openConnection();
ProductDao productDao = new ProductDaoImpl(connection);
Long id = null;
if (categoryId != null)
id = Long.parseLong(categoryId);
rtn = productDao.getProductRowCountByCategoryLevelTwo(id);
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
return rtn;
}
public Long getNewProductId() {
Connection connection = null;
long rtn = 0;
try {
connection = DataSourceUtil.openConnection();
ProductDao productDao = new ProductDaoImpl(connection);
rtn = productDao.getNewProductId();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DataSourceUtil.closeConnection(connection);
}
return rtn;
}
}
JSP/servlet/ajax购物网站源码easybuy （165个子文件） 
ProductUploadServlet.class 8KB UserServlet.class 8KB ProductServiceImpl.class 8KB CartServlet.class 7KB NewsServlet.class 7KB ProductServlet.class 7KB ProductDaoImpl.class 7KB OrderDaoImpl.class 6KB CommentServlet.class 6KB OrderServlet.class 6KB CategoryServlet.class 6KB OrderServiceImpl.class 6KB HomeServlet.class 6KB FacilityServiceImpl.class 6KB UserDaoImpl.class 6KB Validator.class 5KB ProductCategoryDaoImpl.class 5KB CommentDaoImpl.class 5KB NewsDaoImpl.class 4KB RegisterServlet.class 4KB UserServiceImpl.class 4KB LoginServlet.class 3KB BaseDaoImpl.class 3KB Order.class 3KB User.class 3KB Product.class 3KB Pager.class 3KB ShoppingCart.class 2KB Comment.class 2KB OrderDetail.class 1KB DataSourceUtil.class 1KB News.class 1KB ProductService.class 1KB ShoppingCartItem.class 1KB ProductDao.class 1KB ProductCategory.class 1KB ActionResult.class 1023B FacilityService.class 865B OrderDao.class 773B ProductCategoryDao.class 691B OrderService.class 675B UserDao.class 651B CommentDao.class 615B NewsDao.class 581B UserService.class 559B UniqueConstraintException.class 479B .classpath 661B org.eclipse.wst.common.component 420B org.eclipse.wst.jsdt.ui.superType.container 49B style.css 13KB Thumbs.db 6KB
0_tiny.gif 2KB logo.gif 1KB
ojdbc14.jar 1.47MB standard.jar 384KB commons-io-1.3.2.jar 86KB commons-fileupload-1.2.1.jar 56KB jstl.jar 20KB ProductServiceImpl.java 8KB UserServlet.java 7KB CartServlet.java 6KB NewsServlet.java 6KB CategoryServlet.java 6KB ProductUploadServlet.java 6KB ProductDaoImpl.java 5KB FacilityServiceImpl.java 5KB ProductServlet.java 5KB CommentServlet.java 5KB OrderServlet.java 5KB OrderServiceImpl.java 5KB OrderDaoImpl.java 5KB HomeServlet.java 5KB UserDaoImpl.java 4KB Validator.java 4KB ProductCategoryDaoImpl.java 4KB CommentDaoImpl.java 3KB NewsDaoImpl.java 3KB UserServiceImpl.java 3KB RegisterServlet.java 3KB Pager.java 2KB LoginServlet.java 2KB Order.java 2KB User.java 2KB Product.java 2KB BaseDaoImpl.java 2KB Comment.java 1KB ShoppingCart.java 930B ProductDao.java 904B ProductService.java 888B OrderDetail.java 844B DataSourceUtil.java 815B OrderDao.java 734B News.java 730B ActionResult.java 696B FacilityService.java 671B ShoppingCartItem.java 656B ProductCategoryDao.java 585B OrderService.java 547B ProductCategory.java 540B CommentDao.java 524B共 165 条
- 1
- 2
hpjkjgf
- 粉丝: 0
- 资源: 7
最新资源
- 使用Python和Pygame实现圣诞节动画效果
- 数据分析-49-客户细分-K-Means聚类分析
- 企业可持续发展性数据集，ESG数据集，公司可持续发展性数据（可用于多种企业可持续性研究场景）
- chapter9.zip
- 使用Python和Pygame库创建新年烟花动画效果
- 国际象棋检测10-YOLO（v5至v11）、COCO、CreateML、Paligemma、TFRecord、VOC数据集合集.rar
- turbovnc-2.2.6.x86-64.rpm
- 艾利和iriver Astell&Kern SP3000 V1.30升级固件
- VirtualGL-2.6.5.x86-64.rpm
- dbeaver-ce-24.3.1-x86-64-setup.exe
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
- 1
- 2
- 3
前往页