package com.smartor.service.impl; import com.smartor.mapper.UtilsMapper; import com.smartor.service.IServiceTelInfoService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; import java.util.Map; @Slf4j @Service public class ServiceTelInfoServiceImpl implements IServiceTelInfoService { @Autowired private UtilsMapper utilsMapper; /** * 设置电话状态 * * @return 结果 */ @Override public List> getList() { List> lists= utilsMapper.getList("select * from service_telinfo where state=0 "); return lists; } /** * 设置电话状态 * * @param id 主键 * @param state 0正常1占线 * @return 结果 */ @Override public int setState(Integer id, Integer state) { Integer result= utilsMapper.updateSql("update service_telinfo set state= "+state+" where id="+id+" "); return result; } }