Using POI to import and export Excel with large amount of data

Yesterday, the product put forward an urgent demand to export the commodity data shipped in November, write SQL and send it to DBA for execution, and then get more than 30 Excel files of 100W data. There is a property that exists in a field in the table in JSON format. You need to process the excel f ...

Posted by Prismatic on Sat, 11 Jan 2020 03:14:49 -0800

23 design modes: factory method mode

According to the different levels of abstraction, factory pattern can be divided into three types: simple factory pattern (also known as static factory pattern), factory method pattern described in this paper, and abstract factory pattern. Advantages of factory mode: It can make the code structure cle ...

Posted by mojodojo on Fri, 10 Jan 2020 21:31:45 -0800

Talk about carrera's rocket MQ procedure offset fetcher

order This paper mainly studies carrera's rocket MQ procedure offset fetcher RocketMQProduceOffsetFetcher DDMQ/carrera-monitor/src/main/java/com/xiaojukeji/carrera/monitor/lag/offset/RocketMQProduceOffsetFetcher.java public class RocketMQProduceOffsetFetcher { private static final Logger LOGGER = LoggerFactory.getLogger(RocketMQProduceOffse ...

Posted by pit on Thu, 09 Jan 2020 11:38:51 -0800

Group control of several common window functions in Hive

brief introduction Of course, there is nothing to say about regular window functions. It's very simple. Here's an introduction to grouping, focusing on the usage of rows between after grouping and sorting. The key is to understand the meaning of keywords in rows between: Keyword Meaning preceding Forward following In the future current ...

Posted by skyxmen on Thu, 09 Jan 2020 07:26:16 -0800

Implementation of MyBatis Association query: many to many

Two entities: order and commodity. An order can contain multiple commodities, and a commodity can belong to multiple orders, that is, many to many.   Goods table     Order form TB: no is the order number, and the user "id is associated with the id of the user table.     You need to create a new intermediate table, order item TB, and intr ...

Posted by skatermike21988 on Wed, 08 Jan 2020 10:23:53 -0800

Spring boot package separate jar deployment

First of all, a question is raised. Why do we separate the jar package? The reason is very simple. The jar files that we use the spring boot maven plugin plug-in to package are usually large, or tens of meters less. If the external network transmission of the upload cloud server is slow, why the files will be large after packaging? This is bec ...

Posted by rocram16 on Mon, 06 Jan 2020 04:05:12 -0800

nginx jump with parameters

//Original link: https://www.baidu.com/benefit_detail?slug=bankofchina-20170320 //Target link: https://www.test.cn/boc location ~ /benefit_detail { if ($args ~* "slug=bankofchina-20170320") { rewrite ^/benefit_detail /boc? permanent; } try_files $uri $uri/ /index.php?$query_string; } Common jump ca ...

Posted by dingus on Sun, 05 Jan 2020 18:42:22 -0800

Easy to use Popupwindow by Kotlin

Summary XPopupWindow, which further encapsulates and strengthens the PopupWindow of the system for easy use. With Kotlin language, many additional functions are provided, such as setting the position of the pop-up window, adjusting the animation of the pop-up window and so on. Project address XPopupWindow preview C ...

Posted by Seraph on Sun, 05 Jan 2020 00:00:10 -0800

redis key expiration event to realize expiration reminder

redis is turned off by default. It is not recommended to turn it on. This paper provides a reference. Key space notification is usually not enabled because of the additional cost of this process. 1. Enable redis configuration # # notify-keyspace-events Ex # # By default all notifications are disabled because most users don't need # th ...

Posted by ravi.kinjarapu on Sat, 04 Jan 2020 20:27:19 -0800

The use of Java micro benchmark framework JMH

After checking the usage of JMH, many blogs have to be very complicated. This step is quite simple for me Using Intellij IDEA2018.2 as the integrated development environment, JMH version is 1.21 Note that when building a project, you must create a maven project and directly import the two jar s, jmh core and jmh generator ann ...

Posted by Wolphie on Sat, 04 Jan 2020 09:27:05 -0800