Skip to content

Instantly share code, notes, and snippets.

@relax-more
relax-more / ibatis_MySQLRandomSort.sql
Created September 26, 2012 10:15
MySQL Random Sort
SELECT
a.value AS x, b.value AS y
FROM
$table$ a
LEFT JOIN $table$ b ON (a.id = b.id)
WHERE a.category = #categoryA#
AND b.category = #categoryB#
@relax-more
relax-more / Form.java
Created September 26, 2012 10:31
lombok model & spring framework sample
package my.snippet.model;
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.hibernate.validator.constraints.NotEmpty;
@SuppressWarnings("serial")
@Data
public class Form {
@relax-more
relax-more / Parser.java
Created October 9, 2012 07:36
Html Simple Parser
package my.snippet.service.impl;
import java.util.List;
public interface Parser {
public List<String> getValue(String urlString, String cssSelector);
}
@relax-more
relax-more / JacksonComplexObjectMappiongEx.java
Created October 16, 2012 12:11
Jackson で List<Map<String, Object>> にJsonデータをマッピングするサンプル
package my.snippet.service;
import static org.junit.Assert.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.codehaus.jackson.map.ObjectMapper;
@relax-more
relax-more / cast_value.sql
Created October 18, 2012 01:56
MySQLのクエリで型のキャストをするサンプル
SELECT
title
,CAST(value AS UNSIGNED)
FROM hogeTable
@relax-more
relax-more / gist:3978152
Created October 30, 2012 03:31
[Java] String文字列の前後から空白・改行文字を取り除く
public static String trim(String string) {
return string.replaceAll("^[\\s ]*", "").replaceAll("[\\s ]*$", "");
}
@relax-more
relax-more / gist:3979509
Created October 30, 2012 10:33
[MySQL] date_format のサンプル
SELECT date_format(update_datetime, '%Y/%m/%d') AS date, description, url, COUNT(*)
FROM any_table
GROUP BY date_format(update_datetime, '%Y/%m/%d'), description, url
ORDER BY description, date DESC
@relax-more
relax-more / gist:3986627
Created October 31, 2012 11:48
[UNIXコマンドメモ] ログアウトしてもバックグラウンド ジョブを継続する
$ nohup COMMAND [ARG]
@relax-more
relax-more / gist:3986637
Created October 31, 2012 11:49
UNIXコマンドメモ] ディレクトリの指定方法
$ rm -rf /data[1-9]/*
# delete all files under data1 ~ data9
@relax-more
relax-more / gist:3999122
Created November 2, 2012 06:49
[Java] JsoupでコメントアウトのNodeを取得する
import org.jsoup.Jsoup;
import org.jsoup.nodes.Document;
import org.jsoup.nodes.Node;
public class RemoveComments {
public static void main(String... args) {
String h = "<html><head></head><body>" +
"<div><!-- foo --><p>bar<!-- baz --></div><!--qux--></body></html>";
Document doc = Jsoup.parse(h);
removeComments(doc);