基于javaweb的网上书店系统/网上书城系统/书店管理系统Java｜JSP | Servlet mysql | tomcat
·
网上书店系统/网上书城系统/书店管理系统
获取完整项目
https://pan.baidu.com/s/1VraXSIZjkt2yT2QwTzokqw?pwd=c27u 提取码: c27u
项目合集
https://pan.baidu.com/s/1K2f-s3A_MVdfIA9393cYWg?pwd=gut6 提取码: gut6
有问题，或者需要协助调试运行项目的也可以
功能:
用户功能: 在线查看当前图书信息，加入购物车，订单支付，个人信息管理等功能
管理员功能: 进行发货，订单信息管理，图书商品信息管理，用户信息管理等功能
一、项目文档
二、项目页面展示
三、部分代码
package com.shine.bookshop.bean;
import java.util.Date;
import java.util.Map;
/**
* 管理员用户类
*
*
*/
public class Admin {
private Integer id; //用户编号
private String userName; //用户名
private String passWord; //用户密码
private String name; //用户姓名
private Date lastLoginTime; //最后登录时间
public Admin() {}
public Admin(String userName,String passWord) {
this.userName=userName;
this.passWord=passWord;
}
public Admin(Integer id, String passWord, String name) {
super();
this.id = id;
this.passWord = passWord;
this.name = name;
}
public Admin(String userName, String passWord, String name) {
super();
this.userName = userName;
this.passWord = passWord;
this.name = name;
}
public Admin(Map<String,Object> map) {
this.id = (Integer) map.get("id");
this.userName=(String) map.get("userName");
this.passWord = (String) map.get("passWord");
this.name = (String) map.get("name");
this.lastLoginTime=(Date) map.get("lastLoginTime");
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassWord() {
return passWord;
}
public void setPassWord(String passWord) {
this.passWord = passWord;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Date getLastLoginTime() {
return lastLoginTime;
}
public void setLastLoginTime(Date lastLoginTime) {
this.lastLoginTime = lastLoginTime;
}
}
package com.shine.bookshop.bean;
import java.util.Date;
import java.util.Map;
public class Book {
private int bookId; // 图书编号
private String bookName; // 图书名称
private double price; // 价格
private String description; // 描述信息
private String author; // 图书作者
private String press; // 图书出版社
private int catalogId; // 图书分类id
private int imgId; // 图片id
private Date addTime;//上架时间
private Catalog catalog = new Catalog(); // 图书分类类属性
private UpLoadImg upLoadImg = new UpLoadImg(); // 图片类属性
public Book() {
}
// 这里是从数据库获取时集合转对象
public Book(Map<String, Object> map) {
this.bookId = (int) map.get("bookId");
this.bookName = (String) map.get("bookName");
this.price = (double) map.get("price");
this.description = (String) map.get("description");
this.author = (String) map.get("author");
this.press = (String) map.get("press");
this.addTime=(Date) map.get("addTime");
this.catalog = new Catalog(map);
this.upLoadImg = new UpLoadImg(map);
}
public int getBookId() {
return bookId;
}
public void setBookId(int bookId) {
this.bookId = bookId;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public String getPress() {
return press;
}
public void setPress(String press) {
this.press = press;
}
public int getCatalogId() {
this.catalogId = this.catalog.getCatalogId();
return catalogId;
}
public void setCatalogId(int catalogId) {
this.catalog.setCatalogId(catalogId);
}
public int getImgId() {
this.imgId = this.upLoadImg.getImgId();
return imgId;
}
public void setImgId(int imgId) {
this.upLoadImg.setImgId(imgId);
;
}
public Catalog getCatalog() {
return catalog;
}
public void setCatalog(Catalog catalog) {
this.catalog = catalog;
}
public UpLoadImg getUpLoadImg() {
return upLoadImg;
}
public void setUpLoadImg(UpLoadImg upLoadImg) {
this.upLoadImg = upLoadImg;
}
public Date getAddTime() {
return addTime;
}
public void setAddTime(Date addTime) {
this.addTime = addTime;
}
@Override
public String toString() {
return "Book [bookId=" + bookId + ", bookName=" + bookName + ", price=" + price + ", description=" + description
+ ", author=" + author + ", press=" + press + ", catalogId=" + catalogId + ", imgId=" + imgId
+ ", catalog=" + catalog + ", upLoadImg=" + upLoadImg + "]";
}
}
package com.shine.bookshop.bean;
import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
public class Order {
private int orderId; //订单编号
private String orderNum; //订单号
private int userId; //用户编号
private String orderDate; //订单日期
private double money; //订单金额
private int orderStatus; //订单状态
private List<OrderItem> oItem=new ArrayList<>();
private User user=new User();
public Order() {
}
public Order(Map<String, Object> map) {
this.setOrderId((int) map.get("orderId"));
this.setOrderNum((String) map.get("orderNum"));
this.setUserId((int) map.get("userId"));
this.setOrderDate((String) map.get("orderDate"));
this.setMoney((double) map.get("money"));
this.setOrderStatus((int) map.get("orderStatus"));
}
public int getOrderId() {
return orderId;
}
public void setOrderId(int orderId) {
this.orderId = orderId;
}
public String getOrderNum() {
return orderNum;
}
public void setOrderNum(String orderNum) {
this.orderNum = orderNum;
}
public int getUserId() {
return userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
public String getOrderDate() {
return orderDate;
}
public void setOrderDate(String orderDate) {
this.orderDate = orderDate;
}
public int getOrderStatus() {
return orderStatus;
}
public void setOrderStatus(int orderStatus) {
this.orderStatus = orderStatus;
}
public List<OrderItem> getoItem() {
return oItem;
}
public void setoItem(List<OrderItem> oItem) {
this.oItem = oItem;
}
public double getMoney() {
return money;
}
public void setMoney(double money) {
this.money = money;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
}
package com.shine.bookshop.dao.impl;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import com.shine.bookshop.bean.Admin;
import com.shine.bookshop.bean.PageBean;
import com.shine.bookshop.dao.AdminDao;
import com.shine.bookshop.util.DateUtil;
import com.shine.bookshop.util.DbUtil;
public class AdminDaoImpl implements AdminDao {
/**
* @param user 传递要登录的用户信息
* @return 返回一个boolean值，true登录成功，false失败
*/
@Override
public boolean userLogin(Admin admin) {
boolean flag=false;
String sql="select * from s_admin where userName=? and passWord=?";
String sql2="update s_admin set lastLoginTime=? where id=?";
List<Map<String,Object>> list=DbUtil.executeQuery(sql, admin.getUserName(),admin.getPassWord());
if(list.size()>0){
flag=true;
//这里需要name值传入对象中
admin.setName((String)list.get(0).get("name"));
//通过登录成功用户的id更新最后登录时间
DbUtil.excuteUpdate(sql2, DateUtil.getTimestamp(),list.get(0).get("id"));
}
return flag;
}
/**
* @param pageBean 传递分页对象
* @return 返回一个list集合，这里是通过limit分页查询的结果
*/
@Override
public List<Admin> userList(PageBean pageBean) {
List<Admin> lu=new ArrayList<>();
List<Map<String, Object>> list=new ArrayList<Map<String,Object>>();
String sql="select * from s_admin limit ?,?";
list=DbUtil.executeQuery(sql,(pageBean.getCurPage()-1)*pageBean.getMaxSize(),pageBean.getMaxSize());
if(list.size()>0) {
for(Map<String,Object> map:list) {
Admin u=new Admin(map);
lu.add(u);
}
}
return lu;
}
/**
* @param user 要增加的用户对象
* @return 返回一个boolean true用户增加成功 false用户增加失败
*/
@Override
public boolean userAdd(Admin user) {
String sql="insert into s_admin(userName,password,name) values(?,?,?)";
int i= DbUtil.excuteUpdate(sql, user.getUserName(),user.getPassWord(),user.getName());
return i>0?true:false;
}
/**
* @param id 根据id查找一个用户信息
* @return 返回一个list用户信息集合
*/
//查找指定id用户信息
@Override
public Admin findUser(Integer id) {
String sql="select * from s_admin where id=?";
Admin admin=null;
List<Map<String,Object>> list=DbUtil.executeQuery(sql, id);
if(list.size()>0) {
admin=new Admin(list.get(0));
}
return admin;
}
//查找用户名是否存在true存在
@Override
public boolean findUser(String userName) {
String sql="select * from s_admin where userName=?";
List<Map<String,Object>> list=DbUtil.executeQuery(sql, userName);
return list.size()>0?true:false;
}
/**
*
* @param admin 更新用户,根据传过来的id
* @return boolean
*/
@Override
public boolean userUpdate(Admin admin) {
String sql="update s_admin set password=? , name=? where id =?";
int i=DbUtil.excuteUpdate(sql, admin.getPassWord(),admin.getName(),admin.getId());
return i>0?true:false;
}
/**
* @param id 要删除的用户id
* @return 返回boolean true删除用户成功，false删除用户失败
*/
@Override
public boolean delUser(int id) {
String sql="delete from s_admin where id=?";
int i=DbUtil.excuteUpdate(sql, id);
return i>0?true:false;
}
/**
* @param ids 要批量删除id组的字符串
*/
@Override
public boolean batDelUser(String ids) {
String sql="delete from s_admin where id in ("+ids+")";
int i=DbUtil.excuteUpdate(sql);
return i>0?true:false;
}
@Override
public long bookReadCount() {
long count=0;
String sql="select count(*) as count from s_admin";
List<Map<String, Object>> lm=DbUtil.executeQuery(sql);
if(lm.size()>0){
count=(long) lm.get(0).get("count");
}
return count;
}
}
package com.shine.bookshop.dao.impl;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import com.shine.bookshop.bean.Book;
import com.shine.bookshop.bean.Catalog;
import com.shine.bookshop.bean.PageBean;
import com.shine.bookshop.bean.UpLoadImg;
import com.shine.bookshop.dao.BookDao;
import com.shine.bookshop.util.DateUtil;
import com.shine.bookshop.util.DbUtil;
public class BookDaoImpl implements BookDao {
@Override
public List<Book> bookList(PageBean pageBean) {
List<Book> list = new ArrayList<>();
String sql = "select * from view_book limit ?,?";
// 查询的分页结果集
List<Map<String, Object>> lm = DbUtil.executeQuery(sql, (pageBean.getCurPage() - 1) * pageBean.getMaxSize(),
pageBean.getMaxSize());
// 把查询的book结果由List<Map<String, Object>>转换为List<Book>
if (lm.size() > 0) {
for (Map<String, Object> map : lm) {
Book book = new Book(map);
list.add(book);
}
}
return list;
}
@Override
public long bookReadCount() {
String sql = "select count(*) as count from s_book";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql);
return lm.size() > 0 ? (long) lm.get(0).get("count") : 0;
}
@Override
public boolean bookAdd(Book book) {
String sql = "insert into s_book(bookName,catalogId,author,press,price,description,imgId,addTime) values(?,?,?,?,?,?,?,?)";
int i = DbUtil.excuteUpdate(sql, book.getBookName(), book.getCatalog().getCatalogId(), book.getAuthor(),
book.getPress(), book.getPrice(), book.getDescription(), book.getUpLoadImg().getImgId(),
DateUtil.getTimestamp());
return i > 0 ? true : false;
}
@Override
public Book findBookById(int bookId) {
String sql = "select * from view_book where bookId=?";
Book book = null;
List<Map<String, Object>> list = DbUtil.executeQuery(sql, bookId);
if (list.size() > 0) {
book = new Book(list.get(0));
}
return book;
}
/**
*
*/
@Override
public boolean findBookByBookName(String bookName) {
String sql = "select * from s_book where bookName=?";
List<Map<String, Object>> list = DbUtil.executeQuery(sql, bookName);
return list.size() > 0 ? true : false;
}
/**
* 更新图书信息
*/
@Override
public boolean bookUpdate(Book book) {
String sql = "update s_book set catalogId=?,author=?,press=?,price=?,description=? where bookId=?";
int i = DbUtil.excuteUpdate(sql, book.getCatalogId(), book.getAuthor(), book.getPress(), book.getPrice(),
book.getDescription(), book.getBookId());
return i > 0 ? true : false;
}
/**
* 图书删除
*/
@Override
public boolean bookDelById(int bookId) {
String sql = "SET FOREIGN_KEY_CHECKS = 0;delete from s_book where bookId=?";
int i = DbUtil.excuteUpdate(sql, bookId);
return i > 0 ? true : false;
}
/**
* 批量查询
*/
@Override
public String findimgIdByIds(String ids) {
String imgIds = "";
String sql = "select imgId from s_book where bookId in(" + ids + ")";
List<Map<String, Object>> list = DbUtil.executeQuery(sql);
if (list.size() > 0) {
for (int i = 0; i < list.size(); i++) {
if (i != list.size() - 1) {
imgIds += list.get(i).get("imgId") + ",";
} else {
imgIds += list.get(i).get("imgId");
}
}
}
return imgIds;
}
// 批量删除
@Override
public boolean bookBatDelById(String ids) {
String sql = "delete from s_book where bookId in(" + ids + ")";
int i = DbUtil.excuteUpdate(sql);
return i > 0 ? true : false;
}
// 随机查询一定数量的书
@Override
public List<Book> bookList(int num) {
List<Book> list = new ArrayList<>();
String sql = "select * from view_book order by rand() LIMIT ?";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql, num);
// 把查询的book结果由List<Map<String, Object>>转换为List<Book>
if (lm.size() > 0) {
for (Map<String, Object> map : lm) {
Book book = new Book(map);
list.add(book);
}
}
return list;
}
/**
* 查询指定数量新书
*/
@Override
public List<Book> newBooks(int num) {
List<Book> list = new ArrayList<>();
String sql = "SELECT * FROM view_book ORDER BY addTime desc limit 0,?";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql, num);
// 把查询的book结果由List<Map<String, Object>>转换为List<Book>
if (lm.size() > 0) {
for (Map<String, Object> map : lm) {
Book book = new Book(map);
list.add(book);
}
}
return list;
}
/**
* 按分类id统计图书数量
*/
@Override
public long bookReadCount(int catalogId) {
String sql = "select count(*) as count from s_book where catalogId=?";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql, catalogId);
return lm.size() > 0 ? (long) lm.get(0).get("count") : 0;
}
/**
* 按分类id获取图书列表
*/
@Override
public List<Book> bookList(PageBean pageBean, int catalogId) {
List<Book> list = new ArrayList<>();
String sql = "select * from view_book where catalogId=? limit ?,?";
// 查询的分页结果集
List<Map<String, Object>> lm = DbUtil.executeQuery(sql, catalogId,
(pageBean.getCurPage() - 1) * pageBean.getMaxSize(), pageBean.getMaxSize());
// 把查询的book结果由List<Map<String, Object>>转换为List<Book>
if (lm.size() > 0) {
for (Map<String, Object> map : lm) {
Book book = new Book(map);
list.add(book);
}
}
return list;
}
/**
* 按分类id获取图书列表
*/
@Override
public List<Book> bookList(PageBean pageBean, String bookname) {
List<Book> list = new ArrayList<>();
String sql = "select * from view_book where bookName like '%"+bookname+"%' limit ?,?";
// 查询的分页结果集
List<Map<String, Object>> lm = DbUtil.executeQuery(sql,
(pageBean.getCurPage() - 1) * pageBean.getMaxSize(), pageBean.getMaxSize());
// 把查询的book结果由List<Map<String, Object>>转换为List<Book>
if (lm.size() > 0) {
for (Map<String, Object> map : lm) {
Book book = new Book(map);
list.add(book);
}
}
return list;
}
@Override
public long bookReadCount(String bookname) {
String sql = "select count(*) as count from s_book where bookName like '%"+bookname+"%'";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql);
return lm.size() > 0 ? (long) lm.get(0).get("count") : 0;
}
}
package com.shine.bookshop.dao.impl;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import com.shine.bookshop.bean.Catalog;
import com.shine.bookshop.bean.PageBean;
import com.shine.bookshop.dao.CatalogDao;
import com.shine.bookshop.util.DbUtil;
public class CatalogDaoImpl implements CatalogDao {
/**
* 获取图书分类信息
*/
@Override
public List<Catalog> catalogList(PageBean pb) {
List<Catalog> list=new ArrayList<Catalog>();
String sql = "select * from s_catalog limit ?,?";
// 查询的分页结果集
List<Map<String, Object>> lm = DbUtil.executeQuery(sql, (pb.getCurPage() - 1) * pb.getMaxSize(),
pb.getMaxSize());
if(lm.size()>0){
for(Map<String,Object> map:lm){
Catalog catalog=new Catalog(map);
list.add(catalog);
}
}
return list;
}
@Override
public long catalogReadCount() {
long count=0;
String sql="select count(*) as count from s_catalog";
List<Map<String, Object>> lm=DbUtil.executeQuery(sql);
if(lm.size()>0){
count=(long) lm.get(0).get("count");
}
return count;
}
@Override
public List<Catalog> getCatalog() {
List<Catalog> list=new ArrayList<Catalog>();
String sql="select * from s_catalog";
List<Map<String,Object>> lmso=DbUtil.executeQuery(sql);
if(lmso.size()>0){
for(Map<String,Object> map:lmso){
Catalog catalog=new Catalog(map);
list.add(catalog);
}
}
return list;
}
@Override
public boolean catalogDel(int catalogId) {
String sql = "delete from s_catalog where catalogId=?";
int i = DbUtil.excuteUpdate(sql, catalogId);
return i > 0 ? true : false;
}
@Override
public boolean catalogBatDelById(String ids) {
String sql="delete from s_catalog where catalogId in("+ids+")";
int i=DbUtil.excuteUpdate(sql);
return i>0?true:false;
}
@Override
public boolean findCatalogByCatalogName(String catalogName) {
String sql = "select * from s_catalog where catalogName=?";
List<Map<String, Object>> list = DbUtil.executeQuery(sql, catalogName);
return list.size() > 0 ? true : false;
}
@Override
public boolean catalogAdd(String catalogName) {
String sql="insert into s_catalog(catalogName) values(?)";
int i = DbUtil.excuteUpdate(sql, catalogName);
return i > 0 ? true : false;
}
}
package com.shine.bookshop.dao.impl;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import com.shine.bookshop.bean.Order;
import com.shine.bookshop.bean.PageBean;
import com.shine.bookshop.bean.User;
import com.shine.bookshop.dao.OrderDao;
import com.shine.bookshop.util.DbUtil;
/**
* @version 创建时间：2017年10月27日 下午11:12:29
*/
public class OrderDaoImpl implements OrderDao {
/**
* 向s_order插入一条订单记录
*/
@Override
public boolean orderAdd(Order order) {
String sql="insert into s_order(orderNum,userId,orderDate,orderStatus,money) values(?,?,?,?,?)";
int i= DbUtil.excuteUpdate(sql,order.getOrderNum(),order.getUserId(),order.getOrderDate(),order.getOrderStatus(),order.getMoney());
return i>0?true:false;
}
/**
* by订单号查询订单编号
*/
@Override
public int findOrderIdByOrderNum(String orderNum) {
int orderId=0;
String sql="select orderId from s_order where orderNum=?";
List<Map<String, Object>> query = DbUtil.executeQuery(sql, orderNum);
if(query.size()>0) {
orderId=(int) query.get(0).get("orderId");
}
return orderId;
}
@Override
public long orderReadCount(int userId) {
String sql = "select count(*) as count from s_order where userId=?";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql,userId);
return lm.size() > 0 ? (long) lm.get(0).get("count") : 0;
}
@Override
public List<Order> orderList(PageBean pageBean,int userId) {
List<Order> lo=new ArrayList<>();
List<Map<String, Object>> list=new ArrayList<Map<String,Object>>();
String sql="select * from s_order where userId=? limit ?,?";
list=DbUtil.executeQuery(sql,userId,(pageBean.getCurPage()-1)*pageBean.getMaxSize(),pageBean.getMaxSize());
if(list.size()>0) {
for(Map<String,Object> map:list) {
Order order=new Order(map);
lo.add(order);
}
}
return lo;
}
@Override
public List<Order> orderList(PageBean pageBean,String ordernum) {
List<Order> lo=new ArrayList<>();
List<Map<String, Object>> list=new ArrayList<Map<String,Object>>();
String sql="select * from s_order where orderNum like '%"+ordernum+"%' limit ?,?";
list=DbUtil.executeQuery(sql,(pageBean.getCurPage()-1)*pageBean.getMaxSize(),pageBean.getMaxSize());
if(list.size()>0) {
for(Map<String,Object> map:list) {
Order order=new Order(map);
lo.add(order);
}
}
return lo;
}
@Override
public long orderReadCount() {
String sql = "select count(*) as count from s_order";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql);
return lm.size() > 0 ? (long) lm.get(0).get("count") : 0;
}
@Override
public List<Order> orderList(PageBean pageBean) {
List<Order> lo=new ArrayList<>();
List<Map<String, Object>> list=new ArrayList<Map<String,Object>>();
String sql="select * from s_order limit ?,?";
list=DbUtil.executeQuery(sql,(pageBean.getCurPage()-1)*pageBean.getMaxSize(),pageBean.getMaxSize());
if(list.size()>0) {
for(Map<String,Object> map:list) {
Order order=new Order(map);
lo.add(order);
}
}
return lo;
}
@Override
public Order findOrderByOrderId(int orderId) {
Order order=null;
String sql="select * from s_order where orderId=?";
List<Map<String, Object>> query = DbUtil.executeQuery(sql, orderId);
if(query.size()>0) {
order=new Order(query.get(0));
}
return order;
}
@Override
public long orderReadCountByStatus(int status) {
String sql = "select count(*) as count from s_order where orderStatus=?";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql,status);
return lm.size() > 0 ? (long) lm.get(0).get("count") : 0;
}
@Override
public long orderReadCountByStatus(int status,String ordernum) {
String sql = "select count(*) as count from s_order where orderStatus=? and orderNum like '%"+ordernum+"%'";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql,status);
return lm.size() > 0 ? (long) lm.get(0).get("count") : 0;
}
@Override
public List<Order> orderListByStatus(PageBean pageBean, int status) {
List<Order> lo=new ArrayList<>();
List<Map<String, Object>> list=new ArrayList<Map<String,Object>>();
String sql="select * from s_order where orderStatus=? limit ?,?";
list=DbUtil.executeQuery(sql,status,(pageBean.getCurPage()-1)*pageBean.getMaxSize(),pageBean.getMaxSize());
if(list.size()>0) {
for(Map<String,Object> map:list) {
Order order=new Order(map);
lo.add(order);
}
}
return lo;
}
@Override
public List<Order> orderListByStatus(PageBean pageBean, int status, String ordernum) {
List<Order> lo=new ArrayList<>();
List<Map<String, Object>> list=new ArrayList<Map<String,Object>>();
String sql="select * from s_order where orderStatus=? and ordernum like '%"+ordernum+"%' limit ?,?";
list=DbUtil.executeQuery(sql,status,(pageBean.getCurPage()-1)*pageBean.getMaxSize(),pageBean.getMaxSize());
if(list.size()>0) {
for(Map<String,Object> map:list) {
Order order=new Order(map);
lo.add(order);
}
}
return lo;
}
@Override
public boolean orderStatus(int orderId,int status) {
String sql="update s_order set orderStatus=? where orderId=?";
int i = DbUtil.excuteUpdate(sql, status,orderId);
return i>0?true:false;
}
@Override
public long orderReadCount(String ordernum) {
String sql = "select count(*) as count from s_order where orderNum like '%"+ordernum+"%'";
List<Map<String, Object>> lm = DbUtil.executeQuery(sql);
return lm.size() > 0 ? (long) lm.get(0).get("count") : 0;
}
@Override
public boolean deleteOrder(int orderid) {
String sql = "delete from s_order where orderId=?";
int i = DbUtil.excuteUpdate(sql, orderid);
return i > 0 ? true : false;
}
@Override
public boolean deleteOrderItem(int orderid) {
String sql = "delete from s_orderitem where orderId=?";
int i = DbUtil.excuteUpdate(sql, orderid);
return i > 0 ? true : false;
}
}
package com.shine.bookshop.dao.impl;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import com.shine.bookshop.bean.Admin;
import com.shine.bookshop.bean.PageBean;
import com.shine.bookshop.bean.User;
import com.shine.bookshop.dao.UserDao;
import com.shine.bookshop.util.DbUtil;
/**
* @version 创建时间：2017年10月24日 下午7:26:31
*/
public class UserDaoImpl implements UserDao {
@Override
public long bookReadCount() {
long count=0;
String sql="select count(*) as count from s_user";
List<Map<String, Object>> lm=DbUtil.executeQuery(sql);
if(lm.size()>0){
count=(long) lm.get(0).get("count");
}
return count;
}
@Override
public long bookReadCount(String username) {
long count=0;
String sql="select count(*) as count from s_user where userName like '%"+username+"%'";
List<Map<String, Object>> lm=DbUtil.executeQuery(sql);
if(lm.size()>0){
count=(long) lm.get(0).get("count");
}
return count;
}
@Override
public List<User> userList(PageBean pageBean) {
List<User> lu=new ArrayList<>();
List<Map<String, Object>> list=new ArrayList<Map<String,Object>>();
String sql="select * from s_user limit ?,?";
list=DbUtil.executeQuery(sql,(pageBean.getCurPage()-1)*pageBean.getMaxSize(),pageBean.getMaxSize());
if(list.size()>0) {
for(Map<String,Object> map:list) {
User u=new User(map);
lu.add(u);
}
}
return lu;
}
@Override
public List<User> userList(PageBean pageBean,String username) {
List<User> lu=new ArrayList<>();
List<Map<String, Object>> list=new ArrayList<Map<String,Object>>();
String sql="select * from s_user where userName like '%"+username+"%' limit ?,?";
list=DbUtil.executeQuery(sql,(pageBean.getCurPage()-1)*pageBean.getMaxSize(),pageBean.getMaxSize());
if(list.size()>0) {
for(Map<String,Object> map:list) {
User u=new User(map);
lu.add(u);
}
}
return lu;
}
@Override
public boolean findUser(String userName) {
String sql="select * from s_user where userName=?";
List<Map<String,Object>> list=DbUtil.executeQuery(sql, userName);
return list.size()>0?true:false;
}
/**
* @param user 要增加的用户对象
* @return 返回一个boolean true用户增加成功 false用户增加失败
*/
@Override
public boolean userAdd(User user) {
String sql="insert into s_user(userName,userPassWord,name,sex,age,tell,address,enabled) values(?,?,?,?,?,?,?,?)";
int i= DbUtil.excuteUpdate(sql, user.getUserName(),user.getUserPassWord(),user.getName(),user.getSex(),user.getAge()
,user.getTell(),user.getAddress(),user.getEnabled());
return i>0?true:false;
}
/**
* @param id 根据id查找一个用户信息
* @return 返回一个list用户信息集合
*/
//查找指定id用户信息
@Override
public User findUser(Integer id) {
String sql="select * from s_user where userId=?";
User u=null;
List<Map<String,Object>> list=DbUtil.executeQuery(sql, id);
if(list.size()>0) {
u=new User(list.get(0));
}
return u;
}
/**
*
* @param admin 更新用户,根据传过来的id
* @return boolean
*/
@Override
public boolean userUpdate(User user) {
String sql="update s_user set userPassWord=?,name=?,sex=?,age=?,tell=?,address=?,enabled=? where userId =?";
int i=DbUtil.excuteUpdate(sql,user.getUserPassWord(),user.getName(),user.getSex(),user.getAge()
,user.getTell(),user.getAddress(),user.getEnabled(),user.getUserId());
return i>0?true:false;
}
/**
* @param id 要删除的用户id
* @return 返回boolean true删除用户成功，false删除用户失败
*/
@Override
public boolean delUser(int id) {
String sql="delete from s_user where userId=?";
int i=DbUtil.excuteUpdate(sql, id);
return i>0?true:false;
}
/**
* @param ids 要批量删除id组的字符串
*/
@Override
public boolean batDelUser(String ids) {
String sql="delete from s_user where userId in ("+ids+")";
int i=DbUtil.excuteUpdate(sql);
return i>0?true:false;
}
@Override
public User userLogin(User user) {
User user1=null;
String sql="select * from s_user where userName=? and userPassWord=?";
List<Map<String, Object>> list = DbUtil.executeQuery(sql, user.getUserName(),user.getUserPassWord());
if(list.size()>0) {
Map<String, Object> map = list.get(0);
user1=new User(map);
}
return user1;
}
}
更多推荐
4
0- 0
已为社区贡献11条内容
所有评论(0)