window.open('./login.wf?sid=<#sid>&cmd=TBS&planId=<#planId>','_blank','width=200,height=500,scrollbars=yes'); <iframe id="iframe" name="iframe" width="380px" height="500px" frameborder="0" sroclling="auto" src="./login.wf?sid=<#sid>&cmd=TBA&planId='+planId+'&init=type"></iframe> jQuery.ajax({ url:'../ajax', type:'post', data:{ sid:'<#sid>',' cmd:'TBS', param:0 }, success:function(data){ if(data=="ok"){ var framMain = document.getElemetById("framMain"); framMain.cmd.value="TBSS_SVS"; framMain.target="_blank"; framMain.submit(); return false; }else{ alert("出错..."); } } }); jQuery.ajax({ url:'../ajax', type:'post', data:{ sid:$("input[name='sid']").val(), cmd:'TBS_JY_FB_CONTRACT_SEARCH_ISAGREE', detection:arr.join(",") }, success:function(data){ removeSelect(); var arr = d.split(","); for(var i=0;i<arr.length;i++){ $("CZ").append("<option value='"+arr[i]+"'>"+arr[i]+"</option>"); } } }); var arr=getCheckedArray("one"); arr.join(","); function checkAll(){ var all = document.getElementById("all"); var one = document.getElementsByName("one"); if(var i=0;i<one.length;i++){ one[i].checked=all.checked; } } <input type="reset" value="重置" /> function remove(){ formreset("framMain"); } function removeRadio(){ $("input[name='radio']").removeAttr('checked'); } function removeSelect(){ $("#CZ option").each(function(){ if($(this).val()!=""){ $(this).remove(); } }); } <input type="button" value="重置" onclick="remove();" /> getParams("framMain"); <input type="hidden" name="parameters" id="parameters" /> String parameters = UtilCode.decode(myStr.matchValue("_parameters[", "]parameters_")); Hashtable hashTags = FormParametersUtil.getParameters(parameters); DBSql.open(); String field = DBSql.getString("select field from emp","field"); int num = DBSql.getInt("select count(1) num from emp","num"); DBSql.close(null); DBSql.executeUpdate(update / delete); List list = DaoUtil.getData(""); DBSql.getString(conn,""); DBSql.getInt(conn,""); DBSql.executeUpdate(conn,""); close(conn,null,null); DBSql.executeUpdate("update tbs_equ_purchase_equipment set equtype='"+xgfl+"' where id in('"+equid.replace(",","','")+"')"); case a.deptno when '10' then 'dept10' when '20' then 'deptno20' when '30' then 'deptno30' end department decode(deptno,10,'dept10',20,'dept20',30,'dept30')department select decode(sign(3-5),1,3,5) from dual; select 重复字段 from 表名 group by 重复字段 having count(重复字段)>1; select wm_concat(name) from test; select t.* from tbs_hse_danger_factor t start with superfactorcode='0' connect by prior factorcode=superfactorcode order siblings by to_char(to_number(factorcode),'fm000000'); public String factorCode_wxyh(String factorid, String factorcode) { String sql = "select count(1) c from tbs_hse_danger_factor where factorcode='"+DaoUtil.nullToString(factorcode)+"' "; if(!"".equals(DaoUtil.nullToString(factorid))){ sql+="and factorid<>'"+DaoUtil.nullToString(factorid)+"' " } int c = DBSql.getInt(sql,"c"); if(c==0){ return "ok"; }else{ return ""; } } public static Hashtable<String,String> getOptionHashtable(Connection conn,String appdicid){ Hashtable<String,String> ht = new Hashtable<String,String>(); Statement st = null; ResultSet rs = null; try{ st = conn.createStatement(); rs = st.executeQuery("select dicname,dicvalue from sys_dic where appdicid='"+appdicid+"' and isleaf='1' "); while(rs.next()){ ht.put(rs.getString("dicvalue"),rs.getString("dicname")); } }catch(SQLException e){ e.printStackTrace(); }finally{ DBSql.close(st,rs); } return ht; } Hashtable<String,String> equtype = DaoUtil.getOptionHashtable(conn,"5031"); sb.append("<td width="120" style="word-break:break-all;">"+DaoUtil.nullToNBSP(equtype.get(DaoUtil.nullToString(hash.get("EQUTYPE"))))+"</td>");