分页

先定义一个工具类 有四个参数，和一个pagedata接受返回数据

dao层判断 index count 写sql语句

在这里插入图片描述

在项目中使用
// 模糊查询
public List queryByLike(String cond, String col, int i, int j) {
List all = new ArrayList();
if (null == col) {
String sql = “SELECT id,title,author,content,img,imgUrl FROM note WHERE title LIKE ? or AUTHOR LIKE ? or CONTENT LIKE ? limit ?,?”;
PreparedStatement pstmt = null;
ResultSet rs = null;
Connection connection = DBUtils.getConnection();
try {
pstmt = connection.prepareStatement(sql);
pstmt.setString(1, “%” + cond + “%”);
pstmt.setString(2, “%” + cond + “%”);
pstmt.setString(3, “%” + cond + “%”);
pstmt.setInt(4, i);
pstmt.setInt(5, j);
rs = pstmt.executeQuery();
while (rs.next()) {
Note note = new Note();
note.setId(rs.getInt(1));
note.setTitle(rs.getString(2));
note.setAuthor(rs.getString(3));
note.setContent(rs.getString(4));
note.setImg(rs.getString(5));
note.setImgUrl(rs.getString(6));
all.add(note);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtils.jdbcClose(rs, pstmt, connection);
}

	} else {
		String sql = "SELECT id,title,author,content,img,imgUrl FROM note WHERE "
				+ col + " LIKE ?  limit ?,?";
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		Connection connection = DBUtils.getConnection();
		try {
			pstmt = connection.prepareStatement(sql);
			pstmt.setString(1, "%" + cond + "%");
			pstmt.setInt(2, i);
			pstmt.setInt(3, j);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				Note note = new Note();
				note.setId(rs.getInt(1));
				note.setTitle(rs.getString(2));
				note.setAuthor(rs.getString(3));
				note.setContent(rs.getString(4));
				note.setImg(rs.getString(5));
				note.setImgUrl(rs.getString(6));
				all.add(note);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBUtils.jdbcClose(rs, pstmt, connection);
		}
	}
	return all;
}