发表于: 2020-06-23 23:27:37

1 1508


今天完成的事情:

设计DB:

需要一张学员表:



需要一张职业表:

使用mybatis-generator插件快速生成代码:


手动编写Service层

StudentService及其实现类:

package com.jnshu.service;

import com.jnshu.pojo.Student;

import java.util.List;

public interface StudentService {
int deleteByPrimaryKey(Long id);

   int insert(Student record);

   Student selectByPrimaryKey(Long id);

   List<Student> selectStudent();//查询优秀学员

   int selectByLearning();//查询累计在线学习人数

   int selectByWorking();//查询已经找到工作人数

   int updateByPrimaryKeySelective(Student record);
}
package com.jnshu.service;

import com.jnshu.dao.StudentMapper;
import com.jnshu.pojo.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class StudentServiceImpl implements StudentService {

@Autowired private StudentMapper studentMapper;

   @Override
   public int deleteByPrimaryKey(Long id) {
return studentMapper.deleteByPrimaryKey(id);
   }

@Override
   public int insert(Student record) {
return studentMapper.insert(record);
   }

@Override
   public Student selectByPrimaryKey(Long id) {
return studentMapper.selectByPrimaryKey(id);
   }

@Override
   public List<Student> selectStudent() {
return studentMapper.selectStudent();
   }

@Override
   public int selectByLearning() {
return studentMapper.selectByLearning();
   }

@Override
   public int selectByWorking() {
return studentMapper.selectByWorking();
   }

@Override
   public int updateByPrimaryKeySelective(Student record) {
return studentMapper.updateByPrimaryKeySelective(record);
   }
}

ProfessionService及其实现类:

package com.jnshu.service;

import com.jnshu.pojo.Profession;

import java.util.List;

public interface ProfessionService {
int deleteByPrimaryKey(Long id);

   int insert(Profession record);

   Profession selectByPrimaryKey(Long id);

   List<Profession> selectProfession();

   int updateByPrimaryKeySelective(Profession record);
}
package com.jnshu.service;

import com.jnshu.dao.ProfessionMapper;
import com.jnshu.pojo.Profession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class ProfessionServiceImpl implements ProfessionService {

@Autowired
   private ProfessionMapper professionMapper;

   @Override
   public int deleteByPrimaryKey(Long id) {
return professionMapper.deleteByPrimaryKey(id);
   }

@Override
   public int insert(Profession record) {
return professionMapper.insert(record);
   }

@Override
   public Profession selectByPrimaryKey(Long id) {
return professionMapper.selectByPrimaryKey(id);
   }

@Override
   public List<Profession> selectProfession() {
return professionMapper.selectProfession();
   }

@Override
   public int updateByPrimaryKeySelective(Profession record) {
return professionMapper.updateByPrimaryKeySelective(record);
   }
}


编写Controller:

package com.jnshu.controller;

import com.jnshu.pojo.Profession;
import com.jnshu.pojo.Student;
import com.jnshu.service.ProfessionService;
import com.jnshu.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import java.util.List;

@Controller
public class TaskController {

@Autowired
   private StudentService studentService;

   @Autowired
   private ProfessionService professionService;

   @RequestMapping(value = "home",method = RequestMethod.GET)
public String getIndex(Model model){
List<Student> studentList = studentService.selectStudent();//查询优秀学员
       Integer count = studentService.selectByLearning();//累计在线学习人数
       Integer number = studentService.selectByWorking();//已找到工作的学员
       model.addAttribute("studentlist",studentList);
       model.addAttribute("count",count);
       model.addAttribute("number",number);
       return "index";
   }

@RequestMapping(value = "profession",method = RequestMethod.GET)
public String getProfession(Model model){
List<Profession> professionsList = professionService.selectProfession();
       model.addAttribute("profession",professionsList);
       return "profession";
   }
}


编写jsp页面:

可以看到页面已经改过来了:


图片尺寸有点问题


收获:将html静态页面转换成了jsp动态的。


明天计划完成的事情:

用Tiles来完成页面的复用配置。


返回列表 返回列表
评论

    分享到