ps -aux |grep java
ps -ef |grep java
netstat -anp |grep 端口号
lsof -i :端口号
kill -9 进程号

tail -100f console.log

grep 关键字 文件名
cat 文件名 | grep 关键字

grep -r 关键字 目录

#! /bin/bash
CURRENT_PATH=$(cd $(dirname $0); pwd)
JAR=$(find $CURRENT_PATH -maxdepth 1 -name "*.jar")
PID=$(ps -ef | grep $JAR| grep -v grep | awk '{ print $2 }')

JAVA_OPTIONS="-Dfile.encoding=UTF-8  -Xmx2048m -Xms2048m -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=xxxx"
STARTFLAG="Application {0} is running! Access URLs"
function read_log
{
    echo "$JAR service boot console.log read"
    tail -100f console.log|while read line
    do
    result=`echo "$line"|grep "$STARTFLAG" |wc -l`
    if [ $result -eq 1 ]; then
        echo "$JAR service boot success"
        break

    fi
    done
    echo "$JAR service boot 退出日志打印"
    exit 0

}
case "$1" in
    start)
        if [ ! -z "$PID" ]; then
            echo " $JAR is already online ,PID : $PID"
        else
            echo -n -e "booting $JAR ... \n"
            rm -f $CURRENT_PATH/console.log
            nohup java -jar $JAVA_OPTIONS $JAR > console.log 2>& 1 &
            if [ "$?" = "0" ]; then
                echo "$JAR service boot success,please check console.log"
                read_log
            else
                echo "$JAR service boot failure,view console.log for more information"
            fi
        fi
        ;;
    stop)
        if [ -z "$PID" ]; then
            echo "$JAR is not running ... shutdown failure"
        else
            echo "$JAR shutting down"
            kill -9 $PID
            if [ "$?"="0" ];then
                echo "Service shutdown success"
            else    
                echo "Service shutdown failure"
            fi
        fi
        ;;
    restart)
        sh ${0} stop
        sh ${0} start
        ;;
    status)
        if [! -z "$PID"]; then
            echo "$JAR ONLINE"
        else
            echo "$JAR OFFLINE"
        fi
        ;;
    *)
        sh ${0} stop
        sh ${0} start
esac

-------查询字段长度-----------
select length() from 
--------------查询数量-------
select count(1) from 
----------substr------------
select concat(substr(``,1,3),substr(``,4,6)) from 
----------分组查询---------
select distinct(``),sum(``) over(partition by ``) from 
----------查询字段重复的数据---------
select columnname from tablename group by columnname having count(columnname)>1
----------max,min---------
select max(),min() from 
----------分组查询first_value----------
select distinct(),first_value() over(partition by `` order by `` desc) from 
----------根据分组查询排序-------------
select rank() over(partition by `` order by `` desc) as rank from  --值相同排名相同，后续跳跃
select dense_rank() over(partition by `` order by `` desc) as rank from --值相同排名相同，后续连续
select row_number() over(partition by `` order by `` desc) as rank from --单纯排序
------------查询随机数---------
select trunc(dbms_random.value(0,365)) as rn from dual
------------查询随机数据---------
select * from (select * from table_name order by dbms_random.value) where rownum<=(select ceil(count(1)*0.05) as num from table_name);
------------查询当前日期加减------------
select sysdate from dual;
select sysdate+numtodsinterval(1,'day') as res from dual;
select sysdate+numtodsinterval(-1,'day') as res from dual;
select sysdate-numtodsinterval(1,'day') as res from dual;
select sysdate+numtodsinterval(24*3600,'second') as res from dual;
select sysdate+numtoyminterval(1,'month') as res from dual;
select sysdate+numtoyminterval(1,'year') as res from dual;
--------------查询当前日期的月份最后一天-----------
select last_day(sysdate+31) from dual;
--------------查询当前日期的月份第一天-----------
select trunc(sysdate,'MM') from dual;
--------------查询某个字段长度最长的值-------------
select ``,length(``) from  where length(``)=(select max(length(``)) from )
--------------查询被锁的会话id-----------------
select session_id from v$locked_object;
-------------查询会话id详细信息---------------
select sid,serial#,username,osuser from v$session where sid=6;
select sid||','||serial as ss from (select distinct a.sid,a.serial# as serial from v$session a,(select session_id from v$locked_object)b where sid=b.session_id)c;

--------------删除数据------------
delete from tablename where 条件
------------清空表数据-----------
truncate table tablename
------------删除分区------------
alter table   tablename   drop partition ;
------------彻底删除表----------
drop table  tablename  purge;
------------将锁定的会话关闭,格式为'sid,serial'----------
alter system kill session ',';

-------------更新字段值-------------
update table_name set a='',b='' where
update table_name set (a,b)=(select '','' from dual) where

alter table  tablename add  columnname vachar(20) default TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') NOT NULL ;----增加字段
alter table  tablename  modify --修改字段
alter table  tablename  drop columnname ---删除字段

---------------插入数据------------
insert into tablename   (,,,) values (,,,),(,,,);
-------------插入表数据--------------
insert into tablename select * from  tablename;

create global temporary table tmp_user (
  user_id   varchar2(10),
  user_name varchar2(20)
) on commit delete rows; --------------commit后清空。

create global temporary table tmp_user1 (
  user_id   varchar2(10),
  user_name varchar2(20)
)on commit preserve rows;------------commit后数据还在，但是数据只在这个会话，新建一个会话是没有的。

partition by range (INPUT_DATE) INTERVAL (NUMTODSINTERVAL(1,'day'))
(partition part_t01 values less than(to_date('2018-12-12','yyyy-mm-dd')));

select * from user_tab_partitions where table_name='';--------查询表分区------------
alter table tablename  drop partition;---------删除分区------------
select * from user_ind_partitions;---------查询分区索引---------

select PARTITION_NAME,HIGH_VALUE from user_tab_partitions where table_name='FIVE_DETAIL_INFO';

/**
*删除指定日期n天前的分区
**/
public void deletePartitionByDate(String date) throws ParseException {
    /**
    *获取表的所有分区名称和值
    **/
    List<FiveDetailInfo> list = fiveDetailInfoMapper.selectPartitionName(date);
    
    /**
    *把字符串date转换成日期类型减n天并加1天，再转回字符串类型
    **/
    Date newDate = new SimpleDateFormat("yyyy-MM-dd").parse(date);
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(newDate);
    int n = fiveDetailInfoMapper.findDictionaryN();
    calendar.add(Calendar.DAY_OF_MONTH, -n+1);//因为分区的值要多1天
    String newDateStr = new SimpleDateFormat("yyyy-MM-dd").format(calendar.getTime());
    /**
    *根据分区值和日期找到分区名称并删除
    **/
    logger.info("----------开始查找FIVE_DETAIL_INFO表"+n+"天前的分区"---------------");
    if (list.size() >0){
        Iterator<FiveDetailInfo> it = list.iterator();
        FiveDetailInfo fiveDetailInfo = it.next();
        while (it.hasNext()){
            FiveDetailInfo next =it.next();
            String str = next.getHighValue().substring(10,20);//截取yyyy-MM-dd部分
            if (str.compareTo(newDateStr)<=0&&str.compareTo("2018-12-12")>0) {
                fiveDetailInfoMapper.deleteByPartitionName(next.getPartitionName());
                Date tempDate=new SimpleDateFormat("yyyy-MM-dd").parse(str);
                Calendar tempDate= Calendar.getInstance();
                tempCalendar.setTime(tempDate);
                tempCalendar.add(Calendar.DAY_OF_MONTH,-1);//因为分区值是T+1的，所以减一天才是真正的日期
                String tempDateStr = new SimpleDateFormat("yyyy-MM-dd").format(tempCalendar.getTime());
                logger.info("删除日期为"+tempDateStr+"的分区成功");
            }
        }
    }

}

select loan_ac_no,cust_id,cust_name,loanacno_real 
from biz_loan_info_detail 
where loanacno_real in (select loanacno_real 
                        from (select loanacno_real 
                              from biz_loan_info_detail 
                              group by (loanacno_real,cust_id)) 
                        group by (loanacno_real) 
                        having count(loanacno_real) >1);

select party_id,party_name,cert_no 
from cus_basic_info 
where cert_no in (select cert_no 
                  from (select party_id,cert_no 
                        from cus_basic_info 
                        group by (party_id,cert_no)) 
                  group by (cert_no) 
                  having count(cert_no)>1);