-----------------ibatis取不到数据---------------

[Brokenfango]

<resultMap id="frResult" class="Friend">
<result property="id" column="ID"/>
<result property="uId" column="U_ID"/>
<result property="fId" column="F_ID"/>
</resultMap>
<resultMap id="fsResult" class="java.util.HashMap">
<result property="id" column="ID"/>
<result property="uId" column="U_ID"/>
<result property="fId" column="F_ID"/>
</resultMap>
<select id="getFById" parameterClass="java.lang.Integer" resutlMap="frResult">
<![CDATA[
select * from fs where id=#value#
]]>
</select>
<select id="getFList" parameterClass="java.lang.Integer" resutlMap="fsResult">
<![CDATA[
select * from fs where u_id=#value#
]]>
</select>

fs表确实有数据 可是取出来的数据为空！！
请大侠们看看问题出在哪里？？

[c2one]

select * from fs where id=#id# 试试

或者
<select id="getFById" parameterClass="String" resutlMap="frResult">
<![CDATA[
select * from fs where id=#value#
]]>
</select>

[jinsu_st]

把你DAO层的代码贴上来一起看

[Brokenfango]

[Quote=引用 1 楼 c2one 的回复:]
select * from fs where id=#id# 试试

或者
<select id="getFById" parameterClass="String" resutlMap="frResult">
<![CDATA[
select * from fs where id=#value#
]]>
</select>
[/Quote]
这样也不行哈

我取别的表的数据是可以的 取这个表就是不行

[Brokenfango]

import java.io.Serializable;
public class Friend implements Serializable{
private int id;
private int uId;//
private int fId;//
//
public Friend(int uId,int fId){
this.uId = uId;
this.fId = fId;
}
//
public Friend(){

}
//getters and setters
public void setId(int id){
this.id = id;
}
public int getId(){
return this.id;
}
public void setUId(int uId){
this.uId = uId;
}
public int getUId(){
return this.uId;
}
public void setFId(int fId){
this.fId = fId;
}
public int getFId(){
return this.fId;
}
}

try {
reader = Resources.getResourceAsReader ("sqlmap_cfg.xml");
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
} catch (IOException e) {
e.printStackTrace();
}
try {
Object obj = sqlMap.queryForObject("getFById",4);
if (obj == null) {
System.out.println("obj = null");
} else {
Friend f = (Friend) obj;
System.out.println(f.getUserId());
}
} catch (SQLException e){
e.printStackTrace();
}

输出 obj = null

[Brokenfango]

f.getUserId()-->f.getUId();

[song1216]

up