发布于2021-06-12 15:04 阅读(528) 评论(0) 点赞(18) 收藏(5)
<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();
}
/**
* 分页查询借阅信息
* @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"));
}
/**
* 分页查询借阅列表
*
* @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黑洞网
任何形式的转载都请注明出处,如有侵权 一经发现 必将追究其法律责任
昵称:
评论内容:(最多支持255个字符)
---无人问津也好,技不如人也罢,你都要试着安静下来,去做自己该做的事,而不是让内心的烦躁、焦虑,坏掉你本来就不多的热情和定力
Copyright © 2018-2021 java黑洞网 All Rights Reserved 版权所有,并保留所有权利。京ICP备18063182号-2
投诉与举报,广告合作请联系vgs_info@163.com或QQ3083709327
免责声明:网站文章均由用户上传,仅供读者学习交流使用,禁止用做商业用途。若文章涉及色情,反动,侵权等违法信息,请向我们举报,一经核实我们会立即删除!