商家功能：

對書籍進(jìn)行增加，上架，下架操作

一、書籍的增加

1、加載書籍類別下拉框

①Category

package com.dhm.entity;public class Category {private long id;private String name;public long getId() {return id;}public void setId(long id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}@Overridepublic String toString() {return "Category [id=" + id + ", name=" + name + "]";}}

②CategoryDao

package com.dhm.dao;import java.util.List;import com.dhm.entity.Category; import com.zking.util.BaseDao; import com.zking.util.PageBean;public class CategoryDao extends BaseDao<Category>{public List<Category> list(Category category, PageBean pageBean) throws Exception {String sql="select * from t_easyui_category";return super.executeQuery(sql, Category.class, pageBean);} }

③CategoryAction

package com.dhm.web;import java.util.List;import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;import com.dhm.dao.CategoryDao; import com.dhm.entity.Category; import com.zking.framework.ActionSupport; import com.zking.framework.ModelDriver; import com.zking.util.ResponseUtil;public class CategoryAction extends ActionSupport implements ModelDriver<Category>{private Category category=new Category();private CategoryDao categoryDao=new CategoryDao();public Category getModel() {return category;}/*** 加載書籍類別下拉框* @param req* @param resp* @return*/public String combobox(HttpServletRequest req, HttpServletResponse resp) {try {List<Category> list = categoryDao.list(category, null);ResponseUtil.writeJson(resp, list);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return null;}}

js代碼：

/* 類別下拉框顯示 */$(function () {$('#cid').combobox({url:'${pageContext.request.contextPath}/category.action?methodName=combobox',valueField:'id',textField:'name'});});function submitForm() {$('#ff').form('submit',{url:'${pageContext.request.contextPath}/book.action?methodName=add',success:function(data){if(data == 1){$('#ff').form('clear');}}});}function clearForm() {$('#ff').form('clear');}

?效果展示：

?

二、增加書籍/上架/下架

①、Book

package com.dhm.entity;import java.util.Date;public class Book {private long id;private String name;private String pinyin;private long cid;private String author;private float price;private String image;private String publishing;private String description;private int state;private Date deployTime;private int sales;public long getId() {return id;}public void setId(long id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getPinyin() {return pinyin;}public void setPinyin(String pinyin) {this.pinyin = pinyin;}public long getCid() {return cid;}public void setCid(long cid) {this.cid = cid;}public String getAuthor() {return author;}public void setAuthor(String author) {this.author = author;}public float getPrice() {return price;}public void setPrice(float price) {this.price = price;}public String getImage() {return image;}public void setImage(String image) {this.image = image;}public String getPublishing() {return publishing;}public void setPublishing(String publishing) {this.publishing = publishing;}public String getDescription() {return description;}public void setDescription(String description) {this.description = description;}public int getState() {return state;}public void setState(int state) {this.state = state;}public Date getDeployTime() {return deployTime;}public void setDeployTime(Date deployTime) {this.deployTime = deployTime;}public int getSales() {return sales;}public void setSales(int sales) {this.sales = sales;}@Overridepublic String toString() {return "Book [id=" + id + ", name=" + name + ", pinyin=" + pinyin + ", cid=" + cid + ", author=" + author+ ", price=" + price + ", image=" + image + ", publishing=" + publishing + ", description="+ description + ", state=" + state + ", deployTime=" + deployTime + ", sales=" + sales + "]";}}

②、BookDao

package com.dhm.dao;import java.util.Date; import java.util.List;import com.dhm.entity.Book; import com.dhm.utils.PinYinUtil; import com.zking.util.BaseDao; import com.zking.util.PageBean; import com.zking.util.StringUtils;public class BookDao extends BaseDao<Book>{ /*** 查詢* @param sql* @param clz* @param pageBean* @return* @throws Exception*/public List<Book> list(Book book, PageBean pageBean) throws Exception {String sql="select * from t_easyui_book where 1=1";String name = book.getName();int state = book.getState();if(StringUtils.isNotBlank(name)) {sql+=" and name like '%"+name+"%'";}if(state!=0) {sql+=" and state= "+state;}return super.executeQuery(sql, Book.class, pageBean);}/*** 修改* @param sql* @param clz* @param pageBean* @return* @throws Exception*/ public void edit(Book b) throws Exception {String sql="update t_easyui_book set name=?,pinyin=?,cid=?,author=?,price=?,image=?,state=?,sales=? where id=?";super.executeUpdate(sql, b, new String[] {"name","pinyin","cid","author","price","image","state","sales","id"});}/*** 增加* @param sql* @param clz* @param pageBean* @return* @throws Exception*/public void add(Book b) throws Exception {b.setPinyin(PinYinUtil.getAllPingYin(b.getName()));b.setDeployTime(new Date());String sql="insert into t_easyui_book(name,pinyin,cid,author,price,image,publishing,description,state,deployTime,sales) values(?,?,?,?,?,?,?,?,?,?,?)";super.executeUpdate(sql, b, new String[] {"name","pinyin","cid","author","price","image","publishing","description","state","deployTime","sales"}); }public void editStatus(Book book) throws Exception {String sql="update t_easyui_book set state=? where id=?";super.executeUpdate(sql, book, new String[] {"state","id"}); } }

③、BookAction

package com.dhm.web;import java.util.List;import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;import com.dhm.dao.BookDao; import com.dhm.entity.Book; import com.zking.framework.ActionSupport; import com.zking.framework.ModelDriver; import com.zking.util.PageBean; import com.zking.util.R; import com.zking.util.ResponseUtil;public class BookAction extends ActionSupport implements ModelDriver<Book>{private Book book=new Book();private BookDao bookDao =new BookDao();public Book getModel() {return book;}/*** 查詢上架下架書籍* @param req* @param resp* @return*/public void list(HttpServletRequest req, HttpServletResponse resp) {PageBean pageBean =new PageBean();pageBean.setRequest(req);try {List<Book> list = bookDao.list(book, pageBean );ResponseUtil.writeJson(resp, new R().data("total", pageBean.getTotal()).data("rows", list));} catch (Exception e) {e.printStackTrace();}}/*** * @param req* @param resp* @return*/ public void add(HttpServletRequest req, HttpServletResponse resp) {try {bookDao.add(book);ResponseUtil.writeJson(resp, 1);} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp, 0);} catch (Exception e1) {e1.printStackTrace();}} }/*** 如果上架書籍的狀態(tài)改為2，如果下架改為3* @param req* @param resp*/ public void editStatus(HttpServletRequest req, HttpServletResponse resp) {try {bookDao.editStatus(book);ResponseUtil.writeJson(resp, 1);} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp, 0);} catch (Exception e1) {e1.printStackTrace();}} }}

④、mvc2.xml?

<?xml version="1.0" encoding="UTF-8"?> <config><action path="/user" type="com.dhm.web.UserAction"><forward name="main" path="/bg/mainTemp.jsp" redirect="false" /><forward name="toLogin" path="/login.jsp" redirect="true" /><forward name="toRegister" path="/register.jsp" redirect="false" /></action><action path="/permission" type="com.dhm.web.PermissionAction"></action><action path="/category" type="com.dhm.web.CategoryAction"></action><action path="/book" type="com.dhm.web.BookAction"></action> </config>

js代碼

上架 function shangjia() {$.messager.confirm('確認(rèn)','您確認(rèn)想要上架此書籍嗎？',function(r){if (r){var row = $('#dg').datagrid('getSelected');if (row){$.ajax({url:'${pageContext.request.contextPath}/book.action?methodName=editStatus&state=2&id=' + row.id,success:function (data) {}})} }});下架function xiajia() {$.messager.confirm('確認(rèn)','您確認(rèn)想要下架此書籍嗎？',function(r){if (r){var row = $('#dg').datagrid('getSelected');if (row){$.ajax({url:'${pageContext.request.contextPath}/book.action?methodName=editStatus&state=3&id=' + row.id,success:function (data) {}})}}});

效果展示：

為上架書籍：

?已上架書籍：

?已下架書籍：

?

?

總結(jié)

以上是生活随笔為你收集整理的项目之书籍管理的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。