不管我怎么弄,有且只有一條,而且是最后一條。。。實(shí)體類(lèi)Users中有屬性cardId,為主鍵,是實(shí)體類(lèi)RealEstate的外鍵,RealState中有1對(duì)多關(guān)系屬性private Users user;dao接口和映射文件代碼:public?interface?RealEstateMapper?{
@MapKey("users")
public?Map<Users,RealEstate>?getReListByUsers(Users?users);
@MapKey("id")
public?Map<Integer,RealEstate>?getReListById(Integer?Id);
public?Integer?insertRes(RealEstate?realEstate);
public?Integer?deleteRes(RealEstate?realEstate);
public?Integer?updateRes(RealEstate?realEstate);
}<?xml?version="1.0"?encoding="UTF-8"?>
<!DOCTYPE?mapper?PUBLIC?"-//mybatis.org//DTD?Mapper?3.0//EN"????
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper?namespace="dao.RealEstateMapper">
<select?id="getReListById"?resultType="RealEstate"?parameterType="RealEstate">
select?*?from?real_estate?where?id=#{id}
</select>
<select?id="getReListByUsers"?resultType="RealEstate"?parameterType="Users">
select?*?from?real_estate?where?cardId=#{cardId}
</select>
<select?id="insertRes"?parameterType="RealEstate">
insert?into?real_estate(id,cardId,projectName,address,houseType,area,buildTime)?values(
#{id},#{cardId},#{projectName},#{address},#{houseType},#{area},#{buildTime}
)
</select>
<select?id="updateRes"?parameterType="RealEstate">
update?real_estate?set?cardId=#{cardId},projectName=#{projectName},address=#{address},houseType=#{houseType},area=#{area},buildTime=#{buildTime}?
where?cardId=#{cardId}
</select>
<select?id="deleteRes"?parameterType="RealEstate">
delete?from?real_estate?where?cardId=#{cardId}?or?id=#{id}
</select>
</mapper>controller中調(diào)用了getReListByUsers(users)方法,users對(duì)象的cardId屬性已賦值,控制臺(tái)輸出語(yǔ)句如下:[DEBUG] 2017-09-01 20:26:09,375 dao.RealEstateMapper.getReListByUsers - ==> ?Preparing: select * from real_estate where cardId=??[DEBUG] 2017-09-01 20:26:09,375 dao.RealEstateMapper.getReListByUsers - ==> Parameters: 123456789123456789(String)用foreach輸出查詢(xún)到的對(duì)象只顯示mysql中符合條件的最后一個(gè)數(shù)據(jù),但是在mysql中能全部查出,參數(shù)我試了好幾種,結(jié)果都一樣,求解啊!
2 回答
已采納

精慕門(mén)9254224
TA貢獻(xiàn)167條經(jīng)驗(yàn) 獲得超46個(gè)贊
一對(duì)多關(guān)系查出來(lái)不是應(yīng)該用list 來(lái)接收嗎?還有你的增刪改為什么還用select 標(biāo)簽,不應(yīng)該有對(duì)應(yīng)的insert ,update ,delete 標(biāo)簽嗎?

慕UI9581161
TA貢獻(xiàn)4條經(jīng)驗(yàn) 獲得超0個(gè)贊
增刪改標(biāo)簽不應(yīng)該用select 標(biāo)簽,有對(duì)應(yīng)的insert ,update,delete 。 另外你是要做聯(lián)合查詢(xún)嗎?
添加回答
舉報(bào)
0/150
提交
取消