<sqlMap namespace="PersonnelRegist">
? <typeAlias alias="ID" type="com.xindeco.core.pojo.IDEntity"/>
? </select>
?? <select id="GraAppInfo.searchUpApply" parameterClass="com.xindeco.business.dto.GraAppInfoDTO"????resultClass="ID" cacheModel="userCache">
?? select distinct a.ID AS id
?? from TGraAppInfo a? left join TEMPLOYUNITBASEINFO b on a.unit=b.MEMBERID
?? where appstatus = '1'
?? <dynamic>
?? <isNotEmpty prepend="AND" property="name">(a.name like '%' + #name# + '%')</isNotEmpty>
?? <isNotEmpty prepend="AND" property="unit">(b.UNITNAME like '%' + #unit# + '%')</isNotEmpty>
?? </dynamic>
? </select>
</sqlMap>
注意sqlmapGraAppInfoDTO的name,unit只能是基本數(shù)據(jù)類型,不能是復(fù)雜數(shù)據(jù)類型.
2、<script>的位置
<script>
form1.srchEdit.value='<%=srchEdit%>';
form1.srchType.value='<%=srchType%>';????
</script>
<form>
<input type="text" name="srchEdit"/>
<input type="text" name="srchType"/></form>
與<form>
<input type="text" name="srchEdit"/>
<input type="text" name="srchType"/>
</form>
<script>
form1.srchEdit.value='<%=srchEdit%>';
form1.srchType.value='<%=srchType%>';????
</script>
的差別,必須在form加載完對(duì)它賦值,否則srchEdit又重新加載,為null
3、hibernate屬性設(shè)置出現(xiàn)錯(cuò)誤:
????? 如果pojo類取fSUnit屬性名,系統(tǒng)將無法識(shí)別。get和set將取不到值。