<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ElvisDream的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ElvisDream</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ElvisDream]]></copyright><item><title><![CDATA[mac上使用dbeaver设置字体大小]]></title><link>https://blog.youkuaiyun.com/ElvisDream/article/details/130077056</link><guid>https://blog.youkuaiyun.com/ElvisDream/article/details/130077056</guid><author>ElvisDream</author><pubDate>Tue, 11 Apr 2023 10:18:14 +0800</pubDate><description><![CDATA[mac上设置dbeaverSQL编辑器的字体大小，及结果集字体大小的有效方式]]></description><category></category></item><item><title><![CDATA[【Java根据自定义规则排序】]]></title><link>https://blog.youkuaiyun.com/ElvisDream/article/details/129027787</link><guid>https://blog.youkuaiyun.com/ElvisDream/article/details/129027787</guid><author>ElvisDream</author><pubDate>Tue, 14 Feb 2023 15:36:56 +0800</pubDate><description><![CDATA[自定义对象集合排序]]></description><category></category></item><item><title><![CDATA[PAT (Basic Level) Practice 1003]]></title><link>https://blog.youkuaiyun.com/ElvisDream/article/details/124886915</link><guid>https://blog.youkuaiyun.com/ElvisDream/article/details/124886915</guid><author>ElvisDream</author><pubDate>Fri, 20 May 2022 17:05:06 +0800</pubDate><description><![CDATA[import java.util.Scanner;

public class Main {
    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        int n = sc.nextInt();
        String[] text = new String[n];
        for (int i = 0; i &lt; n; i++) {
         ]]></description><category></category></item><item><title><![CDATA[IDEA在XML中直接写SQL、与数据表关联上需要打开的插件]]></title><link>https://blog.youkuaiyun.com/ElvisDream/article/details/121399417</link><guid>https://blog.youkuaiyun.com/ElvisDream/article/details/121399417</guid><author>ElvisDream</author><pubDate>Thu, 18 Nov 2021 14:12:55 +0800</pubDate><description><![CDATA[项目场景：
写代码一直用的IDEA，有段时间整理了idea的一些插件，把平时可能没咋用到的插件关掉了，结果导致xml的数据库表和字段的一些提示消失，当时找了一些博客看怎么重新开启，但都只是写了关于如何配置的文章。

解决方案：
启用JAVA SQL Libraries插件，然后发现xml的提示又恢复了。说明这个插件是xml中使用sql提示必须开启的。


...]]></description><category></category></item><item><title><![CDATA[mysql8.0日常使用记录]]></title><link>https://blog.youkuaiyun.com/ElvisDream/article/details/121270281</link><guid>https://blog.youkuaiyun.com/ElvisDream/article/details/121270281</guid><author>ElvisDream</author><pubDate>Thu, 11 Nov 2021 16:18:45 +0800</pubDate><description><![CDATA[1. 行转列并拼接
使用数据库函数group_concat()
2.递归
with recursive test_paths(id, path) as 
(
  select id, name
  from test
  where parent_id is null # 溢出条件
  union all
  select tp.id, concat(tp.path, '/', t.name)
  from test_paths tp join test t on tp.id = t.parent_id #]]></description><category></category></item><item><title><![CDATA[IDEA常用插件备忘录]]></title><link>https://blog.youkuaiyun.com/ElvisDream/article/details/120182200</link><guid>https://blog.youkuaiyun.com/ElvisDream/article/details/120182200</guid><author>ElvisDream</author><pubDate>Wed, 08 Sep 2021 16:02:57 +0800</pubDate><description><![CDATA[IDEA常用插件备忘录


]]></description><category></category></item></channel></rss>