Category Archives: Java

[Jersey] disable decode the URL path

Posted on 2017 年 06 月 01 日 by cowman.chiang

use annotation “@Encoded” Ex:

@Path("{first}/get")
public Response getYouWant(@Context HttpHeaders httpHeaders, @PathParam("first") String first, @QueryParam("second")  @Encoded String second);

1 2	@Path("{first}/get") public Response getYouWant(@Context HttpHeaders httpHeaders, @PathParam("first") String first, @QueryParam("second") @Encoded String second);

Posted in Java | Leave a comment

open external program from java for mac os x

Posted on 2017 年 03 月 24 日 by cowman.chiang

String[] cmds = {"open",  tempFile.getAbsolutePath(), "-a", "/Applications/Microsoft Office 2011/Microsoft Excel.app"};
Runtime.getRuntime().exec(cmds);

1 2	String[] cmds = {"open", tempFile.getAbsolutePath(), "-a", "/Applications/Microsoft Office 2011/Microsoft Excel.app"}; Runtime.getRuntime().exec(cmds);

Posted in Java, Mac, Office | Leave a comment

Gson usage : formJson

Posted on 2017 年 02 月 17 日 by cowman.chiang

avoid to face the exception ‘java.lang.ClassCastException With com.google.gson.internal.LinkedTreeMap cannot be cast to…’, we use the TypeToken to convert json to List

public class Object {
    @SerializedName("n")
    private String name;
    @SerializedName("i")
    private String id;

    public String getName() {
        return name;
    }

    public Object setName(String name) {
        this.name = name;
        return this;
    }

    public String getId() {
        return id;
    }

    public Object setId(String id) {
        this.id = id;
        return this;
    }
}

// [{"n":"cowman","i":"cowman@xxx.com.tw"}, {"n":"cowman1","i":"cowman1@xxx.com.tw"}]

List<Object> ObjectList = new Gson().fromJson(targets, 
new TypeToken<List<Object>>(){}.getType());

public class Object {

@SerializedName("n")

private String name;

@SerializedName("i")

private String id;

public String getName() {

return name;

}

public Object setName(String name) {

this.name = name;

return this;

}

public String getId() {

return id;

}

public Object setId(String id) {

this.id = id;

return this;

}

// [{"n":"cowman","i":"cowman@xxx.com.tw"}, {"n":"cowman1","i":"cowman1@xxx.com.tw"}]

List<Object> ObjectList = new Gson().fromJson(targets,

new TypeToken<List<Object>>(){}.getType());

Posted in Java | Leave a comment

[Java] unicode to string

Posted on 2016 年 10 月 21 日 by cowman.chiang

public static void main(String[] args) {
    try {
        String abc = "0043006F0077006D0061002E002E002E90808ACB";
        System.out.print(getString(abc));
    } catch (Exception e) {
        System.out.println("err");
    }
}

public static String getString(String strValue) {
    StringBuilder str = new StringBuilder();
    String temp;
    for (int i = 0; i < strValue.length(); i = i + 4) {
        temp =  strValue.substring(i, i + 4);
        str.append((char) Integer.parseInt( temp, 16 ));
    }

    return str.toString();
}

public static void main(String[] args) {

try {

String abc = "0043006F0077006D0061002E002E002E90808ACB";

System.out.print(getString(abc));

} catch (Exception e) {

System.out.println("err");

}

public static String getString(String strValue) {

StringBuilder str = new StringBuilder();

String temp;

for (int i = 0; i < strValue.length(); i = i + 4) {

temp = strValue.substring(i, i + 4);

str.append((char) Integer.parseInt( temp, 16 ));

}

return str.toString();

}

Posted in Java | Leave a comment

[Java, HBase] Hostname is very important!

Posted on 2015 年 12 月 01 日 by cowman.chiang

If the connection is failed, try to check the hdfs uri setting, it might be used hostname.

Posted in HBase, Java | Leave a comment

[Java] Connect LDAP (subdomain).

Posted on 2015 年 11 月 18 日 by cowman.chiang

Ref. referrals & global catalog, AD Child Domain Referral Searches by Rajnish Bhatia If you want to search all subdomain, the port of ‘PROVIDER_URL’ might be use in 3268.

Posted in Java | 1 Comment

[Java] Check apache poi version

Posted on 2015 年 11 月 17 日 by cowman.chiang

Ref: The Apache POI project – Frequently Asked Questions: My code uses some new feature, compiles fine but fails when live with a “MethodNotFoundException” or “IncompatibleClassChangeError”

    ClassLoader classloader = org.apache.poi.poifs.filesystem.POIFSFileSystem.class.getClassLoader();
    URL res = classloader.getResource("org/apache/poi/poifs/filesystem/POIFSFileSystem.class");
    String path = res.getPath();
    System.out.println("Core POI came from " + path);

ClassLoader classloader = org.apache.poi.poifs.filesystem.POIFSFileSystem.class.getClassLoader();

URL res = classloader.getResource("org/apache/poi/poifs/filesystem/POIFSFileSystem.class");

String path = res.getPath();

System.out.println("Core POI came from " + path);

Posted in Java | Leave a comment

[Java] Write xls files

Posted on 2015 年 11 月 02 日 by cowman.chiang

public String createFile(Object object) {
    try {
        Excel excel = (Excel) object;
        HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
        for (SheetContent sheetContent:excel.getSheets()) {
            HSSFSheet sheet = hssfWorkbook.createSheet(sheetContent.getName());

            List&lt;HSSFCellStyle&gt; formats = new ArrayList&lt;&gt;();
            /** format */
            for (String format:sheetContent.getFormats()) {
                HSSFCellStyle cs = hssfWorkbook.createCellStyle();
                HSSFDataFormat df = hssfWorkbook.createDataFormat();
                cs.setDataFormat(df.getFormat(format));
                formats.add(cs);
            }

            /** header */
            HSSFRow headerRow = sheet.createRow(0);
            for (int i = 0; i &lt; sheetContent.getHeaders().size(); i++) {
                HSSFCell cell = headerRow.createCell(i);
                cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                cell.setCellValue(sheetContent.getHeaders().get(i));
            }

            /** content */
            for (int i = 0; i &lt; sheetContent.getRows().size(); i ++) {
                HSSFRow dataRow = sheet.createRow(i + 1);
                for (int j = 0; j &lt; sheetContent.getRows().get(i).getCells().size(); j++) {
                    HSSFCell cell = dataRow.createCell(j);
                    if (StringUtils.isNotEmpty(sheetContent.getFormats().get(j))) {
                        cell.setCellValue(Double.parseDouble(sheetContent.getRows().get(i).getCells().get(j)));
                        cell.setCellStyle(formats.get(j));
                    } else {
                        cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                        cell.setCellValue(sheetContent.getRows().get(i).getCells().get(j));
                    }
                }
            }

            /** auto size */
            for (int i = 0; i &lt; sheet.getRow(0).getPhysicalNumberOfCells(); i++) {
                sheet.autoSizeColumn(i);
            }
        }

        FileOutputStream out = new FileOutputStream(new File("Excel.xls"));
        hssfWorkbook.write(out);
        out.close();

        return "ok";
    } catch (Exception e) {
        LOG.error(Constants.EXCEPTION_PREFIX, e);
        return null;
    }
}

public class Excel {
    List&lt;SheetContent&gt; sheets;

    public List&lt;SheetContent&gt; getSheets() {
        return sheets;
    }

    public Excel setSheets(List&lt;SheetContent&gt; sheets) {
        this.sheets = sheets;
        return this;
    }

    public Excel addSheets(SheetContent sheet) {
        if (this.sheets == null) {
            this.sheets = new ArrayList&lt;&gt;();
        }
        this.sheets.add(sheet);
        return this;
    }
}

public class SheetContent {
    private String name;
    private List&lt;String&gt; formats;
    private List&lt;String&gt; headers;
    private List&lt;Row&gt; rows;

    public String getName() {
        return name;
    }

    public SheetContent setName(String name) {
        this.name = name;
        return this;
    }


    public List&lt;String&gt; getFormats() {
        return formats;
    }

    public SheetContent setFormats(List&lt;String&gt; formats) {
        this.formats = formats;
        return this;
    }

    public List&lt;String&gt; getHeaders() {
        return headers;
    }

    public SheetContent setHeaders(List&lt;String&gt; headers) {
        this.headers = headers;
        return this;
    }

    public List&lt;Row&gt; getRows() {
        return rows;
    }

    public SheetContent setRows(List&lt;Row&gt; rows) {
        this.rows = rows;
        return this;
    }
}

public class Row {
    private List&lt;String&gt; cells;

    public List&lt;String&gt; getCells() {
        return cells;
    }

    public Row setCells(List&lt;String&gt; cells) {
        this.cells = cells;
        return this;
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

public String createFile(Object object) {

try {

Excel excel = (Excel) object;

HSSFWorkbook hssfWorkbook = new HSSFWorkbook();

for (SheetContent sheetContent:excel.getSheets()) {

HSSFSheet sheet = hssfWorkbook.createSheet(sheetContent.getName());

List<HSSFCellStyle> formats = new ArrayList<>();

/** format */

for (String format:sheetContent.getFormats()) {

HSSFCellStyle cs = hssfWorkbook.createCellStyle();

HSSFDataFormat df = hssfWorkbook.createDataFormat();

cs.setDataFormat(df.getFormat(format));

formats.add(cs);

}

/** header */

HSSFRow headerRow = sheet.createRow(0);

for (int i = 0; i < sheetContent.getHeaders().size(); i++) {

HSSFCell cell = headerRow.createCell(i);

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setCellValue(sheetContent.getHeaders().get(i));

}

/** content */

for (int i = 0; i < sheetContent.getRows().size(); i ++) {

HSSFRow dataRow = sheet.createRow(i + 1);

for (int j = 0; j < sheetContent.getRows().get(i).getCells().size(); j++) {

HSSFCell cell = dataRow.createCell(j);

if (StringUtils.isNotEmpty(sheetContent.getFormats().get(j))) {

cell.setCellValue(Double.parseDouble(sheetContent.getRows().get(i).getCells().get(j)));

cell.setCellStyle(formats.get(j));

} else {

cell.setCellType(HSSFCell.CELL_TYPE_STRING);

cell.setCellValue(sheetContent.getRows().get(i).getCells().get(j));

}

/** auto size */

for (int i = 0; i < sheet.getRow(0).getPhysicalNumberOfCells(); i++) {

sheet.autoSizeColumn(i);

}

FileOutputStream out = new FileOutputStream(new File("Excel.xls"));

hssfWorkbook.write(out);

out.close();

return "ok";

} catch (Exception e) {

LOG.error(Constants.EXCEPTION_PREFIX, e);

return null;

}

public class Excel {

List<SheetContent> sheets;

public List<SheetContent> getSheets() {

return sheets;

}

public Excel setSheets(List<SheetContent> sheets) {

this.sheets = sheets;

return this;

}

public Excel addSheets(SheetContent sheet) {

if (this.sheets == null) {

this.sheets = new ArrayList<>();

}

this.sheets.add(sheet);

return this;

}

public class SheetContent {

private String name;

private List<String> formats;

private List<String> headers;

private List<Row> rows;

public String getName() {

return name;

}

public SheetContent setName(String name) {

this.name = name;

return this;

}

public List<String> getFormats() {

return formats;

}

public SheetContent setFormats(List<String> formats) {

this.formats = formats;

return this;

}

public List<String> getHeaders() {

return headers;

}

public SheetContent setHeaders(List<String> headers) {

this.headers = headers;

return this;

}

public List<Row> getRows() {

return rows;

}

public SheetContent setRows(List<Row> rows) {

this.rows = rows;

return this;

}

public class Row {

private List<String> cells;

public List<String> getCells() {

return cells;

}

public Row setCells(List<String> cells) {

this.cells = cells;

return this;

}

Posted in Excel, Java | Leave a comment

[Java] Binary numbers in enum type.

Posted on 2015 年 10 月 12 日 by cowman.chiang

public enum Type {
  /** none */
  NONE(0),
  /** ONE */
  ONE(1),
  /** TWO */
  TWO(2),
  /** FOUR */
  FOUR(4),
  /** EIGHT */
  EIGHT(8),
  /** SIXTEEN */
  SIXTEEN(16);

  private int key;
  private static int[] binaryArray = { 0, 1, 2, 4, 8, 16 };

  Type(int code) {
    this.key = code;
  }

  public int getKey() {
    return key;
  }

  public static void main(String[] args) {
    System.out.println(findListByKey(60));
  }

  public static List&lt;Type&gt; findListByKey(int key) {
    List&lt;Type&gt; matchList = new ArrayList&lt;&gt;();

    List&lt;Integer&gt; binarySequence = getBinarySequence(key);

    for (Integer code:binarySequence) {
        matchList.add(findByKey(code));
    }

    return matchList;
  }

  public static Type findByKey(int key) {
    Type match;
    for (Type e : values()) {
        if (e.getKey() == key) {
            match = e;
            return match;
        }
    }

    return NONE;
  }

  private static List&lt;Integer&gt; getBinaryNumberSequence(int target){
    List&lt;Integer&gt; result = new ArrayList&lt;&gt;();

    boolean flag = true;
    while (flag == true) {
        int code = findCloseDigit(target);
        target = target - code;
        result.add(code);
        if (target == 0) {
            flag = false;
        }
    }

    return result;
  }

  private static int findCloseDigit(int target) {
    int result = 0;
    for (int code:binaryArray) {
        if (code &lt;= target) {
            result = code;
        } else {
            break;
        }
    }
    return result;
  }
}

public enum Type {

/** none */

NONE(0),

/** ONE */

ONE(1),

/** TWO */

TWO(2),

/** FOUR */

FOUR(4),

/** EIGHT */

EIGHT(8),

/** SIXTEEN */

SIXTEEN(16);

private int key;

private static int[] binaryArray = { 0, 1, 2, 4, 8, 16 };

Type(int code) {

this.key = code;

}

public int getKey() {

return key;

}

public static void main(String[] args) {

System.out.println(findListByKey(60));

}

public static List<Type> findListByKey(int key) {

List<Type> matchList = new ArrayList<>();

List<Integer> binarySequence = getBinarySequence(key);

for (Integer code:binarySequence) {

matchList.add(findByKey(code));

}

return matchList;

}

public static Type findByKey(int key) {

Type match;

for (Type e : values()) {

if (e.getKey() == key) {

match = e;

return match;

}

return NONE;

}

private static List<Integer> getBinaryNumberSequence(int target){

List<Integer> result = new ArrayList<>();

boolean flag = true;

while (flag == true) {

int code = findCloseDigit(target);

target = target - code;

result.add(code);

if (target == 0) {

flag = false;

}

return result;

}

private static int findCloseDigit(int target) {

int result = 0;

for (int code:binaryArray) {

if (code <= target) {

result = code;

} else {

break;

}

return result;

}

Posted in Java | Leave a comment

[Java] String.format

Posted on 2015 年 10 月 02 日 by cowman.chiang

private String GroupMessageAuto = "已完成自動同步動作，共計新增 %s 筆、刪除 %s 筆、同步 %s 筆”;
groupMsg = String.format(GroupMessageAuto, syncCount.getAdd(), syncCount.getDel(), syncCount.getSync());

private String GroupMessageAuto = "已完成自動同步動作，共計新增 %s 筆、刪除 %s 筆、同步 %s 筆”;

groupMsg = String.format(GroupMessageAuto, syncCount.getAdd(), syncCount.getDel(), syncCount.getSync());

Posted in Java | Leave a comment

Category Archives: Java

Categories