基于javaweb+mysql的ssm校园社团门户管理系统(java+ssm+jsp+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM校园社团门户管理系统(java+ssm+jsp+mysql)
系统主要实现的功能分前台用户和后台管理:
前台功能主要有:账号登录、添加关注模块,新闻快讯、通知公告、校历、求职招聘、学科资源信息展现等。
后台管理功能有:后台管理员角色管理、权限管理、社团管理、老师管理、用户管理、公告管理、新闻管理、校园风采管理、求职招聘管理、校历管理、学科资源管理等,老师。系统功能非常丰富完善。
运行环境:jdk1.8、eclipse/idea、Mysql5.7、Navicat/Sqlyog、Maven3.5/3.6
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//roleService.deleteBySqId("deleteBySql", params);
//状态删除
//Role load = roleService.load(id);
//load.setIsDelete(1);
//roleService.update(load);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "删除成功");
return jsonObject.toString();
}
/**
* 单文件上传
* @param file
* @param request
* @param model
* @return
*/
@RequestMapping(value = "/saveFile")
public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {
System.out.println("开始");
String path = request.getSession().getServletContext().getRealPath("/upload");
String fileName = file.getOriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!targetFile.exists()){
targetFile.mkdirs();
}
//保存
try {
file.transferTo(targetFile);
} catch (Exception e) {
e.printStackTrace();
}
return "";
}
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete.do")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
//真正删除
newsService.deleteById(id);
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//newsService.deleteBySqId("deleteBySql", params);
//状态删除
//News load = newsService.load(id);
//load.setIsDelete(1);
//newsService.update(load);
return "redirect:/news/findByObj.do";
}
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.json", method = RequestMethod.GET)
@ResponseBody
public String findByObjByEntity(News news, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<News> pagers = newsService.findByEntity(news);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", news);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap.json", method = RequestMethod.GET)
@ResponseBody
public String findByMapMap(News news, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
@RequestMapping(value = "/update.do")
public String update(Integer id,Model model) {
UserNotice obj = userNoticeService.load(id);
model.addAttribute("obj",obj);
return "userNotice/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate.do")
public String exUpdate(UserNotice userNotice, Model model, HttpServletRequest request, HttpServletResponse response) {
userNoticeService.update(userNotice);
return "redirect:/userNotice/findByObj.do";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete.do")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
//真正删除
userNoticeService.deleteById(id);
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//userNoticeService.deleteBySqId("deleteBySql", params);
//状态删除
//UserNotice load = userNoticeService.load(id);
//load.setIsDelete(1);
//userNoticeService.update(load);
return "redirect:/userNotice/findByObj.do";
}
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list json(通过对象)
@RequestMapping(value = "/findByMap.do")
public String findByMap(Role role, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(role.getName())){
params.put("name", role.getName());
}
if(!isEmpty(role.getIsDelete())){
params.put("isDelete", role.getIsDelete());
}
//分页查询
Pager<Role> pagers = roleService.findByMap(params);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", role);
return "role/role";
}
/**
* 跳至添加页面
* @return
*/
@RequestMapping(value = "/add.do")
public String add() {
return "role/add";
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd.do")
public String exAdd(Role role, Model model, HttpServletRequest request, HttpServletResponse response) {
role.setIsDelete(0);
roleService.insert(role);
return "redirect:/role/findByObj.do";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update.do")
public String update(Integer id,Model model) {
Role role = roleService.load(id);
model.addAttribute("obj",role);
return "role/update";
model.addAttribute("obj",obj);
return "schoolInfo/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate.do")
public String exUpdate(@RequestParam(value = "file", required = false) MultipartFile file,SchoolInfo schoolInfo, Model model, HttpServletRequest request, HttpServletResponse response) {
if(!file.isEmpty()){
System.out.println("开始");
String path = request.getSession().getServletContext().getRealPath("/")+"upload/";
String fileName = file.getOriginalFilename();
String uploadPath=path+fileName;
File targetFile = new File(uploadPath);
if(!targetFile.exists()){
targetFile.mkdirs();
}
schoolInfo.setContent(request.getServletContext().getContextPath()+"/upload/" + fileName);
//保存
try {
file.transferTo(targetFile);
} catch (Exception e) {
e.printStackTrace();
}
}
schoolInfoService.update(schoolInfo);
return "redirect:/schoolInfo/findByObj.do";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete.do")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
//真正删除
schoolInfoService.deleteById(id);
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//schoolInfoService.deleteBySqId("deleteBySql", params);
//状态删除
//SchoolInfo load = schoolInfoService.load(id);
* @return
*/
@RequestMapping(value = "/delete.json", produces = "text/html;charset=UTF-8", method = RequestMethod.GET)
@ResponseBody
public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
//真正删除
xkzyService.deleteById(id);
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//xkzyService.deleteBySqId("deleteBySql", params);
//状态删除
//Xkzy load = xkzyService.load(id);
//load.setIsDelete(1);
//xkzyService.update(load);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "删除成功");
return jsonObject.toString();
}
/**
* 单文件上传
* @param file
* @param request
* @param model
* @return
*/
@RequestMapping(value = "/saveFile")
public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {
System.out.println("开始");
String path = request.getSession().getServletContext().getRealPath("/upload");
String fileName = file.getOriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!targetFile.exists()){
targetFile.mkdirs();
}
//保存
try {
file.transferTo(targetFile);
} catch (Exception e) {
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(webCount.getCountAll())){
params.put("countAll", webCount.getCountAll());
}
//分页查询
Pager<WebCount> pagers = webCountService.findByMap(params);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", webCount);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAdd.json", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(WebCount webCount, Model model, HttpServletRequest request, HttpServletResponse response) {
webCountService.insert(webCount);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* ajax 修改
* @param
* @return
*/
@RequestMapping(value = "/exUpdate.json",method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(WebCount webCount, Model model, HttpServletRequest request, HttpServletResponse response) {
webCountService.update(webCount);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "修改成功");
return jsonObject.toString();
}
/**
* @ClassName:
* @Description:
*/
@Controller
@RequestMapping("/xl")
public class XlController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private XlService xlService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.do")
System.out.println("开始");
String path = request.getSession().getServletContext().getRealPath("/upload");
String fileName = file.getOriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!targetFile.exists()){
targetFile.mkdirs();
}
//保存
try {
file.transferTo(targetFile);
} catch (Exception e) {
e.printStackTrace();
}
return "";
}
/**
* springMvc多文件上传
* @param files
* @param id
* @return
*/
@RequestMapping(value = "/saveFiles")
public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
for(int i = 0;i<files.length;i++){
System.out.println("fileName---------->" + files[i].getOriginalFilename());
if(!files[i].isEmpty()){
int pre = (int) System.currentTimeMillis();
try {
//拿到输出流,同时重命名上传的文件
String filePath = request.getRealPath("/upload");
File f=new File(filePath);
if(!f.exists()){
f.mkdirs();
}
String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
File file=new File(filePath+"/"+pre + files[i].getOriginalFilename());
if(!file.exists()){
file.createNewFile();
}
files[i].transferTo(file);
} catch (Exception e) {
e.printStackTrace();
System.out.println("上传出错");
}
}
}
return "";
}
// --------------------------------------- 华丽分割线 ------------------------------
*/
@Controller
@RequestMapping("/userRole")
public class UserRoleController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private UserRoleService userRoleService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.do")
public String findByObj(UserRole userRole, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<UserRole> pagers = userRoleService.findByEntity(userRole);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", userRole);
return "userRole/userRole";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap.do")
public String findByMap(UserRole userRole, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(userRole.getUserId())){
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAdd.json", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(Action action, Model model, HttpServletRequest request, HttpServletResponse response) {
actionService.insert(action);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* ajax 修改
* @param
* @return
*/
@RequestMapping(value = "/exUpdate.json",method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(Action action, Model model, HttpServletRequest request, HttpServletResponse response) {
actionService.update(action);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "修改成功");
return jsonObject.toString();
}
/**
* ajax 删除
* @return
*/
@RequestMapping(value = "/delete.json", produces = "text/html;charset=UTF-8", method = RequestMethod.GET)
@ResponseBody
public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
//真正删除
actionService.deleteById(id);
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//actionService.deleteBySqId("deleteBySql", params);
//状态删除
//Action load = actionService.load(id);
//load.setIsDelete(1);
@RequestMapping(value = "/delete.do")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
//真正删除
schoolInfoService.deleteById(id);
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//schoolInfoService.deleteBySqId("deleteBySql", params);
//状态删除
//SchoolInfo load = schoolInfoService.load(id);
//load.setIsDelete(1);
//schoolInfoService.update(load);
return "redirect:/schoolInfo/findByObj.do";
}
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.json", method = RequestMethod.GET)
@ResponseBody
public String findByObjByEntity(SchoolInfo schoolInfo, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<SchoolInfo> pagers = schoolInfoService.findByEntity(schoolInfo);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", schoolInfo);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//actionService.deleteBySqId("deleteBySql", params);
//状态删除
Action load = actionService.load(id);
load.setIsDelete(1);
actionService.update(load);
return "redirect:/action/findByObj.do";
}
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.json", method = RequestMethod.GET)
@ResponseBody
public String findByObjByEntity(Action action, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Action> pagers = actionService.findByEntity(action);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", action);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap.json", method = RequestMethod.GET)
@ResponseBody
public String findByMapMap(Action action, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(action.getName())){
params.put("name", action.getName());
}
if(!isEmpty(action.getIsDelete())){
params.put("isDelete", action.getIsDelete());
/**
* springMvc多文件上传
* @param files
* @param id
* @return
*/
@RequestMapping(value = "/saveFiles")
public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
for(int i = 0;i<files.length;i++){
System.out.println("fileName---------->" + files[i].getOriginalFilename());
if(!files[i].isEmpty()){
int pre = (int) System.currentTimeMillis();
try {
//拿到输出流,同时重命名上传的文件
String filePath = request.getRealPath("/upload");
File f=new File(filePath);
if(!f.exists()){
f.mkdirs();
}
String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
File file=new File(filePath+"/"+pre + files[i].getOriginalFilename());
if(!file.exists()){
file.createNewFile();
}
files[i].transferTo(file);
} catch (Exception e) {
e.printStackTrace();
System.out.println("上传出错");
}
}
}
return "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap.json", method = RequestMethod.GET)
@ResponseBody
public String findByMapMap(Action action, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(action.getName())){
params.put("name", action.getName());
}
if(!isEmpty(action.getIsDelete())){
params.put("isDelete", action.getIsDelete());
}
//分页查询
Pager<Action> pagers = actionService.findByMap(params);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", action);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAdd.json", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(Action action, Model model, HttpServletRequest request, HttpServletResponse response) {
actionService.insert(action);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
if(!isEmpty(manage.getIsDelete())){
params.put("isDelete", manage.getIsDelete());
}
//分页查询
Pager<Manage> pagers = manageService.findByMap(params);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", manage);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAdd.json", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
manageService.insert(manage);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* ajax 修改
* @param
* @return
*/
@RequestMapping(value = "/exUpdate.json",method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
manageService.update(manage);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "修改成功");
return jsonObject.toString();
}
/**
* ajax 删除
* @return
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private RoleActionService roleActionService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.do")
public String findByObj(RoleAction roleAction, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<RoleAction> pagers = roleActionService.findByEntity(roleAction);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", roleAction);
return "roleAction/roleAction";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap.do")
public String findByMap(RoleAction roleAction, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(roleAction.getActionId())){
params.put("actionId", roleAction.getActionId());
}
if(!isEmpty(roleAction.getRoleId())){
params.put("roleId", roleAction.getRoleId());
}
//分页查询
Pager<RoleAction> pagers = roleActionService.findByMap(params);
model.addAttribute("pagers", pagers);
//存储查询条件
load.setIsDelete(1);
roleService.update(load);
return "redirect:/role/findByObj.do";
}
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.json", method = RequestMethod.GET)
@ResponseBody
public String findByObjByEntity(Role role, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Role> pagers = roleService.findByEntity(role);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", role);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap.json", method = RequestMethod.GET)
@ResponseBody
public String findByMapMap(Role role, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(role.getName())){
params.put("name", role.getName());
}
if(!isEmpty(role.getIsDelete())){
params.put("isDelete", role.getIsDelete());
}
//分页查询
Pager<Role> pagers = roleService.findByMap(params);