项目介绍
教材征订与发放管理系统。本系统共分三种角色，分别为管理员、老师、班长；现在分别来介绍各个角色的功能：
管理员
查看所有图书
修改图书库存
审批图书订单(通过图书订单,不通过订单)
删除图书订单
查看等待发放的图书
查看已经发放的图书
增加库存图书
删除库存图书
修改图书数量
教师与班级管理
查看教师列表
查看班长列表
修改教师信息
修改班长信息
修改班长密码
修改教师密码
删除教师
删除班长
发放图书
修改教师信息
修改学生信息
查看已经发放订单
老师
查看自己订单
查看图书信息
增加订单
查看发放订单
修改个人信息
修改学生
查看班长列表
修改班长信息
班长
修改个人信息
查看自己班已经审批订单
环境需要
1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；
5.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目
6.数据库：MySql 5.7版本；
技术栈
- 后端：Spring SpringMVC MyBatis
- 前端：JSP+jQuery
使用说明
- 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
- 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置
- 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行； - 运行项目，输入localhost:8080/xxx 登录
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
public String findAllBookKind(){
List allKinds = bookService.findAllBookKind();
return JSON.toJSONString(allKinds);
}
@RequestMapping("/book/exportData")
public String exportData(HttpServletResponse response){
List books = bookService.findAllBook();
POIUtil.exportExcel(books,Book.class,"书籍基本信息","",response);
return NormalExcelConstants.EASYPOI_EXCEL_VIEW;//需要配置新的视图解析器并设置优先级和扫描
}
@ResponseBody
@RequestMapping(value = "/updateBookById")
public String updateBookById(@RequestBody Map map){
int n = bookService.updateBookById(map);
if(n>0){
return "success";
}
Map userMap = new HashMap();
Map userInfoMap = new HashMap();
String id = RandNum.getGUID();
userMap.put("id",id);
userMap.put("identification","学生");
userMap.put("name",map.get("name"));
userMap.put("password",map.get("password"));
userMap.put("phone",map.get("phone"));
userMap.put("email",map.get("email"));
userInfoMap.put("user_id",id);
userInfoMap.put("col_id",map.get("col_id"));
userInfoMap.put("prof_id",map.get("prof_id"));
userInfoMap.put("gra_id",map.get("gra_id"));
userInfoMap.put("ccl_id",map.get("ccl_id"));
userInfoMap.put("t_id",map.get("t_id"));
userMap.put("password",map.get("password"));
userMap.put("phone",map.get("phone"));
userMap.put("email",map.get("email"));
userInfoMap.put("user_id",id);
userInfoMap.put("col_id",map.get("col_id"));
userInfoMap.put("prof_id",map.get("prof_id"));
userInfoMap.put("gra_id",map.get("gra_id"));
userInfoMap.put("ccl_id",map.get("ccl_id"));
userInfoMap.put("t_id",map.get("t_id"));
userService.insertUser(userMap);
int n = userService.insertStuUserInfo(userInfoMap);
if(n>0){
return "success";
}else {
return "failure";
}
}
@ResponseBody
@RequestMapping(value = "/insertTeaUser",produces="application/json;charset=UTF-8")
public String insertTeaUser(@RequestBody Map map){
Map userMap = new HashMap();
}
@ResponseBody
@RequestMapping(value = "/insertTeaUser",produces="application/json;charset=UTF-8")
public String insertTeaUser(@RequestBody Map map){
Map userMap = new HashMap();
Map teacherInfoMap = new HashMap();
String id = RandNum.getGUID();
userMap.put("id",id);
userMap.put("identification","教师");
userMap.put("name",map.get("name"));
userMap.put("password",map.get("password"));
userMap.put("phone",map.get("phone"));
userMap.put("email",map.get("email"));
teacherInfoMap.put("user_id",id);
return "success";
}else {
return "failure";
}
}
return "failure";
}
@ResponseBody
@RequestMapping("/insertUser")
public String insertUser(){
return "";
}
@ResponseBody
@RequestMapping(value = "/findAllTeacher",produces="application/json;charset=UTF-8")
public String findAllTeacher(){
List users = userService.findAllTeacher();
Layui l = Layui.data(users.size(), users);
//System.out.println("bjshbd");
//int error = 1/0;
int start = (Integer.parseInt(page) - 1)*Integer.parseInt(limit);
int pageSize = Integer.parseInt(limit);
Listlist = userService.findAllUsersByPage(start,pageSize);
ListallData = userService.findAllUsers();
System.out.println(list);
Layui l = Layui.data(allData.size(), list);
String result = JSON.toJSONString(l);
System.out.println(result);
return result;
}
@ResponseBody
@RequestMapping(value = "/getUserInfo",produces="application/json;charset=UTF-8",method =RequestMethod.POST )
teacherInfoMap.put("user_id",id);
teacherInfoMap.put("col_id",map.get("col_id"));
teacherInfoMap.put("prof_id",map.get("prof_id"));
teacherInfoMap.put("gra_id",map.get("gra_id"));
teacherInfoMap.put("ccl_id",map.get("ccl_id"));
userService.insertUser(userMap);
int n = userService.insertStuUserInfo(teacherInfoMap);
if(n>0){
return "success";
}else {
return "failure";
}
}
}
库存管理控制层：
@Controller
public class StoreInController {
@Autowired
StoreInService storeInService;
@ResponseBody
@RequestMapping(value = "/getAllStoreInByPage",produces="application/json;charset=UTF-8")
public String getAllStoreInByPage(@RequestParam("limit") String limit, @RequestParam("page") String page){
,@RequestParam("book_count")String book_count
,@RequestParam("book_name")String book_name*/
@RequestBody Map dataMap
){
System.out.println(dataMap);
String store_info =dataMap.get("store_info").toString();
String book_count = dataMap.get("book_count").toString();
String book_name =dataMap.get("book_name").toString();
String qs_name = dataMap.get("qs_name").toString();
String id = RandNum.getGUID();
Date date = new Date();
StoreIn storeIn = new StoreIn(id,date,store_info,Integer.parseInt(book_count),book_name,qs_name,Integer.parseInt(book_count));
@ResponseBody
@RequestMapping("/book/insertData")
public Object supplierImportExcel(@RequestParam("file") MultipartFile file){
int n= 0;
//long s = file.getSize();
Map map = new HashMap<>();
Map result = new HashMap();
List book = POIUtil.importExcel(file,Book.class);
Layui l = Layui.data(allData.size(), list);
String result = JSON.toJSONString(l);
System.out.println("result:"+result);
return result;
}
@ResponseBody
@RequestMapping(value = "/insertStoreIn")
public String insertStoreIn(
@RequestBody Map dataMap
){
System.out.println(dataMap);
String store_info =dataMap.get("store_info").toString();
String book_count = dataMap.get("book_count").toString();
String book_name =dataMap.get("book_name").toString();
String qs_name = dataMap.get("qs_name").toString();
String id = RandNum.getGUID();
Date date = new Date();
StoreIn storeIn = new StoreIn(id,date,store_info,Integer.parseInt(book_count),book_name,qs_name,Integer.parseInt(book_count));
}
Layui l = Layui.data(allData.size(), list);
String result = JSON.toJSONString(l);
System.out.println("result:"+result);
return result;
}
@ResponseBody
@RequestMapping(value = "/insertStoreIn")
public String insertStoreIn(
@RequestBody Map dataMap
){
System.out.println(dataMap);
String store_info =dataMap.get("store_info").toString();
String book_count = dataMap.get("book_count").toString();
String book_name =dataMap.get("book_name").toString();
