[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:ﾟ |