package com.hr.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.hr.entity.EASYBUY_PRODUCT;
public class EASYBUY_PRODUCTDao {
/**
* 查询所有
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAll(){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
Connection conn = Basedao.getconn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("select * from EASYBUY_PRODUCT");
rs = ps.executeQuery();
while(rs.next()){
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) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* 名字模糊查询
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByName(String name){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
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()){
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) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* 根据id查询单个
* @param id
* @return
*/
public static EASYBUY_PRODUCT selectById(int id){
EASYBUY_PRODUCT p = null;
ResultSet rs = null;
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) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return p;
}
/**
* 根据fid查询所有
* @param fid
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByFid(int fid){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
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()){
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) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
/**
* 根据cid查询所有
* @param fid
* @return
*/
public static ArrayList<EASYBUY_PRODUCT> selectAllByCid(int cid){
ArrayList<EASYBUY_PRODUCT> list = new ArrayList<EASYBUY_PRODUCT>();
ResultSet rs = null;
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()){
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) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Basedao.closeall(rs, ps, conn);
}
return list;
}
public static int insert(EASYBUY_PRODUCT p){
String sql = "insert into EASYBUY_PRODUCT values(null,?,?,?,?,?,?,?)";
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(EASYBUY_PRODUCT p){
if(!p.getEP_FILE_NAME().equals("")){
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=?";
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);
}else{
String sql = "update EASYBUY_PRODUCT set EP_NAME=?," +
"EP_DESCRIPTION=?," +
"EP_PRICE=?," +
"EP_STOCK=?," +
"EPC_ID=?," +
"EPC_CHILD_ID=? " +
" where EP_ID=?";
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(int id){
String sql = "delete from EASYBUY_PRODUCT where EP_ID=?";
Object[] params = {id};
return Basedao.exectuIUD(sql, params);
}
public static int totalPage(int count){
int tpage = 1;
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()){
int sum = rs.getInt(1);//获得表的总行数
if(sum%count==0){
tpage = sum/count;//总行数是每页行数的整倍数
}else {
tpage = sum/count+1;//不是整倍数要加一
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return tpage;
}
public static int totalPageByFid(int count,int fid){
int tpage = 1;
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, fid);
rs = ps.executeQuery();
if(rs.next()){
int sum = rs.getInt(1);//获得表的总行数
if(sum%count==0){
tpage = sum/count;//总行数是每页行数的整倍数
}else {
tpage = sum/count+1;//不是整倍数要加一
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
Basedao.closeall(rs, ps, conn);
}
return tpage;
}
public static int to
课程设计-基于java web的网上花店系统（源码+数据库）.zip
版权申诉
168 浏览量
2024-03-31
23:20:30
上传
评论
收藏 24.75MB ZIP 举报
课程设计-基于java web的网上花店系统（源码+数据库）.zip （863个子文件） 
EASYBUY_PRODUCTDao.class 12KB EASYBUY_PRODUCTDao.class 12KB EASYBUY_COMMENTDao.class 7KB EASYBUY_COMMENTDao.class 7KB EASYBUY_USERDao.class 7KB EASYBUY_USERDao.class 7KB EASYBUY_ORDERDao.class 6KB EASYBUY_ORDERDao.class 6KB ESDao.class 5KB ESDao.class 5KB EASYBUY_PRODUCT_CATEGORYDao.class 5KB EASYBUY_PRODUCT_CATEGORYDao.class 5KB EASYBUY_NEWSDao.class 4KB EASYBUY_NEWSDao.class 4KB SelectProductListServlet.class 4KB SelectProductListServlet.class 4KB EASYBUY_ORDER_DETAILDao.class 3KB EASYBUY_ORDER_DETAILDao.class 3KB gmServlet.class 3KB gmServlet.class 3KB DoProductUpdateServlet.class 3KB DoProductUpdateServlet.class 3KB ShopAdd2Servlet.class 3KB ShopAdd2Servlet.class 3KB DoProductAddServlet.class 3KB DoProductAddServlet.class 3KB UserNumServlet.class 3KB UserNumServlet.class 3KB ShopAddServlet.class 3KB ShopAddServlet.class 3KB EASYBUY_USER.class 3KB EASYBUY_USER.class 3KB SelectDD.class 3KB SelectDD.class 3KB SelectProductViewServlet.class 3KB SelectProductViewServlet.class 3KB EASYBUY_ORDER.class 3KB EASYBUY_ORDER.class 3KB eb_shop.class 2KB LoginServlet.class 2KB eb_shop.class 2KB LoginServlet.class 2KB RegisterInServlet.class 2KB RegisterInServlet.class 2KB UserDoupdate.class 2KB UserDoupdate.class 2KB IndexSelectServlet.class 2KB IndexSelectServlet.class 2KB SelallServlet.class 2KB SelallServlet.class 2KB Basedao.class 2KB Basedao.class 2KB ShopSelect.class 2KB ShopSelect.class 2KB UpManage.class 2KB UpManage.class 2KB EASYBUY_DdanDao.class 2KB EASYBUY_DdanDao.class 2KB EASYBUY_PRODUCT.class 2KB EASYBUY_PRODUCT.class 2KB OrderSelServlet.class 2KB OrderSelServlet.class 2KB UseraddServlet.class 2KB UseraddServlet.class 2KB SelManage.class 2KB SelManage.class 2KB EASYBUY_DDDao.class 2KB EASYBUY_DDDao.class 2KB OrderDoUServlet.class 2KB OrderDoUServlet.class 2KB GueServlet.class 2KB GueServlet.class 2KB EASYBUY_Ddan.class 2KB EASYBUY_Ddan.class 2KB NewsDouServlet.class 2KB NewsDouServlet.class 2KB EASYBUY_COMMENT.class 2KB EASYBUY_COMMENT.class 2KB UpdateServlet.class 2KB UpdateServlet.class 2KB NewsInsServlet.class 2KB NewsInsServlet.class 2KB UpdateManage.class 2KB UpdateManage.class 2KB ToProductUpdateServlet.class 2KB ToProductUpdateServlet.class 2KB ProductSelectServlet.class 2KB ProductSelectServlet.class 2KB NewsselectServlet.class 2KB NewsselectServlet.class 2KB UserServlet.class 2KB UserServlet.class 2KB NewsSelectServlet2.class 2KB NewsSelectServlet2.class 2KB DoProductClassAddServlet.class 2KB DoProductClassAddServlet.class 2KB ToProductClassUpdateServlet.class 2KB ToProductClassUpdateServlet.class 2KB NewsDelServlet.class 2KB NewsDelServlet.class 2KB共 863 条
- 1
- 2
- 3
- 4
- 5
- 6
- 9
资源评论
等天晴i
- 粉丝: 3478
- 资源: 10万+
最新资源
- pta题库答案c语言之排序4统计工龄.zip
- pta题库答案c语言之树结构7堆中的路径.zip
- pta题库答案c语言之树结构3TreeTraversalsAgain.zip
- pta题库答案c语言之树结构2ListLeaves.zip
- pta题库答案c语言之树结构1树的同构.zip
- 基于C++实现民航飞行与地图简易管理系统可执行程序+说明+详细注释.zip
- pta题库答案c语言之复杂度1最大子列和问题.zip
- 三维装箱问题（Three-Dimensional Bin Packing Problem,3D-BPP）是一个经典的组合优化问题
- 以下是一些关于Linux线程同步的基本概念和方法.txt
- 以下是一个简化的示例，它使用pygame库来模拟烟花动画的框架.txt
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
