//
// Decompiled by Procyon v0.5.29
//
package com.hr.dao;
import java.sql.PreparedStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import com.hr.entity.EASYBUY_PRODUCT;
import java.util.ArrayList;
public class EASYBUY_PRODUCTDao
{
public static ArrayList<EASYBUY_PRODUCT> selectAll() {
final ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
final Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT");
rs = ps.executeQuery();
while (rs.next()) {
final EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"), rs.getString("EP_NAME"), rs.getString("EP_DESCRIPTION"), rs.getInt("EP_PRICE"), rs.getInt("EP_STOCK"), rs.getInt("EPC_ID"), rs.getInt("EPC_CHILD_ID"), rs.getString("EP_FILE_NAME"));
list.add(p);
}
}
catch (SQLException e) {
e.printStackTrace();
return list;
}
finally {
Basedao.closeall(rs, ps, conn);
}
Basedao.closeall(rs, ps, conn);
return list;
}
public static ArrayList<EASYBUY_PRODUCT> selectAllByName(final String name) {
final ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
final Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EP_NAME like ?");
ps.setString(1, "%" + name + "%");
rs = ps.executeQuery();
while (rs.next()) {
final EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"), rs.getString("EP_NAME"), rs.getString("EP_DESCRIPTION"), rs.getInt("EP_PRICE"), rs.getInt("EP_STOCK"), rs.getInt("EPC_ID"), rs.getInt("EPC_CHILD_ID"), rs.getString("EP_FILE_NAME"));
list.add(p);
}
}
catch (SQLException e) {
e.printStackTrace();
return list;
}
finally {
Basedao.closeall(rs, ps, conn);
}
Basedao.closeall(rs, ps, conn);
return list;
}
public static EASYBUY_PRODUCT selectById(final int id) {
EASYBUY_PRODUCT p = null;
ResultSet rs = null;
final Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EP_ID=?");
ps.setInt(1, id);
rs = ps.executeQuery();
while (rs.next()) {
p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"), rs.getString("EP_NAME"), rs.getString("EP_DESCRIPTION"), rs.getInt("EP_PRICE"), rs.getInt("EP_STOCK"), rs.getInt("EPC_ID"), rs.getInt("EPC_CHILD_ID"), rs.getString("EP_FILE_NAME"));
}
}
catch (SQLException e) {
e.printStackTrace();
return p;
}
finally {
Basedao.closeall(rs, ps, conn);
}
Basedao.closeall(rs, ps, conn);
return p;
}
public static ArrayList<EASYBUY_PRODUCT> selectAllByFid(final int fid) {
final ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
final Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EPC_ID=?");
ps.setInt(1, fid);
rs = ps.executeQuery();
while (rs.next()) {
final EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"), rs.getString("EP_NAME"), rs.getString("EP_DESCRIPTION"), rs.getInt("EP_PRICE"), rs.getInt("EP_STOCK"), rs.getInt("EPC_ID"), rs.getInt("EPC_CHILD_ID"), rs.getString("EP_FILE_NAME"));
list.add(p);
}
}
catch (SQLException e) {
e.printStackTrace();
return list;
}
finally {
Basedao.closeall(rs, ps, conn);
}
Basedao.closeall(rs, ps, conn);
return list;
}
public static ArrayList<EASYBUY_PRODUCT> selectAllByCid(final int cid) {
final ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
final Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT where EPC_CHILD_ID=?");
ps.setInt(1, cid);
rs = ps.executeQuery();
while (rs.next()) {
final EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(rs.getInt("EP_ID"), rs.getString("EP_NAME"), rs.getString("EP_DESCRIPTION"), rs.getInt("EP_PRICE"), rs.getInt("EP_STOCK"), rs.getInt("EPC_ID"), rs.getInt("EPC_CHILD_ID"), rs.getString("EP_FILE_NAME"));
list.add(p);
}
}
catch (SQLException e) {
e.printStackTrace();
return list;
}
finally {
Basedao.closeall(rs, ps, conn);
}
Basedao.closeall(rs, ps, conn);
return list;
}
public static int insert(final EASYBUY_PRODUCT p) {
final String sql = "insert into EASYBUY_PRODUCT values(null,?,?,?,?,?,?,?)";
final Object[] params = { p.getEP_NAME(), p.getEP_DESCRIPTION(), p.getEP_PRICE(), p.getEP_STOCK(), p.getEPC_ID(), p.getEPC_CHILD_ID(), p.getEP_FILE_NAME() };
return Basedao.exectuIUD(sql, params);
}
public static int update(final EASYBUY_PRODUCT p) {
if (!p.getEP_FILE_NAME().equals("")) {
final String sql = "update EASYBUY_PRODUCT set EP_NAME=?,EP_DESCRIPTION=?,EP_PRICE=?,EP_STOCK=?,EPC_ID=?,EPC_CHILD_ID=?,EP_FILE_NAME=? where EP_ID=?";
final Object[] params = { p.getEP_NAME(), p.getEP_DESCRIPTION(), p.getEP_PRICE(), p.getEP_STOCK(), p.getEPC_ID(), p.getEPC_CHILD_ID(), p.getEP_FILE_NAME(), p.getEP_ID() };
return Basedao.exectuIUD(sql, params);
}
final String sql = "update EASYBUY_PRODUCT set EP_NAME=?,EP_DESCRIPTION=?,EP_PRICE=?,EP_STOCK=?,EPC_ID=?,EPC_CHILD_ID=? where EP_ID=?";
final Object[] params = { p.getEP_NAME(), p.getEP_DESCRIPTION(), p.getEP_PRICE(), p.getEP_STOCK(), p.getEPC_ID(), p.getEPC_CHILD_ID(), p.getEP_ID() };
return Basedao.exectuIUD(sql, params);
}
public static int del(final int id) {
final String sql = "delete from EASYBUY_PRODUCT where EP_ID=?";
final Object[] params = { id };
return Basedao.exectuIUD(sql, params);
}
public static int totalPage(final int count) {
int tpage = 1;
final Connection conn = Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select count(*) from EASYBUY_PRODUCT");
rs = ps.executeQuery();
if (rs.next()) {
final int sum = rs.getInt(1);
if (sum % count == 0) {
tpage = sum / count;
}
else {
tpage = sum / count + 1;
}
}
}
catch (SQLException e) {
e.printStackTrace();
return tpage;
}
finally {
Basedao.closeall(rs, ps, conn);
}
Basedao.closeall(rs, ps, conn);
return tpage;
}
public static int totalPageByFid(final int count, final int fid) {
int tpage = 1;
final Connection conn = Basedao.getconn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select count(*) from EASYBUY_PRODUCT where EPC_ID=?");
ps.setInt(1, f
基于jsp+servlet宠物商城网站系统+sql数据库(毕设源码).zip （276个子文件） 
EASYBUY_PRODUCTDao.class 12KB EASYBUY_COMMENTDao.class 7KB EASYBUY_USERDao.class 7KB EASYBUY_ORDERDao.class 6KB ESDao.class 5KB EASYBUY_PRODUCT_CATEGORYDao.class 4KB EASYBUY_NEWSDao.class 4KB SelectProductListServlet.class 4KB EASYBUY_USER.class 3KB EASYBUY_ORDER_DETAILDao.class 3KB gmServlet.class 3KB RegisterInServlet.class 3KB DoProductUpdateServlet.class 3KB DoProductAddServlet.class 3KB ShopAdd2Servlet.class 3KB UserModifyServlet.class 3KB UserNumServlet.class 3KB ShopAddServlet.class 3KB SelectDD.class 3KB SelectProductViewServlet.class 3KB LoginServlet.class 3KB EASYBUY_DdanDao.class 3KB EASYBUY_ORDER.class 3KB UserDoupdate.class 2KB eb_shop.class 2KB EASYBUY_DDDao.class 2KB IndexSelectServlet.class 2KB SelallServlet.class 2KB UseraddServlet.class 2KB ShopSelect.class 2KB Basedao.class 2KB UpManage.class 2KB EASYBUY_PRODUCT.class 2KB DeleteDingdanServlet.class 2KB OrderSelServlet.class 2KB SelManage.class 2KB OrderDoUServlet.class 2KB GueServlet.class 2KB EASYBUY_Ddan.class 2KB NewsDouServlet.class 2KB EASYBUY_COMMENT.class 2KB UpdateServlet.class 2KB NewsInsServlet.class 2KB UpdateManage.class 2KB ToProductUpdateServlet.class 2KB ProductSelectServlet.class 2KB NewsselectServlet.class 2KB UserServlet.class 2KB NewsSelectServlet2.class 2KB DoProductClassAddServlet.class 2KB ToProductClassUpdateServlet.class 2KB NewsDelServlet.class 2KB DoProductClassUpdateServlet.class 2KB OrderTouServlet.class 2KB UserDelServlet.class 2KB EncodeUtil.class 2KB UserUpdateServlet.class 2KB EASYBUY_DD.class 2KB CheckUserNumServlet.class 2KB SelServlet.class 1KB OderDelServlet.class 1KB UsernameCheckServlet.class 1KB CheckNameServlet.class 1KB EASYBUY_ORDER_DETAIL.class 1KB DelManage.class 1KB ProductAddServlet.class 1KB NewsUpdServlet.class 1KB EASYBUY_NEWS.class 1KB ProductClassAddServlet.class 1KB ProductClassServlet.class 1KB ProductDelServlet.class 1KB ChaManage.class 1KB EASYBUY_PRODUCT_CATEGORY.class 1KB ProductClassDelServlet.class 1KB ZXServlet.class 1KB .classpath 841B org.eclipse.wst.common.component 485B org.eclipse.wst.jsdt.ui.superType.container 49B style.css 13KB
w3.gif 114KB login.gif 2KB logo.gif 2KB Calendar.htc 31KB
classes12.jar 1.53MB mysql-connector-java-5.1.21.jar 809KB jstl-1.2.jar 405KB servlet-api.jar 141KB smartupload.jar 13KB EASYBUY_PRODUCTDao.java 17KB EASYBUY_COMMENTDao.java 8KB EASYBUY_USERDao.java 8KB EASYBUY_ORDERDao.java 6KB EASYBUY_PRODUCT_CATEGORYDao.java 5KB ESDao.java 5KB EASYBUY_NEWSDao.java 4KB EASYBUY_USER.java 3KB SelectProductListServlet.java 3KB EASYBUY_ORDER_DETAILDao.java 3KB gmServlet.java 3KB EASYBUY_ORDER.java 3KB共 276 条
- 1
- 2
- 3
资源评论
manylinux
- 粉丝: 4564
- 资源: 2484
最新资源
- 基于flask的微信公众号智能机器人详细文档+全部资料+高分项目.zip
- 基于django的视频点播网站开发全部资料+详细文档+高分项目.zip
- 基于Django的图书销售管理系统全部资料+详细文档+高分项目.zip
- 基于django的微信订阅号的服务全部资料+详细文档+高分项目.zip
- 基于django和layui,xadmin的知识管理web，可以团队使用，也可以当做个人博客全部资料+详细文档+高分项目.zip
- 基于Django和elasticsearch搭建电影搜索网站全部资料+详细文档+高分项目.zip
- 基于django和wechat的会员推广二维码模块全部资料+详细文档+高分项目.zip
- 基于django和scrapy的新浪数据分析网站全部资料+详细文档+高分项目.zip
- 基于Django开发的出租屋信息管理系统全部资料+详细文档+高分项目.zip
- 基于flask的陶瓷论坛详细文档+全部资料+高分项目.zip
- 基于flask的验证码程序详细文档+全部资料+高分项目.zip
- 基于django和深度学习实现的图像处理网页全部资料+详细文档+高分项目.zip
- 基于Django框架，使用Django REST framework前后端分离技术搭建的网上图书商店全部资料+详细文档+高分项目.zip
- 基于Flask的学员管理系统，是Bootstrap-Flask极简开发网站、身份认证、密码修改；学生浏览开设的课程、选课；教师查看已选课学生、学生录入成绩等功能
- 基于Django亚鹿逊在线书店，全部资料+详细文档+高分项目.zip
- 基于django框架的企业信贷管理系统全部资料+详细文档+高分项目.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
