- 前言
- 任务目标
- 我的任务
- 工作内容
- 代码
项目仓库
本项目是为开发一套容器化的开发、运行、测试环境,用以支持Web开发、程序设计等课程的实验教学。
任务目标实现通知的新建,查询,更新功能。
我的任务Mapper层编写sql,操作数据库,建立通知的Service和controller层,编写通知的新建,查询,更新接口。
工作内容建立Message表,设计对应操作API
代码实体类
Message.java
@AllArgsConstructor
@NoArgsConstructor
@Data
public class Message {
private Integer id;
private Integer organizationId;
private String name;
private String description;
private Integer status;
private Date createTime;
private Date lastModifyTime;
}
lombok注解自动补全get,set方法。
MessageMapper.xml
insert into message(id, organization_id, name, description, status) values (#{id}, #{organizationId}, #{name}, #{description}, #{status}) update message set name = #{name} where id=#{id} and status=0 update message set description = #{desc} where id=#{id} and status=0 update message set status=1 where id=#{id} update message set status=1 where name=#{name} and organization_id=#{orgId}
MessageServiceImpl.java
@Service
public class MessageServiceImpl implements MessageService {
@Autowired
MessageMapper messageMapper;
@Override
public void addMessage(Message message) {
messageMapper.addMessage(message);
}
@Override
public Message getMessageById(int id) {
Message message = messageMapper.getMessageById(id);
return message;
}
@Override
public List getMessageByName(String name, int orgId) {
List messagelist = messageMapper.getMessageByName(name, orgId);
return messagelist;
}
@Override
public void updateNameById(int id, String name) {
messageMapper.reNameById(id, name);
}
@Override
public void updateDescriptionById(int id, String desc) {
messageMapper.reDescriptionById(id, desc);
}
@Override
public void deleteMessageById(int id) {
messageMapper.deleteMessageById(id);
}
@Override
public void deleteMessageByName(String name, int orgId) {
messageMapper.deleteMessageByName(name, orgId);
}
@Override
public List getMessageList(int orgId) {
List list = messageMapper.getOrgMessageList(orgId);
return list;
}
}
@RestController
@RequestMapping("/message")
@Slf4j
public class MessageController {
@Autowired
private MessageService messageService;
@Autowired
private OrganizationService organizationService;
@PostMapping(value = "/createMessage")
public ResultEntity createMessage(int orgId, String name,String desc) throws Exception {
if(organizationService.getOrgById(orgId)==null)
return ResultEntity.error("Organization not found",null);
Message message = new Message();
message.setOrganizationId(orgId);
message.setId(Integer.parseInt(UserUtil.getVerifyCode(6)));
message.setStatus(0);
message.setName(name);
message.setDescription(desc);
System.out.println(message);
messageService.addMessage(message);
return ResultEntity.success(message.getId());
}
@PostMapping(value = "/getMessageById")
public ResultEntity getMessageById(int id){
Message message = messageService.getMessageById(id);
if(message==null)
return ResultEntity.error("Message not found",null);
if(organizationService.getOrgById(message.getOrganizationId())==null)
return ResultEntity.error("Organization not found",null);
return ResultEntity.success(message);
}
@PostMapping(value = "/getMessageByName")
public ResultEntity getMessageByName(String name, int orgId) {
if(organizationService.getOrgById(orgId)==null)
return ResultEntity.error("Organization not found",null);
List messagelist = messageService.getMessageByName(name,orgId);
return ResultEntity.success(messagelist);
}
@PostMapping(value = "/getOrgMessageList")
public ResultEntity getOrgMessageList(int orgId) {
if(organizationService.getOrgById(orgId)==null)
return ResultEntity.error("Organization not found",null);
List list = messageService.getMessageList(orgId);
return ResultEntity.success(list);
}
@PostMapping(value = "/updateNameById")
public ResultEntity updateNameById(int id, String name) {
if(messageService.getMessageById(id)==null)
return ResultEntity.error("Message not found",null);
if(organizationService.getOrgById(messageService.getMessageById(id).getOrganizationId())==null)
return ResultEntity.error("Organization not found",null);
messageService.updateNameById(id, name);
return ResultEntity.success(messageService.getMessageById(id));
}
@PostMapping(value = "/updateDescriptionById")
public ResultEntity updateDescriptionById(int id, String desc) {
if(messageService.getMessageById(id)==null)
return ResultEntity.error("Message not found",null);
if(organizationService.getOrgById(messageService.getMessageById(id).getOrganizationId())==null)
return ResultEntity.error("Organization not found",null);
messageService.updateDescriptionById(id, desc);
return ResultEntity.success(messageService.getMessageById(id));
}
@PostMapping(value = "/deleteMessageById")
public ResultEntity deleteMessageById(int id) {
if(messageService.getMessageById(id)==null)
return ResultEntity.error("Message not found",null);
if(organizationService.getOrgById(messageService.getMessageById(id).getOrganizationId())==null)
return ResultEntity.error("Organization not found",null);
messageService.deleteMessageById(id);
return ResultEntity.success();
}
}



