jLR8ZC-855575-64585156829082269
D:\WEBLOGIC\Oracle\Middleware\user_projects\domains
wwj
ftp
http://www.open-open.com/lib/view/open1342167969281.html
管理资料档案库已置于安全模式下, 在此模式下将对 Enterprise Manager 数据进行加密。加密密钥已放置在文件 E:\app\pc\pc-PC_orcl\sysman\config\emkey.ora 中。请务必备份此文件, 因为如果此文件丢失, 则加密数据将不可用。
svn plsql自动 eclipse快捷 数据库导入导出
<context:property-placeholder
Properties Log log = LogFactory.getLog(PropertiesUtil.class)
rownum rn a.*
SuppressWarnings int TRUNCATE
on where having Not exists
用EXISTS替换DISTINCT sql语句用大写的
免在索引列上使用NOT
java代码中尽量少用连接符“+”连接字符串
web Service
String result = element.getFirstElement().getText(); incrementAndGet
volatile
invokeBlocking(entry, values, classes)QName("http://com/","getValue")
选中状态 提交日期 $("#msg").val("22222222222") .data()
${pageContext.request.contextPath} confirm("确认删除 节点 --"+ treeNode.name +"吗?")
setting.callback.onClick = zTreeOnClick(); log4j
remove(); WSDD Web开发中获取Spring的ApplicationContext的三种方式 默认tab
getScheme bean为public getRomortIp/getHeader("x-forwarded-for") Pattern string for循环i weblogic
版本版本 HttpServletRequestWrapper servlet异常处理 脚本注入 click(),click(...)
where syscode=?VSwhere syscode=syscode .toArray(new String[requestIdsList.size()])
Properties默认认为is的编码是ISO-8859-1
window->preference->java->compiler
System.setProperty("javax.xml.stream.XMLInputFactory", "com.ctc.wstx.stax.WstxInputFactory");
System.setProperty("javax.xml.stream.XMLOutputFactory", "com.ctc.wstx.stax.WstxOutputFactory");
System.setProperty("javax.xml.stream.XMLEventFactory", "com.ctc.wstx.stax.WstxEventFactory");
覆盖ajax请求 "javascript:void(0);" (expires 0;pragma No-cache;cache-control no-cache)
(meta name http-equiv) (if (top != self) top.location = self.location;) selfVSthis
($("#t").jqGrid("getGridParam","selrow")) (并不是获取的配置文件相对应用(项目)的路径,而是相对src)
(,../struts.xml ) (struts 转发,重定向,返json,返二进制,获取session[map],拦截器)
(Could not resolve placeholder 'driverClassName') solr facet sb.append(" +"+fField+":"+fdata+"\\r\\n");
加载顺序是listener>filter>servlet
template.query(sql, new Object[]{start,end}, new int[]{4,4},new BeanPropertyRowMapper(D_FILE7_0000.class));
solrhome路径非web路径 /X.do(url-pattern精确匹配必须加/) 能够导致响应已经committed的操作包括:forward, redirect, flushBuffer
栈中数据可以共享(修改时给出新数据,不影响其他变量) StringEscapeUtils.escapeHtml()
request.getSession().getServletContext().getRealPath("/") 读取配置文件 HttpServletRequestWrapper
Method method=requestParams.getClass().getMethod("setLocked",new Class[]{boolean.class});
method.invoke(requestParams,new Object[]{new Boolean(false)});
SOLR
start为0(jqgri为1) 排除操作符不能单独与项使用构成查询 solrFieldType:location,uuid,dataField,externalFildField,boolField
params.add(filterQuery); @Field(必须添加)
jgGrid
$.jgrid.stripHtml(tittt);
LOG4J
threshold
B
$(document).ready(function() {autoWindowWH();$(window).resize(function(){ autoWindowWH(); });}
$(this).parent().next().stop(true,true).slideToggle('normal',callback); editrules:{custom:true, custom_func:myCheckBox}}
失去焦点后关闭 datepicker jQuery("#" + id + "_sdate", "#rowed6")(aria describedby,相对选择器)
jQuery("#grid_id").jqGrid('editRow',rowid, keys, oneditfunc, succesfunc, url, extraparam, aftersavefunc,errorfunc, afterrestorefunc); jQuery("#rowed4").jqGrid('saveRow', "13", checksave); event.keyCode <a href="http://www.baidu.com" target="mainIframe">
(saveRow restoreRow) 判断ie/ie6$.browser.msie && ($.browser.version == "6.0") && !$.support.style
iepngfix window.myiframe.location.href= onclick(this) getByIdVSgetByParam 下载时window.open(url); text-overflow:ellipsis Server.Htmlencode
{$().each(function(){})循环出dom} {ie6return false} {用下划线CSS属性来单独定义IE6的CSS版本} 绑定事件(on one off) $n2.trigger("click.foo.bar!"); // 触发A (event.namespace = "bar.foo")
ACCORDION
$( "#accordion" ).accordion({
active: 1,
animate: "easeInBounce" ,
collapsible: true,
disabled: false,
//header: "h3",
heightStyle: "content",
event: "mouseover",
//icons: { "header": "ui-icon-plus", "activeHeader": "ui-icon-minus"
});
ORACLE
{
1.下面的语句用来查询哪些对象被锁:
select object_name,machine,s.sid,s.serial#
from v$locked_object l,dba_objects o ,v$session s
where l.object_id = o.object_id and l.session_id=s.sid;
2.下面的语句用来杀死一个进程:
alter system kill session '24,111'; (其中24,111分别是上面查询出的sid,serial#)
【注】以上两步,可以通过Oracle的管理控制台来执行。
3.如果利用上面的命令杀死一个进程后,进程状态被置为"killed",但是锁定的资源很长时间没有被释放,那么可以在os一级再杀死相应的进程(线程),首先执行下面的语句获得进程(线程)号:
select spid, osuser, s.program
from v$session s,v$process p
where s.paddr=p.addr and s.sid=24 (24是上面的sid)
4.在OS上杀死这个进程(线程):
1)在unix上,用root身份执行命令:
#kill -9 12345(即第3步查询出的spid)
2)在windows(unix也适用)用orakill杀死线程,orakill是oracle提供的一个可执行命令,语法为:
orakill sid thread
其中:
sid:表示要杀死的进程属于的实例名
thread:是要杀掉的线程号,即第3步查询出的spid。
例:c:>orakill orcl 12345
}
--修改数据库编码格式
select name,status from v$datafile;
select * from v$nls_parameters
alter DATABASE character set ZHS16GBK
---查看修改表空间
select tablespace_name, sum(bytes) / 1024 / 1024 from dba_data_files group by tablespace_name; --查看表空间大小
alter database datafile 'E:\app\Administrator\oradata\orcl11g\amsbz.dbf' resize 25840m ; --修改表空间大小
select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files; --查看临时表空间大小
alter database tempfile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL11G\TEMP01.DBF' autoextend on next 5m maxsize 700M; --修改临时表空间大小
----amsbz表空间导入数据-----------
create tablespace jsdl
logging
datafile 'E:\app\pc\oradata\orcl\jsdl.dbf'
size 1024m
autoextend on next 100m maxsize 15550m
extent management local;
create user jsdl identified by jsdl DEFAULT tablespace jsdl quota 10m on jsdl ;
grant dba to jsdl ;
create or replace directory dump_dir as 'E:\dmp' ;
grant read,write on directory dump_dir to jsdl ;
------------------cmd命令断执行
impdp jsdl/jsdl@orcl directory=dump_dir dumpfile=005.DMP schemas=jsdl --数据泵导入命令
imp c##amsbz/c##amsbz@orcl11g file='c:\dmp\geweifeng.dmp' full=y --plsql导入命令
--只对include包含的对象类型(如 TABLE,VIEW,FUNCTION,INDEX)导入,table_exists_action代表如果已导入则替换掉原来的数据信息
impdp c##amsbz/c##amsbz@orcl11g directory=dump_dir dumpfile=C##AMSBZ.DMP logfile=include_1.log include=SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA table_exists_action=replace
------------------导出数据
create or replace directory dump_dir as 'E:\dmp';
grant read,write on directory dump_dir to c##amsbz
expdp c##amsbz/c##amsbz@orcl directory=dump_dir dumpfile=amsbz.DMP schemas=c##amsbz
--expdp c##amsbz/c##amsbz@orcl directory=dump_dir dumpfile=c##amsbz.dmp schemas=c##amsbz logfile=c##amsbz.log version=10.2.0.1.0
------------coa_sgdag表空间导入数据---------------
create tablespace coa_sgdag
logging
datafile 'E:\app\Administrator\oradata\orcl11g\coa_sgdag.dbf'
size 1024m
autoextend on next 100m maxsize 5550m
extent management local;
create user c##coa_sgdag identified by c##coa_sgdag default tablespace coa_sgdag quota 10m on coa_sgdag ;
grant dba to c##coa_sgdag ;
create or replace directory dump_dir as 'c:\dmp' ;
grant read,write on directory dump_dir to c##coa_sgdag ;
------------------cmd命令端执行
impdp c##coa_sgdag/c##coa_sgdag@orcl directory=dump_dir dumpfile=C##COA_SGDAG.DMP schemas= c##coa_sgdag ;
---修改表空间AMSBZ为新的表空间C##AMSBZ
impdp system/orcl11g@orcl directory=dump_dir dumpfile=C##COA_SGDAG.DMP schemas= c##coa_sgdag remap_tablespace=AMSBZ:C##AMSBZ ;
------------------导出数据
create or replace directory dump_dir as 'E:\dmp';
grant read,write on directory dump_dir to c##coa_sgdag
expdp c##coa_sgdag/c##coa_sgdag@orcl directory=dump_dir dumpfile=sgdag.DMP schemas=c##coa_sgdag
expdp c##coa_sgdag/c##coa_sgdag@orcl11g directory=dump_dir dumpfile=sgdagP.DMP logfile=include_1.log include=SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE table_exists_action=replace
------删除表空间和数据
Drop tablespace coa_sgdag INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
Drop tablespace c##amsbz INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
---删除用户
drop user c##amsbz cascade ;
drop user c##coa_sgdag cascade ;
grant dba to cqdl ;
create or replace directory dump_dir as 'E:\dmp' ;
grant read,write on directory dump_dir to cqdl ;
impdp cqdl/cqdl@orcl directory=dump_dir dumpfile=CQDL101.DMP schemas=thams;
select * from v$version;
数组转集合可增删方法Collections.addAll(new ArrayList<Integer>(5), ob), ArrayList<Integer> copyArrays=new ArrayList<Integer>(Arrays.asList(ob)),Arrays.asList(ArrayUtils.toObject(i));
每次关闭时log4j报错occured while converting date.
获取路径方法
IE
下载失败:不支持不支持http 201响应码 根本原因:http://blog.csdn.net/jackpk/article/details/38234949
下载失败解决方法:修改返回状态码,如果还未解决,添加以下代码设置catch使ie识别此次为下载文件:
response.setHeader("Content-Transfer-Encoding","binary");
response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0");
response.setHeader("Pragma", "public");
disabled适用于所有标签,且可以锁定鼠标无法focus,readonly只适用于input
select onchange事件