一、新增頁面書籍類別下拉框加載

1.1書籍類別的實體類：

package com.zw.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 + "]";}}

1.2.CategoryDao:

public class CategoryDao extends BaseDao<Category>{public List<Category> list(Category category, PageBean pageBean) throws Exception {String sql="select * from t_easyui_category where 1=1";long id = category.getId();if(id!=0) {sql+=" and id="+id;}return super.executeQuery(sql, Category.class, pageBean);}}

1.3.CategoryAction:

public class CategoryAction extends ActionSupport implements ModelDriver<Category>{private Category category=new Category();private CategoryDao categoryDao=new CategoryDao();@Overridepublic 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) {e.printStackTrace();}return null;}public String load(HttpServletRequest req, HttpServletResponse resp) {try { // 傳遞id到后臺，只會查出一個類別Category c = categoryDao.list(category, null).get(0);ResponseUtil.writeJson(resp, c);} catch (Exception e) {e.printStackTrace();}return null;}}

1.4.js文件：

$(function(){$("#bookMenus").tree({url:$("#ctx").val()+"/permission.action?methodName=tree", // 給菜單欄一個點擊onClick: function(node){console.log($("#ctx").val()+node.attributes.self.url) // 判斷面板是否存在var exists=$("#bookTabs").tabs('exists',node.text);if(exists){$("#bookTabs").tabs('select',node.text);}else{$('#bookTabs').tabs('add',{ title:node.text, content:'<iframe width="100%" height="100%" src="'+$("#ctx").val()+node.attributes.self.url+'" />', closable:true}); }}}); })

展示效果：

?2.新增

2.1Book類：

package com.zw.entity;import java.util.Date;import com.fasterxml.jackson.annotation.JsonFormat;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;@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")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 + "]";}}

2.2BookDao:

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"});}

2.3BookAction:

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();}}}

2.4獲取數(shù)據(jù)，提交表單：

/* 通過form控件提交 */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');}

二、上下架功能

1.上架

// 查詢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);}// 上下架public void editStatus(Book book) throws Exception {super.executeUpdate("update t_easyui_book set state=? where id=?", book,new String[] {"state","id"});}

2.Action(子控制器)

public void list(HttpServletRequest req, HttpServletResponse resp) {PageBean pageBean=new PageBean();pageBean.setRequest(req);try {List<Book> list = bd.list(book, pageBean);ResponseUtil.writeJson(resp, new R().data("total", pageBean.getTotal()).data("rows", list));} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}// 如果上架，書籍的狀態(tài)改為2 // 如果下架，書籍的狀態(tài)改為3public void editStatus(HttpServletRequest req, HttpServletResponse resp) {try {bd.editStatus(book);ResponseUtil.writeJson(resp, 1);} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp, 0);} catch (Exception e1) {e1.printStackTrace();}}

3.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) {}})} }});}根據(jù)狀態(tài)的不同，改變上下架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) {$('#dg').datagrid('reload'); // 重新載入當(dāng)前頁面數(shù)據(jù) }})}}}); }

總結(jié)

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

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