Dao层代码
public interface AttachmentDao {
List<AttachmentExtends> selectAttachmentList();
}
Service层代码
@Service
public class AttachmentServiceImp implements AttachmentService {
@Autowired
private AttachmentDao attachmentDao;
//查询所有的附件
@Override
public PageInfo<AttachmentExtends> queryAttachmentList(int currentPage) throws Exception {
PageHelper.startPage(currentPage,3);
List<AttachmentExtends> list = attachmentDao.selectAttachmentList();
PageInfo<AttachmentExtends> pageInfo = new PageInfo<>(list,5);
return pageInfo;
}
}
public interface AttachmentService {
PageInfo<AttachmentExtends> queryAttachmentList(int currentPage)throws Exception;
}
Controller层代码
@Controller
@RequestMapping("/atta")
public class AttachmentController {
@Autowired
private AttachmentService attachmentService;
//查询后台数据库的所有附件
@RequestMapping("/attachment-show")
public String attachmentShow(Model model,@RequestParam(defaultValue = "1") int currentPage)throws Exception{
PageInfo<AttachmentExtends> pageInfo = attachmentService.queryAttachmentList(currentPage);
model.addAttribute("pageInfo",pageInfo);
return "../project-file.jsp";
}
}
前端数据的显示及前端分页的代码
<c:forEach items="${pageInfo.list}" var="att" varStatus="xxoo">
<tr align='center' bgcolor="#FFFFFF" onMouseMove="javascript:this.bgColor='#FCFDEE';" onMouseOut="javascript:this.bgColor='#FFFFFF';" height="22" >
<td><input name="id" type="checkbox" id="id" value="101" class="np"></td>
<td>${xxoo.count}</td>
<td>${att.attname}</td>
<td align="center"><a href=''><u>${att.projectExtends.pname}</u></a></td>
<td><fmt:formatDate value="<%= new Date() %>" pattern="yyyy-MM-dd HH:mm:ss"></fmt:formatDate> </td>
<td><fmt:formatDate value="<%= new Date() %>" pattern="yyyy-MM-dd HH:mm:ss"></fmt:formatDate></td>
<td><a href="${pageContext.request.contextPath}/attachment/download?path=${att.path}">下载</a> |<a href="#">删除</a> |<a href="project-file-edit.jsp">编辑</a> | <a href="project-file-look.jsp">查看详情</a></td>
</tr>
</c:forEach>
页码部分
<tr align="right" bgcolor="#EEF4EA">
<td height="36" colspan="12" align="center">
<!--翻页代码 -->
<a href="javascript:pageFun(1)">首页</a>
<a href="javascript:pageFun(${pageInfo.prePage})">上一页</a>
【
<c:forEach items="${pageInfo.navigatepageNums}" var="num">
<c:choose>
<c:when test="${pageInfo.pageNum == num}">
<a href="javascript:pageFun(${num})" style="color: red;">${num}</a>
</c:when>
<c:otherwise>
<a href="javascript:pageFun(${num})">${num}</a>
</c:otherwise>
</c:choose>
</c:forEach>
】
<a href="javascript:pageFun(${pageInfo.nextPage})">下一页</a>
<a href="javascript:pageFun(${pageInfo.pages})">尾页</a>
</td>
</tr>