The everyday of a technology

-----------------------------------------------------Replicable, communicable-----------------------------------------------------
How does the window background of win10 file turn to bean green?
The specific steps are as follows:
1. Open the registry: run "regedit" to confirm;
2. Open [HKEY ﹣ current ﹣ UserControl panelcolors] and change the value of Windows to "202 234 206"
3. Log out and log in again. Open Notepad or word to see that the background color of the window changes to light green (eye protection color)

1. Cluster command

2.linux view file size

View disk space
    dp -h

3.Dockerfile

<filecommands>
        <number>1</number>
        <title>build</title>
        <description>Use-f Pointing anywhere Dockerfile File remote can also be specified</description>
        <command>docker build -f /path/to/a/Dockerfile</command>
     
        <number>2</number>
        <title>Dockerfile structure</title>
        <description>Basic image information, maintainer information, image operation instructions, and execution instructions at container startup,'#’Is the comment in the Dockerfile. </description>
        <command></command>
        
        <number>3</number>
        <title>command 6 Species type</title>
        <description>FROM,MAAINTAINER,RUN,ARG,CMD,EXPOSE,ENV</description>
        <command></command>
        
        <number></number>
        <title></title>
        <description></description>
        <command></command>
        
        <number></number>
        <title></title>
        <description></description>
        <command></command>
        
        <number></number>
        <title></title>
        <description></description>
        <command></command>
        
        <number></number>
        <title></title>
        <description></description>
        <command></command>
    
</filecommands>

4. The dockerfile parameters are introduced in detail

https://www.cnblogs.com/panwenbin-logs/p/8007348.html

5. View the directory structure of the running container - enter the container interaction containerID: image ID

<command>docker exec -it {containerID} /bin/bash</command>
//Exit container
<command>exit</command>

6. What does / bin/bash mean in the docker command

<command>docker run -i -t tomcat /bin/bash</command>
The function of < description > / bin / Bash is that the docker background must run a process, otherwise the container will exit. Here it means that bash will be started after the container is started < / description >

7. Copy the project directly to the container

<url>Reference address: https://blog.csdn.net/yuxuan_08/article/details/74278949</url>

8. Find the location of the container

#####

9. How to mount the container's files on the hard disk?
10. Create a cluster network

docker network create --driver overlay my-network
#A cluster network named my network was created

11. Install yum software

[docker]
1.ssh root@172.16.5.66
2.docker ps
3.docker exec -it jenkin image sh (Jenkins? Master. 1. Rr53q4gzwh2hlqrjmyykqv1bp): docker exec - it Jenkins? Master. 1. Rr53q4gzwh2hlqrjmyykqv1bp sh
4.cd /var/jenkins_home/workspace/
5.rm -rf ...

yum install -y yum-utils device-mapper-persistent-data lvm2 curl
yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
yum -y install docker-ce

service docker start
docker ps
docker run -p 80:80 -d nginx:latest background start docker

[jekens]

Configure password free login
ssh-keygen -t rsa

[eclipse merge]https://www.cnblogs.com/jtlgb/p/9875491.html

[oracle]
The syntax of merge sql is as follows
MERGE INTO [your table-name] [rename your table here]
USING ( [write your query here] )[rename your query-sql and using just like a table]
ON ([conditional expression here] AND [...]...)
WHEN MATHED THEN [here you can execute some update sql or something else ]
WHEN NOT MATHED THEN [execute something else here ! ]

2019-4-29
[use and difference of th:include and th:replace in Thymeleaf]
https://blog.csdn.net/weixin_41461992/article/details/82345385

2019-5-8
understand
rest

sed -n '/^2019-05-15 01:00/,/^2019-05-15 10:15/p' catalina.out > zzzz.out

tail -f /home/dpadmin/dpprod/liferay-portal-6.2-ce-ga6/tomcat-7.0.62/logs/catalina.2019-05-13.log

Create dblink
create public database link DRM_DP_LINK
connect to dpjxs identified by password
using '(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.13.14)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = tdps)
)

)';

create public database link DRM_BI_LINK
connect to odsapi identified by gac_123
using '(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.13.121)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = bidwproddg)
)

)';
--Grant authority
grant CREATE PUBLIC DATABASE LINK to drm_prod;
--Give table permissions to users
grant select on table name to user name;

DROP PUBLIC DATABASE LINK DRM_BI_LINK;
DROP PUBLIC DATABASE LINK DRM_DP_LINK;

oracle export table

-- multiple tables
exp drm_prod/gac_123@bitest tables=(drm_policy) file=D:workspacedrm.dmp

--Export all
exp drm_prod/gac_123@bitest file=D:workspacedrm.dmp

13465650389 Weifang fengshuo Automobile Trade Co., Ltd

----------web embedded player demo
https://www.cnblogs.com/500k/p/4807506.html

[js]
1.input text can only input numbers
onkeyup="this.value=this.value.replace(/1/g,'')" onafterpaste="if(this.value<1){this.value=1}else{this.value=this.value.replace(/2/g,'')}"

Time needs of daily study

boundary objects

1.code code
2. Class diagram

3.domain model domain model

4.sequence diagram (collaboration diagram)
5.robustness diagram
6.use case model - use case

domain model
1. Business actor, role
Operational entities in business processes, models

2.fileinput transfer parameters

General ajaxs requests
$.ajax({

    url:/*[[@{/mortgageaterialapply/findMaterialsByCityName}]]*/,
    type:'GET',
    cache:false,
    async:true,
    data:{cityName:_sel_val},
    dataType:'json',
    success:function(result){
        
    },
    error:function(){
        swal("Failed to load","","error");
    }

});

$.ajax({

    url:/*[[@{/mortgagematerialapply/findMaterialsByCityName}]]*/,
    type:'GET',
    cache:false,
    async:true,
    data:{cityName:_sel_val},
    dataType:'json',
    success:function(data){
        if(data){
            materialApply.newTableBody(data);
        }else{
            swal("There are no materials to apply for in the current city","","warn");
        }
    },
    error:function(){
        swal("Failed to load","","error");
    }
});



//Requirements:
  1. Bachelor degree or above in computer or related major
  2. At least 3 years java development experience, solid Java programming foundation, familiar with Spring, Spring Boot, Spring Cloud and other frameworks.
  3. Familiar with microservice architecture and REST API interface experience; familiar with HTTP, Restful API and large-scale software system design capability
  4. Have experience in front-end development, understand basic CSS, JavaScript,JQuery usage
  5. Experience in using and developing Mysql, Oracle and other large databases
  6. Good communication skills and teamwork spirit, strong initiative and sense of responsibility, self driven, continuous learning.

[bonus if you have the following skills]:

  1. Familiar with the use of Redis, wechat development, App development, etc.
  2. Familiar with container technology, including Docker, Swarm, k8s, etc.

swal({

        title:'',
        text : "Failed to submit retail information change. Please try again later!",
        type:"error",
        confirmButtonColor : '#dd6b55',
        confirmButtonText : "Determine",
        closeOnConfirm : false,
        allowEscapeKey:false,
        allowOutsideClick:false
});

<td th:text="${value.totalAmount != null} ? ${#numbers.formatDecimal(value.totalAmount,1,2)}:''" class="colorOrange"></td>

thymeleafe

api

https://www.e-learn.cn/thymeleaf



[DB]

Alter table test1 add (name VARCHAR2 (30) default 'anonymous' not null);
alter table test1 modify (name varchar2(16) default 'unknown');
alter table test1 drop column name;
oracle yyyy-MM-dd hh24:mi:ss

Reference: ReceiveMarginController

[json-object]
if(tempInfo==null){

List<ExpressInfo> infos=new ArrayList<>();
ExpressInfo info=new ExpressInfo(expressName,expressNumber);
infos.add(info);
JSONArray jsonArray = JSONArray.fromObject(infos);
expressInfo=jsonArray.toString();

}else{

JSONArray jsonArray = JSONArray.fromObject(tempInfo);
jsonArray.add(new ExpressInfo(expressName,expressNumber));
expressInfo=jsonArray.toString();

}

172.16.13.22
DRM APP(drmadmin/gac&1234) 172.16.13.27 DRM DB 172.16.13.119 PDRMS
      DRM_PROD/gac_1234
DP APP(dpadmin/gac&1234) 172.16.13.24 DP DB 172.16.13.22 tdps
      DPJXS /gac_1234

[linux command]

[mysql common sql]
1. Row column conversion

 select name,
     SUM(case course when 'language' then score else 0 end) as language,
     SUM(case course when 'Mathematics' then score else 0 end) as mathematics,
     SUM(case course when 'physics' then score else 0 end) as physics
 from scores group by name 
  1. Multi row to column oracle sql

    select max(t.last_update_date) as last_update_date, t.status_name, wm_concat(t.remark) as remark
    from DRM_MORTGAGE_MATERIAL_STATUS t
    where apply_id = 10293689
    and status_type = 1
    group by status_name
    order by last_update_date asc

[eclipse cancels automatic networking]

window → preferences → Install/Update → automatic update → cancel automatic upgrade 

[linux]

  1. View port usage
    netstat -ntulp |grep 80
    netstat -tnlp | grep :22

2.

DRM_MORTGAGE_PERMISSIONS_LIST

1727620
10187064

debug="0" privileged="true"

ssh root@172.16.5.66
docker ps
docker exec -it imagename(jenkins_master.1.f1kvahzdilojwa4bkpsblyinp) sh
cd var/jenkins_home/workspace/
rm -rf drm-*

dlrActivity/activityIndex?activityType=&activityId=

select

    
   apply.CREATION_DATE,
    apply.APPROVAL_NUMBER,
   m.material_number,
   APPROVAL_NUM,
    address.distinctname,
   address.cityname , 
   address.regionname ,
   address.delivery_address,
   address.receiver_name,
   address.phone,   
   EXPRESS_NAME as expressName,
   EXPRESS_NUMBER as expressNumber

from DRM_MORTGAGE_MATERIAL_APPLY apply,

   DRM_MORTGAGE_DELIVERY_ADDRESS address,
   DRM_MORTGAGE_MATERIAL_QUOTA   mquota,
   (select
      apply.APPLY_NUMBER,        
      LISTAGG( to_char(material.material_number), ',') WITHIN GROUP(ORDER BY material.material_number) as material_number 
      from DRM_MORTGAGE_MATERIAL_DETAIL detail,
      DRM_MORTGAGE_MATERIAL        material,
      DRM_MORTGAGE_MATERIAL_APPLY  apply
where detail.material_id = material.id
  and apply.id = detail.apply_id
  and apply.inner_status in ('501', '1')
     --and APPLY_ID applyId);
  and detail.REQUIRE_CONTENT is null
  and detail.SPECIAL_REQUIRE = '0'
  group by apply.APPLY_NUMBER
  ) m
    

where 1 = 1
and apply.ADDRESS_ID = address.id
and apply.DEALER_NAME = mquota.dealer_name
and apply.distributor = mquota.distributor
and address.id=apply.address_id
and apply.inner_status in ('501', '1')
and m.APPLY_NUMBER=apply.APPLY_NUMBER
order by apply.creation_date desc

Oracle multi line to one line
select address.cityname || address.distinctname || address.regionname || address.delivery_address addressInfo from DRM_MORTGAGE_DELIVERY_ADDRESS address

jaspersoft opens the software. When I leave, what can I take with me?

What is x-forward-for?

Real ip used to represent the requester

How to get ip

    HttpServletRequest httpServletRequest=request;
    String ip = httpServletRequest.getHeader("x-forwarded-for"); 
    if(ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) { 
    ip = httpServletRequest.getHeader("Proxy-Client-IP"); 
    } 
    if(ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) { 
    ip = httpServletRequest.getHeader("WL-Proxy-Client-IP"); 
    } 
    if(ip == null || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) { 
    ip = httpServletRequest.getRemoteAddr(); 
    }
    
<entity name="SysAccessLog" uuid="true" local-service="true" remote-service="false" table="CT_SYS_ACCESS_LOG">
         <column name="id" type="long" primary="true"/>
    <column name="loginName" type="String"/>
    <column name="loginTime" type="String"/>
    <column name="sourceIp" type="String"/>
    <column name="address" type="String"/>
    <column name="url" type="String"/>
    <column name="mobilePhone" type="String"/>
    <column name="browser" type="String"/>
    <column name="sessionId" type="String"/>
    <column name="updateDate" type="String"/>
    <column name="remark" type="Date"/>
</entity>

liferay build service

http://blog.sina.com.cn/s/blog_1667076510102woe1.html

liferay->maven -build service
liferya portlet  Resources


  1. d
  2. d

Tags: Operation & Maintenance Docker Oracle SQL network

Posted on Wed, 08 Jan 2020 00:54:48 -0800 by Serpent_Guard