2015 – Poor Coding

C# The reason why be shown same perfomance of List VS Array

The List class contains an internal array and exposes methods and properties that, among other things, allow read and write access to the elements of the internal array.

The List: a Homogeneous, Self-Redimensioning Array

Conclusion…
The List class has same performance of array.
but needs multiple memories.

JavaScript Excel coordination changer

http://jsfiddle.net/easywaru/8euvLuha/

Excel:A1 <-> Coord:(1,1)

// 0 | 1 case 0: (0,0) -> A1 case 1: (1,1) -> A1
var coordinationIndexBase = 1;

var reRow = new RegExp("(\\d+)$");
var reCol = new RegExp("^([A-Z]+)");

var getRowName = function(cellName) {
    var found = cellName.match(reRow);
    if(!found){
        throw new Error("Parameter \"cellName\" has no convertable row name. cellName = " + cellName + "");
    }
    return found[0];
};

var getColName = function(cellName) {
    var found = cellName.match(reCol);
    if(!found){
        throw new Error("Parameter \"cellName\" has no convertable column name. cellName = " + cellName + "");
    }
    return found[0];
};

var getRowIndex= function(cellName) {
    var rowIndex = parseInt(getRowName(cellName));
    rowIndex -= 1 - coordinationIndexBase;
    return rowIndex;
};

var getColIndex  = function(cellName){
    var colName = getColName(cellName);
    var colIndex = 0;
    for (var i = 0, iLen = colName.length; i < iLen ; i++) {
        colIndex *= 26;
        colIndex += alpha2number(colName[i]) + 1;
    }
    colIndex -= 1 - coordinationIndexBase;
    return colIndex;
};

var getCellName = function(rowIndex , colIndex){
    if(rowIndex < coordinationIndexBase){
         throw new Error("Parameter \"rowIndex\" can't less then "+coordinationIndexBase  +". rowIndex = " + rowIndex + "");
    }
    
    if(colIndex < coordinationIndexBase){
         throw new Error("Parameter \"colIndex\" can't less then "+coordinationIndexBase  +". colIndex = " + colIndex + "");
    }
    
    rowIndex -= coordinationIndexBase - 1;
    colIndex -= coordinationIndexBase - 1;
    var colName = '';
    while (true) {
        colIndex -= 1 
        colName = number2alpha(colIndex % 26) + colName;
        colIndex = Math.floor(colIndex / 26);
        if (colIndex <= 0) {
            break;
        }
    }
    return cellName = colName + rowIndex;
}
// A -> 0
var alpha2number = function(alpha) {
    var number = alpha.charCodeAt(0) - 65;
    return number;
}
    
// 0 -> A
var number2alpha = function(number) {
    if (number < 0) {
        return "";
    }
    var alpha = String.fromCharCode(65 + number);
    return alpha;
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

// 0 | 1 case 0: (0,0) -> A1 case 1: (1,1) -> A1

var coordinationIndexBase = 1;

var reRow = new RegExp("(\\d+)$");

var reCol = new RegExp("^([A-Z]+)");

var getRowName = function(cellName) {

var found = cellName.match(reRow);

if(!found){

throw new Error("Parameter \"cellName\" has no convertable row name. cellName = " + cellName + "");

}

return found[0];

};

var getColName = function(cellName) {

var found = cellName.match(reCol);

if(!found){

throw new Error("Parameter \"cellName\" has no convertable column name. cellName = " + cellName + "");

}

return found[0];

};

var getRowIndex= function(cellName) {

var rowIndex = parseInt(getRowName(cellName));

rowIndex -= 1 - coordinationIndexBase;

return rowIndex;

};

var getColIndex = function(cellName){

var colName = getColName(cellName);

var colIndex = 0;

for (var i = 0, iLen = colName.length; i < iLen ; i++) {

colIndex *= 26;

colIndex += alpha2number(colName[i]) + 1;

}

colIndex -= 1 - coordinationIndexBase;

return colIndex;

};

var getCellName = function(rowIndex , colIndex){

if(rowIndex < coordinationIndexBase){

throw new Error("Parameter \"rowIndex\" can't less then "+coordinationIndexBase +". rowIndex = " + rowIndex + "");

}

if(colIndex < coordinationIndexBase){

throw new Error("Parameter \"colIndex\" can't less then "+coordinationIndexBase +". colIndex = " + colIndex + "");

}

rowIndex -= coordinationIndexBase - 1;

colIndex -= coordinationIndexBase - 1;

var colName = '';

while (true) {

colIndex -= 1

colName = number2alpha(colIndex % 26) + colName;

colIndex = Math.floor(colIndex / 26);

if (colIndex <= 0) {

break;

}

return cellName = colName + rowIndex;

}

// A -> 0

var alpha2number = function(alpha) {

var number = alpha.charCodeAt(0) - 65;

return number;

}

// 0 -> A

var number2alpha = function(number) {

if (number < 0) {

return "";

}

var alpha = String.fromCharCode(65 + number);

return alpha;

}

git filename is too long

This is trouble on windows only.

git config --system core.longpaths true

1	git config --system core.longpaths true

Android 4.2.2 default browser canvas bug

When I test canvas animation used createJS,
I found afterimage.

I can find afterimage use setTimeout.
Canvas’s parent div changed after canvas’s animation started.

Devices error found is below.
Sharp AQUOS PHONE SHL24（Android　4.2.2)
Sony XperiaA SO-04E (Android 4.2.2)

pseudo code

<div id="scr01">
   // ... some images
</div> 
<div id="scr02">
   <canvas id="anime"></canvas>
</div>

$("#anime")[some animation started by CreateJS]
setTimeout(function(){
    $("#scr01").hide();
    $("#scr02").show();
},1000);

1

2

3

4

5

6

7

8

9

10

11

12

// ... some images

</div>

</div>

$("#anime")[some animation started by CreateJS]

setTimeout(function(){

$("#scr01").hide();

$("#scr02").show();

},1000);

node.js download file has cjk name

file download throw error if you have file’s name composed CJK characters
encodeURIComponent

res.setHeader('Content-disposition', 'attachment; filename=' + encodeURIComponent(filename));
res.setHeader('Content-type', mimetype);
var filestream = fs.createReadStream(realPath);
filestream.pipe(res);

1

2

3

4

res.setHeader('Content-disposition', 'attachment; filename=' + encodeURIComponent(filename));

res.setHeader('Content-type', mimetype);

var filestream = fs.createReadStream(realPath);

filestream.pipe(res);

Java how to check file exists case sensitive

[File instance].exists() only check case insensitive.
If you want check case sensitive, below code help you.

String filePath = "C:\...\Abc.txt";
File file = new File(filePath);
if(file.exists() && file.getCanonicalPath().equals(filePath)){
    // file exists
    return true;
}else{
    // file is not exist
    return false;
}

1

2

3

4

5

6

7

8

9

String filePath = "C:\...\Abc.txt";

File file = new File(filePath);

if(file.exists() && file.getCanonicalPath().equals(filePath)){

// file exists

return true;

}else{

// file is not exist

return false;

}

Java database connection string mysql oracle sqlserver

String driverName = "";
String driverConfig = "";
String testSql = "";

if (MYSQL.equals(type)) {
	// Download mysql-connector-java-5.1.29-bin.jar from below
	// http://dev.mysql.com/downloads/connector/j/

	driverName = "com.mysql.jdbc.Driver";
	driverConfig = "jdbc:mysql://" + host + "/" + name + "?user=" + user + "&password=" + pass;

	// host = 192.168.1.1:3306
	// name = TESTDB
	// user = ABCD
	// pass = 1234
	testSql = "select 'MySQL connection test' as test";

} else if (ORACLE.equals(type)) {
	// Download ojdbc6.jar from below
	// http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

	driverName = "oracle.jdbc.driver.OracleDriver";
	driverConfig = "jdbc:oracle:thin:" + user + "/" + pass + "@" + host;

	// host = 192.168.1.1:1521:XE
	// name = TESTDB
	// user = ABCD
	// pass = 1234
	testSql = "select 'Oracle connection test' as test from dual";

} else if (SQLSERVER.equals(type)) {
	// Download sqljdbc4.jar from below
	// http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

	driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	driverConfig = "jdbc:sqlserver://" + host + ";databaseName=" + name + ";user=" + user + ";password=" + pass + ";";

	// host = 192.168.1.1\TEST
	// name = TESTDB
	// user = ABCD
	// pass = 1234
	testSql = "select 'SQLServer connection test' as test";

}

Class.forName(driverName).newInstance();
conn = DriverManager.getConnection(driverConfig);

if (ORACLE.equals(type)) {
	conn.createStatement().execute("alter session set current_schema=" + name);
}

ResultSet rs = conn.createStatement().executeQuery(testSql);
while (rs.next()) {
	System.out.println(rs.getString("test"));
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

String driverName = "";

String driverConfig = "";

String testSql = "";

if (MYSQL.equals(type)) {

// Download mysql-connector-java-5.1.29-bin.jar from below

// http://dev.mysql.com/downloads/connector/j/

driverName = "com.mysql.jdbc.Driver";

driverConfig = "jdbc:mysql://" + host + "/" + name + "?user=" + user + "&password=" + pass;

// host = 192.168.1.1:3306

// name = TESTDB

// user = ABCD

// pass = 1234

testSql = "select 'MySQL connection test' as test";

} else if (ORACLE.equals(type)) {

// Download ojdbc6.jar from below

// http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

driverName = "oracle.jdbc.driver.OracleDriver";

driverConfig = "jdbc:oracle:thin:" + user + "/" + pass + "@" + host;

// host = 192.168.1.1:1521:XE

// name = TESTDB

// user = ABCD

// pass = 1234

testSql = "select 'Oracle connection test' as test from dual";

} else if (SQLSERVER.equals(type)) {

// Download sqljdbc4.jar from below

// http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

driverConfig = "jdbc:sqlserver://" + host + ";databaseName=" + name + ";user=" + user + ";password=" + pass + ";";

// host = 192.168.1.1\TEST

// name = TESTDB

// user = ABCD

// pass = 1234

testSql = "select 'SQLServer connection test' as test";

}

Class.forName(driverName).newInstance();

conn = DriverManager.getConnection(driverConfig);

if (ORACLE.equals(type)) {

conn.createStatement().execute("alter session set current_schema=" + name);

}

ResultSet rs = conn.createStatement().executeQuery(testSql);

while (rs.next()) {

System.out.println(rs.getString("test"));

}

Javascript Japanese IME(Input Method Editor) Control V.0.0.1

Japanese IME control using regular expression on javascript.

Sample

// unicode range is referenced by http://www.unicode.org/charts/

// Numeric
//   \u0030-\u0039  -----  u0030:0  u0039:9
// FullWidth Numeric
//   \uFF10-\uFF19  -----  uFF10:０ uFF19:９

// Alphabet Uppercase
//   \u0041-\u005A  -----  u0041:A  u005A:Z
// Alphabet Lowercase
//   \u0061-\u007A  -----  u0061:a  u007A:z
// FullWidth Alphabet Uppercase
//   \uFF21-\uFF3A  -----  uFF21:Ａ uFF3A:Ｚ
// FullWidth Alphabet Lowercase
//   \uFF41-\uFF5A  -----  uFF41:ａ uFF5A:ａ

// kanji
//   \u4E00-\u9FAF  -----  u4E00:一 u9FAF:龯
// Hiragana
//   \u3041-\u3096  -----  u3041:ぁ u3096:ゖ
// Katakana
//   \u30A1-\u30FF  -----  u30A1:ァ u30FF:ヿ
// Katakana Phonetic Extensions
//   \u31F0-\u31FF  -----  u31F0:ㇰ u31FF:ㇿ
// Katakana Halfwidth
//   \uFF66-\uFF9F  -----  uFF66:ｦ  uFF9F:ﾟ

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

// unicode range is referenced by http://www.unicode.org/charts/

// Numeric

// \u0030-\u0039 ----- u0030:0 u0039:9

// FullWidth Numeric

// \uFF10-\uFF19 ----- uFF10:０ uFF19:９

// Alphabet Uppercase

// \u0041-\u005A ----- u0041:A u005A:Z

// Alphabet Lowercase

// \u0061-\u007A ----- u0061:a u007A:z

// FullWidth Alphabet Uppercase

// \uFF21-\uFF3A ----- uFF21:Ａ uFF3A:Ｚ

// FullWidth Alphabet Lowercase

// \uFF41-\uFF5A ----- uFF41:ａ uFF5A:ａ

// kanji

// \u4E00-\u9FAF ----- u4E00:一 u9FAF:龯

// Hiragana

// \u3041-\u3096 ----- u3041:ぁ u3096:ゖ

// Katakana

// \u30A1-\u30FF ----- u30A1:ァ u30FF:ヿ

// Katakana Phonetic Extensions

// \u31F0-\u31FF ----- u31F0:ㇰ u31FF:ㇿ

// Katakana Halfwidth

// \uFF66-\uFF9F ----- uFF66:ｦ uFF9F:ﾟ