xiongkunwei-CSDN博客

原创 linux下运行oracle脚本的例子

#Enviroment define.. /home/oracle/.bash_profile#following is parameter define .#following is excution partsqlplus xfin_arch/xxxxx<<eofset timing on;set serveroutput on;alter session set s...

2020-03-14 17:23:11 638

–查索引select i.TABLE_NAME, i.index_name,i.uniqueness, ic.COLUMN_NAME,ic.COLUMN_POSITIONfrom dba_indexes i,dba_ind_columns icwhere i.TABLE_NAME=ic.table_name and i.TABLE_OWNER = ic.table_owner and i.o...

2020-03-14 17:22:13 518

原创查看数据表的分区信息

–查看表的分区信息SELECT * FROM ALL_PART_TABLES WHERE TABLE_NAME = ‘FIN_SO_BATCH_RECORD’查看表是按照那个列来分区的SELECT * FROM ALL_PART_KEY_COLUMNS WHERE NAME = ‘FIN_SO_BATCH_RECORD’查看表的所有分区SELECT TABLE_NAME,PARTITI...

2020-03-14 17:21:09 4785

原创 oracle创建分区表

–按天分区create table tablename(…)partition by range (column_name) INTERVAL(NUMTODSINTERVAL(1,‘DAY’))(partition P_AFFLIATE_OI_20130132 values less than (TO_DATE(’ 2013-01-01 00:00:00’, ‘SYYYY-MM-DD ...

2020-03-14 17:19:53 175

原创 java发送邮件

1、引入java.mail 包和 javax.activation包compile(‘javax.activation:activation:1.1.1’)compile(‘javax.mail:mail:1.5.0-b01’)2、直接上代码了import com.sun.mail.util.MailSSLSocketFactory;import org.apache.commons....

2020-03-14 17:09:18 230

原创 windows安装docker

1、从阿里云的镜像仓库获取最新的安装包http://mirrors.aliyun.com/docker-toolbox/windows/docker-toolbox/2、安装3、创建虚拟机3.1 首先需要修改一下 docker machine的安装地址1）创建 .bash_profile 配置文件notepad .bash_profile2）在.bash_profile 文件中写...

2020-03-14 17:04:10 189

原创螺旋矩阵

public class CircleArrayTest {public static int[][] circleArray(int[][] array,int x,int y,int start,int n){ //递归截止条件 if(n <= 0){ return array; } //最后一个 if(n == 1){ ...

2020-03-12 15:47:51 128

原创 pdf加水印

依赖包compile(‘com.itextpdf:itextpdf:5.5.3’)import java.awt.FontMetrics;import java.io.*;import javax.swing.JLabel;import com.itextpdf.text.BaseColor;import com.itextpdf.text.Element;import com.it...

2020-03-12 15:33:54 204

原创基于base64的加密解密

import sun.misc.BASE64Decoder;import sun.misc.BASE64Encoder;import javax.crypto.Cipher;import javax.crypto.SecretKey;import javax.crypto.spec.SecretKeySpec;import java.io.ByteArrayOutputStream;p...

2020-03-12 15:29:34 195

原创多线程并发执行并获取结果

//任务接口public interface ParallelTask {String getTaskKey();T execute();}// 任务执行结果import lombok.AllArgsConstructor;import lombok.Data;@Data@AllArgsConstructorpublic class ParallelTaskResult {p...

2020-03-12 15:26:12 707

原创图片缩放加水印

import java.awt.AlphaComposite;import java.awt.Color;import java.awt.Font;import java.awt.Graphics;import java.awt.Graphics2D;import java.awt.Image;import java.awt.RenderingHints;import java.aw...

2020-03-12 15:22:03 144

原创 freemarker模板生成html ，HTML生成pdf文档

需要引入的jar包compile(‘org.xhtmlrenderer:flying-saucer-pdf:9.1.11’)compile(‘org.freemarker:freemarker:2.3.22’)直接上代码import com.lowagie.text.DocumentException;import com.lowagie.text.pdf.BaseFont;impor...

2020-03-12 15:17:25 980

原创 git常用操作

==>git 配置git config --global user.name “Firstname Lastname”git config --global user.email “your_email@youremail.com”==>从服务器拉取代码git clone [-b branchName] https://XXXX.gitgit clone [-b branc...

2020-03-12 15:11:47 94

原创 docker安装mysql

docker pull mysql:5.6mkdir -p ~/sorftware/mysql/data ~/sorftware/mysql/logs ~/sorftware/mysql/confdocker run -p 3307:3306 --name mysql-db -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/da...

2020-03-12 15:01:33 60

原创 docker常用操作

1、查看镜像信息列表docker images2、拉取镜像docker pull [image]:[version]例：docker pull redis:5.0.73、运行容器docker run -p 6380:6379 -tdi [–privileged] [imageID] [imageName:tag] [command]-p: 指定宿主机端口和docker映射端口...

2020-03-12 14:59:18 90

xiongkunwei的博客