1500字范文 > EasyUI(分页模糊查询)

EasyUI(分页模糊查询)

时间：2022-12-16 18:51:26

相关推荐

EasyUI(分页模糊查询)

//双击事件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" "/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;//书籍idprivate 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;}@Overridepublic 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{@Overridepublic 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;}@Overridepublic 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();@Overridepublic List<Book> getBooks(String name, int pageIndex, int pageSize) {return bd.getBooks(name, pageIndex, pageSize);}@Overridepublic int getTotalPage(String name) {// TODO Auto-generated method stubreturn 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();@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {doPost(req, resp);}@Overrideprotected 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();}}

效果图：

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

本内容不代表本网观点和政治立场，如有侵犯你的权益请联系我们处理。

网友评论

网友评论仅供其表达个人看法，并不表明网站立场。