March 24, 2014

MySql Stored Procedure Example

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

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

March 5, 2014

Java analogue of C# System.Configuration.ConfigurationManager.AppSettings

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;
	}
}

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;

}

November 9, 2013

How to find Home Directory of a user in Unix?

Finger command will give you information about system user in Unix.

finger root

1	finger root

Gaurang Jadia

Nothing is permanent except change

Author Archives: Gaurang

MySql Stored Procedure Example

Java analogue of C# System.Configuration.ConfigurationManager.AppSettings

How to find Home Directory of a user in Unix?