//
// 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
- 粉丝: 4425
- 资源: 2491
最新资源
- 410.基于SpringBoot的高校科研信息管理系统(含报告).zip
- 附件1.植物健康状态的影响指标数据.xlsx
- Windows 10 1507-x86 .NET Framework 3.5(包括.NET 2.0和3.0)安装包
- Image_1732500699692.png
- Windows 10 21h1-x86 .NET Framework 3.5(包括.NET 2.0和3.0)安装包
- VMware 是一款功能强大的虚拟化软件，它允许用户在一台物理计算机上同时运行多个操作系统
- 31万条全国医药价格与采购数据.xlsx
- SQL注入详解，SQL 注入是一种常见的网络安全漏洞，攻击者通过在输入数据中插入恶意的 SQL 语句，欺骗应用程序执行这些恶意语句，从而获取、修改或删除数据库中的数据，甚至控制数据库服务器
- 用C语言实现哈夫曼编码：从原理到实现的详细解析
- py爱心代码高级粒子！！
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
