基于javaweb+mysql的ssm+maven毕业生去向登记分析管理系统(java+ssm+html+javascript+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven毕业生去向登记分析管理系统(java+ssm+html+javascript+mysql)
项目介绍
本项目包含两种角色,管理员与学生角色; 管理员角色包含以下功能: 管理员登录,学生管理,留言管理,通知公告管理,查看专业比较,查看年份比较,查看去向明细,查看去向统计,修改密码等功能。
学生角色包含以下功能: 学生登录,查看通知公告,查看我的去向,留言管理,修改个人资料,修改密码等功能。
环境需要
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.数据库:MySql 5.7版本; 6.是否Maven项目: 是;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
技术栈
- 后端:Spring SpringMVC MyBatis 2. 前端:HTML+css+javascript
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/ssm_bysqxdj 登录
/**
* 系统日志
*
* @email 123456@qq.com
*/
@Controller
@RequestMapping("/sys/log")
public class SysLogController {
@Autowired
private SysLogService sysLogService;
/**
* 列表
*/
@ResponseBody
@RequestMapping("/list")
@RequiresPermissions("sys:log:list")
public R list(@RequestParam Map<String, Object> params){
//查询列表数据
Query query = new Query(params);
List<SysLogEntity> sysLogList = sysLogService.queryList(query);
int total = sysLogService.queryTotal(query);
PageUtils pageUtil = new PageUtils(sysLogList, total, query.getLimit(), query.getPage());
return R.ok().put("page", pageUtil);
}
}
/**
* XSS过滤
* @email 123456@qq.com
sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 3));
//在sheet里创建第二行
HSSFRow row2 = sheet.createRow(1);
//创建单元格并设置单元格内容
row2.createCell(0).setCellValue("姓名");
row2.createCell(1).setCellValue("邮箱");
row2.createCell(2).setCellValue("手机号");
row2.createCell(3).setCellValue("状态");
row2.createCell(4).setCellValue("性别");
row2.createCell(5).setCellValue("学院");
row2.createCell(6).setCellValue("专业");
row2.createCell(7).setCellValue("班级");
row2.createCell(8).setCellValue("去向");
row2.createCell(9).setCellValue("单位");
row2.createCell(10).setCellValue("职位");
row2.createCell(11).setCellValue("薪资");
//在sheet里创建第三行
int i = 2;
for (SysUserEntity user : this.sysUserService.queryList(new HashMap<String, Object>())) {
HSSFRow row3 = sheet.createRow(i);
row3.createCell(0).setCellValue(user.getUsername());
row3.createCell(1).setCellValue(user.getEmail());
row3.createCell(2).setCellValue(user.getMobile());
row3.createCell(3).setCellValue(user.getStatus() == 1 ? "正常" : "冻结");
row3.createCell(4).setCellValue(user.getSex());
row3.createCell(5).setCellValue(user.getXy());
row3.createCell(6).setCellValue(user.getZy());
row3.createCell(7).setCellValue(user.getBj());
row3.createCell(8).setCellValue(user.getQx());
row3.createCell(9).setCellValue(user.getDw());
row3.createCell(10).setCellValue(user.getZw());
row3.createCell(11).setCellValue(user.getXz());
i++;
}
//.....省略部分代码
//输出Excel文件
OutputStream output = response.getOutputStream();
response.reset();
response.setHeader("Content-disposition", "attachment; filename=users.xls");
response.setContentType("application/msexcel");
wb.write(output);
output.close();
return null;
}
}
*/
@RequestMapping("/update")
public R update(@RequestBody ReplyEntity reply) {
reply.setRtime(new Date());
replyService.update(reply);
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids) {
replyService.deleteBatch(ids);
return R.ok();
}
}
/**
* 系统配置信息
*
* @email 123456@qq.com
*/
@RestController
@RequestMapping("/sys/config")
public class SysConfigController extends AbstractController {
@Autowired
private SysConfigService sysConfigService;
/**
* 所有配置列表
if(parentType != Constant.MenuType.MENU.getValue()){
throw new RRException("上级菜单只能为菜单类型");
}
return ;
}
}
}
/**
* 登录相关
*
List<NoticeEntity> noticeList = noticeService.queryList(query);
int total = noticeService.queryTotal(query);
PageUtils pageUtil = new PageUtils(noticeList, total, query.getLimit(), query.getPage());
return R.ok().put("page", pageUtil);
}
/**
* 列表
*/
@RequestMapping("/list2")
public R list2(@RequestParam Map<String, Object> params){
Query query = new Query(params);
List<NoticeEntity> noticeList = noticeService.queryList(query);
return R.ok().put("list", noticeList );
}
/**
* 信息
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
NoticeEntity notice = noticeService.queryObject(id);
return R.ok().put("notice", notice);
}
/**
* 保存
*/
@RequestMapping("/save")
public R save(@RequestBody NoticeEntity notice){
noticeService.save(notice);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
public R update(@RequestBody NoticeEntity notice){
/**
* 上传的文件处理工具类
*
*/
public class MultipartFileUtil {
public static final Logger logger = LoggerFactory.getLogger(MultipartFileUtil.class);
/**
* 根据文件名称获取后缀名
*
* @param fileName 文件名称
* @return 结果
*/
public static String getSuffix(String fileName) {
return fileName.substring(fileName.lastIndexOf(".") + 1);
}
/**
* 获取项目根路径
*
* @return 结果
*/
public static String getRootPath(HttpServletRequest request) {
String classPath = request.getSession().getServletContext().getRealPath( "/" );
String rootPath = "";
//windows下
if ("\\".equals(File.separator)) {
// rootPath = classPath.substring(1, classPath.indexOf("/WEB-INF/classes"));
rootPath = classPath;
rootPath = rootPath.replace("/", "\\");
}
//linux下
if ("/".equals(File.separator)) {
rootPath = classPath.substring(0, classPath.indexOf("/WEB-INF/classes"));
orgRequest = request;
}
@Override
public String getParameter(String name) {
String value = super.getParameter(xssEncode(name));
if (StringUtils.isNotBlank(value)) {
value = xssEncode(value);
}
return value;
}
@Override
public String[] getParameterValues(String name) {
String[] parameters = super.getParameterValues(name);
if (parameters == null || parameters.length == 0) {
return null;
}
for (int i = 0; i < parameters.length; i++) {
parameters[i] = xssEncode(parameters[i]);
}
return parameters;
}
@Override
public Map<String,String[]> getParameterMap() {
Map<String,String[]> map = new LinkedHashMap<>();
Map<String,String[]> parameters = super.getParameterMap();
for (String key : parameters.keySet()) {
String[] values = parameters.get(key);
for (int i = 0; i < values.length; i++) {
values[i] = xssEncode(values[i]);
}
map.put(key, values);
}
return map;
}
@Override
public String getHeader(String name) {
String value = super.getHeader(xssEncode(name));
IOUtils.write(data, response.getOutputStream());
}
}
/**
* 通知公告
*
* @email 123456@qq.com
*/
@RestController
@RequestMapping("notice")
public class NoticeController extends AbstractController {
@Autowired
private NoticeService noticeService;
/**
* 列表
*/
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params){
//查询列表数据
Query query = new Query(params);
List<NoticeEntity> noticeList = noticeService.queryList(query);
int total = noticeService.queryTotal(query);
PageUtils pageUtil = new PageUtils(noticeList, total, query.getLimit(), query.getPage());
* @email 123456@qq.com
*/
@Controller
public class SysLoginController {
@Autowired
private Producer producer;
@Autowired
private SysUserService sysUserService;
@RequestMapping("captcha.jpg")
public void captcha(HttpServletResponse response) throws ServletException, IOException {
response.setHeader("Cache-Control", "no-store, no-cache");
response.setContentType("image/jpeg");
//生成文字验证码
String text = String.format("%04d",new Random().nextInt(9999));
//生成图片验证码
BufferedImage image = producer.createImage(text);
//保存到shiro session
ShiroUtils.setSessionAttribute(Constants.KAPTCHA_SESSION_KEY, text);
ServletOutputStream out = response.getOutputStream();
ImageIO.write(image, "jpg", out);
}
/**
* 登录
*/
@ResponseBody
@RequestMapping(value = "/sys/login", method = RequestMethod.POST)
public R login(String username, String password, String captcha) throws IOException {
String kaptcha = ShiroUtils.getKaptcha(Constants.KAPTCHA_SESSION_KEY);
if(!captcha.equalsIgnoreCase(kaptcha)){
return R.error("验证码不正确");
}
try {
Subject subject = ShiroUtils.getSubject();
//sha256加密
// password = new Sha256Hash(password).toHex();
//sha256加密
// newPassword = new Sha256Hash(newPassword).toHex();
//更新密码
int count = sysUserService.updatePassword(getUserId(), password, newPassword);
if (count == 0) {
return R.error("原密码不正确");
}
//退出
ShiroUtils.logout();
return R.ok();
}
@SysLog("修改个人信息")
@RequestMapping("/updateInfo")
public R updateInfo(@RequestBody SysUserEntity user) {
this.sysUserService.update(user);
return R.ok();
}
/**
* 用户信息
*/
@RequestMapping("/info/{userId}")
public R info(@PathVariable("userId") Long userId) {
SysUserEntity user = sysUserService.queryObject(userId);
//获取用户所属的角色列表
List<Long> roleIdList = sysUserRoleService.queryRoleIdList(userId);
user.setRoleIdList(roleIdList);
return R.ok().put("user", user);
}
/**
* 保存用户
*/
/**
* 角色管理
*
* @email 123456@qq.com
*/
@RestController
@RequestMapping("/sys/role")
public class SysRoleController extends AbstractController {
@Autowired
private SysRoleService sysRoleService;
@Autowired
private SysRoleMenuService sysRoleMenuService;
/**
* 角色列表
*/
@RequestMapping("/list")
@RequiresPermissions("sys:role:list")
public R list(@RequestParam Map<String, Object> params){
//如果不是超级管理员,则只查询自己创建的角色列表
// if(getUserId() != Constant.SUPER_ADMIN){
// params.put("createUserId", getUserId());
// }
//查询列表数据
Query query = new Query(params);
List<SysRoleEntity> list = sysRoleService.queryList(query);
int total = sysRoleService.queryTotal(query);
PageUtils pageUtil = new PageUtils(list, total, query.getLimit(), query.getPage());
return R.ok().put("page", pageUtil);
}
/**
public class XssHttpServletRequestWrapper extends HttpServletRequestWrapper {
//没被包装过的HttpServletRequest(特殊场景,需求自己过滤)
HttpServletRequest orgRequest;
//html过滤
private final static HTMLFilter htmlFilter = new HTMLFilter();
public XssHttpServletRequestWrapper(HttpServletRequest request) {
super(request);
orgRequest = request;
}
@Override
public String getParameter(String name) {
String value = super.getParameter(xssEncode(name));
if (StringUtils.isNotBlank(value)) {
value = xssEncode(value);
}
return value;
}
@Override
public String[] getParameterValues(String name) {
String[] parameters = super.getParameterValues(name);
if (parameters == null || parameters.length == 0) {
return null;
}
for (int i = 0; i < parameters.length; i++) {
parameters[i] = xssEncode(parameters[i]);
}
return parameters;
}
@Override
public Map<String,String[]> getParameterMap() {
Map<String,String[]> map = new LinkedHashMap<>();
Map<String,String[]> parameters = super.getParameterMap();
for (String key : parameters.keySet()) {
String[] values = parameters.get(key);
for (int i = 0; i < values.length; i++) {
rootPath = rootPath.replace("/", "\\");
}
//linux下
if ("/".equals(File.separator)) {
rootPath = classPath.substring(0, classPath.indexOf("/WEB-INF/classes"));
rootPath = rootPath.replace("\\", "/");
}
return rootPath;
}
/**
* 判断文件是否未空,或者没有数据
*
* @param file 文件
* @return 结果
*/
public static boolean isEmpty(MultipartFile file) {
return file == null || file.getSize() == 0 || "".equals(file.getOriginalFilename().trim());
}
/**
* 上传文件
*
* @param prefix 存放文件的跟路径
* @param file 文件
* @return 返回相对路径
*/
public static String uploadFile(String prefix, MultipartFile file, HttpServletRequest request) {
prefix = "/cdn/" + prefix;
//取得当前上传文件的文件名称
String myFileName = file.getOriginalFilename();
String suffix = myFileName.substring(myFileName.lastIndexOf(".") + 1);
//重命名上传后的文件名
String fileName = UUID.randomUUID().toString() + "." + suffix.toLowerCase();
//文件夹路径
String filePath = getRootPath(request) + prefix + "/";
File f = new File(filePath);
// 目录已存在创建文件夹
if (!f.exists()) {
f.mkdirs();// 目录不存在的情况下,会抛出异常
}
//定义上传路径
@RequestMapping("/sys/user")
public class SysUserController extends AbstractController {
@Autowired
private SysUserService sysUserService;
@Autowired
private SysUserRoleService sysUserRoleService;
/**
* 所有用户列表
*/
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params) {
//查询列表数据
Query query = new Query(params);
List<SysUserEntity> userList = sysUserService.queryList(query);
int total = sysUserService.queryTotal(query);
PageUtils pageUtil = new PageUtils(userList, total, query.getLimit(), query.getPage());
return R.ok().put("page", pageUtil);
}
@RequestMapping("/list2")
public R list2(@RequestParam Map<String, Object> params) {
//查询列表数据
Query query = new Query(params);
List<SysUserEntity> userList = sysUserService.queryList(query);
return R.ok().put("list", userList);
}
/**
* 获取登录的用户信息
*/
@RequestMapping("/info")
public R info() {
return R.ok().put("user", this.sysUserService.queryObject(getUser().getUserId()));
}
/**
//退出
ShiroUtils.logout();
return R.ok();
}
@SysLog("修改个人信息")
@RequestMapping("/updateInfo")
public R updateInfo(@RequestBody SysUserEntity user) {
this.sysUserService.update(user);
return R.ok();
}
/**
* 用户信息
*/
@RequestMapping("/info/{userId}")
public R info(@PathVariable("userId") Long userId) {
SysUserEntity user = sysUserService.queryObject(userId);
//获取用户所属的角色列表
List<Long> roleIdList = sysUserRoleService.queryRoleIdList(userId);
user.setRoleIdList(roleIdList);
return R.ok().put("user", user);
}
/**
* 保存用户
*/
@SysLog("保存用户")
@RequestMapping("/save")
public R save(@RequestBody SysUserEntity user) {
ValidatorUtils.validateEntity(user, AddGroup.class);
user.setCreateUserId(getUserId());
sysUserService.save(user);
return R.ok();
}
/**
* 修改用户
*/
return R.ok().put("page", pageUtil);
}
}
/**
* XSS过滤
* @email 123456@qq.com
*/
public class XssFilter implements Filter {
@Override
public void init(FilterConfig config) throws ServletException {
}
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain)
throws IOException, ServletException {
XssHttpServletRequestWrapper xssRequest = new XssHttpServletRequestWrapper(
(HttpServletRequest) request);
chain.doFilter(xssRequest, response);
}
@Override
public void destroy() {
}
}
/**
* 系统页面视图
*
* @email 123456@qq.com
*/
@Controller
public class SysPageController {
@RequestMapping("sys/{url}.html")
public String page(@PathVariable("url") String url){
/**
* 角色列表
*/
@RequestMapping("/select")
@RequiresPermissions("sys:role:select")
public R select(){
Map<String, Object> map = new HashMap<>();
//如果不是超级管理员,则只查询自己所拥有的角色列表
// if(getUserId() != Constant.SUPER_ADMIN){
// map.put("createUserId", getUserId());
// }
List<SysRoleEntity> list = sysRoleService.queryList(map);
return R.ok().put("list", list);
}
/**
* 角色信息
*/
@RequestMapping("/info/{roleId}")
@RequiresPermissions("sys:role:info")
public R info(@PathVariable("roleId") Long roleId){
SysRoleEntity role = sysRoleService.queryObject(roleId);
//查询角色对应的菜单
List<Long> menuIdList = sysRoleMenuService.queryMenuIdList(roleId);
role.setMenuIdList(menuIdList);
return R.ok().put("role", role);
}
/**
* 保存角色
*/
@SysLog("保存角色")
@RequestMapping("/save")
@RequiresPermissions("sys:role:save")
public R save(@RequestBody SysRoleEntity role){
ValidatorUtils.validateEntity(role);
String url = MultipartFileUtil.uploadFile("/cdn", file, request);
return R.ok().put("url", url);
}
/**
* 上传资讯内容的图片
*
* @param upload 图片
* @param response 响应
*/
@ResponseBody
@RequestMapping("ckEditorUpload")
public void uploadFile(MultipartFile upload, String CKEditorFuncNum, HttpServletRequest request, HttpServletResponse response) throws IOException {
response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
try {
String path = null;
if (upload != null && !upload.isEmpty()) {
String url = MultipartFileUtil.uploadFile("/cdn", upload, request);
path = url;
}
// 返回“图像”选项卡并显示图片
out.println("<script type=\"text/javascript\">");
out.println("window.parent.CKEDITOR.tools.callFunction(" + CKEditorFuncNum + ",'" + path + "','')");
out.println("</script>");
} catch (RuntimeException e) {
out.println("<script type=\"text/javascript\">");
out.println("window.parent.CKEDITOR.tools.callFunction(" + CKEditorFuncNum + ",'','" + e.getMessage() + "');");
out.println("</script>");
}
}
}