图书管理系统

package com.ctgu.controller; import java.io.IOException; import java.io.PrintWriter; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import com.ctgu.dao.BookDao; import com.ctgu.dao.provider.DynaSqlProvider; import com.ctgu.pojo.BookClass; import com.ctgu.pojo.BookClass2; import com.ctgu.pojo.BorrowBook; import com.ctgu.pojo.LibraryCard2; import com.ctgu.pojo.NewBook; import com.ctgu.pojo.Users; import com.ctgu.service.BookService; import com.ctgu.service.UserService; import com.ctgu.util.DimPaging; import com.ctgu.util.Paging; import com.sun.org.apache.xalan.internal.xsltc.compiler.sym; import net.sf.json.JSONArray; import net.sf.json.JSONObject; import net.sf.json.JsonConfig; import net.sf.json.processors.JsonValueProcessor; @Controller public class AjaxController { /*@Autowired private UserService userService;*/ @Autowired private BookService bookService; @RequestMapping("/servlet/DownBox") public void DownBox(HttpServletRequest req, HttpServletResponse response) throws IOException { req.setCharacterEncoding("utf-8"); response.setContentType("application/json; charset=UTF-8"); System.out.println("hello"); List<BookClass> users = bookService.findBookClass(); JSONObject json = new JSONObject(); JSONArray jsonArray = new JSONArray(); if (users != null && users.size() > 0) { // 添加时间转换器 jsonArray.addAll(users); json.put("count", users.size()); json.put("data", jsonArray); } else { // 没有查询到数据 json.put("count", 0); } PrintWriter out = response.getWriter(); out.write(json.toString()); } @RequestMapping("/servlet/InsertBook") public void InsertBook(String aaa, HttpServletRequest req, HttpServletResponse response) throws IOException { req.setCharacterEncoding("utf-8"); response.setContentType("text/html,charser=utf-8"); NewBook book = new NewBook(); String str2[] = aaa.split("/"); for (int i = 0; i < str2.length; i++) { System.out.println(str2[i]); String str[] = str2[i].split(","); System.out.println("hello2"); book.setBookMC(str[0]); System.out.println("hello3"); book.setAuthorName(str[1]);// 有问题 book.setPressName(str[2]); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); Date dt; Date dt2; try { dt = sdf.parse(str[3]); dt2 = sdf.parse(str[4]); book.setPublicationDate(dt); book.setRecordDate(dt2); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } book.setLocation(str[5]); book.setPrice(str[6]); book.setState(0); book.setEvaluate(0); book.setBrcount(0); book.setClassID(Integer.parseInt(str[9])); bookService.inserBook(book); } } @RequestMapping("/servlet/Statistics") public void Statistics(HttpServletRequest req, HttpServletResponse resp) throws IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("application/json; charset=UTF-8"); List<BookClass2> users = bookService.SelectBookClass(); JSONObject json = new JSONObject(); JSONArray jsonArray = new JSONArray(); if (users != null && users.size() > 0) { // 添加时间转换器 jsonArray.addAll(users); json.put("data", jsonArray); } else { // 没有查询到数据 json.put("count", 0); } PrintWriter out = resp.getWriter(); out.write(json.toString()); } @RequestMapping("/servlet/StatisticsServlet") public void StatisticsServlet(HttpServletRequest req, HttpServletResponse resp) throws IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("application/json; charset=UTF-8"); List<BookClass2> BookClass = bookService.SelectBookClass(); System.out.println("BookClass:" + BookClass); JSONObject json = new JSONObject(); JSONObject json2 = new JSONObject(); JSONArray jsonArray = new JSONArray(); JSONArray jsonArray2 = new JSONArray(); int a = 0; int q = -1; for (BookClass2 bookClass2 : BookClass) { System.out.println("name:" + bookClass2.getName()); List<NewBook> l = bookService.SelectBook(bookClass2.getName()); List<Object> li = new ArrayList<Object>(); json.remove(json); json.clear(); jsonArray.removeAll(jsonArray); jsonArray2.removeAll(jsonArray2); for (int i = 0; i < li.size(); i++) { li.remove(i); } for (int i = 0; i < l.size(); i++) { li.clear(); li.add(l.get(i).getBookMC()); li.add(l.get(i).getBrcount()); jsonArray2.add(li); } if (l != null && l.size() > 0) { // 添加时间转换器 jsonArray.addAll(jsonArray2); json.put("name", bookClass2.getName()); json.put("id", bookClass2.getName()); json.put("data", jsonArray); } else { // 没有查询到数据 json.put("count", 0); } q++; // json2.element(name2, json); json2.element(q + "", json); json2.put("length", q + 1); } PrintWriter out = resp.getWriter(); out.write(json2.toString()); } @RequestMapping("/servlet/DimServlet") public void DimServlet(String otxt, String otxt2, String otxt3, String otxt4, String type, HttpServletRequest request, HttpServletResponse response) throws IOException { request.setCharacterEncoding("utf-8"); response.setContentType("application/json; charset=UTF-8"); DimPaging.DimAllCount = 0; DimPaging.DimpageNumbe = 0; DimPaging.DimpageSize = 2; DimPaging.DimAllCount = bookService.selectCountByDim();// 查询书本数量 System.out.println(otxt + otxt2 + otxt3 + otxt4); boolean b = false; if (type != null) { if (type.equals("NextPage")) { DimPaging.DimpageNumbe = DimPaging.DimpageNumbe + 1; b = true; } if (type.equals("LastPage")) { DimPaging.DimpageNumbe = DimPaging.DimpageNumbe - 1; b = true; } if (DimPaging.DimpageNumbe < 0 || DimPaging.DimpageNumbe > DimPaging.DimAllCount / DimPaging.DimpageSize) { System.out.println("DimPaging.DimpageNumbe:" + DimPaging.DimpageNumbe); JSONObject json = new JSONObject(); if (DimPaging.DimpageNumbe < 0) { json.put("count", 0); DimPaging.DimpageNumbe = 0; json.put("data", "已经是首页"); } if (DimPaging.DimpageNumbe > DimPaging.DimAllCount / DimPaging.DimpageSize) { json.put("count", 0); DimPaging.DimpageNumbe = (int) Math.ceil(DimPaging.DimAllCount / (double) DimPaging.DimpageSize); json.put("data", "已经是尾页"); } PrintWriter out = response.getWriter(); out.write(json.toString()); } else { if (b == false) { DimPaging.DimpageNumbe = 0; } System.out.println(b); if ("".equals(otxt)) { } else { DynaSqlProvider.otxt = otxt; } if ("".equals(otxt2)) { } else { DynaSqlProvider.otxt2 = otxt2; } if ("".equals(otxt3)) { } else { DynaSqlProvider.otxt3 = otxt3; } if ("".equals(otxt4)) { } else { DynaSqlProvider.otxt4 = otxt4; } if ("".equals(otxt) && "".equals(otxt2) && "".equals(otxt3) && "".equals(otxt4)) { DynaSqlProvider.otxt = ""; DynaSqlProvider.otxt2 = ""; DynaSqlProvider.otxt3 = ""; DynaSqlProvider.otxt4 = ""; } List<NewBook> books = bookService.findByDim(); JSONObject json = new JSONObject(); JSONArray jsonArray = new JSONArray(); JsonConfig jsonConfig = new JsonConfig(); jsonConfig.