JAVA每日一练

最新推荐文章于 2024-08-06 15:18:13 发布

原创最新推荐文章于 2024-08-06 15:18:13 发布 · 297 阅读

0 ·

CC 4.0 BY-SA版权

java学习专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一个基于Spring MVC的部门查询API设计，详细展示了Controller、Service、Mapper层的代码实现，以及异常处理和返回结果的JSON格式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

controller

@Controller
@RequestMapping(value="queryByDepartmentId",method{RequestMethod.POST,RequestMethod.GET})
@ResponseBody
public AjaxJson queryByDepartmentId (String departmentId){
	AjaxJson result = new AjaxJson();
	try{
		List<Department> departments = departmentService.queryByDepartmentId (departmentId);
		result.setSuccess(true);
		result.setObj(departments);
		return result;
	}catche(Exception e){
		result.setSuccess(false);
		return result;
	}
}

Department泛型

public class Department{
	private Long id;
	private String createDay;
	.....
	public Long getId(){
		return id;
  }
   public String getCreateDay() {
    return createDay;
    }
    public void setDepartmentId(Long id){
    	this.id = id;
    }
}

services

 public interface departmentService{
 	List<Department>queryByDepartmentId(String id)
 }

实现接口

 public class departmentServiceImpl implements departmentService{
	@Autowired
	DepartmentMapper departmentMapper;
	@override
	public List<Department> queryByDepartmentId (String id){
		return departmentMapper.queryByDepartmentId(id);
	}
}

Mapper

public interface DepartmentMapper {
	list<Department> queryByDepartmentId(String departmentId)
}

XML

	<select id="queryByDepartmentId" resultMap="" parameterType="">
	    select
	    <include refid="" />
	    from schedule
	    where department_id = #{DepartmentId,jdbcType=VARCHAR}
  </select>