當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

easyui下拉框，增加以及商品的上架，下架

發布時間：2023/12/14 编程问答 28 豆豆

生活随笔收集整理的這篇文章主要介紹了 easyui下拉框，增加以及商品的上架，下架小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

一、下拉框

1.將下拉框需要顯示的值寫入實體類

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

2.dao方法進行查詢

public List<Category> list(Category category, PageBean pageBean) throws Exception {
?? ??? ?String sql = "select * from t_easyui_category";
?? ??? ?long id = category.getId();
?? ??? ?if (id != 0) {
?? ??? ??? ?sql += "and id=" + id;

?? ??? ?}
?? ??? ?return super.executeQuery(sql, Category.class, pageBean);
?? ?}

3.action子控制器內調用

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;
?? ?}

4.配置mvc文件

5.在表單中添加下拉框組件

?<input id="cid" name="cid" value="" label="類別" >

?$(function () {
? ? ? ? $('#cid').combobox({
? ? ? ? ? ? url:'${pageContext.request.contextPath}/category.action?methodName=list',
? ? ? ? ? ? valueField:'id',
? ? ? ? ? ? textField:'name'
? ? ? ? });

? ? });
?

??二、添加

1.添加表單

2.給表單添加點擊事件

<div style="text-align:center;padding:5px 0">
? ? ? ? <a href="javascript:void(0)" class="easyui-linkbutton" οnclick="submitForm()" style="width:80px">Submit</a>
? ? ? ? <a href="javascript:void(0)" class="easyui-linkbutton" οnclick="clearForm()" style="width:80px">Clear</a>
? ? </div>

3.提交表單和清空

//提交編輯信息的表單function submitForm() {$('#ff').form('submit', {success : function(param) {$('#dd').dialog('close');$('#dg').datagrid('reload');$('#ff').form('clear');}});}function clearForm() {$('#ff').form('clear');}

?三、上架和下架

1.書籍實體類

package com.zking.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.書籍的dao方法增改查

public List<Book> list(Book book, PageBean pageBean) throws Exception {String sql = "select * from t_eastui_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 edit(Book t) throws Exception {// TODO Auto-generated method stubsuper.executeUpdate("update t_easyui_book set name=?,pinyin=?,cid=?,image=?,state=?,sales=? where id=?", t,new String[] { "name", "pinyin", "cid", "image", "state", "sales", "id" });}public void add(Book t) throws Exception {t.setPinyin(PinYinUtil.getAllPingYin(t.getName()));super.executeUpdate("insert into t_easyui_book(name,pinyin,cid,author,price,image,publishing,description,state,deployTime,sales) values(?,?,?,?,?,?,?,?,?,?,?)",t, new String[] { "name", "pinyin", "cid", "author", "price", "image", "publishing", "description","state", "deployTime", "sales" });}

3.書籍的action

package com.zking.web;import java.util.List;import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;import com.zking.dao.BookDao; import com.zking.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();@Overridepublic Book getModel() {// TODO Auto-generated method stubreturn book;}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();}}public void add(HttpServletRequest req, HttpServletResponse resp) {try {bookDao.add(book);ResponseUtil.writeJson(resp, 0);} catch (Exception e) {e.printStackTrace();}} /*** 如果上架，書籍的狀態改為2* 如果下架，書籍的狀態改為3* @param req* @param resp*/public void upDown(HttpServletRequest req, HttpServletResponse resp) {try {bookDao.edit(book);ResponseUtil.writeJson(resp, 1);} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp, 1);} catch (Exception e1) {e.printStackTrace();}}}public void editStatus(HttpServletRequest req, HttpServletResponse resp) {try {bookDao.editStatus(book);ResponseUtil.writeJson(resp, 1);} catch (Exception e) {e.printStackTrace();try {ResponseUtil.writeJson(resp, 1);} catch (Exception e1) {e.printStackTrace();}}} }

4.配置mvc文件

5.上架的js代碼

function shangjia() {$.messager.confirm('確認','您確認想要上架此書籍嗎？',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) {}})}}});}

?6.下架的js代碼

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

注意：書籍狀態（1 未上架 2 已上架 3 已下架默認值1 ）

增加時默認為1狀態

總結

以上是生活随笔為你收集整理的easyui下拉框，增加以及商品的上架，下架的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇： html5 indexeddb 排序,H
下一篇： 2021年终总结万千热爱初心未改行