摘要:
String.split():------------------------------------------- String test = "123,123,,123,,"; ------------------------------------------- //结尾的空格元素,不会作为arr的一个元素而返回 split(",");String[] arr1 = test.split(","); System.out.println(arr1.length); ==>4------------------------- 阅读全文
摘要:
public class SyncObj { private static SyncObj obj = null; private SyncObj(){ } public static SyncObj getIns(){ if(obj==null){ System.out.println("obj=null"); obj = new SyncObj(); return obj; } return obj; } public synchronized void say(){ System.out.println("hello world.."); } }= 阅读全文
摘要:
select * from demo.emp_salaryid,name,salary,SAL_DATE1,'A',1000.00,'2012-01-01'2,'A',1100.00,'2012-02-01'3,'A',1150.00,'2012-03-01'4,'A',1300.00,'2012-04-01'5,'A',1200.00,'2012-05-01'6,'A',1500.00,'2012-06-01& 阅读全文
摘要:
jar: jxl.jarpublic void generateExcel() throws Exception {List<ListOrderedMap> result = new ArrayList<ListOrderedMap>();ListOrderedMap head = new ListOrderedMap();head.put(0, "Country", "国家");head.put(1, "Postal", "邮编");result.add(head);ListOrdered 阅读全文
摘要:
VLOOKUP是按列查找,最终返回该列所需查询列序所对应的值;HLOOKUP是按行查找的=vlookup(lookup_value,table_array,col_index_number,[range_lookup])IDLookup NameIDName1=vlookup(?,?,?,?)2zhang323li431wang544lao6举例,以上表格有一个无序的记录ID和Name的表格现在有一个序列的ID,要查找这个序列的Name就可以用=vlookup(A2,C2:D5,2,false)第一个是lookup_value,就是想要匹配的ID的值第二个是table_array,查找范围第三 阅读全文
摘要:
ALTER FUNCTION "DBA"."itv_isvalid_vodchooser"( in v_id bigint, v_request_time timestamp, v_ip_addr varchar(20)/* [IN] 参数名称 参数类型 [DEFAULT 缺省值], ... */ )RETURNS INTEGERDETERMINISTICBEGINDECLARE "result" INTEGER;/* 在此处键入函数语句 */ select top 1 url,request_time,id into #itv_ac 阅读全文