mapping
<resultMap id="BaseResultMap" type="com.teaching.pojo.Project" >
<id column="PID" property="pid" jdbcType="INTEGER" />
<result column="PName" property="pname" jdbcType="CHAR" />
<result column="FPID" property="fpid" jdbcType="INTEGER" />
<result column="CUID" property="cuid" jdbcType="INTEGER" />
<result column="CTime" property="ctime" jdbcType="TIMESTAMP" />
<result column="BTime" property="btime" jdbcType="TIMESTAMP" />
<result column="ETime" property="etime" jdbcType="TIMESTAMP" />
<result column="status" property="status" jdbcType="CHAR" />
<result column="PType" property="ptype" jdbcType="CHAR" />
<result column="TID" property="tid" jdbcType="INTEGER" />
</resultMap>
<resultMap type="ProjectCustom" id="result" extends="BaseResultMap">
<association property="bUser" javaType="UserCustom" >
<id column="UID" property="uid" jdbcType="INTEGER" />
<result column="UserN" property="usern" jdbcType="CHAR" />
<result column="UPassword" property="upassword" jdbcType="CHAR" />
<result column="UName" property="uname" jdbcType="VARCHAR" />
<result column="UImage" property="uimage" jdbcType="VARCHAR" />
<result column="UPhone" property="uphone" jdbcType="VARCHAR" />
<result column="UDept" property="udept" jdbcType="CHAR" />
<result column="UClass" property="uclass" jdbcType="CHAR" />
<result column="RName" property="rname" jdbcType="CHAR" />
</association>
</resultMap>
<sql id="Base_Column_List" >
PID, PName, FPID, CUID, CTime, BTime, ETime, status, PType, TID
</sql>
<select id="selectProjectCustom" resultMap="result" parameterType="java.lang.Integer">
SELECT p.* ,u.*
FROM evaluation e,user u ,project p
where PUID = #{puid,jdbcType=INTEGER} and Scrose = -1 and u.UID= e.BUID and p.PID = e.FPID
GROUP BY BUID
</select>
ProjectCustom類
public class ProjectCustom extends Project{
private UserCustom bUser;
public UserCustom getbUser() {
return bUser;
}
public void setbUser(UserCustom bUser) {
this.bUser = bUser;
}
private List<ItemsCustom> itemslist ; //每個專案下的單項
private float scrose;//專案成績
public List<ItemsCustom> getItemslist() {
return itemslist;
}
public void setItemslist(List<ItemsCustom> itemslist) {
this.itemslist = itemslist;
}
public float getScrose() {
return scrose;
}
public void setScrose(float scrose) {
this.scrose = scrose;
}
@Override
public String toString() {
return /*"自定義專案： [uname=" + uname + ", buid=" + buid +*/ ", bUser="
+ bUser + ", itemslist=" + itemslist + ", scrose=" + scrose
+ "]";
}
}
uj5u.com熱心網友回復：
你在哪塞值的
uj5u.com熱心網友回復：
4條應該是相同的資料，在你配置的resultMap標簽下，存在標簽<id column="PID" property="pid" jdbcType="INTEGER" />代表去重，所以只會顯示一條
uj5u.com熱心網友回復：
貼出你接識訓傳結果的代碼吧，你要拿到四條不應該用list接識訓傳結果嗎？uj5u.com熱心網友回復：
此屬性 property="bUser" 放在Project 類轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/97463.html
標籤：Web 開發