在线学习微信小程序.zip

package com.example.service.AdminService.AdminServiceImpl; import java.io.File; import java.io.IOException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Collections; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.servlet.ModelAndView; import com.alibaba.fastjson.JSONObject; import com.example.dao.AdminDao.AdminDao; import com.example.dao.topicDao.ChapterDao; import com.example.dao.topicDao.DayExerciseDao; import com.example.dao.topicDao.PracticeTestDao; import com.example.dao.vedioDao.VedioDao; import com.example.enumConfig.Monikaoshi; import com.example.pojo.Admin; import com.example.pojo.Book; import com.example.pojo.BookSection; import com.example.pojo.Practice; import com.example.pojo.Section; import com.example.pojo.T_Area; import com.example.pojo.T_File; import com.example.pojo.T_examination; import com.example.pojo.T_topic; import com.example.pojo.T_user; import com.example.pojo.Vedio; import com.example.pojo.t_mistakes; import com.example.service.AdminService.AdminService; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; @Service public class AdminServiceImpl implements AdminService { @Autowired AdminDao ad; @Autowired VedioDao vd; @Autowired ChapterDao cd; @Autowired ChapterDao chapterDao; @Autowired PracticeTestDao pd; @Autowired DayExerciseDao dd; List<Integer> his = new ArrayList<Integer>(); Map<String, List<T_topic>> map = new HashMap<String, List<T_topic>>(); public boolean adminLogin(String username, String password) { List<Admin> a = ad.adminLogin(new Admin(username, password)); if (a.size() > 0) { return true; } else { return false; } } public List<T_File> fileList() { List<T_File> list = ad.fileList(); List<T_File> list2 = new ArrayList<T_File>(); for (T_File t_File : list) { if (t_File.getStatus().equals("1")) { t_File.setStatus("单选题"); } else if (t_File.getStatus().equals("2")) { t_File.setStatus("判断题"); } else { t_File.setStatus("多选题"); } list2.add(t_File); } return list2; } public synchronized int fileUpload(MultipartFile file, HttpServletRequest servletRequest, String id) { //多选题 StringBuilder buffer = new StringBuilder(); int i; int j = 0; Sheet sheet; Workbook book; Cell cell1, cell2, cell3, cell4, cell5, cell6 = null, cell7 = null, cell8 = null; String path = servletRequest.getSession().getServletContext().getRealPath("/upload"); // 上传文件名 String name = file.getOriginalFilename();// 上传文件的真实名称 File filepath = new File(path, name); // 判断路径是否存在，没有就创建一个 if (!filepath.getParentFile().exists()) { filepath.getParentFile().mkdirs(); } // 将上传文件保存到一个目标文档中 File tempFile = new File(path + File.separator + name); try { Date date = new Date(); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); String time = format.format(date); file.transferTo(tempFile); // filepath为要读取的excel文件名 book = Workbook.getWorkbook(filepath); // 获得第一个工作表对象(ecxel中sheet的编号从0开始,0,1,2,3,....) sheet = book.getSheet(0); // 获取左上角的单元格 cell1 = sheet.getCell(0, 0); i = 1; boolean falg = false; int ifFileClass = 0; // 1为单选题。2为多选题。3为判断题 for (int k = 1; k < sheet.getRows(); k++) { System.out.println("行数" + sheet.getColumns()); T_topic topic; if (sheet.getColumns() == 7) {// 单选题 ifFileClass = 1; // 获取每一行的单元格 cell1 = sheet.getCell(0, k);// （列，行） cell2 = sheet.getCell(1, k); cell3 = sheet.getCell(2, k); cell4 = sheet.getCell(3, k); cell5 = sheet.getCell(4, k); cell6 = sheet.getCell(5, k); cell7 = sheet.getCell(6, k); topic = new T_topic(cell1.getContents(), cell2.getContents(), cell3.getContents(), cell4.getContents(), cell5.getContents(), cell6.getContents(), cell7.getContents(), "1"); if (id != null) { topic.setSid(Integer.parseInt(id)); } j = ad.insertTopic(topic); Integer tid = ad.maxTidList(); } else if (sheet.getColumns() >= 8) {// 多选题 ifFileClass = 3; // 获取每一行的单元格 cell1 = sheet.getCell(0, k);// （列，行） cell2 = sheet.getCell(1, k); cell3 = sheet.getCell(2, k); cell4 = sheet.getCell(3, k); cell5 = sheet.getCell(4, k); cell6 = sheet.getCell(5, k); cell7 = sheet.getCell(6, k); cell8 = sheet.getCell(7, k); try { if (cell7.getContents().equals("") || cell7.getContents().equals(null)) { topic = new T_topic(cell1.getContents(), cell2.getContents(), cell3.getContents(), cell4.getContents(), cell5.getContents(), cell6.getContents(), cell8.getContents(), "1"); if (id != null) { topic.setSid(Integer.parseInt(id)); } j = ad.insertTopic(topic); Integer tid = ad.maxTidList(); } else { String contents = cell2.getContents().replaceAll("，", "").replaceAll(" ", "") .replaceAll(",", ""); char[] split = contents.toCharArray(); for (int ii = 0; ii < split.length; ii++) { if (ii < split.length - 1) { buffer.append(split[ii] + ","); } else { buffer.append(split[ii]); } } topic = new T_topic(cell1.getContents(), buffer.toString(), cell3.getContents(), cell4.getContents(), cell5.getContents(), cell6.getContents(), cell7.getContents(), cell8.getContents(), "3"); buffer.delete(0, buffer.length()); System.out.println(topic); System.out.println("传过来的id" + id); if (id != null) { topic.setSid(Integer.parseInt(id)); } j = ad.insertTopic(topic); Integer tid = ad.maxTidList(); } } catch (NullPointerException e) { topic = new T_topic(cell1.getContents(), cell2.getContents(), cell3.getContents(), cell4.getContents(), cell5.getContents(), cell6.getContents(), cell8.getContents(), "1"); if (id != null) { topic.setSid(Integer.parseInt(id)); } j = ad.insertTopic(topic); Integer tid = ad.maxTidList(); } } else {// 判断题 ifFileClass = 2; // 获取每一行的单元格 cell1 = sheet.getCell(0, k);// （列，行） cell2 = sheet.getCell(1, k); cell3 = sheet.getCell(2, k); falg = true; topic = new T_topic(cell1.getContents(), cell2.getContents().toUpperCase(), cell3.getContents(), "2"); if (id != null) { topic.setSid(Integer.parseInt(id)); } j = ad.insertTopic(topic); Integer tid = ad.maxTidList(); } if ("".equals(cell1.getContents()) == true) // 如果读取的数据为空 break; } if (ifFileClass == 2) { T_File t_File = new T_File(name, "2", time, path); j = ad.insertFile(t_File); } else if (ifFileClass == 1) { T_File t_File = new T_File(name, "1", time, path); j = ad.insertFile(t_File); } else if (ifFileClass == 3) { T_File t_File = new T_File(name, "3", time, path); j = ad.insertFile(t_File); } book.close(); } catch