mybatis注解关联查询问题

0 0

mybatis注解关联查询问题0

我的mapper是这个样子的

package com.wzkj.manage.mapper;

import java.util.List;

import org.apache.ibatis.annotations.DeleteProvider;
import org.apache.ibatis.annotations.InsertProvider;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.SelectProvider;
import org.apache.ibatis.annotations.UpdateProvider;
import org.apache.ibatis.annotations.Many;
import com.wzkj.manage.mapper.provider.RouteProvider;
import com.wzkj.web.entity.Route;
public interface RouteMapper {
	@SelectProvider(type = RouteProvider.class, method = "getById")  
	@Options(flushCache = true, timeout = 20000)
	@Result(property="list",column="id",javaType=List.class,many=@Many(select="com.wzkj.manage.mapper.RoutePointMapper.getByRoute"))
	public Route getById(@Param("id") int id);

}

bean


package com.wzkj.web.entity;

import java.sql.Timestamp;
import java.util.Date;
import java.util.List;

import org.apache.ibatis.type.Alias;


@Alias("wz_route")
public class Route {
	private Long id;
	private Long type_id;
	private String route_name;
	private String route_profile;
	private Float distance;
	private String tips;
	private boolean is_top;
	private String cover_img;
	private Long view_count;
	private Timestamp create_time;
	
	private List<RoutePoint> list;
	
	public String getRoute_name() {
		return route_name;
	}
	public void setRoute_name(String route_name) {
		this.route_name = route_name;
	}
	public String getRoute_profile() {
		return route_profile;
	}
	public void setRoute_profile(String route_profile) {
		this.route_profile = route_profile;
	}
	public Float getDistance() {
		return distance;
	}
	public void setDistance(Float distance) {
		this.distance = distance;
	}
	public String getTips() {
		return tips;
	}
	public void setTips(String tips) {
		this.tips = tips;
	}
	public boolean isIs_top() {
		return is_top;
	}
	public void setIs_top(boolean is_top) {
		this.is_top = is_top;
	}

	public Timestamp getCreate_time() {
		return create_time;
	}
	public void setCreate_time(Timestamp create_time) {
		this.create_time = create_time;
	}
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public Long getType_id() {
		return type_id;
	}
	public void setType_id(Long type_id) {
		this.type_id = type_id;
	}
	public Long getView_count() {
		return view_count;
	}
	public void setView_count(Long view_count) {
		this.view_count = view_count;
	}
	public String getCover_img() {
		return cover_img;
	}
	public void setCover_img(String cover_img) {
		this.cover_img = cover_img;
	}
	public List<RoutePoint> getList() {
		return list;
	}
	public void setList(List<RoutePoint> list) {
		this.list = list;
	}
	
	
}


package com.wzkj.manage.mapper;

import java.util.List;

import org.apache.ibatis.annotations.DeleteProvider;
import org.apache.ibatis.annotations.InsertProvider;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.SelectProvider;

import com.wzkj.manage.mapper.provider.RoutePointProvider;
import com.wzkj.web.entity.RoutePoint;

public interface RoutePointMapper {
	
	@SelectProvider(type = RoutePointProvider.class, method = "getById")  
	@Options(flushCache = true, timeout = 20000)
	public RoutePoint getById(@Param("id") int id);
	
	@SelectProvider(type = RoutePointProvider.class, method = "getByRoute")  
	@Options(flushCache = true, timeout = 20000)
	public List<RoutePoint> getByRoute(@Param("id") int id);
	
	
	@DeleteProvider(type = RoutePointProvider.class, method = "del")  
	@Options(flushCache = true, timeout = 20000)
	public int delete(@Param("id") int id);
	
	
	@InsertProvider(type = RoutePointProvider.class, method = "add")  
	@Options(flushCache = true, timeout = 20000)
	public int add(@Param("bean") RoutePoint bean);
}

为什么我查询出来的时候list为null 数据库里面是有数据的

经过分析发现

	@SelectProvider(type = RouteProvider.class, method = "getById")  
	@Options(flushCache = true, timeout = 20000)
	@Result(property="list",column="id",javaType=List.class,many=@Many(select="com.wzkj.manage.mapper.RoutePointMapper.getByRoute"))
	public Route getById(@Param("id") int id);

}

的select="com.wzkj.manage.mapper.RoutePointMapper.getByRoute"这个方法完全没有执行，到底是怎么回事呢

iBATIS