基于javaweb的SSM+Maven教师师资管理系统(java+ssm+jsp+bootstrap+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计,大作业,毕业设计,项目练习,学习演示等

功能说明

510023462402

520023462402

530023462402

540023462402

560023462402

570023462402

基于javaweb的SSM+Maven教师师资管理系统(java+ssm+jsp+bootstrap+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/8.0版本均可; 6.是否Maven项目:是;

技术栈

  1. 后端:Spring+SpringMVC+Mybatis 2. 前端:Jsp+CSS+JavaScript+jQuery+bootstrap

使用说明

  1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
       if(!isEmpty(xm.getTeacherId())){
sql += " and teacherId like '%"+xm.getTeacherId()+"%'";
}
if(!isEmpty(xm.getContent())){
sql += " and content like '%"+xm.getContent()+"%'";
}
if(!isEmpty(xm.getStatus())){
sql += " and status like '%"+xm.getStatus()+"%'";
}
if(!isEmpty(xm.getScore())){
sql += " and score like '%"+xm.getScore()+"%'";
}
sql += " ORDER BY ID DESC ";
Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", xm);
return "xm/spxm2";
}

@RequestMapping(value = "/spfindBySql3")
public String spfindBySql3(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
/* 0 一待审 1 一审不通 2 一审通过
3 二待审 4 二审不通 5 二审通过
6 三待审 7 三审不通 8 三审通过
9 积分设置完成结束*/

String sql = "SELECT * FROM xm WHERE status = 6 or status = 8 or status = 9";
if(!isEmpty(xm.getName())){
sql += " and name like '%"+xm.getName()+"%'";
}
if(!isEmpty(xm.getTeacherId())){
sql += " and teacherId like '%"+xm.getTeacherId()+"%'";
}
if(!isEmpty(xm.getContent())){
sql += " and content like '%"+xm.getContent()+"%'";
}
if(!isEmpty(xm.getStatus())){
sql += " and status like '%"+xm.getStatus()+"%'";
}
if(!isEmpty(xm.getScore())){
sql += " and score like '%"+xm.getScore()+"%'";
}
sql += " ORDER BY ID DESC ";
Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", xm);
return "xm/spxm3";
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
       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 "";
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
    List<Manage> listAll = manageService.listByMap(params);
model.addAttribute("list", listAll);
return "manage/manage";
}


/*********************************查询列表【分页】***********************************************/



/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Manage> pagers = manageService.findByEntity(manage);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", manage);
return "manage/manage";
}

/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM manage WHERE 1=1 ";
if(!isEmpty(manage.getUserName())){
sql += " and userName like '%"+manage.getUserName()+"%'";
}
if(!isEmpty(manage.getPassWord())){
sql += " and passWord like '%"+manage.getPassWord()+"%'";
}
if(!isEmpty(manage.getRealName())){
sql += " and realName like '%"+manage.getRealName()+"%'";
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
       if(!isEmpty(xm.getStatus())){
sql += " and status like '%"+xm.getStatus()+"%'";
}
if(!isEmpty(xm.getScore())){
sql += " and score like '%"+xm.getScore()+"%'";
}
sql += " ORDER BY score DESC ";
List<Xm> pagers = xmService.listBySqlReturnEntity(sql);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", xm);
return "xm/xm4";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMap")
public String findByMap(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(xm.getName())){
params.put("name", xm.getName());
}
if(!isEmpty(xm.getTeacherId())){
params.put("teacherId", xm.getTeacherId());
}
if(!isEmpty(xm.getContent())){
params.put("content", xm.getContent());
}
if(!isEmpty(xm.getStatus())){
params.put("status", xm.getStatus());
}
if(!isEmpty(xm.getScore())){
params.put("score", xm.getScore());
}
//分页查询
Pager<Xm> pagers = xmService.findByMap(params);
model.addAttribute("pagers", pagers);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
       if(!isEmpty(xm.getName())){
sql += " and name like '%"+xm.getName()+"%'";
}
if(!isEmpty(xm.getTeacherId())){
sql += " and teacherId like '%"+xm.getTeacherId()+"%'";
}
if(!isEmpty(xm.getContent())){
sql += " and content like '%"+xm.getContent()+"%'";
}
if(!isEmpty(xm.getStatus())){
sql += " and status like '%"+xm.getStatus()+"%'";
}
if(!isEmpty(xm.getScore())){
sql += " and score like '%"+xm.getScore()+"%'";
}
sql += " ORDER BY ID DESC ";
Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", xm);
return "xm/xm1";
}

@RequestMapping(value = "/findBySql2")
public String findBySql2(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {


Object attribute = request.getSession().getAttribute("userId");

if (attribute == null){
return "redirect:/login/mtuichu";
}

Integer userId = Integer.valueOf(attribute.toString());

/* -1 新建
* 0 一待审 1 一审不通 2 一审通过
3 二待审 4 二审不通 5 二审通过
6 三待审 7 三审不通 8 三审通过
9 积分设置完成结束*/

//分页查询
String sql = "SELECT * FROM xm WHERE 1=1 and (status = 2 or status =3 or status = 4) and teacherId = "+ userId;
if(!isEmpty(xm.getName())){
sql += " and name like '%"+xm.getName()+"%'";
}
if(!isEmpty(xm.getTeacherId())){
sql += " and teacherId like '%"+xm.getTeacherId()+"%'";
}
if(!isEmpty(xm.getContent())){
sql += " and content like '%"+xm.getContent()+"%'";
}


项目链接:
https://javayms.github.io?id=031122532008200ps
https://javayms.pages.dev?id=031122532008200ps