1、mybatis
1)in语句
<if test="null !=status and ''!=status">
and sout.status in
<foreach item="item" index="index" collection="status" open="(" separator="," close=")">
#{item}
</foreach>
</if>
2)动态update
<update id="updateIvtBackDetail">
update inventory_back_detail
<trim prefix="set" suffixOverrides=",">
<if test="null != brandName">
brandName =#{brandName}
</if>
<if test="null != backTotal">
backTotal = #{backTotal}
</if>
</trim>
where detailId = #{detailId}
</update>
2、jquery
1) 去掉小数点后面多余的0
var a=23.8000
alert(parseFloat(a)) //结果:23.8
2) 保留两位小数
toFixed(2)
3) 获取Select选择的Text
var checkText=$("#select_id").find("option:selected").text();
3、jqgrid
1) 重新载入
jQuery(grid_selector).jqGrid('setGridParam', {
url : UrlConfig.projectList,
datatype : 'json',
postData: data,
page : 1
}).trigger('reloadGrid');// 重新载入
2) 获取选中的数据
var ids = jQuery(grid_selector).jqGrid('getGridParam', 'selarrrow');
var planResourceId = jQuery(grid_selector).jqGrid('getGridParam', 'selrow');
3) 获取所有数据
var obj = jQuery('#grid-pc-price').jqGrid("getRowData");
var obj = jQuery(grid_selector).jqGrid("getRowData", ids[0]);
4) 获取当前页数
var page = $(grid_selector).getGridParam('page');
5) 多选改为单选
onSelectRow: function (id) {// 单选
$this = $(this);
if (ids.length<=0)
ids = $this.jqGrid('getGridParam', 'selarrrow');
if (id && ids.length > 1) {
$.each(ids, function (i,v) {
if (v != id)
$this.jqGrid('setSelection',v);
});
}
return true;
}