一个技术的日常

-----------------------------------------------------可复制,可传播-----------------------------------------------------
win10 文件的窗口背景如何变成豆绿色?
具体步骤如下:
1、打开注册表:运行“regedit”确定;
2、依次打开[HKEY_CURRENT_USERControl PanelColors], 把Windows的值改为“202 234 206”
3、注销后重新登录,打开记事本或word可以看到窗口背景色变为淡绿色(护眼色)

1.集群的命令

2.linux 查看文件的大小

查看磁盘空间
dp -h

3.Dockerfile

<filecommands>
<number>1</number>
<title>build</title>
<description>使用-f 指向任何位置的Dockerfile 文件 远程的也可以指定</description>
<command>docker build -f /path/to/a/Dockerfile</command>
<number>2</number>
<title>Dockerfile 结构</title>
<description>基础镜像信息、维护者信息、镜像操作指令和容器启动时执行指令,’#’ 为 Dockerfile 中的注释。</description>
<command></command>
<number>3</number>
<title>command 6种类型</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.Dockerfile 参数介绍 很详细

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

5.查看正在running的 容器的目录结构-进入容器交互 containerID:镜像ID

<command>docker exec -it {containerID} /bin/bash</command>
退出容器
<command>exit</command>

6.docker命令中的/bin/bash 是什么意思

<command>docker run -i -t tomcat /bin/bash</command>
<description>/bin/bash的作用是因为docker后台必须运行一个进程,否则容器就会退出,在这里表示启动容器后启动bash</description>

7.将项目直接拷贝到 容器当中

<url>参考地址:https://blog.csdn.net/yuxuan_08/article/details/74278949</url>

8.查找容器的位置

#####

9.如何将容器的文件,挂载在硬盘上?
10.创建一个集群网络

docker network create --driver overlay my-network
#创建了一个名为my-network 的集群网络

11.安装yum 软件

【docker】
1.ssh root@172.16.5.66
2.docker ps
3.docker exec -it jenkin镜像 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 后台启动docker

【jekens】

配置免密登陆
ssh-keygen -t rsa

【eclipse merge】https://www.cnblogs.com/jtlgb/p/9875491.html

【oracle】
merge sql 语法如下
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
【Thymeleaf中th:include和th:replace的使用和区别】
https://blog.csdn.net/weixin_41461992/article/details/82345385

2019-5-8
了解
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

创建dblink
create public database link DRM_DP_LINK
connect to dpjxs identified by 密码
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 CREATE PUBLIC DATABASE LINK to drm_prod;
--赋予表的权限给用户
grant select on 表名 to 用户名;

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

oracle 导出表

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

--全部导出
exp drm_prod/gac_123@bitest file=D:workspacedrm.dmp

13465650389-潍坊丰硕汽车贸易有限公司

----------web 嵌入播放器 demo
https://www.cnblogs.com/500k/p/4807506.html

【js】
1.input text 只能输入数字
onkeyup="this.value=this.value.replace(/1/g,'')" onafterpaste="if(this.value<1){this.value=1}else{this.value=this.value.replace(/2/g,'')}"

日常学习的时间需要

boundary objects

1.code-编码
2.class-diagram -类图

3.domain model-领域模型

4.sequence diagram-顺序图(协作图)
5.robustness diagram-健壮性分析
6.use case model -用例

领域模型
1.业务的行为主体,角色
业务过程中的操作实体,模型

2.fileinput 传递参数

一般ajaxs 请求
$.ajax({

    url:/*[[@{/mortgageaterialapply/findMaterialsByCityName}]]*/,
type:'GET',
cache:false,
async:true,
data:{cityName:_sel_val},
dataType:'json',
success:function(result){
},
error:function(){
swal("加载失败","","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("当前城市无材料可申请","","warn");
}
},
error:function(){
swal("加载失败","","error");
}
});
任职要求:
  1. 计算机及相关专业毕业,本科及以上学历
  2. 有3年以上 java 开发经验,扎实的 java 编程基础, 熟悉 Spring、Spring Boot、Spring Cloud 等框架。
  3. 悉微服务架构,有 REST API 接口经验;熟悉 HTTP、Restful API、具有大规模软件系统的设计能力
  4. 具有前端开发经验,了解基本的CSS, JavaScript,JQuery 使用
  5. 有Mysql、Oracle等大型数据库使用,开发经验
  6. 良好的沟通能力和团队协作精神,较强的主动性和责任心,能够自我驱动,不断学习。

[如果你具有以下技能,是加分项]:

  1. 熟悉 Redis,微信开发,App 开发 等的使用。
  2. 熟悉容器技术,包括 Docker,Swarm,k8s 等。

swal({

        title:'',
text : "零售信息变更提交失败,请稍后再试!",
type:"error",
confirmButtonColor : '#dd6b55',
confirmButtonText : "确定",
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 ‘无名氏’ not null);
alter table test1 modify (name varchar2(16) default ‘unknown’);
alter table test1 drop column name;
oracle yyyy-MM-dd hh24:mi:ss

参考: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 命令】

【mysql 常用sql】
1.行列转换

 select 姓名,
SUM(case 课程 when  '语文' then 分数 else 0 end) as 语文,
SUM(case 课程 when  '数学' then 分数 else 0 end) as 数学,
SUM(case 课程 when  '物理' then 分数 else 0 end) as 物理
from scores group by 姓名 
  1. 多行转换成列 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

【eclipsse 取消自动联网】

window→preferences→Install/Update→automatic update→取消自动升级

【linux】

  1. 查看端口使用情况
    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

oralce 多行转一行
select address.cityname || address.distinctname || address.regionname || address.delivery_address addressInfo from DRM_MORTGAGE_DELIVERY_ADDRESS address

jaspersoft 打开软件,当我离开的时候,我可以带走什么?

X-Forwarded-For 是什么?

用来代表请求端的真实ip

如何获取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 构建service

http://blog.sina.com.cn/s/blog_1667076510102woe1.html
liferay->maven -build service
liferya portlet  Resources

  1. d ↩
  2. d ↩