JAVA每日一练

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>