随笔

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