<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[bobo_bc的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/bobo_bc</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; bobo_bc]]></copyright><item><title><![CDATA[对List进行分页]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/123505725</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/123505725</guid><author>bobo_bc</author><pubDate>Tue, 15 Mar 2022 16:27:35 +0800</pubDate><description><![CDATA[private &lt;T&gt; Page&lt;T&gt; listToPage(List&lt;T&gt; dataList, Integer pageSize, Integer pageNumber){
    Page&lt;T&gt; result = new Page&lt;T&gt;();
    List&lt;T&gt; monitors = new ArrsyList&lt;T&gt;();
    if(dataList!=null &amp;&amp; dataList.size.]]></description><category></category></item><item><title><![CDATA[oracle 字符串逗号间隔，查询为多行]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/122318515</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/122318515</guid><author>bobo_bc</author><pubDate>Wed, 05 Jan 2022 10:50:21 +0800</pubDate><description><![CDATA[如下对字符串'10003,1004,1005'进行切割查询

select regexp_substr('10003,1004,1005','[^,]+',1,level) from dual

connect by regexp_substr('10003,1004,1005','[^,]+',1,level) is not null
]]></description><category></category></item><item><title><![CDATA[Centos7安装Docker+elasticsearch（离线安装）]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/121885560</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/121885560</guid><author>bobo_bc</author><pubDate>Sun, 12 Dec 2021 17:38:35 +0800</pubDate><description><![CDATA[docker下载地址：https://download.docker.com/linux/static/stable/x86_64/

下载命令：

查看centos7内核版本：uname -r

离线安装包：wgethttps://download.docker.com/linux/static/stable/x86_64/docker-18.09.9.tgz

解压安装包：tar -zxvfdocker-18.09.9.tgz

复制到/usr/bin目录：cp docker/* /usr/bi...]]></description><category></category></item><item><title><![CDATA[webpack、react、es6、antd配置]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/108166055</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/108166055</guid><author>bobo_bc</author><pubDate>Sat, 22 Aug 2020 13:21:57 +0800</pubDate><description><![CDATA[目录

1. 查看源，切换源

2. package.json配置

1. 查看源，切换源


npm config get registry  // 查看npm当前镜像源
npm config set registry https://registry.npm.taobao.org/  // 设置npm镜像源为淘宝镜像

yarn config get registry  // 查看yarn当前镜像源
yarn config set registry https://registry.npm.taobao]]></description><category></category></item><item><title><![CDATA[spring boot编程（打war包，分页）]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/108153183</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/108153183</guid><author>bobo_bc</author><pubDate>Fri, 21 Aug 2020 18:21:21 +0800</pubDate><description><![CDATA[修改POM文件的打包方式，以及修改部分dependency的配置，消除内置Tomcat



        &lt;dependency&gt;
            &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
            &lt;artifactId&gt;spring-boot-starter-web&lt;/artifactId&gt;
            &lt;exclusions&gt;
          ]]></description><category></category></item><item><title><![CDATA[Npm和Yarn常用命令总结]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/87723783</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/87723783</guid><author>bobo_bc</author><pubDate>Mon, 20 Jul 2020 15:24:29 +0800</pubDate><description><![CDATA[package.json


{
  "name": "webpack_react",
  "version": "1.0.0",
  "description": "STABLE VERSION",
  "main": "main.js",
  "scripts": {
    "prod": "webpack-dev-server --config ./build/webpack.prod.c...]]></description><category></category></item><item><title><![CDATA[谷歌浏览器使用devtools，页面刷新或跳转，前面的请求消失]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/107114533</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/107114533</guid><author>bobo_bc</author><pubDate>Fri, 03 Jul 2020 20:23:23 +0800</pubDate><description><![CDATA[这样设置所有请求就不会消失


]]></description><category></category></item><item><title><![CDATA[Redis 使用redisson实现分布式锁（集群模式）]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/106791604</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/106791604</guid><author>bobo_bc</author><pubDate>Tue, 16 Jun 2020 17:35:33 +0800</pubDate><description><![CDATA[引入jar包

spring.redis.cluster.nodes格式为IP:PORT,IP:PORT,IP:PORT,IP:PORT


    @Value("${spring.redis.cluster.nodes}")
    private String redisCluster;

    @Bean
    public RedissonClient redisson(){
        Config config = new Config();
        ClusterServer]]></description><category></category></item><item><title><![CDATA[LocalDateTime LocalDate的使用方法总结]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/106725681</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/106725681</guid><author>bobo_bc</author><pubDate>Fri, 12 Jun 2020 23:39:19 +0800</pubDate><description><![CDATA[获取一天开始的时间点（0点0时0分0秒）
	

//获取字符串
String indicatorTradeDt = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy/MM/dd 00:00:00"));
//获取LocalDateTime对象
LocalDateTime todayStart = LocalDateTime.of(LocalDate.now(), LocalTime.MIN);

比较时间的大小（在一天的指定时间内...]]></description><category></category></item><item><title><![CDATA[使用plsql迁移Oracle数据]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/106466833</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/106466833</guid><author>bobo_bc</author><pubDate>Mon, 01 Jun 2020 11:51:26 +0800</pubDate><description><![CDATA[使用plsql生成pde文件，再使用plsql将pde文件导入其他的数据库中

为什么导出pde文件，而不是SQL脚本、或dmp二进制文件
答：SQL脚本在有大量数据的情况下，执行时间过长（非常长），生成dmp二进制文件需要一个执行文件，而安装plsql和instantclient后也是没有执行文件，其操作过程过于麻烦，但是具体选择因情况而定，比如数据量不大，有需要修改SQL的情况下可以选择导出SQL脚本；dmp网上查询是需要Oracle安装在本地，可以选择（这种情况比较少见）；

无论SQL脚本、pde.]]></description><category></category></item><item><title><![CDATA[with as更高效的使用场景]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/106134247</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/106134247</guid><author>bobo_bc</author><pubDate>Fri, 15 May 2020 09:02:23 +0800</pubDate><description><![CDATA[定义一个SQL查询结果，可以被整个SQL使用，查询结果使用两次及以上会把查询结果放到TEMP表中，
使用了临时表，就会增加额外的I/O开销，因此，表变量的方式并不太适合数据量大且频繁查询的情况
适合数据量大且不是频繁查询的情况
适用场景
1. 子查询过多时，且同一个子查询需要被多次使用的时候
2. UNION ALL使用场景，每隔被UNION ALL的查询，有部分查询条件重复时，可以用with as查询中间表，避免重复查询
缺点
3. with as的查询结果集相对于中间表不支持索引，而且with as查询]]></description><category></category></item><item><title><![CDATA[MySQL Oracle判断字段是否存在不存在添加字段]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/105955832</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/105955832</guid><author>bobo_bc</author><pubDate>Wed, 06 May 2020 17:50:38 +0800</pubDate><description><![CDATA[MySQL


DROP PROCEDURE
IF EXISTS pro_AddColumn;
DELIMITER $$


CREATE PROCEDURE pro_AddColumn ()
BEGIN

IF NOT EXISTS (
	SELECT
		1
	FROM
		information_schema.`COLUMNS`
	WHERE
		table_name = 'sc_user'...]]></description><category></category></item><item><title><![CDATA[BigDecimal判断大小、计算（加减乘除）]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/105797770</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/105797770</guid><author>bobo_bc</author><pubDate>Mon, 27 Apr 2020 19:27:23 +0800</pubDate><description><![CDATA[总结：比较equals和compareTo， 排除位数的话compareTo更保险，BigDecimal比较大小时，位数会影响比较结果
	

    public static void main(String[] args) {
        HashMap&lt;String, Object&gt; map = new HashMap&lt;&gt;();
        map.put...]]></description><category></category></item><item><title><![CDATA[OracleSQL操作总结]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/105635562</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/105635562</guid><author>bobo_bc</author><pubDate>Mon, 20 Apr 2020 15:08:41 +0800</pubDate><description><![CDATA[需要注意的是，如下操作，是在表中的每条数据有唯一标识的情况下执行的，其他情况不建议；

第一步：创建备份表market_index_bak，并将原表数据复制到备份表
create table market_index_bak as select * from market_index;

第二步：将原表需要修改字段类型的值更新为null
update market_index MIset MI...]]></description><category></category></item><item><title><![CDATA[ZeroMQ订阅发布 在Java中的简单使用示例]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/105493017</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/105493017</guid><author>bobo_bc</author><pubDate>Mon, 13 Apr 2020 18:00:03 +0800</pubDate><description><![CDATA[引入jar包

        &lt;!-- https://mvnrepository.com/artifact/org.zeromq/jeromq --&gt;
        &lt;dependency&gt;
            &lt;groupId&gt;org.zeromq&lt;/groupId&gt;
            &lt;artifactId&gt;jero...]]></description><category></category></item><item><title><![CDATA[Controller下载本地文件]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/105359697</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/105359697</guid><author>bobo_bc</author><pubDate>Tue, 07 Apr 2020 11:04:43 +0800</pubDate><description><![CDATA[/**
 * 导出excel文件
 * 
 * @author K0570071
 * @version
 * @date 2019/11/25
 */
public class ExcelUtils {
	private static final Logger logger = LoggerFactory.getLogger(ExcelUtil.class);
	private static ...]]></description><category></category></item><item><title><![CDATA[Linux安装新的字体]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/104019204</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/104019204</guid><author>bobo_bc</author><pubDate>Fri, 17 Jan 2020 15:17:43 +0800</pubDate><description><![CDATA[需求：Java程序跑在Linux机器上，有功能生成图片（含文字），但Linux没有指定的字体

进入到Linux系统字体目录
cd/usr/share/fonts/

切换root用户，创建文件夹，并将新文件夹赋权给指定用户(也可以一直root用户操作)
mkdir new

chown -R appadmin:appadmin new/

将Windows机器(C:\Windows\Fonts...]]></description><category></category></item><item><title><![CDATA[CMD 或 PowerShell 普通用户切换为管理员]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/103848790</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/103848790</guid><author>bobo_bc</author><pubDate>Sun, 05 Jan 2020 22:59:09 +0800</pubDate><description><![CDATA[情景：你试图执行的操作需要提升权限，那么你可以使用“RunasAdministrator”选项启动Powershell，并更改执行策略，成功后，你就可以执行你的操作了

执行：get-ExecutionPolicy，显示Restricted，表示状态是禁止的，如果是RemoteSigned，那么就不用往下执行了
	以管理员启动：Start-Process powershell -Verb runA...]]></description><category></category></item><item><title><![CDATA[软件开发工具安装]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/103794258</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/103794258</guid><author>bobo_bc</author><pubDate>Thu, 02 Jan 2020 16:17:42 +0800</pubDate><description><![CDATA[Git安装


git config --global  user.name "这里换上你的用户名"
git config --global user.email "这里换上你的邮箱"
ssh-keygen -t rsa -C "这里换上你的邮箱"
找到C:\Users\当前用户名\.ssh\id_rsa.pub文件，将内容新增到gitlab的SSH key管理中，即可clone、push、pul...]]></description><category></category></item><item><title><![CDATA[Java POI操作]]></title><link>https://blog.youkuaiyun.com/bobo_bc/article/details/103671894</link><guid>https://blog.youkuaiyun.com/bobo_bc/article/details/103671894</guid><author>bobo_bc</author><pubDate>Mon, 23 Dec 2019 19:29:08 +0800</pubDate><description><![CDATA[单元格显示格式化（数值加百分号）
	设置字体
	添加批注


import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder;
import org.slf4j.Logger;
i...]]></description><category></category></item></channel></rss>