validateform正则表达式 datatype验证数字
正则表达式验证正数负数 浮点数
/^\-?[0-9]+(.[0-9]+)?$/
datatype="/^\-?[0-9]+(.[0-9]+)?$/"
正则表达式验证正数负数 浮点数
/^\-?[0-9]+(.[0-9]+)?$/
datatype="/^\-?[0-9]+(.[0-9]+)?$/"
onkeyup="if(isNaN(value))execCommand('undo')" onafterpaste="if(isNaN(value))execCommand('undo')"
hibernate sql查询转换成VO@Override public List<FenxiVo> getTuanDuiFenxiList(FenxiVo FenxiVo,Integer pageNo,IntegerpageSize){
String sql="SELECTb.tuanhao,"+" t.chebiao,u.name ASxiaoshouname"+" FROMBaoMing b"+" LEFT JOIN ChuInfo c ON t.id=c.fentuanid where 1=1";if(FenxiVo.getXiaoshouname()!=null){
sql+=" and u.name like '%"+FenxiVo.getXiaoshouname()+"%'";
}
Query query=this.getSession().createSQLQuery(sql);
query.setMaxResults(pageSize);
query.setFirstResult((pageNo-1)*pageSize);
List<FenxiVo> list= (List<FenxiVo>) query.setResultTransformer(Transformers.aliasToBean(FenxiVo.class)).list();//List<FenxiVo> list =query.list();returnlist;
}
嵌套批量更新
UPDATE CheLiang SET lineName = t.linename
FROM TeamJiHua t ,CheLiang tc WHERE t.id = tc.teamid
$(".mingxirmspan").click(function(){
$(this).closest("tr").remove();
})