栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

11.通用分页01

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

11.通用分页01

思路

基于MySql数据库的通用分页  limit 
    
   通用分页核心思路:将上一次查询请求再发一次,只不过页码变了
   实现步骤:
   1)先查询全部数据
    Junit测试
    baseDao、CallBack
   2)通用分页实现
    pagebean
    

1. PageBean
   分页三要素 
   page=1        页码        视图层传递过来
   rows=10         页大小      视图层传递过来
   total=0       总记录数    后台查出来

   pagination=true  是否分页    视图层传递过来

   getStartIndex()        基于MySql数据库分页,获取分页开始标记
  (page-1)*rows


2. 后台
  2.1 entity
  2.2 dao
      BaseDao
      1)匿名内部接口
         public static interface CallBack{
            //只做一件事情,遍历ResultSet结果集,返回List
            public List forEach(ResultSet rs) throws SQLException;
         }
      2)分页查询方法,接口方法传参
         List executeQuery(String sql,PageBean pageBean,CallBack callBack)
         if(如果分页)
           (返回:总记录数+指定页码并满足条件的记录集)
         else
            直接查询sql语句

         return callBack.forEach(rs);
      3)二次查询的条件要一致
    getCountSql()/getPagerSql()

      ResultSet rs=super.executeQuery(sql,pageBean);
      CommonUtils.toList(rs,Book.class);


3. junit
   java单元测试/白盒测试
   setUp
   tearDown 
   测试用例
   
   Servlet中的init和destory方法只会运行一次
   Junit中的setUp和tearDown方法是根据方法数量来决定的

 例题:

Book.java

package com.aike.entity;

import java.io.Serializable;

public class Book implements Serializable{

	
	private static final long serialVersionUID = 1L;

	private Integer bid;
	private String bname;
	private double price;
	public Integer getBid() {
		return bid;
	}
	public void setBid(Integer bid) {
		this.bid = bid;
	}
	public String getBname() {
		return bname;
	}
	public void setBname(String bname) {
		this.bname = bname;
	}
	public double getPrice() {
		return price;
	}
	public void setPrice(double price) {
		this.price = price;
	}
	
	public Book() {
		// TODO Auto-generated constructor stub
	}
	public Book(Integer bid, String bname, double price) {
		this.bid = bid;
		this.bname = bname;
		this.price = price;
	}
	@Override
	public String toString() {
		return "Book [bid=" + bid + ", bname=" + bname + ", price=" + price + "]";
	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
}

DBHelper.java

package com.aike.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class DBHelper {

	private static final String url="jdbc:sqlserver://localhost:1433;DatabaseName=Zy";
	private static final String cname="com.microsoft.sqlserver.jdbc.SQLServerDriver";

	static {
		try {
			
			Class.forName(cname);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	

	public static Connection getsCon() {
		Connection con = null;
		try {
			con = DriverManager.getConnection(url,"sa","zkingedu");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return con;
		
	}

	public static void Close(Connection con,PreparedStatement ps,ResultSet rs) {
		try {
			if(rs!=null) {
				rs.close();
			}
			if(ps!=null) {
				ps.close();
			}
			if(con!=null&&!con.isClosed()) {
				con.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	public static void main(String[] args) {
		System.out.println(getsCon());
	}
}

StringUtils.java

package com.aike.util;

public class StringUtils {
	// 私有的构造方法,保护此类不能在外部实例化
	private StringUtils() {
	}

	
	public static boolean isBlank(String s) {
		boolean b = false;
		if (null == s || s.trim().equals("")) {
			b = true;
		}
		return b;
	}
	
	
	public static boolean isNotBlank(String s) {
		return !isBlank(s);
	}

}

BookDao.java

package com.aike.dao;

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

import com.aike.entity.Book;
import com.aike.util.DBHelper;
import com.aike.util.StringUtils;

public class BookDao {
	
	private Connection con = null;
	private PreparedStatement ps = null;
	private ResultSet rs = null;
	
	
	

	
	public void addBook(Book b) {
		try {
			//获得连接
			con=DBHelper.getsCon();
			//定义sql语句
			String sql="INSERT INTO BOOK(bname,price) VALUES(?,?)";
			//获得执行对象
			ps=con.prepareStatement(sql);
			//给占位符赋值
			ps.setString(1, b.getBname());
			ps.setDouble(2, b.getPrice());
			ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	
	public void delBook(Book b) {
		try {
			//获得连接
			con=DBHelper.getsCon();
			//定义sql语句
			String sql="DELETE FROM BOOK WHERe bid=? ";
			//获得执行对象
			ps=con.prepareStatement(sql);
			//给占位符赋值
			ps.setInt(1, b.getBid());
			ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void updateBook(Book b) {
		try {
			//获得连接
			con=DBHelper.getsCon();
			//定义sql语句
			String sql="UPDATE BOOK SET bname=?,price=? WHERe bid=? ";
			//获得执行对象
			ps=con.prepareStatement(sql);
			//给占位符赋值
			ps.setString(1, b.getBname());
			ps.setDouble(2, b.getPrice());
			ps.setInt(3, b.getBid());
			ps.executeUpdate();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public Book loadBook(Book b) {
		try {
			//获得连接
			con=DBHelper.getsCon();
			//定义sql语句
			String sql="SELECT bid,bname,price FROM BOOK WHERe bid=? ";
			//获得执行对象
			ps=con.prepareStatement(sql);
			//给占位符赋值
			ps.setString(1, b.getBname());
			ps.setDouble(2, b.getPrice());
			ps.setInt(3, b.getBid());
			rs=ps.executeQuery();
			Book bb=null;
			if(rs.next()) {
				bb=new Book();
				bb.setBid(rs.getInt("bid"));
				bb.setBname(rs.getString("bname"));
				bb.setPrice(rs.getDouble("price"));
			}
			return bb;
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}
	
	public List listBook(Book b) {
		try {
			//获得连接
			con=DBHelper.getsCon();
			//定义sql语句
			String sql="SELECt bid,bname,price FROM BOOK WHERe 1=1 ";
			//模糊查询
			if(StringUtils.isNotBlank(b.getBname())) {
				sql+=" AND bname LIKE '%"+b.getBname()+"%'";
			}
			//获得执行对象
			ps=con.prepareStatement(sql);
			//给占位符赋值
			ps.setString(1, b.getBname());
			ps.setDouble(2, b.getPrice());
			ps.setInt(3, b.getBid());
			rs=ps.executeQuery();
			Book bb=null;
			List ls=new ArrayList();
			while(rs.next()) {
				bb=new Book();
				bb.setBid(rs.getInt("bid"));
				bb.setBname(rs.getString("bname"));
				bb.setPrice(rs.getDouble("price"));
				ls.add(bb);
			}
			return ls;
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}
	
	
}

BookDaoText.java

增加

package com.aike.dao;

import static org.junit.Assert.*;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.aike.entity.Book;

public class BookDaoTest {

	private BookDao bookdao;
	private Book b;
	
	
	@Before
	public void setUp() throws Exception {
		bookdao=new BookDao();
		b=new Book();
	}

	@After
	public void tearDown() throws Exception {
	
	}

	@Test
	public void testAddBook() {
		for (int i = 1; i < 101; i++) {
			b.setBname("菜菜三打果果第"+i+"回");
			b.setPrice(66f);
			bookdao.addBook(b);
		}
	}



}

效果图:

 删除

package com.aike.dao;

import static org.junit.Assert.*;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.aike.entity.Book;

public class BookDaoTest {

	private BookDao bookdao;
	private Book b;
	
	
	@Before
	public void setUp() throws Exception {
		bookdao=new BookDao();
		b=new Book();
	}

	@After
	public void tearDown() throws Exception {
	
	}



	@Test
	public void testDelBook() {
		b.setBid(1);
		bookdao.delBook(b);
	}



}

 效果图:删除bid为1的数据

 修改

package com.aike.dao;

import static org.junit.Assert.*;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.aike.entity.Book;

public class BookDaoTest {

	private BookDao bookdao;
	private Book b;
	
	
	@Before
	public void setUp() throws Exception {
		bookdao=new BookDao();
		b=new Book();
	}

	@After
	public void tearDown() throws Exception {
	
	}


	@Test
	public void testUpdateBook() {
		b.setBid(2);
		b.setBname("菜菜喜欢果果");
		b.setPrice(520f);
		bookdao.updateBook(b);
	}



}

效果图:修改bid为2的数据

 查询单个

package com.aike.dao;

import static org.junit.Assert.*;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.aike.entity.Book;

public class BookDaoTest {

	private BookDao bookdao;
	private Book b;
	
	
	@Before
	public void setUp() throws Exception {
		bookdao=new BookDao();
		b=new Book();
	}

	@After
	public void tearDown() throws Exception {
	
	}




	@Test
	public void testLoadBook() {
		b.setBid(2);
		Book loadBook = bookdao.loadBook(b);
		System.out.println(loadBook);
	}



}

 效果图:

查询全部

package com.aike.dao;

import static org.junit.Assert.*;

import java.util.List;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.aike.entity.Book;

public class BookDaoTest {

	private BookDao bookdao;
	private Book b;
	
	
	@Before
	public void setUp() throws Exception {
		bookdao=new BookDao();
		b=new Book();
	}

	@After
	public void tearDown() throws Exception {
	
	}



	@Test
	public void testListBook() {
		List listBook = bookdao.listBook(b);
		for (Book book : listBook) {
			System.out.println(book);
		}
	}

}

 效果图:

模糊查询

package com.aike.dao;

import static org.junit.Assert.*;

import java.util.List;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.aike.entity.Book;

public class BookDaoTest {

	private BookDao bookdao;
	private Book b;
	
	
	@Before
	public void setUp() throws Exception {
		bookdao=new BookDao();
		b=new Book();
	}

	@After
	public void tearDown() throws Exception {
	
	}



	@Test
	public void testListBook() {
        b.setBname("1");
		List listBook = bookdao.listBook(b);
		for (Book book : listBook) {
			System.out.println(book);
		}
	}

}

 效果图:bid带1的数据

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/944996.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号