基于javaweb+mysql的ssm校园社团门户网站管理系统(前台、后台)(java+jsp+ssm+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
分为前台和后台
前台校园门户网站信息查看:学生
后台内容管理:管理员、教师、社团(角色不同,权限菜单不同)
前台
后台
技术框架
JavaBean MVC JSP SSM(Spring SpringMVC MyBatis) MySQL jQuery JavaScript CSS…
基于javaweb+mysql的SSM校园社团门户网站管理系统(前台、后台)(java+jsp+ssm+mysql)
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(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.json", method = RequestMethod.GET)
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);
//load.setIsDelete(1);
//schoolInfoService.update(load);
return "redirect:/schoolInfo/findByObj.do";
}
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 "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
*/
@RequestMapping(value = "/delete.do")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
//真正删除
//userService.deleteById(id);
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//userService.deleteBySqId("deleteBySql", params);
//状态删除
User load = userService.load(id);
load.setIsDelete(1);
userService.update(load);
User obj = userService.load(id);
return "redirect:/user/findByMap.do?type="+obj.getType();
}
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.json", method = RequestMethod.GET)
@ResponseBody
public String findByObjByEntity(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<User> pagers = userService.findByEntity(user);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", user);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap.json", method = RequestMethod.GET)
/**
* @ClassName:
* @Description:
*/
@Controller
@RequestMapping("/xkzy")
public class XkzyController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private XkzyService xkzyService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.do")
public String findByObj(Xkzy xkzy, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Xkzy> pagers = xkzyService.findByEntity(xkzy);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", xkzy);
return "xkzy/xkzy";
}
@RequestMapping(value = "/findByObj2.do")
public String findByObj2(Xkzy xkzy, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Xkzy> pagers = xkzyService.findByEntity(xkzy);
}
//分页查询
Pager<Notice> pagers = noticeService.findByMap(params);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", notice);
return "notice/notice";
}
/**
* 跳至添加页面
* @return
*/
@RequestMapping(value = "/add.do")
public String add() {
return "notice/add";
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd.do")
public String exAdd(Notice notice, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = request.getSession().getAttribute("isManage");
if(isEmpty(attribute)){
Integer id = Integer.valueOf(request.getSession().getAttribute("userId").toString());
notice.setAddUserId(id);
}
notice.setAddTime(new Date());
noticeService.insert(notice);
/**
* 下面执行短信推送
* d1.setNum(1);
d1.setName("新闻快讯");
dtos.add(d1);
GzDto d2 = new GzDto();
d2.setNum(2);
d2.setName("通知公告");
dtos.add(d2);
GzDto d3 = new GzDto();
d3.setNum(3);
d3.setName("求职招聘");
dtos.add(d3);
GzDto d4 = new GzDto();
/**
* 判断当前登陆角色和信息
*
*/
public class UserUtils {
@Autowired
private static HttpSession session;
public static HttpSession getSession(){
return session;
}
/**
* 获取当前登陆的用户
* @return
*/
public static User getUser(){
//将用户信息放入session
try {
User user = (User)session.getAttribute("user");
return user;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/**
* 获取当前登陆的管理员
* @return
*/
public static Manage getManage(){
//将用户信息放入session
try {
Manage manage = (Manage)session.getAttribute("manage");
return manage;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/**
* 获取当前登陆的id
* @return
*/
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("/notice")
public class NoticeController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private NoticeService noticeService;
@Autowired
private GzService gzService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.do")
public String findByObj(Notice notice, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = request.getSession().getAttribute("isManage");
if(isEmpty(attribute)){
Integer id = Integer.valueOf(request.getSession().getAttribute("userId").toString());
notice.setAddUserId(id);
}
//分页查询
Pager<Notice> pagers = noticeService.findByEntity(notice);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", notice);
return "notice/notice";
}
@RequestMapping(value = "/findByObj2.do")
public String findByObj2(Notice notice, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Notice> pagers = noticeService.findByEntity(notice);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", notice);
return "notice/notice2";
}
@RequestMapping(value = "/detail.do")
public String detail(Integer id,Model model) {
Notice obj = noticeService.load(id);
model.addAttribute("obj",obj);
return "notice/detail";
}
/**
* 分页查询 返回list对象(通过Map)
*/
@Controller
@RequestMapping("/schoolJob")
public class SchoolJobController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private GzService gzService;
@Autowired
private SchoolJobService schoolJobService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.do")
public String findByObj(SchoolJob schoolJob, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = request.getSession().getAttribute("isManage");
if(isEmpty(attribute)){
Integer id2 = Integer.valueOf(request.getSession().getAttribute("userId").toString());
schoolJob.setAddUserId(id2);
}
//分页查询
Pager<SchoolJob> pagers = schoolJobService.findByEntity(schoolJob);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", schoolJob);
return "schoolJob/schoolJob";
}
@RequestMapping(value = "/findByObj2.do")
public String findByObj2(SchoolJob schoolJob, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<SchoolJob> pagers = schoolJobService.findByEntity(schoolJob);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", schoolJob);
return "schoolJob/schoolJob2";
}
//状态删除
//Xl load = xlService.load(id);
//load.setIsDelete(1);
//xlService.update(load);
return "redirect:/xl/findByObj.do";
}
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.json", method = RequestMethod.GET)
@ResponseBody
public String findByObjByEntity(Xl xl, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Xl> pagers = xlService.findByEntity(xl);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", xl);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap.json", method = RequestMethod.GET)
@ResponseBody
public String findByMapMap(Xl xl, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(xl.getRiqi())){
params.put("riqi", xl.getRiqi());
}
if(!isEmpty(xl.getContent())){
params.put("content", xl.getContent());
}
//分页查询
Pager<Xl> pagers = xlService.findByMap(params);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", xl);
return jsonObject.toString();
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 "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
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 "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
/**
* @ClassName:
* @Description:
*/
@Controller
@RequestMapping("/userRole")
@RequestMapping(value = "/add.do")
public String add() {
return "manage/add";
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd.do")
public String exAdd(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
manageService.insert(manage);
return "redirect:/manage/findByObj.do";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update.do")
public String update(Integer id,Model model) {
Manage obj = manageService.load(id);
model.addAttribute("obj",obj);
return "manage/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate.do")
public String exUpdate(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
manageService.update(manage);
return "redirect:/manage/findByObj.do";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete.do")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
//真正删除
manageService.deleteById(id);
//通过参数删除
//Map<String,Object> params = new HashMap<String,Object>();
//params.put("id", id);
//manageService.deleteBySqId("deleteBySql", params);
/**
* 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 "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(userNotice.getType())){
params.put("type", userNotice.getType());
}
if(!isEmpty(userNotice.getUserId())){
params.put("userId", userNotice.getUserId());
}
//分页查询
Pager<UserNotice> pagers = userNoticeService.findByMap(params);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", userNotice);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAdd.json", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(UserNotice userNotice, Model model, HttpServletRequest request, HttpServletResponse response) {
userNoticeService.insert(userNotice);
JSONObject jsonObject = JsonUtil2.getJsonObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* ajax 修改
* @param
* @return
*/
@RequestMapping(value = "/exUpdate.json",method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(UserNotice userNotice, Model model, HttpServletRequest request, HttpServletResponse response) {
userNoticeService.update(userNotice);
JSONObject jsonObject = JsonUtil2.getJsonObject();
/**
* @ClassName:
* @Description:
*/
@Controller
@RequestMapping("/news")
public class NewsController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private NewsService newsService;
@Autowired
private GzService gzService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj.do")
public String findByObj(News news, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = request.getSession().getAttribute("isManage");
if(isEmpty(attribute)){
Integer id = Integer.valueOf(request.getSession().getAttribute("userId").toString());
news.setAddUserId(id);
}
//分页查询
Pager<News> pagers = newsService.findByEntity(news);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", news);
return "news/news";