Skip to content

Instantly share code, notes, and snippets.

@clxy
clxy / PoiExcelCopySheetPrintConfig.java
Created January 11, 2023 08:07
Copy print configuration of sheet by POI
/**
* 印刷設定をコピーする
* TODO: 四つのTabのうち、シートTabが対応できてないみたい
*
* @deprecated 利用しない
*/
@Deprecated
void copySheetPrintConfig(XSSFSheet from, XSSFSheet to) {
CTWorksheet fromCt = from.getCTWorksheet();
CTWorksheet toCt = to.getCTWorksheet();
@clxy
clxy / with_recursive.sql
Last active April 13, 2020 10:22
MS SQL Server - create list of month by with clause. @see https://stackoverflow.com/a/9255298
---
-- Personally, I liked this one!
---
declare @ym_to date = cast('20190401' as date);
declare @ym_from date = cast('20181201' as date);
with months(dt) as (
select @ym_to dt
union all
select dateadd(month, -1, dt) from months
)
@clxy
clxy / EmojiTextView.java
Created February 23, 2019 07:50
Emoji colors look faded. Emoji颜色发灰的解决办法
import android.content.Context;
import android.text.InputFilter;
import android.util.AttributeSet;
import androidx.annotation.Nullable;
import androidx.appcompat.widget.AppCompatTextView;
import androidx.emoji.widget.EmojiTextViewHelper;
/**
* 变更构建器里 init 方法的调用顺序
@clxy
clxy / BindingUtil.java
Created August 24, 2018 12:25
Android Databinding
public class BindingUtil {
/**
* 四方形是基准。none:不做任何调整,width:基于宽度调整成四方形
*/
public enum Size {
none, width, height
}
/**
@clxy
clxy / AppDao.java
Last active February 25, 2024 03:26
Android Room Generic Dao
import android.arch.persistence.db.SimpleSQLiteQuery;
import android.arch.persistence.db.SupportSQLiteQuery;
import android.arch.persistence.room.Dao;
import android.arch.persistence.room.Delete;
import android.arch.persistence.room.Insert;
import android.arch.persistence.room.OnConflictStrategy;
import android.arch.persistence.room.RawQuery;
import java.lang.reflect.ParameterizedType;
import java.util.List;
public final class AndroidImageUtil {
private AndroidImageUtil() {
}
/**
* 按图片尺寸压缩时,无法准确知道压缩后的文件大小。
* http://stackoverflow.com/questions/477572/strange-out-of-memory-issue-while-loading-an-image-to-a-bitmap-object/823966#823966
* @param file
* @return