qq_43373802的博客

审计问题sqlplus system/123456 as sysdba;以sys登录SQL>shutdown immediate;SQL>startup;开启alter system set audit_sys_operations=TRUE scope=spfile;--审计管理用户(以sysdba/sysoper角色登陆)alter system set audit_trail=DB,extended scope=spfile;audit_trail 的value值为NONE

一些数据库语句记录好久没写代码了，最近都去做区域数据集业务去了，回顾一下代码NLSSORT，可以用来进行语言排序，且不影响当前会话．用法示例:拼音SELECT * FROM TEAM ORDER BY NLSSORT(排序字段,'NLS_SORT = SCHINESE_PINYIN_M')笔划SELECT * FROM TEAM ORDER BY NLSSORT(排序字段,'NLS_SORT = SCHINESE_STROKE_M')部首SELECT * FROM TEAM ORDER

url: jdbc:mysql://xxx.xx.x.xx:3306/xxx_xx?useUnicode=true&characterEncoding=UTF-8&generateSimpleParameterMetadata=true&useSSL=false&serverTimezone=Asia/Shanghai&serverTimezon...

Freemarker 集合里参数为集合的循环方法我以宏作为模板来复现//data start end三个参数 其中data内包含树形结构children<#macro tree data start end> //为了区分不需要改动的标签 <#if (start=="start")> ...

sql递归速记<select id="selectOrgTree" parameterType="com.jx.uac.api.doman.dto.OrganizationDto" resultType="com.jx.uac.api.doman.vo.OrganizationTreeVO"> select ID,PID,NAME title, ...

记录下sql里map入参增删查mybatis处理入参map新增： INSERT INTO JKGL_JQ_JTCY <trim prefix="(" suffix=")" suffixOverrides=","> <if test="objectid != null and objectid != ''"> ...

两个LIST里不同对象无法使用containsAll及重写equals等方法，我的业务逻辑是一个实体类数据保存在历史数据里首先两个实体类public class NewStudent { private int id; private String name; private String email; get/set方法.....}public...

1.cfg.setClassForTemplateLoading(XXX.class,ftlFilePath);类加载是模板最好的用法，类地址ftlFilePath写法是同一层的地址/templates/ftl2.Template template = cfg.getTemplate(modelName);getTemplate文件地址 不需要加/ 直接写模板XXX.ftl3.ITextFo...

package com.jx.common.tool.utils;import java.util.Set;import javax.validation.ConstraintViolation;import javax.validation.Validation;import javax.validation.Validator;import org.hibernate.vali...

mapper.xml文件内写法select t2.* from (select rownum rn,t1.* from (select rownum, routing.* from ESB_ROUTING routing <where> <if test="jkid != nul...