EasyUI(分页&模糊查询)

এ 清ོ眸ꦿ℘゜

于 2022-04-09 22:17:36 发布

阅读量1.5k

点赞数 1

分类专栏： easyui 文章标签： easyui eclipse oracle

本文链接：https://blog.csdn.net/qq_63845026/article/details/124067790

版权

easyui 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

        //双击事件
		onDblClick:function(node){
			 //判重，如果为false就添加新的tab页
			if(!$("#tt").tabs("exists",node.text)){
				// add a new tab panel    
				$('#tt').tabs('add',{    
				    title:node.text,    
				    //将内容更改为iframe框架，跳转到servlet处理
				    content:'<iframe frameborder=0 src="' 
						+ node.url 
						+ '" scrolling="no" style="width:100%;height:100%;"></iframe>',        
				    closable:true    
				});  
			}else{
				//反之为true，选择一个选项卡面板
				$("#tt").tabs("select",node.text)
			}
		}

三、页面搭建 bookList.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">
<title>Insert title here</title>
<%@include file="../../common/head.jsp" %>
<script>
	$(function(){
		$('#dg').datagrid({    
		    url:ctx+'/BookServlet',    
		    toolbar: '#tb',
		    pagination:true, //显示底部分页工具栏
		    columns:[[    
		    	//表格的结构，需要与实体类保持一致
		        {field:'id',title:'ID',width:100,align:'center'},    
		        {field:'bookname',title:'书本名称',width:100,align:'center'},    
		        {field:'price',title:'价格',width:100,align:'center'},
		        {field:'booktype',title:'类型',width:100,align:'center'} 
		    ]]    
		});  
		
		$("#qrybtn").click(function(){
			qry();
		})
		
		function qry(){
			$('#dg').datagrid("reload",{
				bookName:$("#bookName").val()
			});
		}
		
	});
</script>
</head>
<body>
<form style="margin-top:20px;">
	<label for="name">书籍名称:</label>  
	<input id="bookName" class="easyui-textbox" data-options="" style="width:300px;">
	<a id="qrybtn" href="#" class="easyui-linkbutton" data-options="iconCls:'icon-search'">查询</a>  
</form>

<div style="margin-top:10px;">
	<table id="dg"></table>  
</div>

<div id="tb" style="text-align:right;">
	<a href="#" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true"></a>
	<a href="#" class="easyui-linkbutton" data-options="iconCls:'icon-edit',plain:true"></a>
	<a href="#" class="easyui-linkbutton" data-options="iconCls:'icon-remove',plain:true"></a>
</div>

</body>
</html>

四、entity层开发 Book.java

package com.zking.euidemo.entity;

import java.math.BigDecimal;

public class Book{
	private Integer id;//书籍id
	private String bookname;//书籍名称
	private BigDecimal price;//价格
	private String booktype;//书籍类型
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getBookname() {
		return bookname;
	}
	public void setBookname(String bookname) {
		this.bookname = bookname;
	}
	public BigDecimal getPrice() {
		return price;
	}
	public void setPrice(BigDecimal price) {
		this.price = price;
	}
	public String getBooktype() {
		return booktype;
	}
	public void setBooktype(String booktype) {
		this.booktype = booktype;
	}
	
	@Override
	public String toString() {
		return "Book [id=" + id + ", bookname=" + bookname + ", price=" + price + ", booktype=" + booktype + "]";
	}
	
}

五、dao层开发

IBookDao 实现一个接口

package com.zking.euidemo.dao;

import java.util.List;

import com.zking.euidemo.entity.Book;

public interface IBookDao {
	/**
	 * 带模糊查询的分页
	 * @param name 你要查询的书籍名称
	 * @param pageIndex 第几页
	 * @param pageSize 每页多少条记录
	 * @return 书籍集合
	 */
	List<Book> getBooks(String name,int pageIndex, int pageSize);
	
	/**
	 * 获取总记录数
	 * @param name 书籍名称
	 * @return
	 */
	int getTotalPage(String name);
}

BookDao

package com.zking.euidemo.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.zking.euidemo.entity.Book;
import com.zking.euidemo.util.DBHelper;

public class BookDao implements IBookDao{

	@Override
	public List<Book> getBooks(String name, int pageIndex, int pageSize) {
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		List<Book> list = new ArrayList<>();
		try {
			String sql = "select id,bookname,price,booktype,rownum as rid from t_book";
			if(name != null && !"".equals(name)) {
				sql += " where bookname like ?";
			}
			
			sql = "select * from (" + sql + ")b where b.rid between ? and ?";
			
			con = DBHelper.getCon();
			ps = con.prepareStatement(sql);
			
			int start =(pageIndex-1)*pageSize+1;
			int end = pageIndex*pageSize;
			
			if(name != null && !"".equals(name)) {
				ps.setString(1, name+"%");
				ps.setInt(2, start);
				ps.setInt(3, end);
			} else {
				ps.setInt(1, start);
				ps.setInt(2, end);
			}
			
			rs = ps.executeQuery();
			
			while(rs.next()) {
				Book m = new Book();
				m.setId(rs.getInt("id"));
				m.setBookname(rs.getString("bookname"));
				m.setPrice(rs.getBigDecimal("price"));
				m.setBooktype(rs.getString("booktype"));
				list.add(m);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBHelper.myClose(con, ps, rs);
		}
		return list;
	}
	
	
	
	@Override
	public int getTotalPage(String name) {
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		int n  = 0;
		try {
			con= DBHelper.getCon();
			String sql = "select count(*) from  t_book";
			if(name != null && !"".equals(name)) {
				sql += " where bookname like ?";
			}
			
			ps = con.prepareStatement(sql);
			
			if(name != null && !"".equals(name)) {
				ps.setString(1, name+"%");
			}
			
			rs= ps.executeQuery();
			if(rs.next()) {
				n = rs.getInt(1);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.myClose(con, ps, rs);
		}
		return n;
	}
	
}

六、service层开发

IBookService

package com.zking.euidemo.service;

import java.util.List;

import com.zking.euidemo.entity.Book;

public interface IBookService {
	/**
	 * 带模糊查询的分页
	 * @param name 你要查询的书籍名称
	 * @param pageIndex 第几页
	 * @param pageSize 每页多少条记录
	 * @return 书籍集合
	 */
	List<Book> getBooks(String name,int pageIndex, int pageSize);
	
	/**
	 * 获取总记录数
	 * @param name 书籍名称
	 * @return
	 */
	int getTotalPage(String name);
}

BookService

package com.zking.euidemo.service;

import java.util.List;

import com.zking.euidemo.dao.BookDao;
import com.zking.euidemo.dao.IBookDao;
import com.zking.euidemo.entity.Book;

public class BookService implements IBookService{
	
	private IBookDao bd = new BookDao();
	
	@Override
	public List<Book> getBooks(String name, int pageIndex, int pageSize) {
		return bd.getBooks(name, pageIndex, pageSize);
	}

	@Override
	public int getTotalPage(String name) {
		// TODO Auto-generated method stub
		return bd.getTotalPage(name);
	}
	
}

七、servlet开发(控制器)

BookServlet

package com.zking.euidemo.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson.JSON;
import com.zking.euidemo.entity.Book;
import com.zking.euidemo.service.BookService;
import com.zking.euidemo.service.IBookService;
@WebServlet("/BookServlet")
public class BookServlet extends HttpServlet{
	
	private IBookService service = new BookService();
	
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		doPost(req, resp);
	}
	
	 @Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
	 	//设置字符编码
	 	req.setCharacterEncoding("utf-8");
		resp.setContentType("application/json; charset=utf-8");
		
		String name = req.getParameter("bookName");
		String pageIndex = req.getParameter("page");
		int pid = pageIndex == null || "".equals(pageIndex) ?  1 : Integer.parseInt(pageIndex);
		int pageSize = 10;
		
		List<Book> books = service.getBooks(name, pid, pageSize);
		int totalPage = service.getTotalPage(name);
		
		Map<String,Object> data = new HashMap<>();
		data.put("total", totalPage);
		data.put("rows", books);
		
		String json = JSON.toJSONString(data);
		
		PrintWriter out = resp.getWriter();
		out.write(json);
		out.flush();
		out.close();
		 
		 
	}
}

效果图：

好了我的分享到此结束，希望能帮到大家！！！

এ 清ོ眸ꦿ℘゜

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
EasyUI(分页&模糊查询)

目录一、创建数据库二、创建包结构三、页面搭建四、entity层开发五、dao层开发六、service层开发七、servlet开发前言：这次的功能是基于上一次的项目做的，如果有不懂可以看上一节...
复制链接

扫一扫