IT_小小程序员-优快云博客

原创死锁查询以及删除

–查询死锁select * from vlockedobjecta,dbaobjectsaa,vlocked_object a ,dba_objects aa,vlockedobjecta,dbaobjectsaa,vsession b where a.session_id = b.sid and a.OBJECT_ID=aa.OBJECT_ID order by b.logon_time;–杀掉死锁alter system kill session ‘47,60033’;–SID,SERIAL#

2021-05-31 16:31:18 217

原创 Oracle生成uuid

select sys_guid() from dual connect by rownum<128

2021-05-31 16:30:12 526

原创表结构复制

– 表结构复制create table test_a as SELECT * FROM test

2021-05-31 16:29:33 151

原创两表关联修改信息

update test_aset test_a.aaaa =(SELECT b.bbbbbb FROM test_b where ttest_a.id=test_b.aId)

2021-05-31 16:28:49 910

原创 2021-05-31

oracle操作– 删除信息找回select * from (select * from test as of timestamp to_date(‘2021-03-03 10:00:00’,‘yyyy-MM-dd HH24:mi:ss’ ) )where return_infor=‘条件’;

2021-05-31 16:26:54 117

原创按照时间每天统计

SELECT@s := @s + 1 AS index,DATE( DATE_SUB( DATE_FORMAT(‘2019-11-10’,’%Y-%m-%d’), INTERVAL @s DAY ) ) AS dateFROMmysql.help_topic,( SELECT @s := - 1 ) tempWHERE@s < 10ORDER BYdate DESC函数天DAY 周WEEK 月MONTH

2020-07-29 11:59:08 222

原创时间差

天之间的时间差SELECT TIMESTAMPDIFF(DAY,‘2019-12-29’,‘2020-01-08’)周之间的时间差SELECT TIMESTAMPDIFF(WEEK,‘2019-12-29’,‘2020-01-08’)月之间的时间差SELECT TIMESTAMPDIFF(MONTH,#{startTime}, DATE_FORMAT(#{endTime}, ‘%Y-%m-%d’))...

2020-07-29 11:58:05 235

原创图片水印

package 水印;import java.awt.Color;import java.awt.Font;import java.awt.Graphics2D;import java.awt.Image;import java.awt.image.BufferedImage;import java.io.File;import java.io.FileInputStream;import java.io.InputStream;import javax.imageio.ImageIO;

2020-07-28 10:14:53 118

原创 png生成

package 水印;import javax.imageio.ImageIO;import java.awt.*;import java.awt.font.FontRenderContext;import java.awt.geom.AffineTransform;import java.awt.geom.Rectangle2D;import java.awt.image.BufferedImage;import java.io.File;import java.nio.file.Path

2020-07-28 09:57:33 557

原创 ptf水印

public class ptf水印 {public static void main(String[] args) { try { watermark(new File("C:\\Users\\86151\\Desktop\\chang.pdf")); } catch (Exception e) { e.printStackTrace(); }}private static void watermark(File file) throws E

2020-07-28 09:56:47 264

原创 Excel水印

package 水印;import java.awt.;import java.awt.font.FontRenderContext;import java.awt.geom.Rectangle2D;import java.awt.image.BufferedImage;import java.io.;import java.util.Date;import java.util.UUID;import javax.imageio.ImageIO;import org.apache.poi.

2020-07-28 09:55:35 192

原创 Word水印

public static void main(String[] args){//加载Word文档Document doc = new Document();doc.loadFromFile(“C:\Users\86151\Desktop\1111.docx”);//创建TextWatermark实例TextWatermark textWatermark = new TextWatermark();//设置水印文本内容textWatermark.setText(“审核完成”);//自定义文本

2020-07-28 09:52:57 368

原创 LayUI不刷新页面改变输入框中的值

1、首先获取table表格中的数据var temp=layui.table.cashe.tableInfo //具体的tableInfo需要根据各自定义的值2、通过for循环进行便利for (let i = 0; i <temp.length ; i++) {//根据满足某个条件的信息进行修改if(temp[i].id==id){ //id是获取的当前行的idvar tr= $ (‘tr[table-index=’ + temp[i].LAY_TABLE_INDEX+’]’).fi

2020-07-23 16:01:31 1135

原创 el-table selection复选框只选择一个

首先在 el-table 标签上添加,ref=“tableInfo” @select=“selectRow” @select-all=“selectAll”再在 methods 中添加以下方法select(selection, row) {// 选择项大于1时if (selection.length > 1) {let del_row = selection.shift();this.$refs.tableInfo.toggleRowSelection(del_row, false);

2020-07-22 16:46:34 2098 1

原创 dialog 弹窗关闭事件

<el-dialog title=“房间” :visible.sync=“dialog” @close=‘close’>//关闭弹框的事件close(){　　console.log(‘close’)}

2020-07-22 16:40:54 2380

原创 Linux_开放端口

cd /root/.ssh上传id_rsa.pub 到 /root/.ssh授权密钥：chmod 600 /root/.ssh/authorized_keyscat /root/.ssh/id_rsa.pub >> /root/.ssh/authorized_keys安装启动防火墙：yum -y install firewalldsystemctl start firew...

2020-03-20 14:06:39 430

原创 Linux_JDK

1）安装JDK下载并解压源码包“jdk-8u191-linux-x64.tar.gz”下载地址：https://download.oracle.com/otn-pub/java/jdk/8u191-b12/2787e4a523244c269598db4e85c51e0c/jdk-8u191-linux-x64.tar.gz?AuthParam=1547103716_bb96beef03bfd...

2020-03-20 14:06:05 134

原创 Linux_redis

一、在线安装yum install -y epel-releaseyum install -y redis二、离线安装（CentOs7.5操作系统）1）获取Redis的安装包及对应的依赖包放于/opt/目录下2）开启防火墙firewall-cmd --add-port=6379/tcp --permanentfirewall-cmd --reload3）安装依赖包cd /opt...

2020-03-20 14:04:52 134

原创 Linux_nginx

一、在线安装rpm -Uvh http://nginx.org/packages/centos/7/noarch/RPMS/nginx-release-centos-7-0.el7.ngx.noarch.rpmyum install -y nginxsystemctl start nginx.servicesystemctl enable nginx.service二、nginx的相关文...

2020-03-20 14:02:36 114

原创 Linux_MySQL

Linux一、在线安装（yum安装）yum -y install wgetwget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpmyum -y install mysql57-community-release-el7-10.noarch.rpmyum -y install mysql-...

2020-03-20 14:00:38 220

weixin_43927116的博客