今天完成的事情：

设计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来完成页面的复用配置。