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
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
前往页