SY项目开发随记

编译器字符集：-Dfile.encoding=UTF-8

编译器(Eclipse)内存： -Xms256m -Xmx512m -XX:PermSize=256m -XX:MaxPermSize=512m

--查询空格
select t.*, t.rowid from HR_EDUCATION t  where regexp_like(t.start_date, '( )+');

merge into 目标表 a
using 源表 b
on(a.条件字段1=b.条件字段1 and a.条件字段2=b.条件字段2 ……)  
when matched then update set a.更新字段=b.字段
when  not macthed then insert into a(字段1,字段2……)values(值1,值2……)
 

数据库备份批处理：

set fileName=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%
set fileName=HR%fileName: =0%.dmp
echo %fileName%
exp admin/admin1234@ORCL file=E:\backup\database\%fileName% log=E:\backup\database\exp.log owner=(admin)
exit

Oracle数据库日志查询：

select t.SQL_TEXT, t.FIRST_LOAD_TIME
from v$sqlarea t
where t.FIRST_LOAD_TIME like '2018-11-08%'
order by t.FIRST_LOAD_TIME desc

jsp页面与Controler映射

jsp：<input type="text" name="seach_COURSE_TEACHER" id="seach_COURSE_TEACHER" value="${COURSE_TEACHER}"/>

java：modelMap.put("COURSE_TEACHER", request.getParameter("seach_COURSE_TEACHER"));