mybatis注解关联查询问题

三味书屋 2015-05-06 09:57:38
我的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);

}



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"这个方法完全没有执行,到底是怎么回事呢
...全文
290 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
三味书屋 2015-05-06
  • 打赏
  • 举报
回复
有人知道吗。。。。

67,513

社区成员

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧