摘要: str.replace(new RegExp('ITAP_XPURL','g'),'123') 阅读全文
posted @ 2017-03-09 18:33 来临 阅读(247) 评论(0) 推荐(0)
摘要: //判断浏览器版本 function myBrowser(){ var userAgent = navigator.userAgent; //取得浏览器的userAgent字符串 var isOpera = userAgent.indexOf("Opera") > -1; if (isOpera) 阅读全文
posted @ 2017-03-09 18:31 来临 阅读(190) 评论(0) 推荐(0)
摘要: 打开Eclipse时:Workspace in use or cannot be created, choose a different one.–错误解决办法原因:出现这种情况一般是workspace的配置文件中出现了.lock文件(workspace/.metadata/.lock),锁定了wo 阅读全文
posted @ 2017-03-09 18:30 来临 阅读(818) 评论(0) 推荐(0)
摘要: 阿拉伯语(维语)转中文 String XM = "è?¨???éo|????·éo|éo|?"; //乱码转中文XM=XM.matches("^[a-zA-Z0-9_.@\u4e00-\u9fa5]+$")?XM:new String(XM.getBytes("iso8859-1"),"utf-8" 阅读全文
posted @ 2017-03-09 18:24 来临 阅读(2086) 评论(0) 推荐(0)
摘要: 解析TXT文件步骤:1、File file = new file('D:\a.txt');// 创建文件对象2、String code = ReadFile.codeString(file.getAbsolutePath());//获得文件编码3、InputStreamReader read = n 阅读全文
posted @ 2017-03-09 18:23 来临 阅读(4670) 评论(0) 推荐(0)
摘要: delete from qb_cbxx where rowid not in (select max(rowid) from qb_cbxx where sjly='情报报送' and del='false' group by (rwid,stxx)) 阅读全文
posted @ 2017-03-09 18:21 来临 阅读(219) 评论(0) 推荐(0)
摘要: select * from table where dbms_lob.instr(CLOB字段,utl_raw.cast_to_raw('13629964880'),1,1)<>0; 阅读全文
posted @ 2017-03-09 18:19 来临 阅读(287) 评论(0) 推荐(0)
摘要: select * from mbk.qb_qbbs_xc as of timestamp to_timestamp('2016-12-21 15:40:00','yyyy-mm-dd hh24:mi:ss') //查询还原时间点数据flashback table qb_qbbs_xc to time 阅读全文
posted @ 2017-03-09 18:15 来临 阅读(5161) 评论(0) 推荐(0)
摘要: //查询当前记录的 //oracle 上一条记录select decode(decode(txbs,'无',null,txbs),lag(t.txbs, 1, 0) over(order by t.cjid),'是','否')from qb_app_rycj t //下一条记录select t.id 阅读全文
posted @ 2017-03-09 18:14 来临 阅读(8154) 评论(1) 推荐(0)