• 随笔


    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>");
    

      

  • 相关阅读:
    STM32F401
    按字母顺序排列的IDC函数列表
    IDA 中文字符串
    Retrieving ST-Link/V2 Firmware from Update Utility
    IDA IDC Tutorials: Additional Auto-Commenting
    IDA resources
    Digital Current-Mode Control Challenges Analog Counterparts
    SQLSERVER 里SELECT COUNT(1) 和SELECT COUNT(*)哪个性能好?
    将ACCESS数据库迁移到SQLSERVER数据库
    RedGate 工具SQLMultiScript1.1
  • 原文地址:https://www.cnblogs.com/demon09/p/9104717.html
Copyright © 2020-2023  润新知