Easyui_4_datagrid之查询

最新推荐文章于 2024-09-24 17:29:02 发布

阿立不油腻

最新推荐文章于 2024-09-24 17:29:02 发布

阅读量89

点赞数

分类专栏： web easyui MySQL 文章标签： easyui

本文链接：https://blog.csdn.net/qq_58530605/article/details/120300469

版权

MySQL 同时被 3 个专栏收录

11 篇文章 0 订阅

订阅专栏

easyui

9 篇文章 0 订阅

订阅专栏

web

6 篇文章 0 订阅

订阅专栏

一、代码

userManage.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.1/themes/default/easyui.css">   
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.1/themes/icon.css">   
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.1/jquery.min.js"></script>   
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.1/jquery.easyui.min.js"></script>  
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/book.js"></script> 
<title>存放书籍页面</title>
</head>
<body>
<input type="hidden" id="ctx" value="${pageContext.request.contextPath }">
 
<!-- <div id="tb">
<a href="#" class="easyui-linkbutton" data-options="iconCls:'icon-edit',plain:true"/a>
<a href="#" class="easyui-linkbutton" data-options="iconCls:'icon-help',plain:true"/a>
</div> -->

<div id="tb">
	<input class="easyui-textbox" id= "name" name="name" style="width:30%; padding-left: 10px" data-options="label:'书名：',required:true">
	<a id="btn-search" href="#" class="easyui-linkbutton" data-options="iconCls:'icon-search'">搜索</a>
	<!-- <a id="" href="#" class="easyui-linkbutton" data-options="iconCls:'icon-search'">新增</a> -->
	

</div>





<table id="dg"></table> 
</body>
</html>

book.js

$(function(){
	/*在easyUI中，点击上一页下一页等默认的范爷效果，携带的参数是page/rows
	在bootstrap中，点击上一页下一页等默认的范爷效果，携带的参数是page/offset*/
	$('#dg').datagrid({    
	    url:$("#ctx").val()+'/book.action?methodName=datagrid',   
	    pagination:true,
	    fitColumns:true,
	    toolbar: '#tb',
	    columns:[[    
	        {field:'bid',title:'id',width:100},    
	        {field:'bname',title:'名称',width:400},    
	        {field:'price',title:'价格',width:100,align:'right'}    
	    ]]    
	});  
	
	$("#btn-search").click(function(){
		$('#dg').datagrid('load', {    
			bname: $("#name").val()   
	    
		});  
	
	});
})

book实体

package com.dzl.entity;

public class Book {
	
	private int bid;
	private String bname;
	private float price;
	public int getBid() {
		return bid;
	}
	public void setBid(int bid) {
		this.bid = bid;
	}
	public String getBname() {
		return bname;
	}
	public void setBname(String bname) {
		this.bname = bname;
	}
	public float getPrice() {
		return price;
	}
	public void setPrice(float price) {
		this.price = price;
	}
	@Override
	public String toString() {
		return "Book [bid=" + bid + ", bname=" + bname + ", price=" + price + "]";
	}
	
	
}

BookDao

package com.dzl.dao;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.dzl.entity.Book;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;
import com.zking.util.StringUtils;

public class BookDao extends BaseDao<Book> {
/*ctrl+shift+o 导包*/
		
//	查询
	public List<Book> list(Book book, PageBean pageBean) throws Exception {
		String bname = book.getBname();
		String sql ="select * from t_mvc_book where 1=1";
		if(StringUtils.isNotBlank(bname)) {
			sql+=" and bname like '%"+ bname +"%'";
		}
		return super.executeQuery(sql, Book.class, pageBean);
	}
	
	public static void main (String [] args) throws Exception {
		BookDao bookDao = new BookDao();
		PageBean pageBean=new PageBean();
		List<Book> list = bookDao.list(new Book(),new PageBean());
		ObjectMapper om = new ObjectMapper();
//		json数组
		Map<String,Object>map =new HashMap<String, Object>();
		map.put("total", pageBean.getTotal());
		map.put("rows", list);
		System.out.println(om.writeValueAsString(map));
	}




	
	
}

BookAction

package com.dzl.web;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.dzl.dao.BookDao;
import com.dzl.entity.Book;
import com.fasterxml.jackson.databind.ObjectMapper;
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> {
	 Book book = new Book();
     BookDao bookDao = new BookDao();
	
	@Override
	public Book getModel() {
		// TODO Auto-generated method stub
		return book;
	}
	
	public String datagrid(HttpServletRequest req, HttpServletResponse resp) {
		BookDao bookDao = new BookDao();
		PageBean pageBean=new PageBean();
		pageBean.setRequest(req);
		try {
			List<Book> list = bookDao.list(book, pageBean);
			ObjectMapper om = new ObjectMapper();
//		json数组		链式编程
//			Map<String,Object>map =new HashMap<String, Object>();
//			map.put("total", pageBean.getTotal());
//			map.put("rows", list);
			ResponseUtil.writeJson(resp,new R()
					.data("total",pageBean.getTotal())
					.data("rows",list));
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}
	
	

}

配置mvc2.xml

<?xml version="1.0" encoding="UTF-8"?>
<config>
	
<action type="com.zking.web.BlogAction" path="/blog">

<forward path="/blogList.jsp" redirect="false" name="list"/>

<forward path="/blog.action?methodName=list" redirect="true" name="toList"/>

<forward path="/blogEdit.jsp" redirect="false" name="toEdit"/>

</action>
	
	<action path="/menu" type="com.dzl.web.MenuAction">
	</action>
	
	<action path="/book" type="com.dzl.web.BookAction">
	
	</action>
</config>

二、链式编程

新建R：

package com.zking.util;

import java.util.HashMap;

public class R extends HashMap{
		public R data(String key,Object value) {
			this.put(key, value);
			return this;
		}

}

用：

	public String datagrid(HttpServletRequest req, HttpServletResponse resp) {
		BookDao bookDao = new BookDao();
		PageBean pageBean=new PageBean();
		pageBean.setRequest(req);
		try {
			List<Book> list = bookDao.list(book, pageBean);
			ObjectMapper om = new ObjectMapper();
//			链式编程
			ResponseUtil.writeJson(resp,new R()
					.data("total",pageBean.getTotal())
					.data("rows",list));
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}

执行效果：