程序员最近都爱上了这个网站  程序员们快来瞅瞅吧!  it98k网:it98k.com

本站消息

站长简介/公众号

  出租广告位,需要合作请联系站长


+关注
已关注

分类  

暂无分类

标签  

暂无标签

日期归档  

练习——图书管理系统十一(时间查询)

发布于2021-06-12 15:04     阅读(528)     评论(0)     点赞(18)     收藏(5)


在这里插入图片描述

borrowinfolist.html

在这里插入图片描述

在这里插入图片描述

	<table style="width: 100%;">
				<tr>
					<td style="width: 100%;"><a class="mini-button"
						iconCls="icon-add" onclick="add()">借阅图书</a></td>
						
					<td style="white-space: nowrap;">开始时间:
					<input id="borrowTime" class="mini-datepicker" style="width: 150px;"
						 format="yyyy-MM-dd" onenter="onKeyEnter"/>
					</td>
					<td style="white-space: nowrap;">结束时间:
					<input id="returnTime" class="mini-datepicker" style="width: 150px;"
						 format="yyyy-MM-dd" onenter="onKeyEnter"/>
					 <a class="mini-button" onclick="search()">查询</a>
					 <a class="mini-button" onclick="reset()">重置</a>
					</td>
				</tr>
			</table>
//查询操作
		function search() {
			var borrowTime = mini.get("borrowTime").getValue();
			var returnTime = mini.get("returnTime").getValue();
			grid.load({
				borrowTime : borrowTime,
				returnTime : returnTime
			});
		}
		
		//重置
		function reset() {
			mini.get("borrowTime").setValue('');
			mini.get("returnTime").setValue('');
			grid.load();
		}
		function onKeyEnter(e) {
			search();
		}

BorrowInfoAction.java

在这里插入图片描述

	/**
	 * 分页查询借阅信息
	 * @Description 
	 * @param request
	 * @param response
	 * @throws ServletException
	 * @throws IOException
	 * @throws ParseException 
	 */
	protected void borrowInfoList(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ParseException {
		
		String borrowTime = request.getParameter("borrowTime");
		String returnTime = request.getParameter("returnTime");
		
		String pageIndex = request.getParameter("pageIndex");
		String pageSize = request.getParameter("pageSize");
		String sortField = request.getParameter("sortField");
		String sortOrder = request.getParameter("sortOrder");
		
		List<BorrowInfo> borrowInfos = borrowInfoService.getBorrowList(borrowTime,returnTime,Integer.valueOf(pageIndex), Integer.valueOf(pageSize), sortField, sortOrder);
		
		//根据图书编号设置图书名称
		for(BorrowInfo borrowInfo : borrowInfos) {
			Map<String, String> bookNames = bookInfoService.getBookNames(borrowInfo.getBookId(),"");
			
			borrowInfo.setBookName(bookNames.get(borrowInfo.getBookId()));
		}
		int totalCount = borrowInfoService.getTotalCount(borrowTime,returnTime);
		Map<String,Object> resultMap = new HashMap<>();
		
		resultMap.put("data", borrowInfos);
		resultMap.put("total", totalCount);
		
		response.getWriter().print(JSONObject.toJSONStringWithDateFormat(resultMap, "yyyy-MM-dd HH:mm:ss"));
	}

BorrowInfoDao.java

在这里插入图片描述

	/**
	 * 分页查询借阅列表
	 * 
	 * @Description
	 * @param pageIndex
	 * @param pageSize
	 * @param sortFiled
	 * @param sortOrder
	 * @return
	 */
	public List<BorrowInfo> getBorrowList(String borrowTime,String returnTime,int pageIndex, int pageSize, String sortField,
			String sortOrder) {
		Connection connection = JDBCUtil.getConnection();
		PreparedStatement pStatement = null;
		ResultSet rSet = null;

		List<BorrowInfo> result = new ArrayList<>();
		StringBuilder sBuilder = new StringBuilder();

		sBuilder.append("select * from borrowinfo where 1 = 1");

		if(!StringUtils.isEmpty(borrowTime)) {
			//格式化时间
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			java.util.Date date = new java.util.Date(borrowTime);
			
			String borrowTimeStr = sdf.format(date);
			
			sBuilder.append(" and borrowtime >='" + borrowTimeStr + "'");
			
		}
		
		if(!StringUtils.isEmpty(returnTime)) {
			//格式化时间
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			java.util.Date date = new java.util.Date(returnTime);
			
			String returnTimeStr = sdf.format(date);
			
			sBuilder.append(" and returntime <='" + returnTimeStr + "'");
			
		}
		
		if (!StringUtils.isEmpty(sortField) && !StringUtils.isEmpty(sortOrder)) {
			sBuilder.append(" order by " + sortField + " " + sortOrder);
		}

		if (-1 != pageSize && -1 != pageIndex) {
			sBuilder.append(" limit " + pageIndex * pageSize + "," + pageSize);
		}

		try {
			
			pStatement = connection.prepareStatement(sBuilder.toString());

			rSet = pStatement.executeQuery();

			while (rSet.next()) {
				BorrowInfo borrowInfo = new BorrowInfo();
				borrowInfo.setBorrowId(rSet.getString("borrowid"));
				borrowInfo.setBookId(rSet.getString("bookId"));
				borrowInfo.setBorrower(rSet.getString("borrower"));
				borrowInfo.setPhone(rSet.getString("phone"));
				borrowInfo.setBorrowTime(rSet.getTimestamp("borrowTime"));
				borrowInfo.setReturnTime(rSet.getTimestamp("returnTime"));
				
				result.add(borrowInfo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JDBCUtil.closeConnection(connection, pStatement, rSet);
		}

		return result;
	}
	

	/**
	 * 计算总条数
	 * 
	 * @Description
	 * @return
	 */
	public int getTotalCount(String borrowTime,String returnTime) {
		Connection connection = JDBCUtil.getConnection();

		PreparedStatement pStatement = null;
		ResultSet rSet = null;
		try {

			String sql = "select count(*) from borrowinfo where 1 = 1";
			if(!StringUtils.isEmpty(borrowTime)) {
				//格式化时间
				SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
				java.util.Date date = new java.util.Date(borrowTime);
				
				String borrowTimeStr = sdf.format(date);
				
				sql += " and borrowtime >='" + borrowTimeStr + "'";
				
			}
			
			if(!StringUtils.isEmpty(returnTime)) {
				//格式化时间
				SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
				java.util.Date date = new java.util.Date(returnTime);
				
				String returnTimeStr = sdf.format(date);
				
				sql += " and returntime <='" + returnTimeStr + "'";
				
			}
			
			pStatement = connection.prepareStatement(sql);

			rSet = pStatement.executeQuery();

			if (rSet.next()) {
				return rSet.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JDBCUtil.closeConnection(connection, pStatement, rSet);
		}

		return 0;
	}

原文链接:https://blog.csdn.net/qq_45554909/article/details/117695000



所属网站分类: 技术文章 > 博客

作者:我爱编程

链接:http://www.javaheidong.com/blog/article/222497/4d7153218fcaca4e55ec/

来源:java黑洞网

任何形式的转载都请注明出处,如有侵权 一经发现 必将追究其法律责任

18 0
收藏该文
已收藏

评论内容:(最多支持255个字符)