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.
http://jsfiddle.net/easywaru/8euvLuha/
Excel:A1 <-> Coord:(1,1)
|
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; } |
This is trouble on windows only.
|
1 |
git config --system core.longpaths true |
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
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<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); |
file download throw error if you have file’s name composed CJK characters
encodeURIComponent
|
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); |
[File instance].exists() only check case insensitive.
If you want check case sensitive, below code help you.
|
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; } |
|
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")); } |
Japanese IME control using regular expression on javascript.
|
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:ﾟ |
In IE10
When click DIV positioned top of DOM
that has no background and exist text of another DOM,
mouse event passed by
Solution:
backgroud:#ffffff;
opacity:0;
SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT * FROM INFORMATION_SCHEMA.COLUMNS