Java 实战项目之教材管理系统的实现流程

Java 实战项目之教材管理系统的实现流程

一、项目简述

功能包括： 管理员可以增删改查教材、教材商、入库教材、用户(用 户包括学生和教师)可以对教材商、教材进行。Excel的导入 导出操作。教师以领取入库的教材，可以退还教材。学生只能在对应的教师那里领取教材，并且可以退还教材、 查询自己已经领取的教材。并且对已领教材付款等等。

二、项目运行

环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术： jsP +Spring + SpringMVC + MyBatis + html+ css + javascript + jquery + Ajax + layui+ maven等等。

查看班级选报信息：

@Service

public class TopicsServiceImpl implements TopicsService {

@Autowired

private MyClassMapper classMapper;

@Autowired

private StudentMapper studentMapper;

@Autowired

private SubjectselectedMapper subjectselectedMapper;

@Autowired

private SubjectMapper subjectMapper;

@Autowired

private HttpServletRequest request;

/**

* 查看班级选报信息

*/

@Override

public List classinfo(Long id) {

MyClass className = classMapper.selectById(id);//查到班级名字

List students = studentMapper.selectByListAll(id);//根据student表里班级id查到用户所在班级的所有人

List projectselectedlist = new ArrayList<>();

List projectlist = new ArrayList<>();

Subjectselected projectselected = null;

Subject project = null;

for (int i = 0; i < students.size(); i++) {

List tprojectselecteds = subjectselectedMapper.selectBystudentid(students.get(i).getId());

if (tprojectselecteds != null && tprojectselecteds.size() > 0)

projectselected = tprojectselecteds.get(0);

if (projectselected != null) {

projectselectedlist.add(projectselected);

} else {

projectselected = new Subjectselected();

projectselected.setId(0L);

projectselected.setIdProject(0L);

projectselected.setIdStudent(0L);

projectselected.setStuselectFlag(0L);

projectselectedlist.add(projectselected);

}

}

for (int i = 0; i < projectselectedlist.size(); i++) {

if (projectselectedlist.get(i).getId() != 0) {

projectlist.add(subjectMapper.selectById(projectselectedlist.get(i).getIdProject()));

} else {

project = new Subject();

project.setProjectname("无");

project.setTeachernames("无");

projectlist.add(project);

}

}

List infolist = new ArrayList<>();

classinfo info = null;

for (int i = 0; i < projectlist.size(); i++) {

info = new classinfo();

info.setId(students.get(i).getId());

info.setClassName(className.getClassName());

info.setName(students.get(i).getName());

info.setStuNum(students.get(i).getStunum());

info.setProjectName(projectlist.get(i).getProjectname());

info.setTeacherNames(projectlist.get(i).getTeachernames());

info.setStuSelectFlag(projectselectedlist.get(i).getStuselectFlag());

infolist.add(info);

}

return infolist;

}

/**

* 查看课题信息

* 通过classid

*/

@Override

public List topics(Long id) {

String specialty = classMapper.selectByspecialty(id);

List projectlist = subjectMapper.selectByAll("%" + specialty + "%");

List topicsinfolist = new ArrayList<>();

topicsinfo info = null;

for (int i = 0; i < projectlist.size(); i++) {

info = new topicsinfo();

info.setProject_id(projectlist.get(i).getId());

info.setProjectType(subjectMapper.selectByprojectType(projectlist.get(i).getIdProjecttype().intValue()));

info.setProjectSource(subjectMapper.selectByprojectSource(projectlist.get(i).getIdProjectsource().intValue()));

info.setProjectName(projectlist.get(i).getProjectname());

info.setSelectFlag(projectlist.get(i).getSelectFlag());

info.setMarchSpecialty(projectlist.get(i).getMarchspecialty());

info.setTeacherNames(projectlist.get(i).getTeachernames());

topicsinfolist.add(info);

}

return topicsinfolist;

}

/**

* 课题具体信息

*/

@Override

public List topicsinfo(Long project_id) {

List listed = subjectselectedMapper.selectByprojectid(project_id);//中间表

request.getSession().setAttribute("listsize",listed.size());

List tolist = new ArrayList<>();

topicsto to = null;

Student student = null;

for (int i = 0; i < listed.size(); i++) {

to = new topicsto();

student = studentMapper.selectByid(listed.get(i).getIdStudent());

if(student == null)

continue;

to.setStuNum(student.getStunum());

to.setName(student.getName());

to.setStuSelectFlag(listed.get(i).getStuselectFlag());

to.setClassName(classMapper.selectById(student.getIdClass()).getClassName());

tolist.add(to);

}

return tolist;

}

/**

* 获取该用户是否选报了课题

*/

public Long state(Student student) {

Subjectselected project = null;

List tprojectselecteds = subjectselectedMapper.selectBystudentid(student.getId());

if (tprojectselecteds != null && tprojectselecteds.size() > 0)

project = tprojectselecteds.get(0);

if (project == null) {

return 0L;

} else

return project.getStuselectFlag();

}

/**

* 添加选题

*/

@Override

public void insertproject(String project, Long studentid) {

Long projectid = subjectMapper.selectByprojectid(project);

int flagid = subjectselectedMapper.insertenroll(projectid, studentid);

}

/**

* 删除选题

*/

@Override

public int deleteprojectselectedid(Long id) {

int flag = subjectselectedMapper.deleteBystudentId(id);

return flag;

}

/**

* 查询课题名

*

*/

public String selectprojectname(Long id){

String project_Name = subjectMapper.selectById(id).getProjectname();

return project_Name;

}

/**

* 获取该题是否可选

*/

@Override

public Long flag(Long project_id) {

return subjectMapper.selectByselectFlag(project_id);

}

}

班级信息查询业务：

@Service

public class ClassServiceImpl implements ClassService {

@Autowired

MyClassMapper myClassMapper;

@Autowired

SpecialtyService specialtyService;

@Autowired

StudentService studentService;

@Override

public List getClasses(Integer offset, String getName, Long specialtyid, Long id_institute) {

// 设置分页查询条件

MyClassExample myClassExample = new MyClassExample();

// 添加查询条件

myClassExample = addCondition(myClassExample,offset,id_institute,getName,specialtyid);

if(myClassExample==null)

return null;

//如果 offset 为 -1 则只查询 id 和 name 列

if(offset==-1)

{

return myClassMapper.selectByExampleSelective(myClassExample,

MyClass.Column.id,

MyClass.Column.className);

}else{

return myClassMapper.selectByExampleSelective(myClassExample);

}

}

@Override

public long getClassesCount(Integer offset, String getName, Long specialtyid, Long id_institute) {

// 设置分页查询条件

MyClassExample myClassExample = new MyClassExample();

// 添加查询条件

myClassExample = addCondition(myClassExample,offset,id_institute,getName,specialtyid);

if(myClassExample==null)

return 0;

return myClassMapper.countByExample(myClassExample);

}

@Override

public long delClass(MyClass myClass, Long id_institute) throws MyException {

checkSpecialtyId(myClass,id_institute);

return myClassMapper.deleteByPrimaryKey(myClass.getId());

}

@Override

public long putClass(MyClass myClass, Long id_institute) throws MyException {

checkSpecialtyId(myClass,id_institute);

return myClassMapper.updateByPrimaryKey(myClass);

}

@Override

public long postClass(MyClass myClass, Long id_institute) throws MyException {

checkSpecialtyId(myClass,id_institute);

long count = getClassesCount(1,myClass.getClassName(),null, id_institute);

if(count!=0)

throw new MyException("该班级已存在");

return myClassMapper.insert(myClass);

}

@Override

public long delClassBySpecialty(Long specialtyid) {

return myClassMapper.deleteByExample(new MyClassExample().createCriteria().andIdSpecialtyEqualTo(specialtyid).example());

}

public MyClassExample addCondition(MyClassExample myClassExample,Integer offset , Long id_institute , String keyWord , Long id_specialty){

//代表为超管，则可以查询所有；

if(id_institute==-1)

{

return myClassExample.newAndCreateCriteria()

.when(StringUtil.stringIsNotNull(keyWord), criteria -> criteria.andClassNameEqualTo(keyWord)) //根据关键字查询

.when(id_specialty!=null,criteria -> criteria.andIdSpecialtyEqualTo(id_specialty)) //根据指定教研室查询

.example()

.when(offset!=-1 && offset != 0,criteria -> criteria.page(offset-1, 10));

}

//查询出来当前学院的所有专业

List specialties = specialtyService.getSpecialtys(-1,null,null,id_institute);

//提取 id列 列表

List specialtiesIDs = specialties.stream().map(Specialty::getId).collect(Collectors.toList());

if(specialtiesIDs.size()==0||specialtiesIDs==null)

return null;

return myClassExample.newAndCreateCriteria()

.when(StringUtil.stringIsNotNull(keyWord),criteria -> criteria.andClassNameEqualTo(keyWord)) //根据关键字查询

.when(id_specialty!=null,criteria -> criteria.andIdSpecialtyEqualTo(id_specialty)) //根据指定教研室查询

// 查询的专业只能在当前的学院的教研室下

.andIdSpecialtyIn(specialtiesIDs)

.example()

.when(offset!=-1 && offset != 0,criteria -> criteria.page(offset-1, 10));// 查询第offest-1页数据（每页10条）

}

public void checkSpecialtyId(MyClass myClass ,Long id_institute) throws MyException {

//如果为超管则不需要检查有没有权力

if(id_institute==-1)

{

return ;

}

long id_specialty = myClass.getIdSpecialty();

List specialtyes = specialtyService.getSpecialtys(1,null,null,id_institute);

//如果被删除的专业是不属于本系教研室则提示没有权限

for(Specialty specialty :specialtyes)

{

if(specialty.getId()==id_specialty)

return;

}

throw new MyException("没有权限操作");

}

}

管理员业务操作：

@Service

public class AdminServiceImpl implements AdminService {

@Autowired

AdminMapper adminMapper;

@Autowired

SadminMapper sadminMapper;

@Autowired

GeneralPurposeMapper mapper;

@Autowired

PublicService publicService;

//Session 保存时间（秒）

private final Integer SAVE_TIME = 60*60*24;

//超管 和 子管用一个登录

@Autowired

StudentMapper studentMapper;

@Autowired

SubjectselectedMapper subjectselectedMapper;

@Autowired

SubjectMapper subjectMapper;

@Autowired

ProjectMapper projectMapper;

@Autowired

ClassMapper classMapper;

@Autowired

SpecialtyMapper specialtyMapper;

@Autowired

InstituteMapper instituteMapper;

@Autowired

HttpServletRequest request;

@Autowired

HttpServletResponse response;

@Override

public Msg login(String name, String pwd , HttpSession httpSession) {

Sadmin sadmin = selectSadminByName(name);

if(sadmin!=null){

//验证密码是否与数据库中的相同

if(sadmin.getPwd().equals(pwd)){

User user = new User();

//-1表示为超管

user.setId(-1L);

user.setRole("sadmin");

user.setUserName(sadmin.getName());

//生成Token 存到 Cookie

Cookie chttp://ookie = new Cookie("token",TokenUtil.createToken(

user

));

//该Cookie无法被js读取

cookie.setHttpOnly(true);

cookie.setPath("/");

response.addCookie(cookie);

return Msg.success();

}

return Msg.error("密码错误");

}else {

Admin admin = selectByName(name);

if(admin == null){

return Msg.error("账号不存在");

}else {

if(admin != null && admin.getPwd().equals(pwd)){

User user = new User();

user.setId(admin.getId());

user.setRole("admin");

user.setUserName(admin.getName());

Cookie cookie = new Cookie("token",TokenUtil.createToken(

user

));

cookie.setPath("/");

cookie.setHttpOnly(true);

response.addCookie(cookie);

return Msg.success();//账号密码正确

}

return Msg.error("密码错误");

}

}

}

@Override

public Admin selectByName(String name) {

//创建一个 Admin 实例 ，添加条件 为 Name == name

AdminExample adminExample = new AdminExample();

adminExample.createCriteria().andNameEqualTo(name);

//根据实例 来查询

List admin = adminMapper.selectByExample(adminExample);

if( admin==null || admin.size()==0 ) {

return null;

}

return admin.get(0);

}

@Override

public Sadmin selectSadminByName(String name) {

SadminExample sadminExample = new SadminExample();

sadminExample.createCriteria().andNameEqualTo(name);

List sadmin = sadminMapper.selectByExample(sadminExample);

if( sadmin==null|| sadmin.size()==0 )

return null;

return sadmin.get(0);

}

@Override

public int updatePwdByUserName(String name, String pwd) {

AdminExample adminExample = new AdminExample();

adminExample.createCriteria().andNameEqualTo(name);

Admin admin = new Admin();

admin.setPwd(pwd);

adminMapper.updateByExampleSelective(admin,adminExample);

return 0;

}

@Override

public int updateSadminPwdByUserName(String name, String pwd) {

SadminExample sadminExample = new SadminExample();

sadminExample.createCriteria().andNameEqualTo(name);

Sadmin sadmin = new Sadmin();

sadmin.setPwd(pwd);

return sadminMapper.updateByExampleSelective(sadmin, sadminExample);

}

// 班级的增加

@Override

public int add_class(Long specialty_id, String class_name) {

List classes = select_class(null, null, null, null, class_name);

if (classes == null || classes.size() == 0) {

Class class1 = new Class();

class1.setClassName(class_name);

class1.setIdSpecialty(specialty_id);

return classMapper.insert(class1);

}

return 0;

}

@Override

public int addAdmin(Admin admin) {

//添加的时候检测又没用户名重复的

publicService.CheckIfTheUsernameIsDuplicated(admin.getName());

return adminMapper.insert(admin);

}

@Override

public int delAdmin(Admin admin) {

return adminMapper.deleteByPrimaryKey(admin.getId());

}

@Override

public int updateAdmin(Admin admin) {

//不更新username

admin.setName(null);

return adminMapper.updateByPrimaryKeySelective(admin);

}

@Override

public List selectAdmins(Long offset) {

if(offset!=null && offset==-1){

return adminMapper.selectByExampleSelective(

new AdminExample(),

Admin.Column.id

);

}

return adminMapper.selectByExample(

new AdminExample()

);

}

// 学生的增删改查

@Override

public int add_student(String userName, String stuNum, Long id_class, String name, String gender, String pwd){

Student ss = studentMapper.select_studentbyName(userName, stuNum);

if (ss == null) {

StudentWithBLOBs student = new StudentWithBLOBs();

student.setUsername(userName);

student.setStunum(stuNum);

student.setIdClass(id_class);

student.setName(name);

student.setGender(gender);

student.setPwd(pwd);

return studentMapper.insert(student);

}

return 0;

}

public int delete_class(Long class_id) {

return classMapper.deleteByPrimaryKey(class_id);

}

@Override

public int update_class(Long class_id, Long specialty_id, String class_name) {

Class class1 = new Class();

class1.setId(class_id);

class1.setIdSpecialty(specialty_id);

class1.setClassName(class_name);

return classMapper.updateByPrimaryKeySelective(class1);

}

@Override

public List select_project(Long institute_id, Long section_id, String section_name) {

return projectMapper.select_project(institute_id, null, null);

}

@Override

public List select_studentXT_all(Long section_id, String section_name, Long specialty_id, String specialty_name, Long class_id, String class_name) {

List static_students = studentMapper.select_studentXT_all(section_id, section_name, specialty_id, specialty_name, class_id, class_name);

if (static_students != null && static_students.size() > 0) {

for (int i = 0; i < static_students.size(); i++) {

List projectselecteds = select_Projectselected(static_students.get(i).getId(), null);

if (projectselecteds != null && projectselecteds.size() > 0) {

static_students.get(i).setStuselectFlag("" + projectselecteds.get(0).getStuselectFlag());

static_students.get(i).setProjectname(projectselecteds.get(0).getProject_name());

static_students.get(i).setTeachernames(projectselecteds.get(0).getProject_teachers());

} else {

static_students.get(i).setProjectname("未选题");

static_students.get(i).setTeachernames("");

}

}

}

return static_students;

}

@Override

public List select_class(Long institute_id, Long section_id, Long specialty_id, Long class_id, String class_name) {

return classMapper.select_class(institute_id, section_id, specialty_id, class_id, class_name);

}

// 专业方向的增删改查

@Override

public int add_specialty(Long section_id, String specialty_name) {

List specialties = select_specialty(null, null, nulhttp://l, specialty_name);

if (specialties == null || specialties.size() == 0) {

Specialty specialty = new Specialty();

specialty.setIdSection(section_id);

specialty.setSpecialtyName(specialty_name);

return specialtyMapper.insert(specialty);

}

return 0;

}

@Override

public int delete_student(Long student_id) {

return studentMapper.deleteByPrimaryKey(student_id);

}

@Override

public int update_student(Long student_id, String userName, String stuNum, Long id_class, String name, String gender, String pwd) {

Student student = new Student();

student.setId(student_id);

student.setUsername(userName);

student.setStunum(stuNum);

student.setIdClass(id_class);

student.setName(name);

student.setGender(gender);

student.setPwd(pwd);

return studentMapper.updateByPrimaryKeySelective((StudentWithBLOBs) student);

}

@Override

public List select_student(Long institute_id, Long specialty_id, Long class_id, Long student_id, String name) {

List static_students = studentMapper.select_Student(institute_id, specialty_id, class_id, student_id, name);

if (static_students != null) {

for (int i = 0; i < static_students.size(); i++) {

Static_student static_student = static_students.get(i);

List projectselected = select_Projectselected(static_student.getId(), null);

if (projectselected != null && projectselected.size() != 0) {

String s = "";

if (projectselected.get(0).getStuselectFlag() == 1) s = "选题待审核";

else if (projectselected.get(0).getStuselectFlag() == 2) s = "选题未通过";

else s = "选题通过";

static_student.setStuselectFlag(s);

static_student.setProjectname(projectselected.get(0).getProject_name());

static_student.setTeachernames(projectselected.get(0).getProject_teachers());

}

}

return static_students;

}

return null;

}

// 通过学生id 或者 课题id 查 课题的选择 情况

public List select_Projectselected(Long student_id, Long project_id) {

return subjectselectedMapper.select_Projectselected(student_id, project_id);

}

public List select_ProjectXQ(Long institute_id, Long section_id, String name) {

List projects = subjectMapper.select_ProjectXQ(institute_id, section_id, name);

if (projects != null) {

for (int i = 0; i < projects.size(); i++) {

if (projects.get(i).getSelectFlag() == 0) projects.get(i).setProjectGB("可选");

else if (projects.get(i).getSelectFlag() == 1) projects.get(i).setProjectGB("不可选");

}

}

return projects;

}

public int delete_specialty(Long specialty_id) {

return specialtyMapper.deleteByPrimaryKey(specialty_id);

}

@Override

public int update_specialty(Long specialty_id, Long section_id, String specialty_name) {

Specialty specialty = new Specialty();

specialty.setId(specialty_id);

specialty.setIdSection(section_id);

specialty.setSpecialtyName(specialty_name);

return specialtyMapper.updateByPrimaryKeySelective(specialty);

}

@Override

public List select_specialty(Long institute_id, Long section_id, Long specialty_id, String specialty_name) {

return specialtyMapper.select_specialty(institute_id, section_id, specialty_id, specialty_name); // 根据学院id 或者 教研室id 查所有专业方向

}

@Override

public List select_institute(Long institute_id, String institute_name) {

InstituteExample instituteExample = new InstituteExample();

InstituteExample.Criteria criteria = instituteExample.createCriteria();

if (institute_id != null && institute_id != 0) criteria.andIdEqualTo(institute_id);

if (institute_name != null && institute_name.length() > 0) criteria.andInstituteNameEqualTo(institute_name);

return instituteMapper.selectByExample(instituteExample);

}

}

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。