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 |
DELIMITER $$ CREATE DEFINER=`root`@`%` PROCEDURE `GetAllFiles`( IN sort VARCHAR(4) ) BEGIN SET @orderBy = sort; SET @sqlStatement = concat(' SELECT id, name, path, type, size, ispublic, code, insertdate FROM File ORDER BY insertdate' + @orderBy + '; '); PREPARE statement FROM @sqlStatement; EXECUTE statement; DEALLOCATE PREPARE statement; END |
Java analogue of C# System.Configuration.ConfigurationManager.AppSettings
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 |
package com.gaurangjadia.java.base; import java.io.FileInputStream; import java.io.IOException; import java.util.Hashtable; import java.util.Properties; public class ConfigurationManager { private Properties prop; private Hashtable<String, String> AppSettings; public ConfigurationManager(String strConfigPath) { this.prop = new Properties(); this.AppSettings = new Hashtable<String, String>(); try { this.prop.load(new FileInputStream(strConfigPath)); } catch (IOException ex) { ex.printStackTrace(); } } public Hashtable<String, String> getAppSettings() { this.AppSettings.clear(); for(String key : this.prop.stringPropertyNames()) { this.AppSettings.put(key, this.prop.getProperty(key)); } return this.AppSettings; } } |
How to find Home Directory of a user in Unix?
Finger command will give you information about system user in Unix.
1 |
finger root |