Spring+mybatis项目 节假日库表业务实现

package com.yilingxinxi.model;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;


public class Holiday extends baseEntity {
    private static final long serialVersionUID = 1L;

    
    private Long id;

    
    private Long beginDate;

    
    private Long endDate;

    
    private String name;

    public void setId(Long id) {
        this.id = id;
    }

    public Long getId() {
        return id;
    }

    public void setBeginDate(Long beginDate) {
        this.beginDate = beginDate;
    }

    public Long getBeginDate() {
        return beginDate;
    }

    public void setEndDate(Long endDate) {
        this.endDate = endDate;
    }

    public Long getEndDate() {
        return endDate;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getName() {
        return name;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
                .append("id", getId())
                .append("beginDate", getBeginDate())
                .append("endDate", getEndDate())
                .append("name", getName())
                .toString();
    }
}

package com.yilingxinxi.mapper;

import com.yilingxinxi.model.Holiday;
import org.apache.ibatis.annotations.Select;

import java.util.List;


public interface HolidayMapper
{
    
    public Holiday selectLxHolidayById(Long id);

    
    public List selectLxHolidayList(Holiday holiday);

    
    public int insertLxHoliday(Holiday holiday);

    
    public int updateLxHoliday(Holiday holiday);

    
    public int deleteLxHolidayById(Long id);

    
    public int deleteLxHolidayByIds(String[] ids);

    @Select("SELECTn" +
            "tname n" +
            "FROMn" +
            "tlx_holiday n" +
            "WHERen" +
            "tDATE_FORMAT( now(), '%Y-%m-%d' ) = DATE_FORMAT( FROM_UNIXTIME( lx_holiday.begin_date / 1000 ), '%Y-%m-%d' )")
    List findHoliday();
}

    
    
        
        
        
        
    

    
        select id, begin_date, end_date, name from lx_holiday
    

    
        
          
             and begin_date = #{beginDate}
             and end_date = #{endDate}
             and name like concat('%', #{name}, '%')
        
    
    
    
        
        where id = #{id}
    
        
    
        insert into lx_holiday
        
            id,
            begin_date,
            end_date,
            name,
         
        
            #{id},
            #{beginDate},
            #{endDate},
            #{name},
         
    

    
        update lx_holiday
        
            begin_date = #{beginDate},
            end_date = #{endDate},
            name = #{name},
        
        where id = #{id}
    

    
        delete from lx_holiday where id = #{id}
    

    
        delete from lx_holiday where id in 
        
            #{id}
        
    

package com.yilingxinxi.service.service;

import com.yilingxinxi.model.Holiday;

import java.util.List;


public interface HolidayService {
    
    public Holiday selectHolidayById(Long id);

    
    public List selectHolidayList(Holiday holiday);

    
    public int insertHoliday(Holiday holiday);

    
    public int updateHoliday(Holiday holiday);

    
    public int deleteHolidayByIds(String ids);

    
    public int deleteHolidayById(Long id);

    List findHoliday();
}

serviceimpl

package com.yilingxinxi.service.service.impl;

import com.yilingxinxi.common.utils.Convert;
import com.yilingxinxi.mapper.HolidayMapper;
import com.yilingxinxi.model.Holiday;
import com.yilingxinxi.service.service.HolidayService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service
public class HolidayServiceImpl implements HolidayService
{
    @Autowired
    private HolidayMapper holidayMapper;

    
    @Override
    public Holiday selectHolidayById(Long id)
    {
        return holidayMapper.selectLxHolidayById(id);
    }

    
    @Override
    public List selectHolidayList(Holiday lxHoliday)
    {
        return holidayMapper.selectLxHolidayList(lxHoliday);
    }

    
    @Override
    public int insertHoliday(Holiday lxHoliday)
    {
        return holidayMapper.insertLxHoliday(lxHoliday);
    }

    
    @Override
    public int updateHoliday(Holiday holiday)
    {
        return holidayMapper.updateLxHoliday(holiday);
    }

    
    @Override
    public int deleteHolidayByIds(String ids)
    {
        return holidayMapper.deleteLxHolidayByIds(Convert.toStrArray(ids));
    }

    
    @Override
    public int deleteHolidayById(Long id)
    {
        return holidayMapper.deleteLxHolidayById(id);
    }

    @Override
    public List findHoliday() {
        return holidayMapper.findHoliday();
    }
}

controller

package com.yilingxinxi.weapp.controller.pro;

import com.yilingxinxi.common.response.json.JsonResponseBean;

import com.yilingxinxi.model.Holiday;
import com.yilingxinxi.service.service.HolidayService;
import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class HolidayController2 {
    @Autowired
    private HolidayService holidayService;

    
    @GetMapping("/getHolidayList")
    public String getCityList(Holiday holiday){
        List holidays = holidayService.selectHolidayList(holiday);
        return new JsonResponseBean(holidays).toJson();
    }
    
    @PostMapping("/insertHoliday")
    public String insertHoliday(Holiday holiday){
        Holiday holidays = new Holiday();
        holidays.setId(holiday.getId());
        return JsonResponseBean.result(holidayService.insertHoliday(holiday)).toJson();
    }
    
    @PostMapping("/updateHoliday")
    public String updateUserChildren(Holiday holiday){
        return JsonResponseBean.result(holidayService.updateHoliday(holiday)).toJson();
    }
    
    @PostMapping("/deleteHoliday")
    public String deleteHoliday(Long id){
        return "";
    }
}