MYRS|-| Programmer's Inn

Extract Numbers from a String

2011-12-21T07:32:00.000-08:00


public static List extractNumsFromStr(String line) {
  List numbers = new ArrayList();
  Long no;
  String number = null;
  Pattern p = Pattern.compile("\\d+");
  Matcher m = p.matcher(line);

  while (m.find()) {
   number = m.group();
   no = Long.parseLong(number);
   numbers.add(no);
  }
  return numbers;
 }

Convert XML file To String object

2011-11-10T02:32:00.000-08:00

The following code will read the XML from file specified as method argument, and will return the String object containing the XML file contents, null otherwise.


public static String convertXMLFileToString(String filePath) { 
      try { 
        DocumentBuilderFactory documentBuilderFactory = DocumentBuilderFactory.newInstance(); 
        InputStream inputStream = new FileInputStream(new File(filePath)); 
        org.w3c.dom.Document document = documentBuilderFactory.newDocumentBuilder().parse(inputStream); 
        StringWriter stwriter = new StringWriter(); 
        Transformer serializer = TransformerFactory.newInstance().newTransformer(); 
        serializer.transform(new DOMSource(document), new StreamResult(stwriter)); 
        return stwriter.toString(); 
      } catch (Exception e) { 
        e.printStackTrace(); 
      } 
        return null; 
    }

MySql LOAD_FILE Function

2011-09-28T08:29:00.000-07:00

LOAD_FILE(file_name_and_complete_path)

It’s built in MySql String function that reads a file from server host and returns the contents of file as string. If file can’t read or doesn’t exist then this function will return NULL.

Important Points:

è Must pass the full path name to the file as parameter
è User must have the FILE privilege
è File must be readable
è Size of file must be less than max_allowed_packet in bytes. Default is (1048576 bytes). Its range is 1024 – 1073741824
è If system variable named secure_file_priv is set to a non empty directory, then the file must be located in the directory specified by this system variable. Its advisable to set this variable to the source directory for your file, otherwise there is a risk for LOAD_FILE Injection. If you want to check the current value for this system variable you can simply use the command:

mysql>SELECT @@secure_file_priv;

Example:

Mysql> UPDATE SET blob_column_name = LOAD_FILE(‘/tmp/picture’) WHERE id = 1;

Java Puzzle Animal Farm

2011-09-16T07:56:00.000-07:00

Readers of George Orwell's Animal Farm may remember old Major's pronouncement that "all animals are equal." The following Java program attempts to test this pronouncement.

What does it print? and Why?


public class AnimalFarm {
public static void main(String[] args) {

final String pig = "length: 10";
final String dog = "length: " + pig.length();

System.out.println("Animals are equal: "+ pig == dog);

}
}

Solution:

A superficial analysis of the program might suggest that it should print Animals are equal: true. After all, pig and dog are both final String variables initialized to the character sequence "length: 10". In other words, the strings referred to by pig and dog are and will forever remain equal to each other. The == operator, however, does not test whether two objects are equal; it tests whether two object references are identical. In other words, it tests whether they refer to precisely the same object. In this case, they do not. You may be aware that compile-time constants of type String are interned [JLS 15.28]. In other words, any two constant expressions of type String that designate the same character sequence are represented by identical object references. If initialized with constant expressions, both pig and dog would indeed refer to the same object, but dog is not initialized with a constant expression. The language constrains which operations are permitted to appear in a constant expression [JLS 16.28], and method invocation is not among them. Therefore the program should print Animals are equal: false, right?

Well, no, actually. If you ran the program, you found that it prints false and nothing else. It doesn't print Animals are equal: . How could it not print this string literal, which is right there in black and white? The + operator, whether used for addition or string concatenation, binds more tightly than the == operator. Therefore, the parameter of the println method is evaluated like this:

System.out.println(("Animals are equal: " + pig) == dog);

The value of the boolean expression is, of course, false, and that is exactly what the program prints. There is one surefire way to avoid this sort of difficulty: When using the string concatenation operator, always parenthesize nontrivial operands. More generally, when you are not sure whether you need parentheses, err on the side of caution and include them. If you parenthesize the comparison in the println statement as follows, it will produce the expected output of Animals are equal: false:

System.out.println("Animals are equal: " + (pig == dog));

Arguably, the program is still broken. Your code should rarely, if ever, depend on the interning of string constants. Interning was designed solely to reduce the memory footprint of the virtual machine, not as a tool for programmers. As this puzzle demonstrates, it isn't always obvious which expressions will result in string constants. Worse, if your code depends on interning for its correct operation, you must carefully keep track of which fields and parameters must be interned. The compiler can't check these invariants for you, because interned and noninterned strings are represented by the same type (String). The bugs that result from the failure to intern a string are typically quite difficult to detect.


When comparing object references, you should use the equals method in preference to the == operator unless you need to compare object identity rather than value. Applying this lesson to our program, here is how the println statement should look. It is clear that the program prints True when it is fixed in this fashion:

System.out.println("Animals are equal: " + pig.equals(dog));

This puzzle has two lessons for language designers. The natural precedence of string concatenation might not be the same as that of addition. This implies that it is problematic to overload the + operator to perform string concatenation. Also, reference equality is more confusing than value equality for immutable types, such as String. Perhaps the == operator should perform value comparisons when applied to immutable reference types. One way to achieve this would be to make the == operator a shorthand for the equals method, and to provide a separate method to perform reference identity comparison, akin to System.identityHashCode.

Gang of Four (GOF) Design Patterns

2011-09-16T05:19:00.000-07:00

The Gang of four (GOF) patterns are categorized into three main categories:

Creational:- Deals with the creation of objects. Following are the creational patterns:

Factory
Abstract Factory
Factory Method
Builder
Prototype
Singleton

Structural:- Deals with the relationships between portion of your application. Followings are the Structural patterns:

Adapter
Bridge
Composite
Decorator
Facade
Flyweight
Proxy

Behavioural:- Deals with the state and behaviour flow through the system. Followings are the behavioural patterns:

Chain of Responsibility
Command
Interpreter
Iterator
Mediator
Memento
Observer
State
Strategy
Template Method
Visitor

New Features in Java version 7

2011-09-15T02:00:00.000-07:00

The new release of Java 7 introduced exciting new features in the language; following is the list of these features:

Strings in the Switch Statement

For details please visit: http://download.oracle.com/javase/7/docs/technotes/guides/language/strings-switch.html

Type Inference for Generic Instance Creation (diamond symbol <>)

For details please visit:
http://download.oracle.com/javase/7/docs/technotes/guides/language/type-inference-generic-instance-creation.html

The try-with-resources Statement

For details please visit:
http://download.oracle.com/javase/7/docs/technotes/guides/language/try-with-resources.html

Catching multiple Exception Types and Rethrowing Exception with Improved Type Checking

For details please visit:
http://download.oracle.com/javase/7/docs/technotes/guides/language/catch-multiple.html

Enhancements in Java I/O (new package named java.nio)

For details please visit:
http://download.oracle.com/javase/7/docs/technotes/guides/io/enhancements.html#7
http://download.oracle.com/javase/tutorial/essential/io/notification.html

Java Virtual Machine Support for Non-Java Languages

For details please visit:
http://download.oracle.com/javase/7/docs/technotes/guides/vm/multiple-language-support.html

JLayer Pane to Decorate Components with JLayer Class

For details please visit:
http://download.oracle.com/javase/tutorial/uiswing/misc/jlayer.html

To Check Internet Explorer (IE) version

2011-08-10T03:24:00.000-07:00

Little helper function to return details about IE 8 and its various compatibility settings either use as it is or incorporate into a browser object. Remember browser sniffing is not the best way to detect user-settings as spoofing is very common so use with caution.



function IEVersion(){

    var _n=navigator,_w=window,_d=document;

    var version="NA";

    var na=_n.userAgent;

    var ieDocMode="NA";

    var ie8BrowserMode="NA";

    // Look for msie and make sure its not opera in disguise

    if(/msie/i.test(na) && (!_w.opera)){

        // also check for spoofers by checking known IE objects

        if(_w.attachEvent && _w.ActiveXObject){        

            // Get version displayed in UA although if its IE 8 running in 7 or compat mode it will appear as 7

            version = (na.match( /.+ie\s([\d.]+)/i ) || [])[1];

            // Its IE 8 pretending to be IE 7 or in compat mode        

            if(parseInt(version)==7){                

                // documentMode is only supported in IE 8 so we know if its here its really IE 8

                if(_d.documentMode){

                    version = 8; //reset? change if you need to

                    // IE in Compat mode will mention Trident in the useragent

                    if(/trident\/\d/i.test(na)){

                        ie8BrowserMode = "Compat Mode";

                    // if it doesn't then its running in IE 7 mode

                    }else{

                        ie8BrowserMode = "IE 7 Mode";

                    }

                }

            }else if(parseInt(version)==8){

                // IE 8 will always have documentMode available

                if(_d.documentMode){ ie8BrowserMode = "IE 8 Mode";}

            }

            // If we are in IE 8 (any mode) or previous versions of IE we check for the documentMode or compatMode for pre 8 versions            

            ieDocMode = (_d.documentMode) ? _d.documentMode : (_d.compatMode && _d.compatMode=="CSS1Compat") ? 7 : 5;//default to quirks mode IE5                               

        }

    }



    return {

        "UserAgent" : na,

        "Version" : version,

        "BrowserMode" : ie8BrowserMode,

        "DocMode": ieDocMode

    }            

}

var ieVersion = IEVersion();

var IsIE8 = ieVersion.Version != "NA" && ieVersion.Version >= 8;



if (!IsIE8) {

	alert("Please upgrade to Internet Explorer 8 or better!" ) ;

}

Masking a HTML TextField as Numeric or Float

2011-07-13T14:19:00.000-07:00

Add these functions to your JavaScript code under <script> tag.

function getKey(evt) { // works for IE, Netscape, Firefox, Opera, Chrome

var theEvent = evt || window.event;

var key = theEvent.keyCode || theEvent.which;

return key;

}

function MaskNumeric(evt) {

//8 Delete, 39 left cursor, 37 right cursor, 35 end, 36 home, 9 tab, 116 f5

//127 Backspace 48-57 0-9

var key = getKey(evt);

if( (key == 116 || key == 8 || key == 9 || key == 39 || key == 37 || key == 35 ||

key == 36 || key == 189 || key == 109 || key == 127 || key == 46) ||

(key >= 48 && key <= 57) ||

(key >= 96 && key <= 105) ) {

return true;

} else {

return false;

}

function MaskFloat(evt) {

//8 Delete, 39 left cursor, 37 right cursor, 35 end, 36 home, 9 tab, 116 f5

//127 Backspace 48-57 0-9

var key = getKey(evt);

if( (key == 116 || key == 8 || key == 9 || key == 39 || key == 37 || key == 35 ||

key == 36 || key == 189 || key == 109 || key == 127 || key == 46 || key == 110 || key == 190) ||

(key >= 48 && key <= 57) ||

(key >= 96 && key <= 105) ) {

return true;

} else {

return false;

}

Then use the following code in your HTML form.

For Numeric Masked Field:

For Float Masked Field.

Passing Variable No of Arguments to Oracle Stored Procedure

2011-02-16T14:34:00.000-08:00

If you want to pass variable number of arguments in a Oracle stored procedure, you can use array Type as stored procedure's parameter to accomplish this. Like in Java you can pass varargs as an array.

1- Create an Oracle nested table type in the database

CREATE OR REPLACE TYPE nt_type IS TABLE OF VARCHAR2(30);

2- Create a procedure in the database

CREATE OR REPLACE PROCEDURE nt_proc (nt nt_type) IS

i NUMBER;

BEGIN

FOR i IN nt.FIRST .. nt.LAST

LOOP

INSERT INTO nt_test(id, description) VALUES (i, nt(i));

END LOOP;

END nt_proc;

3- Create a test table, This is just for test purposes.

CREATE TABLE nt_test (id NUMBER, description VARCHAR2(30));

4- Create a module which defines the array of values

DECLARE

nt nt_type := nt_type(); -- nested table variable initialized to empty

BEGIN

nt := nt_type('Chester','Swindon','Corby','London','Swansea','Cardiff'); -- create your string of variables here

nt_proc(nt);

END;

SELECT * FROM nt_test;

Renaming Foreign Keys

2011-02-14T10:09:00.000-08:00

There is an Oracle DDL command which will rename a Foreign Key constraint:
SQL>ALTER TABLE <tablename> RENAME CONSTRAINT <foreign_key> TO <foreign_key_new_name>;
eg
SQL>ALTER TABLE emp RENAME CONSTRAINT SYS_C0017017 TO FK_EMP_DEPT;
I have written an Oracle stored procedure which shows how this can be done:
1)
CREATE OR REPLACE PROCEDURE rename_foreign_key(p_table_name IN VARCHAR2, p_foreign_key IN VARCHAR2, p_foreign_key_new VARCHAR2)
IS
l_action VARCHAR2(2000) := NULL;
  
  CURSOR c_uc(p_table_name VARCHAR2, p_fk VARCHAR2, p_fk_new VARCHAR2)
  IS
    SELECT 'ALTER TABLE ' || uc.table_name || ' RENAME CONSTRAINT ' || uc.constraint_name || ' TO ' || p_fk_new
    FROM  user_constraints uc 
    WHERE uc.table_name = p_table_name
    AND   uc.constraint_name = p_fk
    AND   uc.constraint_type = 'R';
BEGIN NULL;
  OPEN c_uc(p_table_name, p_foreign_key, p_foreign_key_new);
  FETCH c_uc INTO l_action;
  CLOSE c_uc;
  EXECUTE IMMEDIATE l_action;
END;
/
2) Example: create a master table DEPT and a child table EMP
CREATE TABLE dept (
deptno NUMBER(4) PRIMARY KEY,
dname VARCHAR2(14),
loc VARCHAR2(13));

CREATE TABLE emp (
empno NUMBER(4) PRIMARY KEY,
ename VARCHAR2(10),
deptno NUMBER(2),
FOREIGN KEY (DEPTNO) REFERENCES DEPT(DEPTNO));

3) Find the generated name for the foreign key in the EMP table
SELECT constraint_name FROM user_constraints WHERE table_name = 'EMP' AND constraint_type = 'R' AND generated = 'GENERATED NAME';
  --> SYS_C0017017
4) Rename SYS_C0017017 to FK_EMP_DEPT
SQL> EXEC rename_foreign_key('EMP','SYS_C0017017','FK_EMP_DEPT')

DOS Script to detect Windows/OS Version

2010-12-05T03:52:00.000-08:00

Simply save the following script in a .bat file and run, it will detect the OS version and will give you the results.

#----------------------------------------

# detectOS.bat

#----------------------------------------

@echo off

ver | find "2003" > nul

if %ERRORLEVEL% == 0 goto ver_2003

ver | find "XP" > nul

if %ERRORLEVEL% == 0 goto ver_xp

ver | find "2000" > nul

if %ERRORLEVEL% == 0 goto ver_2000

ver | find "NT" > nul

if %ERRORLEVEL% == 0 goto ver_nt

if not exist %SystemRoot%\system32\systeminfo.exe goto warnthenexit

systeminfo | find "OS Name" > %TEMP%\osname.txt

FOR /F "usebackq delims=: tokens=2" %%i IN (%TEMP%\osname.txt) DO set vers=%%i

echo %vers% | find "Windows 7" > nul

if %ERRORLEVEL% == 0 goto ver_7

echo %vers% | find "Windows Server 2008" > nul

if %ERRORLEVEL% == 0 goto ver_2008

echo %vers% | find "Windows Vista" > nul

if %ERRORLEVEL% == 0 goto ver_vista

goto warnthenexit

:ver_7

:Run Windows 7 specific commands here.

echo Windows 7

goto exit

:ver_2008

:Run Windows Server 2008 specific commands here.

echo Windows Server 2008

goto exit

:ver_vista

:Run Windows Vista specific commands here.

echo Windows Vista

goto exit

:ver_2003

:Run Windows Server 2003 specific commands here.

echo Windows Server 2003

goto exit

:ver_xp

:Run Windows XP specific commands here.

echo Windows XP

goto exit

:ver_2000

:Run Windows 2000 specific commands here.

echo Windows 2000

goto exit

:ver_nt

:Run Windows NT specific commands here.

echo Windows NT

goto exit

:warnthenexit

echo Machine undetermined.

:exit

#----------------------------------------

Oracle: Rename a column in a table

2010-11-18T13:26:00.000-08:00

Oracle provides "alter table" syntax to rename data columns in-place in this form:

ALTER TABLE
table_name
RENAME COLUMN
old_column_name
TO
new_column_name;

Here are the example of Oracle "alter table" syntax to rename data columns:

ALTER TABLE
pick_line
RENAME COLUMN
"VOLUME"
TO
"volume";

Dos Command to read JDK Path from registry

2010-11-13T01:31:00.000-08:00

These lines of code will get the JDK path from registry:

set KeyName=HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Development Kit
set Cmd=reg query "%KeyName%" /s
for /f "tokens=2*" %%i in ('%Cmd% ^| find "JavaHome"') do set JVM_HOME=%%j
echo Path is : %JVM_HOMPublish PostE%

Create Dependencies between Windows Services

2010-11-10T15:05:00.000-08:00

The following steps need to be performed in order to create a dependency.

1-Backup your current registry settings.

2-Run 'regedit' to open your registry.

3-Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and locate the
service that you need to set a dependency for.

4-Open the 'DependOnService' key on the right side. If the selected service does not have a 'DependOnService' key, then create one by right-clicking and selecting New > Multi-String Value.

5-In the value field, enter the names of all services that the current service will depend on. Each service name must be entered properly and on a separate line.

6-Click OK, close your registry and restart your machine.

Create Zip file of resources using Maven Assembly Plugin

2010-09-30T00:03:00.000-07:00

If you have some resources (xml files, properties files etc) that contains project properties to be substituted before generating the zip package of those resources. Probably Maven is pretty helpful to create it. For example you have some paths of DTD schema in your xml files that you need to resolve before generating the deployable resource package.
You need to use Maven Assembly plugin to generate a zip file. You have to create an assembly descriptor file that you will include in your POM file.
The assembly descriptor will look like. you can save it as (zip-descriptor.xml)

<assembly xmlns="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.0 " xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance "
xsi:schemaLocation="http://maven.apache.org/plugins/maven-assembly-plugin/assembly/1.1.0 http://maven.apache.org/xsd/assembly-1.1.0.xsd " >

<includeBaseDirectory >false </includeBaseDirectory >
<formats >
<format >zip </format >
</formats >
<fileSets >
<fileSet >
<directory >directory-name </directory >
<outputDirectory > </outputDirectory >
<filtered >true </filtered >
</fileSet >
</fileSets >
</assembly >

your POM file will look like. (POM.xml)

<project xmlns="http://maven.apache.org/POM/4.0.0 " xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance "
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd " >

<modelVersion >4.0.0 </modelVersion >
<groupId >iceland-picking </groupId >
<artifactId >iceland-picking </artifactId >
<version >0.0.1-SNAPSHOT </version >
<packaging >pom </packaging >
<name >iceland-picking </name >

<prerequisites >
<maven >2.2.0 </maven >
</prerequisites >

<properties >
<product.codename >codename </product.codename >
<product.name >product name </product.name >
<product.version >${project.version} </product.version >

<model.codename >${product.codename} </model.codename >
<model.name >${product.name } </model.name >
<model.version >${project.version} </model.version >

<metabase.version >1 </metabase.version >
<database.version >1 </database.version >
</properties >

<build >
<plugins >
<plugin >
<groupId >org.apache.maven.plugins </groupId >
<artifactId >maven-assembly-plugin </artifactId >
<configuration >
<descriptors >
<descriptor >zip-descriptor.xml </descriptor >
</descriptors >
<finalName >this will be the name of the output zip file </finalName >
<appendAssemblyId >false </appendAssemblyId >
</configuration >
<executions >
<execution >
<id >make-assembly </id >
<phase >package </phase >
<goals >
<goal >single </goal >
</goals >
</execution >
</executions >
</plugin >
</plugins >
</build >
</project >

For more details please visit the following Maven link:
1) http://maven.apache.org/guides/mini/guide-assemblies.html
2) http://maven.apache.org/plugins/maven-assembly-plugin/descriptor-refs.html

ORA-01000: maximum open cursors limit exceeded

2010-09-24T11:52:00.000-07:00

If you are getting ORA-01000 exception, it means you need to review your design or you need to optimize your code. You need to make sure that all the open cursors are being closed after they are finished being used in application.

To check amount of open cursors in Oracle simple run this query:

select count(*) from v$open_cursor;

To increase/decrease the amount of open cursors limit run the following query:

ALTER SYSTEM SET open_cursors = 1000 SCOPE=BOTH;

OPEN_CURSORS sets the maximum number of cursors each session can have open, per session. For example, if OPEN_CURSORS is set to 1000, then each session can have up to 1000 cursors open at one time. If a single session has OPEN_CURSORS # of cursors open, it will get an ora-1000 error when it tries to open one more cursor.

The default value for OPEN_CURSORS is 50, but Oracle recommends that you set this to at least 500 for most applications. Some applications may need more, eg. High volume web applications.

Only increase the OPEN CURSOR limit if your application really needs it, otherwise focus on releasing the unused cursors in your code. For example, In Java close ResultSet or Statement or Connection object as soon as you are finished with them.

Default Argument Value for Methods

2010-09-03T02:59:00.000-07:00

Like in C++, C#, PHP or SQL we can provide the default value for the argument that will be used in case when value is not supplied during method/function call. For example the following function declaration in C++:


void int someFun(int a, int b =0) {
      // some implementation here...
}

In the above function the last argument has a default value of 0, and it will be used when we will call this function by providing only one parameter, like;
someFun(5);
The above function call will give value 5 to argument “a” and 0 for argument “b”.
The same function can be called to provide both of the values, like:
someFun(5,10);
Fortunately/Unfortunately you can not declare a function/constructor with default values for arguments because experts say this is a bad implementation design. If you have to achieve the same kind of functionality the better way is to declare overloaded methods and call one with default value in other. For example:


void int someMethod(int a, int b ) {
      // some implementation here...
}
void int someMethod(int a) {
     // call overloaded method with default value of the argument
     someMethod(a, 0);
}

SQL SERVER: Creating Comma Separate Values List from Table Column

2010-08-12T08:07:00.001-07:00

There are two ways to generate a comma separated list from a table column. First is to manually concatenate the result and the second that is more sophisticated is to use the built-in function COALESCE of SQL Server.

Example Problem:
For example you have a table named COUNTRY that has a column named NAME, and you want to generate a comma separated list for countries.

Solution 1:
This is the simple but not the smartest way to implement it:

DECLARE @listStr VARCHAR(MAX)
SET @listStr = ''
SELECT @listStr = @listStr + ISNULL(NAME,'') + ','
FROM COUNTRIES
SELECT SUBSTRING(@listStr , 1, LEN(@listStr)-1)

Solution 2:
This is the smartest way:

DECLARE @listStr VARCHAR(MAX)
SELECT @listStr = COALESCE(@listStr+',' , '') + NAME
FROM COUNTRIES
SELECT @listStr

Javascript: Checkall/Uncheckall feature in the enclosing Form

2010-08-02T01:27:00.000-07:00

on the web page dynamically generated, I am having different number fo forms and in each form I have a list of checkboxes genererated dynamically.
The number of textboxes in a form may varry, but in each form the checkbox Id/name will have a certain prefix to identify.
The following piece of Java Script code can be used to checkall/uncheckall the checkboxes in a specific form on some event(button, checkbox or any other javascript event)

Simply place the following piece of code in the head section of your web page:



/**
   *Prototypes for JS functions
   */
  String.prototype.startsWith = function(str){return (this.match("^"+str)==str)}
  String.prototype.endsWith = function(str){return (this.match(str+"$")==str)}
  
  /**
   *START SEGMENT: 
   *Check/Uncheck all the checkboxes in the selector column of a report.
   */
  function getArray(formName,inputtype, prefix)
  {

   var checkBoxesArray=new Array();
    var count = 0;
   for(i=0; i < formName.elements.length ; i++)
   {
    var elmNameStr = formName.elements[i].name.toString(); 
    var elmName =formName.elements[i];
    
    //alert (elmName+ " :: elementName (startsWith): "+ elmNameStr.startsWith(prefix));
    
    if(formName.elements[i].type==inputtype  &&  elmNameStr.startsWith(prefix))
    {   
     checkBoxesArray[count++] = elmName;        
    }
   } 
   //alert(checkBoxesArray.length + " checkboxes found");
   return checkBoxesArray;
  }

  function checkall(elem,flag,pattren)
  {
   var form = findParentForm(elem);
    
   var arrayCheckboxes = getArray(form,"checkbox", pattren);
   
   for ( i = 0 ; i < arrayCheckboxes.length ; i++) {                
     arrayCheckboxes[i].checked = flag;      
   } 
  }
  
     function findParentForm(elem){   
   var parent = elem.parentNode;  
   if(parent  && parent.tagName != 'FORM'){
    parent = findParentForm(parent);
   }
   return parent;
   }

  /**
   *END SEGMENT:
   */

To call the checkall functionality, simply call "checkall" function as:

onclick="javascript:checkall(this, this.checked,'butt-');"

@param1: Element Id you are calling on the function, usually a checkbox
@param2: Current state of check box, whether the checkbox state is checked or unchecked. If this checkbox is checked then all the associated checkboxes should also be checkd and vice versa
@param3: String prefix for the checkbox Id/name pattern to identify the appropriate list.

Example:


 
 <form name ="formName0">
 
   check/uncheck all:   <input type ="checkbox" name ="test"  onclick="javascript:checkall(this, this.checked,'butt-');"/> <br/> 
   <hr/>
  Must Change State: <br/>
   <input type ="checkbox" name ="butt-1234"/>
   <input type ="checkbox" name ="butt-2141"/>
   <input type ="checkbox" name ="butt-3_abh"/>
   <input type ="checkbox" name ="butt-asgas"/>
   <input type ="checkbox" name ="butt-0"/>
   <hr/>
   Must have ignored:<br/>
   <input type ="checkbox" name ="abc"/>
   <input type ="checkbox" name ="def"/>
   
 </form>
 <hr/>
 <h3>  Form 2 </h3> 
 <form  name ="FormName1">
 <span>
  <div id ="asda" name ="divName">
   check/uncheck all:   <input type ="checkbox" name ="test"  onclick="javascript:checkall(this, this.checked,'selected-');"/> <br/> 
   <hr/>
    Must Change State: <br/>
   <input type ="checkbox" name ="selected-1af"/>
   <input type ="checkbox" name ="selected-wf2"/>
   <input type ="checkbox" name ="selected-3_abh"/>
   <input type ="checkbox" name ="selected-asgas"/>
   <input type ="checkbox" name ="selected-0"/>
   <hr/>
   Must have ignored:<br/>
   <input type ="checkbox" name ="selected_sabah"/>
   <input type ="checkbox" name ="abnsd"/>
 
  </div>
  </span>
 </form>
 Sabah u Din Irfan



SQL Server: To check all the advanced configuration of the SQL Server
2010-07-30T09:08:00.000-07:00
Run the following database script to check all the advanced configuration options

EXEC sp_configure 'Show Advanced Options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure;Sabah u Din Irfan


Javascript: How to Find the enclosing/parent FORM Element
2010-07-29T03:17:00.000-07:00
I was working on a project and came across a situation where we have more than one forms being generated dynamically in one page. And each form contains lots of input fields. To identify the enclosing/parent form element on some action of input tags, I used the following code:

Put these two javascript functions in script tag under head section of your page:


 function findParentForm(elem){   
   var parent = elem.parentNode;  
   if(parent  && parent.tagName != 'FORM'){
    parent = findParentForm(parent);
   }
   return parent;
   }

  function getParentForm( elem )
  {
     var parentForm = findParentForm(elem);
     if(parentForm){
    alert("Form found: ID = " + parentForm.id + " & Name = " +parentForm.name);
     }else{
    alert("unable to locate parent Form");
     }
      
  }




Here is the example to call  this code:


<body>
  <h3>  Form 1 </h3>
 <form name ="formName1"  id ="formId1">
   <span>
    <div>
   <input type ="button" name ="button1" value="button1" onclick="javascript:getParentForm(this);"/> <br/> 
    </div>
   </span>
   
 </form>
 <hr/>
 <h3>  Form 2 </h3> 
 <form  name ="FormName2" id ="formId2">
 <span>
  <div id ="asda" name ="divName">
 <input type ="button" name ="button1" value="button2" onclick="javascript:getParentForm(this);"/> <br/> 
  </div>
  </span>
 </form>
</body>


Sabah u Din Irfan


Oracle: Generate SQL script to drop all tables of any database
2010-07-23T05:41:00.001-07:00
In oracle there is no option to drop all the user tables, but you can achieve this by generating a scrip and run that script. 
To generate a script for dropping all the user tables, simply run this query and then run the result/output of this query.


SELECT 'DROP TABLE '||table_name|| '  CASCADE CONSTRAINTS;'
FROM user_tables;
Sabah u Din Irfan


Eclipse getting Out of Memory
2010-07-21T03:08:00.000-07:00
I installed latest version of JDK 1.6.21 and latest eclipse Halilos version to Windows 7 (32bit). Eclipse started crashing again and again after few minutes, giving me the out of Memory issue in logs.




Here is the exception log:


!ENTRY org.eclipse.ui 4 0 2010-07-21 09:08:30.662
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.OutOfMemoryError: PermGen space
  at java.lang.ClassLoader.defineClass1(Native Method)
  at java.lang.ClassLoader.defineClassCond(ClassLoader.java:632)
  at java.lang.ClassLoader.defineClass(ClassLoader.java:616)
  at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.defineClass(DefaultClassLoader.java:165)
  at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.defineClass(ClasspathManager.java:554)
  at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findClassImpl(ClasspathManager.java:524)
  at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClassImpl(ClasspathManager.java:455)
  at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass_LockClassLoader(ClasspathManager.java:443)
  at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:423)
  at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:193)
  at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:370)
  at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:446)
  at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:399)
  at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:387)
  at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:87)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
  at org.eclipse.wst.sse.ui.StructuredTextEditor.createActions(StructuredTextEditor.java:1277)
  at org.eclipse.ui.texteditor.AbstractTextEditor.createPartControl(AbstractTextEditor.java:3362)
  at org.eclipse.ui.texteditor.StatusTextEditor.createPartControl(StatusTextEditor.java:53)
  at org.eclipse.ui.texteditor.AbstractDecoratedTextEditor.createPartControl(AbstractDecoratedTextEditor.java:394)
  at org.eclipse.wst.sse.ui.StructuredTextEditor.createPartControl(StructuredTextEditor.java:1362)
  at org.eclipse.ui.part.MultiPageEditorPart.addPage(MultiPageEditorPart.java:217)
  at org.eclipse.ui.part.MultiPageEditorPart.addPage(MultiPageEditorPart.java:187)
  at org.eclipse.wst.xml.ui.internal.tabletree.XMLMultiPageEditorPart.addSourcePage(XMLMultiPageEditorPart.java:435)
  at org.eclipse.wst.xml.ui.internal.tabletree.XMLMultiPageEditorPart.createPages(XMLMultiPageEditorPart.java:605)
  at org.eclipse.ui.part.MultiPageEditorPart.createPartControl(MultiPageEditorPart.java:310)
  at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:661)
  at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:428)
  at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:594)
  at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:306)
  at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)
  at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)

Solution:

After struggling with this, I found this issue is due to the latest JDK v1.6.21. Best is to use  the stable version of JDK that is: JDK v 1.6.20 and configure it accordingly.
Hopefully it will resolve the issue, if still getting the issue add following line after "-vmargs" to your eclipse.ini file:
-XX:MaxPermSize=256m
The eclipse.ini file can be found under eclipse directory. It will be someting like this:

eclipse.ini 
--------------- 
-showsplash
org.eclipse.platform
--launcher.XXMaxPermSize
512M
-framework
plugins\org.eclipse.osgi_3.4.3.R34x_v20081215-1030.jar
-vm
C:\Program Files\Java\jdk1.5.0_22\bin
-vmargs
-XX:MaxPermSize=512m
-Dosgi.requiredJavaVersion=1.5
-Xms128m
-Xmx1024m
---------------Sabah u Din Irfan


Java Web Service: Developing SOAP Based Web Service via Apache Axis2
2010-07-14T08:28:00.001-07:00
Introduction:
Web service is a distribution software/application component that communicates using open protocols is self contained, self describing and can be discovered by UDDI (Universal Description, Discovery and Integration). Web Services can be used by other applications, or you can say other applications consume the web services. XML is the basis of the web services. XML is a language used to communicate between the different languages. Web Services are language independent and platform independent because all the vendors are agreed to use the common protocols and common way of communication using XML.
There are two main models for web services development in Java, REST based web services and SOAP/WSDL based web services.
REST based Web Services:- REST (REpresentational State Transfer) are resources in which every process is modeled as a unique URI. The protocol used in REST based web services is HTTP. These are not as secure, as flexible, as SOAP based web services. And only supports HTTP protocol.
SOAP/WSDL based Web Services:-  SOAP/WSDL-based web services uses Java utilities create a WSDL file based on the Java code in the web service. The WSDL is exposed on the net. Parties interested in using the web service create a Java client based on the WSDL. Messages are exchanged in SOAP format. The range of operations that can be passed in SOAP is much broader than what is available in REST, especially in security. SOAP-based web services are suitable for heavyweight applications using complicated operations and for applications requiring sophisticated security, reliability or other standards-supported features. They are also suitable when a transport protocol other than HTTP has to be used.

Apache Axis2 is an open-source implementation of the SOAP (Simple Object-Access Protocol) submission to the W3C. Axis2 not only supports SOAP 1.1 and SOAP 1.2, but it also has integrated support for RESTful web services.

We are going to develop a simple web service using Apache Axis2 using eclipse and Tomcat 6 as server.

Setting up the Environment:
Get Eclipse latest version from http://www.eclipse.org/downloads/
Download and install Tomcat 6.0 from the following location: http://tomcat.apache.org/download-60.cgi
Install Tomcat Plug-in for eclipse. Check the following post to get and configure the plugin: http://sabahmyrsh.blogspot.com/2010/07/sysdeo-eclipse-tomcat-launcher-plugin.html
Get the latest Apache Axis2 from the following location: http://ws.apache.org/axis2/download.cgi
Creating a Bottom up Java Bean Web Service:

Step 1:
First step is to configure the Axis2 with tomcat. To accomplish this unzip/extract the downloaded Axis version at any location of your hard drive. I am using this path for this example: C:\axis2\axis2-1.5

Then Open Eclipse and open:
Window -> Preferences -> Web Services -> Axis2 Preferences


Select the Axis2 Runtime tab and point to the correct Axis2 runtime location and click Apply and then Ok.

Step 2: 
Now we need to create a project with the support of Axis2 features. Open File -> New -> Other... -> Web -> Dynamic Web Project 



Click Next and provide project name as CalculatorWebService (you can use any name). Please select the following configurations:
• “Apache Tomcat v6.0” as Select Target runtime.
• “2.5” as Dynamic web module version 
• For Configuration, Press the Modify button.


Now tick the check boxes named as “Axis2 Web Services” and select OK.

After this you will be back on the New Dynamic Web Project. Click Finish. A new project will be created.

Step 3:
Now add a new package (myservices) and a plain Java class (Calculator). This Calculator class will contain methods that we will expose as web service. The methods we want to expose as web service must have public access.





Step 4:
Now Select Calculator.java, open File -> New -> Other... -> Web Services -> Web Service 




Click Next and you will be on the following screen. And make sure you Server rumtine is Tomcat v6.0 Server and Web Service Runtime should be Apache Axis2, if not you can configure these by clicking on the hyperlinks. For example to configure Web Service Runtime, click on the hyperlink highlighted as following.


And it will open a new screen to configure Apache Axis 2 runtime for you. Select Apache Axis2 from the list and click ok.

You will be back on Web Service Screen, click Next.




Again click Next.




Now Click Start Server button.

Now Click Finish. Your web service is created for your Calculator class and it is published to your Tomcat Server.
Step 5:
Right Click on the web service project and run as server.



Choose the server and click Finish.

You will see the following page in your integrated browser of eclipse.

Click on the services link encircled above and you can see your calculator service as following.

If you click on the Calculator link encircled above, you can see the WSDL generated by your web service. This WSDL you will use to create a wb service client. Please copy the link of WSDL:
http://localhost:8080/CalculatorWebService/services/Calculator?wsdl



The next step is to create a Web Service Client to test this web service.

Create a Web Service Client:
To create a web service client and test the web service, we will create a new project and will test this web service. Open File -> New -> Other... -> Web Services -> Web ServiceClient 



Click Next.

Paste the WSDL path in the service definition box and make sure you have the correct configurations as displayed in above snapshot. And click Next.


Now leave the default configurations on this screen and click Finish. I will generate a new project that will contain the Stub class that we can use to call the methods of web service.
Add a new class in the client project to test the web service methods like shown in the following snapshot. 



package myservices;

import java.rmi.RemoteException;
import org.apache.axis2.AxisFault;


public class CalculatorTestClient {

 /**
  * @param args
  * @throws RemoteException 
  */
 public static void main(String[] args) throws RemoteException {
  
  //Step 1: create an object of Stub class that is generated.
   CalculatorStub stub = new CalculatorStub();   
  //Step 2: Web Service Client has created inner classes in CalculatorStub for each of the web service method.
  //        We need to create the object of these classes to utilize the web service method.  
  CalculatorStub.Add add = new CalculatorStub.Add();  
  // Step 3: set the values for parameters for the web service method to call
  add.setA(45.67);
  add.setB(12.34);
  // Step 4: Now call the web service method using the stub object and assign it to specific response variable.
  CalculatorStub.AddResponse resp  = stub.add(add);
  // Step 5: Finally call the get_return method to retrieve the final result from response object.
  System.out.println(" Result for 45.78 + 12.34 = "+resp.get_return());
  
  
  
 }// end main

} // end class
Now finally, run this client as plain java program.  Right Click inside the Java class-->Run as-->Java Application. You can see the results on the console.






NOTE:
You can also use Netbeans to create SOAP based Apache Axis2 Web Services. For this please visit the following tutorial.
http://netbeans.org/kb/docs/websvc/gs-axis.html

Sabah u Din Irfan


Installation of Subclipse and Connecting to Repository
2010-07-08T02:13:00.000-07:00
Installation of Subclipse:
This blog will describe the installation of Subclipse directly through Eclipse.  Please note, for safety purposes, a separate instance of eclipse should be installed prior to installation of the repository.  

Information on Subclipse can be found here:
http://subclipse.tigris.org/

And new versions of Eclipse can be founder here:
http://www.eclipse.org

At the writing of this document, I am using Galileo release of Eclipse (Version 3.5.2).

Step 1
Goto Help menu, and select Install New Software...



Step 2
Add the site where Subclipse can be downloaded from.



Step 3
Select the checkbox that is next to the Subclipse name.  This will install all items required for Subclipse, and an additional merge utility. 



Step 4
Review the install details, and click next.  Then accept the license agreement presented after reviewing the install details.





Step 5
Once completed, and you hit next, the download of the plugin will occur.



Conclusion: Restart Eclipse...



Connecting to Repository:

Next step is to download the repository of your projects source. Unlike CVS, SVN represents branches and tags as files in the folder structure.  We want to be careful not to check out the entire repository.  If the entire repository is checked out, a representation of every tag and branch ever made for the application will be downloaded as a local copy to the hard drive.  This could consume a lot of disk space very carefully.

Create a new project in Eclipse from the SVN repository.  Select "Checkout Projects from SVN." Then click next.



If you do not have any repository yet, select "Create a new repository location" then click next. 



And provide the SVN repository path and click Next and then Finish.



Select the appropriate project listed (Not Shown here) and click Next.
Create a new project to add to your workspace.  Ensure "Check out HEAD revision_"_ and check out as a new project in your workspace, or use the New Project Wizard (not shown) to create a new project.




Use the default workspace, or one you already have defined.




The SVN Repository checkout will start right away.




Sabah u Din Irfan


Sysdeo Eclipse Tomcat Launcher plugin
2010-07-08T01:38:00.000-07:00
Plugin features
Starting and stopping Tomcat 4.x, 5.x and 6.x
Registering Tomcat process to Eclipse debugger
Creating a WAR project (wizard can update server.xml file)
Adding Java Projects to Tomcat classpath
Setting Tomcat JVM parameters, classpath and bootclasspath
Exporting a Tomcat project to a WAR File
Capability to use a custom Tomcat classloader to load classes in several java projects at the same classloader level than classes in a Tomcat project, see readmeDevLoader.html (Thanks Martin Kahr)
Download Link: 
http://www.eclipsetotale.com/tomcatPlugin.html#A3Sabah u Din Irfan


Apache Tomcat Version 7.0 is Released
2010-06-30T04:37:00.000-07:00
The new features provided in Apache Tomcat 7, including the new features in the Servlet 3.0, JSP 2.2 & EL 2.2 specifications, improvements in memory leak detection and prevention, new security features that can prevent CSRF attacks and session fixation attacks and a host of other new features.

Here is the official download link:

http://tomcat.apache.org/download-70.cgiSabah u Din Irfan


SQL: UDF to convert the seconds into MM:SS
2009-07-01T03:26:00.000-07:00
-- =============================================  
-- Author:Sabah u din Irfan
-- Create date: July/1/2009
-- Description:   A UDF to convert the seconds into MM:SS 
-- Example: select [dbo].[fn_SEC2MIN](36)
--          print dbo.fn_SEC2MIN ( 36045)
-- =============================================  
CREATE FUNCTION [dbo].[fn_SEC2MIN]( @Sec as int )  
RETURNS VARCHAR (15)   
AS  
BEGIN  
  

DECLARE @return AS VARCHAR (15)   
DECLARE @i_MM as INT  
DECLARE @i_SS as INT  
  
 SET @i_MM=0
 SET @i_SS=0
 SET @return = '00:00'

 IF ( @SEC >= 60 )  
  BEGIN  
   SET @i_MM = FLOOR(@Sec / 60 )  
   SET @i_SS = @Sec % 60   
  END  
 ELSE  
        BEGIN  
   SET @i_SS = @Sec
     
  END  
SET @return = case len(cast( @i_MM AS Varchar)) when 1 then right('00' + cast( @i_MM AS Varchar), 2 ) else cast( @i_MM AS Varchar) end +':'+ right('00' + cast( @i_SS AS Varchar), 2 )  
  
RETURN @return   

ENDSabah u Din Irfan


SQL: UDF to convert the seconds into HH:MM:SS
2009-07-01T03:12:00.000-07:00
-- =============================================  
-- Author:      Sabah u din Irfan
-- Description:   A UDF to convert the seconds into HH:MM:SS 
-- Example: SELECT fn_SEC2HHMMSS(65)
-- =============================================  
CREATE FUNCTION [dbo].[fn_SEC2HHMMSS]( @sec as int )  
RETURNS VARCHAR (15)   
AS  
BEGIN  


RETURN
 case len(convert(varchar(15),@sec/3600)) 
 when 1 
  then RIGHT('00'+convert(varchar(5),@sec/3600),2)
 else convert(varchar(15),@sec/3600)
end
+':'+RIGHT('0'+convert(varchar(5),@sec%3600/60),2)
+':'+RIGHT('0'+convert(varchar(5),(@sec%60)),2)
  

ENDSabah u Din Irfan


JSP: Defining Implicit Includes
2009-06-27T08:52:00.000-07:00
There are two implicit includes in JSP and both of these are configured in the deployment descriptor (web.xml) file.
1- One that is included in the beginning of every JSP matching the specified property group is called "include-prelude",
2- The other that is  included at the end of ever JSP page matching the specified property group is called "include-coda".
The include-prelude element is an optional subelement of       jsp-property-group. It has no subelements. Its value is a       context-relative path that must correspond to an element in the Web Application.       When the element is present, the given path will be automatically included (as in an       include directive) at the beginning of the JSP page in the       jsp-property-group. When there are more than one       include-prelude element in a group, they are to be included in       the order they appear. When more than one jsp-property-group       applies to a JSP page, the corresponding includeprelude elements will be processed in       the same order as they appear in the JSP configuration section of       web.xml.     
      The include-coda element is an optional subelement of       jsp-property-group. It has no subelements. Its value is a       context-relative path that must correspond to an element in the Web Application. When       the element is present, the given path will be automatically included (as in an       include directive) at the end of the JSP page in the       jsp-property-group. When there are more than one       include-coda element in a group, they are to be included in       the order they appear. When more than one jsp-property-group applies       to a JSP page, the corresponding include-coda elements will be       processed in the same order as they appear in the JSP configuration section      of web.xml. Note that these semantics are in contrast to the       way url-patterns are matched for other configuration elements.
      Preludes and codas follow the same rules as statically included JSP segments.      In particular, start tags and end tags must appear in the same file.     
      For example, the following web.xml fragment defines two groups.       Together they indicate that everything in directory /two/ have       /WEB-INF/jspf/prelude1.jspf and       /WEB-INF/jspf/prelude2.jspf at the beginning and       /WEB-INF/jspf/coda1.jspf and       /WEB-INF/jspf/coda2.jspf at the end, in that order, while other       .jsp files only have /WEB-INF/jspf/prelude1.jspf       at the beginning and /WEB-INF/jspf/coda1.jspf at the      end:      



<jsp-property-group >
 <url-pattern>*.jsp</url-pattern>
 <include-prelude>/WEB-INF/jspf/prelude1.jspf</include-prelude>
 <include-coda>/WEB-INF/jspf/coda1.jspf</include-coda>
</jsp-property-group>

<jsp-property-group>
 <url-pattern>/two/*</url-pattern>
 <include-prelude>/WEB-INF/jspf/prelude2.jspf</include-prelude>
 <include-coda>/WEB-INF/jspf/coda2.jspf</include-coda>
</jsp-property-group>Sabah u Din Irfan


JAVA: Reading Properties File
2009-05-13T05:44:00.000-07:00
public static String getProperty(String filePath,String property) throws java.io.IOException
    {
        String value="";
        java.io.File f = new java.io.File(filePath);
        if(f.exists()){
            java.util.Properties pro = new java.util.Properties();
            java.io.FileInputStream in = new java.io.FileInputStream(f);
            pro.load(in);
           
             value =pro.getProperty(property);
           
          }
        else
        {
            value="";
        }
        return value;
    }Sabah u Din Irfan


Sun Certified Web Component Developer for the Java Platform, Enterprise Edition 5 (CX-310-083)
2009-02-23T10:12:00.000-08:00
Details                      Delivered at: Authorized Worldwide Prometric Testing Centers
Prerequisites: Sun Certified Programmer for the Java Platform (any edition)
Exam type: Multiple Choice and Drag and Drop
Number of questions: 69
Pass score: 70% (49 of 69 questions)
Time limit: 180 minutes
                                                                                                                                                                                                Section 1: The Servlet Technology Model                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  For each of the HTTP Methods (such as GET, POST, HEAD, and so on) describe the purpose of the method and the technical characteristics of the HTTP Method protocol, list triggers that might cause a Client (usually a Web browser) to use the method; and identify the HttpServlet method that corresponds to the HTTP Method.
Using the HttpServletRequest interface, write code to retrieve HTML form parameters from the request, retrieve HTTP request header information, or retrieve cookies from the request.
Using the HttpServletResponse interface, write code to set an HTTP response header, set the content type of the response, acquire a text stream for the response, acquire a binary stream for the response, redirect an HTTP request to another URL, or add cookies to the response.
Describe the purpose and event sequence of the servlet life cycle: (1) servlet class loading, (2) servlet instantiation, (3) call the init method, (4) call the service method, and (5) call destroy method.
  
                                                                                        
                                                                                                                        Section 2: The Structure and Deployment of Web Applications                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  Construct the file and directory structure of a Web Application that may contain (a) static content, (b) JSP pages, (c) servlet classes, (d) the deployment descriptor, (e) tag libraries, (d) JAR files, and (e) Java class files; and describe how to protect resource files from HTTP access.
Describe the purpose and semantics of the deployment descriptor.
Construct the correct structure of the deployment descriptor.
Explain the purpose of a WAR file and describe the contents of a WAR file, how one may be constructed.
  
                                                                                        
                                                                                                                        Section 3: The Web Container Model                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  For the ServletContext initialization parameters: write servlet code to access initialization parameters; and create the deployment descriptor elements for declaring initialization parameters.
For the fundamental servlet attribute scopes (request, session, and context): write servlet code to add, retrieve, and remove attributes; given a usage scenario, identify the proper scope for an attribute; and identify multi-threading issues associated with each scope.
Describe the Web container request processing model; write and configure a filter; create a request or response wrapper; and given a design problem, describe how to apply a filter or a wrapper.
Describe the Web container life cycle event model for requests, sessions, and web applications;create and configure listener classes for each scope life cycle; create and configure scope attribute listener classes; and given a scenario, identify the proper attribute listener to use.
Describe the RequestDispatcher mechanism; write servlet code to create a request dispatcher; write servlet code to forward or include the target resource; and identify and describe the additional request-scoped attributes provided by the container to the target resource.
  
                                                                                        
                                                                                                                        Section 4: Session Management                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  Write servlet code to store objects into a session object and retrieve objects from a session object.
Given a scenario describe the APIs used to access the session object, explain when the session object was created, and describe the mechanisms used to destroy the session object, and when it was destroyed.
Using session listeners, write code to respond to an event when an object is added to a session, and write code to respond to an event when a session object migrates from one VM to another.
Given a scenario, describe which session management mechanism the Web container could employ, how cookies might be used to manage sessions, how URL rewriting might be used to manage sessions, and write servlet code to perform URL rewriting.
  
                                                                                        
                                                                                                                        Section 5: Web Application Security                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  Based on the servlet specification, compare and contrast the following security mechanisms: (a) authentication, (b) authorization, (c) data integrity, and (d) confidentiality.
In the deployment descriptor, declare a security constraint, a Web resource, the transport guarantee, the login configuration, and a security role.
Compare and contrast the authentication types (BASIC, DIGEST, FORM, and CLIENT-CERT); describe how the type works; and given a scenario, select an appropriate type.
  
                                                                                        
                                                                                                                        Section 6: The JavaServer Pages (JSP) Technology Model                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  Identify, describe, or write the JSP code for the following elements: (a) template text, (b) scripting elements (comments, directives, declarations, scriptlets, and expressions), (c) standard and custom actions, and (d) expression language elements.
Write JSP code that uses the directives: (a) 'page' (with attributes 'import', 'session', 'contentType', and 'isELIgnored'), (b) 'include', and (c) 'taglib'.
Write a JSP Document (XML-based document) that uses the correct syntax.
Describe the purpose and event sequence of the JSP page life cycle: (1) JSP page translation, (2) JSP page compilation, (3) load class, (4) create instance, (5) call the jspInit method, (6) call the _jspService method, and (7) call the jspDestroy method.
Given a design goal, write JSP code using the appropriate implicit objects: (a) request, (b) response, (c) out, (d) session, (e) config, (f) application, (g) page, (h) pageContext, and (i) exception.
Configure the deployment descriptor to declare one or more tag libraries, deactivate the evaluation language, and deactivate the scripting language. 6.7 Given a specific design goal for including a JSP segment in another page, write the JSP code that uses the most appropriate inclusion mechanism (the include directive or the jsp:include standard action).
  
                                                                                        
                                                                                                                        Section 7: Building JSP Pages Using the Expression Language (EL)                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  Given a scenario, write EL code that accesses the following implicit variables including pageScope, requestScope, sessionScope, and applicationScope, param and paramValues, header and headerValues, cookie, initParam and pageContext.
Given a scenario, write EL code that uses the following operators: property access (the . operator), collection access (the [] operator).
  
                                                                                        
                                                                                                                        Section 8: Building JSP Pages Using Standard Actions                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  Given a design goal, create a code snippet using the following standard actions: jsp:useBean (with attributes: 'id', 'scope', 'type', and 'class'), jsp:getProperty, jsp:setProperty (with all attribute combinations), and jsp:attribute.
Given a design goal, create a code snippet using the following standard actions:  jsp:include, jsp:forward, and jsp:param.
  
                                                                                        
                                                                                                                        Section 9: Building JSP Pages Using Tag Libraries                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  For a custom tag library or a library of Tag Files, create  the 'taglib' directive for a JSP page.
Given a design goal, create the custom tag structure in a JSP page  to support that goal.
Given a design goal, use an appropriate JSP Standard Tag Library (JSTL v1.1)  tag from the "core" tag library.
  
                                                                                        
                                                                                                                        Section 10: Building a Custom Tag Library                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  Describe the semantics of the "Classic" custom tag event model when each event method (doStartTag, doAfterBody, and doEndTag) is executed, and explain what the return value for each event method means; and write a tag handler class.
Using the PageContext API, write tag handler code to access the JSP implicit  variables and access web application attributes.
Given a scenario, write tag handler code to access the parent tag and  an arbitrary tag ancestor.
Describe the semantics of the "Simple" custom tag event model when the event method (doTag) is executed; write a tag handler class; and explain the constraints on the JSP content within the tag.
Describe the semantics of the Tag File model; describe the web application structure for tag files; write a tag file; and explain the constraints on the JSP content in the body of the tag.
  
                                                                                        
                                                                                                                        Section 11: Java EE Patterns                                
                            

                                                                                                                                                                                                                                                                                                                                                                                                  Given a scenario description with a list of issues, select a pattern that would solve the issues. The list of patterns you must know are: Intercepting Filter, Model-View-Controller, Front Controller, Service Locator, Business Delegate, and Transfer Object.
Match design patterns with statements describing potential benefits that accrue from the use of the pattern, for any of the following patterns: Intercepting Filter, Model-View-Controller, Front Controller, Service Locator, Business Delegate, and Transfer Object.
Sabah u Din Irfan


Sun Certified Programmer for the Java Platform, Standard Edition 5.0 (CX-310-055)
2009-02-11T12:06:00.000-08:00
                                                                Exam Objectives: 
http://www.sun.com/training/catalog/courses/CX-310-055.xml

                                                                                                                                                                                                                         Section 1: Declarations, Initialization and Scoping                                
                               

                                                                                                                                                                                                                                                                                                                                                                                                     Develop code that declares classes (including abstract and all forms of nested classes), interfaces, and enums, and includes the appropriate use of package and import statements (including static imports).
Develop code that declares an interface. Develop code that implements or extends one or more interfaces. Develop code that declares an abstract class. Develop code that extends an abstract class.
Develop code that declares, initializes, and uses primitives, arrays, enums, and objects as static, instance, and local variables. Also, use legal identifiers for variable names.
Develop code that declares both static and non-static methods, and - if appropriate - use method names that adhere to the JavaBeans naming standards. Also develop code that declares and uses a variable-length argument list.
Given a code example, determine if a method is correctly overriding or overloading another method, and identify legal return values (including covariant returns), for the method.
Given a set of classes and superclasses, develop constructors for one or more of the classes. Given a class declaration, determine if a default constructor will be created, and if so, determine the behavior of that constructor. Given a nested or non-nested class listing, write code to instantiate the class.
     
                                                                                              
                                                                                                                           Section 2: Flow Control                                
                               

                                                                                                                                                                                                                                                                                                                                                                                                     Develop code that implements an if or switch statement; and identify legal argument types for these statements.
Develop code that implements all forms of loops and iterators, including the use of for, the enhanced for loop (for-each), do, while, labels, break, and continue; and explain the values taken by loop counter variables during and after loop execution.
Develop code that makes use of assertions, and distinguish appropriate from inappropriate uses of assertions.
Develop code that makes use of exceptions and exception handling clauses (try, catch, finally), and declares methods and overriding methods that throw exceptions.
Recognize the effect of an exception arising at a specified point in a code fragment. Note that the exception may be a runtime exception, a checked exception, or an error.
Recognize situations that will result in any of the following being thrown: ArrayIndexOutOfBoundsException,ClassCastException, IllegalArgumentException, IllegalStateException, NullPointerException, NumberFormatException, AssertionError, ExceptionInInitializerError, StackOverflowError or NoClassDefFoundError. Understand which of these are thrown by the virtual machine and recognize situations in which others should be thrown programatically.
     
                                                                                              
                                                                                                                           Section 3: API Contents                                
                               

                                                                                                                                                                                                                                                                                                                                                                                                     Develop code that uses the primitive wrapper classes (such as Boolean, Character, Double, Integer, etc.), and/or autoboxing & unboxing. Discuss the differences between the String, StringBuilder, and StringBuffer classes.
Given a scenario involving navigating file systems, reading from files, or writing to files, develop the correct solution using the following classes (sometimes in combination), from java.io: BufferedReader,BufferedWriter, File, FileReader, FileWriter and PrintWriter.
Develop code that serializes and/or de-serializes objects using the following APIs from java.io: DataInputStream, DataOutputStream, FileInputStream, FileOutputStream, ObjectInputStream, ObjectOutputStream and Serializable.
Use standard J2SE APIs in the java.text package to correctly format or parse dates, numbers, and currency values for a specific locale; and, given a scenario, determine the appropriate methods to use if you want to use the default locale or a specific locale. Describe the purpose and use of the java.util.Locale class.
Write code that uses standard J2SE APIs in the java.util and java.util.regex packages to format or parse strings or streams. For strings, write code that uses the Pattern and Matcher classes and the String.split method. Recognize and use regular expression patterns for matching (limited to: . (dot), * (star), + (plus), ?, \d, \s, \w, [], ()). The use of *, +, and ? will be limited to greedy quantifiers, and the parenthesis operator will only be used as a grouping mechanism, not for capturing content during matching. For streams, write code using the Formatter and Scanner classes and the PrintWriter.format/printf methods. Recognize and use formatting parameters (limited to: %b, %c, %d, %f, %s) in format strings.
     
                                                                                              
                                                                                                                           Section 4: Concurrency                                
                               

                                                                                                                                                                                                                                                                                                                                                                                                     Write code to define, instantiate, and start new threads using both java.lang.Thread and java.lang.Runnable.
Recognize the states in which a thread can exist, and identify ways in which a thread can transition from one state to another.
Given a scenario, write code that makes appropriate use of object locking to protect static or instance variables from concurrent access problems.
Given a scenario, write code that makes appropriate use of wait, notify, or notifyAll.
     
                                                                                              
                                                                                                                           Section 5: OO Concepts                                
                               

                                                                                                                                                                                                                                                                                                                                                                                                     Develop code that implements tight encapsulation, loose coupling, and high cohesion in classes, and describe the benefits.
Given a scenario, develop code that demonstrates the use of polymorphism. Further, determine when casting will be necessary and recognize compiler vs. runtime errors related to object reference casting.
Explain the effect of modifiers on inheritance with respect to constructors, instance or static variables, and instance or static methods.
Given a scenario, develop code that declares and/or invokes overridden or overloaded methods and code that declares and/or invokes superclass or overloaded constructors. 
Develop code that implements "is-a" and/or "has-a" relationships.
     
                                                                                              
                                                                                                                           Section 6: Collections / Generics                                
                               

                                                                                                                                                                                                                                                                                                                                                                                                     Given a design scenario, determine which collection classes and/or interfaces should be used to properly implement that design, including the use of the Comparable interface.
Distinguish between correct and incorrect overrides of corresponding hashCode and equals methods, and explain the difference between == and the equals method.
Write code that uses the generic versions of the Collections API, in particular, the Set, List, and Map interfaces and implementation classes. Recognize the limitations of the non-generic Collections API and how to refactor code to use the generic versions.
Develop code that makes proper use of type parameters in class/interface declarations, instance variables, method arguments, and return types; and write generic methods or methods that make use of wildcard types and understand the similarities and differences between these two approaches.
Use capabilities in the java.util package to write code to manipulate a list by sorting, performing a binary search, or converting the list to an array. Use capabilities in the java.util package to write code to manipulate an array by sorting, performing a binary search, or converting the array to a list. Use the java.util.Comparator and java.lang.Comparable interfaces to affect the sorting of lists and arrays. Furthermore, recognize the effect of the "natural ordering" of primitive wrapper classes and java.lang.String on sorting.
     
                                                                                              
                                                                                                                           Section 7: Fundamentals                                
                               

                                                                                                                                                                                                                                                                                                                                                                                                     Given a code example and a scenario, write code that uses the appropriate access modifiers, package declarations, and import statements to interact with (through access or inheritance) the code in the example.
Given an example of a class and a command-line, determine the expected runtime behavior.
Determine the effect upon object references and primitive values when they are passed into methods that perform assignments or other modifying operations on the parameters.
Given a code example, recognize the point at which an object becomes eligible for garbage collection, and determine what is and is not guaranteed by the garbage collection system. Recognize the behaviors of System.gc and finalization.
Given the fully-qualified name of a class that is deployed inside and/or outside a JAR file, construct the appropriate directory structure for that class. Given a code example and a classpath, determine whether the classpath will allow the code to compile successfully.
Write code that correctly applies the appropriate operators including assignment operators (limited to: =, +=, -=), arithmetic operators (limited to: +, -, *, /, %, ++, --), relational operators (limited to: <, <=, >, >=, ==, !=), the instanceof operator, logical operators (limited to: &, |, ^, !, &&, ||), and the conditional operator ( ? : ), to produce a desired result. Write code that determines the equality of two objects or two primitives.
Sabah u Din Irfan


JavaScript: TRIM Function
2009-02-04T08:51:00.000-08:00
Following function is very helpful to trim the leading as well as trailing spaces in a string. To make use of this function, first add the following code snip(declaration) in your JS library or in head section of HTML.

 String.prototype.trim = function() {
a = this.replace(/^\s+/, '');
return a.replace(/\s+$/, '');
};



Then you may call this function like:

Example No:1

 alert("Test Case 1:" + " StrinValue                    ".trim()+"sabah" )

Example No:2

< name="textfieldid" type="text" onchange="this.value=this.value.trim()">Sabah u Din Irfan


JAVA ENUM Key Notes for SCJP
2009-01-30T07:48:00.000-08:00
Enumerations are set of closely related items, often called Type Safe Enum that are introduced in JDK 5. It is the better way to define constants, but it is more than that. you can read and test the examples from online sun tutorials on enums.

Couple of Key notes that I have noted are as followings:

enums are implicitly final subclasses of java.lang.Enum that is inherited from java.lang.Object.
As enums are implicitly final classes, so inheritance between enums or simple classes is not possible.
If an enum is member of a class it is implicitly static.
new keyword can never be used with enum.
name() and valueOf() methods simply use the text of enum constant.
Defualt implementation of toString() returns the name of the enum constant, but you can override its implementation.
For enum constants equals() and == amount to the same thing and can be used interchangebly.
enum constants are implicitly public, static and final
The order of appearance of enum constants is called their NATURAL ORDER 
There is a built in method named as values() that returns the array of all enum constants.
All instances of Enums are serializable by default. As Enums are subclasses of class java.lang.Enum, which implements the interface java.io.Serializable. If a class implements the interface java.io.Serialisable, its objects are serializable.
Enums are compiled to a .class file. 
An enum can define a main method and it can be executed as a standalone application
You can provide the abstract methods in the enum, but this abstract method needs to be implemented by all of the enum constants because we can not declare enum itself as abstract. Simply We cannot define abstract enums.
Enums cannot be instantiated, we can only create the reference of an enum
Enums may be used as a operand for the instanceof operator in the same way that it can be used by a class
Enums can be used in switch statements. 
An enum can define more than 1 constructor (similar to a class) and its constructor can accept more than 1 method parameter. Please note we can not create the actual object using new like we do with classes.
name() is a final method, which cannot be overridden. It returns the name of the enum constant, exactly as declared in its enum declaration. 
Constructors for an enum type should be declared as private. The compiler allows non
private declares for constructors, but this seems misleading to the reader, since new can
never be used with enum types.
Constructor of enum can only be private or default. public and protected are not allowed with constructor of Enum.
Enum can implement interface.
Enums cannot be declared within a method!
Sabah u Din Irfan


UET Lahore among the top world ranking universities (2008)
2009-01-19T23:55:00.000-08:00
The University of Engineering and Technology, Lahore has been placed at 592 among the top ranked Universities of the world in World Ranking Universities 2008.
            It is a remarkable achievement for UET, Lahore that it has got international recognition.
            It is also worth noting that only Four Pakistani Universities including UET, Lahore are included in the World Ranking 2008.
           
            http://www.topuniversities.com/university_rankings/results/2008/overall_rankings/fullrankings/Sabah u Din Irfan


JAVA: Named Inner-class Listeners
2009-01-14T10:43:00.000-08:00
Defining an inner class listener to handle events is a very popular style.

     Access:-Use an inner class rather than an outer class to access instance variables of the enclosing class. In the example below, the txt1, txt2, txt3 can be referenced by the listener class. Because simple program listeners typically get or set values of other widgets in the interface, it is very convenient to use an inner class.
     Reuse:-Unlike anonymous inner class listeners, it's easy to reuse the same listener for more than one control, eg, the click of a button might perform the same action as the equivalent menu item, and might be the same as hitting the enter key in a text field.
    Organization:- It's easier to group all the listeners together with inner classes than with anonymous inner class listeners.

EXAMPLE No:1 Using One Inner class for different Events

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.*;

/***
*
* @author Sabah u Din Irfan
* @Description ActionListener Example Using Named Inner Classes
*
***/
public class ActionListenerInnerClassDemo extends JFrame{

JLabel lbl ;
JTextField txt1;
JTextField txt2;
JTextField txt3;
JButton btnAdd;
JButton btnSub;

ActionListenerInnerClassDemo()
{
// Set Frame Window properties
super("Action Listner Demo!!");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
// Get Container
Container container = getContentPane();
container.setLayout(new FlowLayout());
// Create Components
lbl = new JLabel(" Please Enter two values in text fields:");
txt1 = new JTextField(15);
txt2 = new JTextField(15);
txt3 = new JTextField(15);
btnAdd = new JButton("Add");
btnSub = new JButton("Sub");
// Add Components

container.add(lbl);
container.add(txt1);
container.add(txt2);
container.add(txt3);
container.add(btnAdd);
container.add(btnSub);

// Add Action Listners.. Use Annonymous Inner Classes
MyListener listener = new MyListener();

btnAdd.addActionListener(listener);
btnSub.addActionListener(listener);

// Make frame visible and set its size
setVisible(true);
pack();
} // end of Constructor

// Private Named Inner Class to Handle the Events
//////////////////////////////////////////////////////
private class MyListener implements ActionListener
{
     public void actionPerformed(ActionEvent e) {
         if ( e.getSource() == btnAdd)
         {
          int a = Integer.parseInt(txt1.getText());
  int b = Integer.parseInt(txt2.getText());

  int c = a+b;

  txt3.setText(c+"");
         }
         else if( e.getSource() == btnSub)
         {
          int a = Integer.parseInt(txt1.getText());
  int b = Integer.parseInt(txt2.getText());

  int c = a-b;

  txt3.setText(c+"");
         }
      
     }
 }// end named inner class MyListener
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
 ActionListenerInnerClassDemoframe = new ActionListenerInnerClassDemo();

}

}

EXAMPLE No:2 Using Different Inner classes for different Events


import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;

/***
*
* @author Sabah u Din Irfan
* @Description ActionListener Example Using Named Inner Classes
*
***/
public class ActionListenerInnerClassDemo extends JFrame{

 JLabel lbl ;
 JTextField txt1;
 JTextField txt2;
 JTextField txt3;
 JButton btnAdd;
 JButton btnSub;
 
 ActionListenerInnerClassDemo()
 {
  // Set Frame Window properties
  super("Action Listner Demo!!");
  setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  // Get Container
  Container container = getContentPane();
  container.setLayout(new FlowLayout());
  // Create Components
  lbl = new JLabel(" Please Enter two values in text fields:");
  txt1 = new JTextField(15);
  txt2 = new JTextField(15);
  txt3 = new JTextField(15);
  btnAdd = new JButton("Add");
  btnSub = new JButton("Sub");
  // Add Components
  
  container.add(lbl);
  container.add(txt1);
  container.add(txt2);
  container.add(txt3);
  container.add(btnAdd);
  container.add(btnSub);
  
  // Add Action Listners.. Use Annonymous Inner Classes
  AddListener addlistener = new AddListener();
  SubListener sublistener = new SubListener();
  
  btnAdd.addActionListener(addlistener);
  btnSub.addActionListener(sublistener);
  
  // Make frame visible and set its size
  setVisible(true);
  pack();
  } // end of Constructor
 
 // Private Named Inner Classes to Handle the Events
 //////////////////////////////////////////////////////
 private class AddListener implements ActionListener
 {
       public void actionPerformed(ActionEvent e) {
          
            int a = Integer.parseInt(txt1.getText());
    int b = Integer.parseInt(txt2.getText());
    
    int c = a+b;
    
    txt3.setText(c+"");         
       }
   }// end named inner class
 private class SubListener implements ActionListener
 {
       public void actionPerformed(ActionEvent e) {
          
            int a = Integer.parseInt(txt1.getText());
    int b = Integer.parseInt(txt2.getText());
    
    int c = a - b;
    
    txt3.setText(c+"");         
       }
   }// end named inner class MyListener
 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  ActionListenerInnerClassDemo frame = new ActionListenerInnerClassDemo();
   
 }

}

Sabah u Din Irfan


JAVA: Anonymous Listeners
2009-01-14T10:29:00.001-08:00
There is no need to define a named class simply to add a listener object to a button. Java has a somewhat obscure syntax for creating an anonymous innner class listener that implements an interface.  There is no need to memorize the syntax; just copy and paste it each time.   For example,  class myPanel extends JPanel {
. . .
   public MyPanel() {
       . . .  //in the constructor
       JButton b1 = new JButton("Hello");
       b1.addActionListener(
           new ActionListener() {
               public void actionPerformed(ActionEvent e) {
                   // do something for button b1
               }
           }
       );
   Creates a class
 The above example creates a subclass of Object that  implements the ActionListener interface. The compiler creates names for anonymous classes.  The JDK typically uses the enclosing class name followed by $ followed by a number, eg, you may see a MyPanel$1.class  file generated by the compiler.  

ActionListener Example Using Anonymous Inner Classes
-------------------------------------------------------------



import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;

/****
 *
 * @author Sabah u Din Irfan
 * @Description ActionListener Example Using Anonymous Inner Classes
 */
public class ActionListnerDemo extends JFrame{

    JLabel lbl ;
    JTextField txt1;
    JTextField txt2;
    JTextField txt3;
    JButton btnAdd;
    JButton btnSub;
    
    ActionListnerDemo()
    {
        // Set Frame Window properties
        super("Action Listner Demo!!");
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        // Get Container
        Container container = getContentPane();
        container.setLayout(new FlowLayout());
        // Create Components
        lbl = new JLabel(" Please Enter two values in text fields:");
        txt1 = new JTextField(15);
        txt2 = new JTextField(15);
        txt3 = new JTextField(15);
        btnAdd = new JButton("Add");
        btnSub = new JButton("Sub");
        // Add Components
        
        container.add(lbl);
        container.add(txt1);
        container.add(txt2);
        container.add(txt3);
        container.add(btnAdd);
        container.add(btnSub);
        
        // Add Action Listners.. Use Annonymous Inner Classes
        
        btnAdd.addActionListener( new ActionListener() {
            
            public void actionPerformed(ActionEvent e) {
                int a = Integer.parseInt(txt1.getText());
                int b = Integer.parseInt(txt2.getText());
                
                int c = a+b;
                
                txt3.setText(c+"");
                
            }
        }
        );
        
        ////////////////////
        btnSub.addActionListener( new ActionListener() {
            
            public void actionPerformed(ActionEvent e) {
                int a = Integer.parseInt(txt1.getText());
                int b = Integer.parseInt(txt2.getText());
                
                int c = a-b;
                
                txt3.setText(c+"");
                
            }
        }
        );
        
        // Make frame visible and set its size
        setVisible(true);
        pack();
    }
    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
            ActionListnerDemo frame = new ActionListnerDemo();
            
    }

}
Sabah u Din Irfan


Javascript: Function To Check Whether TextField is ReadOnly
2009-01-10T06:21:00.000-08:00
The following Javascript function can be used to check whether the given control is read only or not?

Sample 1:

function isReadOnly()
{
    var m = document.getElementById("TextBox1").getAttribute("Readonly");
   if (m==true)
   {
       alert('Read Only!');
       return true;
   }
   else
   {
     alert('Not Read Only');
    return false;
   }

}

Sample 2:


function isReadOnly(controlID)
{
    var m = document.getElementById(controlID).getAttribute("Readonly");

    if (m==true)
   { 
     alert('Read Only!');
       return true;
  }
   else
   {
     alert('Not Read Only');
    return false;
   }

 }Sabah u Din Irfan


JavaScript: Masking on Text Field
2009-01-09T08:03:00.000-08:00
It is quite often that when we create HTML forms we need masking in fields and most of the times in text fields(Text Boxes) for some specific type of input like for DATE, PHONE NO, CURRENCY etc.  Couple of server side technologies provide built in controls for most common masking but a few does not.

The following Javascript function provides you the facility to customize you text boxes with specific masking.

For Example, you may need masking  for data input like : DD/MM/YYYY e.g 31/12/2008
Similarly sometimes you may want to provide masking like: 121-23-1231
and sometimes you may want to provide masking like: 12-42-1412

The following function is smart enough to handle all these requirements with a little change in the input parameter.

function mask(str,textbox,loc,delim){
var locs = loc.split(',');

for (var i = 0; i <= locs.length; i++){
    for (var k = 0; k <= str.length; k++){
     if (k == locs[i]){
      if (str.substring(k, k+1) != delim){
        str = str.substring(0,k) + delim + str.substring(k,str.length)
      }
     }
    }
 }
textbox.value = str
}

Where the parameters are for:
str - the value of the current textbox control,  
textbox - the actual textbox object, (so that the value can be set)  
loc - a string of multiple locations to place the specified character,  
delim - the character (delimiter) that you want to use a separator. 
Examples to Call this function:

Step 1:
 First of all add this function in the head section.

Step 2:
You need to call this function on onKeyUp & onBlur events like:

To provide the output like(121-23-1231): 

You need to call this javascript function like:
< name="Field1" value="" type="text" onkeyup="javascript:return mask(this.value,this,'3,6','-');" onblur="javascript:return mask(this.value,this,'3,6','-');" style="font-family:verdana;font-size:10pt;width:110px;" maxlength="11">



To provide the output like(21/12/2009): 

You need to call this javascript function like:
< name="Field2" value="" type="text" onkeyup="javascript:return mask(this.value,this,'2,5','/');" onblur="javascript:return mask(this.value,this,'2,5','/');" style="font-family:verdana;font-size:10pt;width:110px;" maxlength="10">


To provide the output like(12,23,2312): 
 
 You need to call this javascript function like:
< name="Field3" value="" type="text" onkeyup="javascript:return mask(this.value,this,'2,5',',');" onblur="javascript:return mask(this.value,this,'2,5',',');" style="font-family:verdana;font-size:10pt;width:110px;" maxlength="10">

 To provide the output like(12#32#1312): 
  
  You need to call this javascript function like:
< name="Field3" value="12#32#1312" type="text" onkeyup="javascript:return mask(this.value,this,'2,5','#');" onblur="javascript:return mask(this.value,this,'2,5','#');" style="font-family:verdana;font-size:10pt;width:110px;" maxlength="10">

You may change your mask symbol and the places accordingly using the provided parameters.Sabah u Din Irfan


Javascript: Function To Validate Date Format DD/MM/YYYY
2009-01-08T07:59:00.002-08:00
Please use the following java script to validate the Date in the format(DD/MM/YYYY) wherever you needed in transcription screens:

Place this code in the head section of your HTML/JSP and pass the value(12/12/2008) to function named as validateDateDDMMYYY(‘12/12/2008’)


function validateDateDDMMYYY(DateOfBirth)
  {

   var Char1 = DateOfBirth.charAt(2);
   var Char2 = DateOfBirth.charAt(5);
   //    alert(Char1);    alert(Char2);

   var flag =false;
 
   if ( Char1 =='/' && Char2 == '/' )
    {
       //       alert ('valid positions of non numeric characters.');
       flag = true;
    }
    else
    {
       //      alert('invalid position of non numeric symbols');
       flag =false;
    }
     
    var day;
    var month;
    var year;
  
    day = DateOfBirth.substring(0,2);
    month = DateOfBirth.substring(3,5);
     year = DateOfBirth.substring(6,10);
  
//     alert(day); alert(month);alert(year);
    if( validDay(day) && validMonth(month) && validYear(year) && (flag ==true) )
    {
     // alert(' Valid Date')
     return true;
    }
     else
    {
      alert('Invalid  Date Format: Please enter DD/MM/YYYY for Date of Birth!');
      return false;
    }
    
 } // end func

function IsNumeric(sText)
{
   var ValidChars = "0123456789.";
   var IsNumber=true;
   var Char;
     
   for (i = 0; i < sText.length && IsNumber == true; i++)    
{    
        Char = sText.charAt(i);    
         if (ValidChars.indexOf(Char) == -1)    
          {    
              IsNumber = false;    
          }
 }

 return IsNumber;  
} // end func      


function validDay(day)  
{    
        if ( IsNumeric(day) )    
            {
                   if( day >0 && day <32)        
                     {         
                        return true;        
                     }
                     else
                    {          
                       return false;        
                    }
           }
         else     
          {
             return false;
           }
  
    }// end func    


function validMonth(month)  
 {
         if ( IsNumeric(month) )    
           {       
                 if( month >0 && month <13)        
                     {         
                            return true;        
                       }
                  else        
                     {          
                           return false;        
                      }         
           }
           else     
           {      
               return false;     
            }
  }// end func    



function validYear(year)  
 {      
            var d = new Date();      
            var currentYear = d.getFullYear();            

           if( year.length!= 4)       {                return false;        }          

         if ( IsNumeric(year) )
         {       
                 if( year >0 && year <=currentYear)
                  {
                      return true;
                   }
                  else
                  {
                      return false;
                   }
  
          }
          else
         {
             return false;
          }
 
 }// end funcSabah u Din Irfan


Javascript: Function To Validate Date Format DD/MM/YYYY
2009-01-08T07:59:00.001-08:00
unhidewhenused="false" name="Medium Grid 2 Accent 1">                                                                                                                                                                                                                                                           Pleas


function validateDateDDMMYYY(DateOfBirth)
  {

   var Char1 = DateOfBirth.charAt(2);
   var Char2 = DateOfBirth.charAt(5);
   //    alert(Char1);    alert(Char2);

   var flag =false;
 
   if ( Char1 =='/' && Char2 == '/' )
    {
       //       alert ('valid positions of non numeric characters.');
       flag = true;
    }
    else
    {
       //      alert('invalid position of non numeric symbols');
       flag =false;
    }
     
    var day;
    var month;
    var year;
  
    day = DateOfBirth.substring(0,2);
    month = DateOfBirth.substring(3,5);
     year = DateOfBirth.substring(6,10);
  
//     alert(day); alert(month);alert(year);
    if( validDay(day) && validMonth(month) && validYear(year) && (flag ==true) )
    {
     // alert(' Valid Date')
     return true;
    }
     else
    {
      alert('Invalid  Date Format: Please enter DD/MM/YYYY for Date of Birth!');
      return false;
    }
    
 } // end func

function IsNumeric(sText)
{
   var ValidChars = "0123456789.";
   var IsNumber=true;
   var Char;
     
   for (i = 0; i < sText.length && IsNumber == true; i++)     {     Char = sText.charAt(i);     if (ValidChars.indexOf(Char) == -1)     {     IsNumber = false;     }     }     return IsNumber;   } // end func       function validDay(day)   {     if ( IsNumeric(day) )     {        if( day >0 && day <32)         {          return true;         }         else         {           return false;         }          }      else      {       return false;      }       }// end func     function validMonth(month)   {     if ( IsNumeric(month) )     {        if( month >0 && month <13)         {          return true;         }         else         {           return false;         }          }      else      {       return false;      }       }// end func     function validYear(year)   {       var d = new Date();       var currentYear = d.getFullYear();             if( year.length!= 4)       {               return false;       }           if ( IsNumeric(year) )     {        if( year >0 && year <=currentYear)
       {
        return true;
       }
       else
       {
         return false;
       }
  
   }
    else
    {
     return false;
    }
 
 }// end func


Sabah u Din Irfan


SQL Server: WAITFOR TIME Statement
2009-01-03T07:57:00.000-08:00
WAITFOR TIME SQL statement is used to set the particular time to execute the next query/SQL statement.

For Example the second query will execute when the particular time will be reached:

DECLARE @MyDateTime DATETIME
/* Add 5 seconds to current time so
system waits for 15 seconds*/
SET @MyDateTime = DATEADD(s,15,GETDATE())
SELECT GETDATE() CurrentTime
WAITFOR TIME @MyDateTime
SELECT GETDATE() CurrentTimeSabah u Din Irfan


SQL Server: WAITFOR DELAY Statement to set Delay in Queries
2009-01-03T07:54:00.000-08:00
WAITFOR DELAY statement is used in T-SQL to set the delay time between the SQL queries. For example the second query will execute after 10 seconds of delay:

SELECT GETDATE() CurrentTime
WAITFOR DELAY ‘00:00:10′ —- 10 Second Delay
SELECT GETDATE() CurrentTime 
Sabah u Din Irfan


Javascript: Making Initial Letter Capital for text box
2008-11-20T07:32:00.000-08:00
Following script will work to make the initial letter in your text box automatically.

I have placed this in onKeyup event, you can use it according to your own requirements.

onkeyup=
"this.value=this.value.substring(0,1).toUpperCase()
+this.value.substring(1,this.value.length)"

Here is the example:

Sabah u Din Irfan


JavaScript: Function To Check Whether provided string contains some wildcard character
2008-11-13T05:01:00.000-08:00
The following function returns true if the string value contains the specific wild-card character.

Parameters:

1- fieldValue -- String 

     It is a string that needs to be checked whether it contains some special/wildcard characters

2- wildChar -- String/ Single Char
It is a character that you want to search whether it is present in the string passed as first parameter of this function.


function containsWildCard(fieldValue, wildChar)
 {
  //   var fieldValue =  window.document.getElementById("fieldID").value;
            if (fieldValue.split(wildChar).length > 1)
         {
                alert ("WildCard!");
                return false;
         }
         else
        {
                 alert ("No - WildCard!");
                 return true;
         }
 
 }Sabah u Din Irfan


Javascript: Function To Get Currrent Time
2008-11-03T04:50:00.000-08:00
function getCurrentTime()
  {
  var d = new Date();
  
  var hour=d.getHours();
  var minute=d.getMinutes();
  var second=d.getSeconds();
  
  if(hour<10)
  {
  hour = '0'+hour;
  }
  if(minute<10)
  {
  minute= '0'+minute;
  }
  
  if(second<10)
  {
  second= '0'+second;
  }
  
  var time =hour+':'+minute+':'+second

   return time;
   }Sabah u Din Irfan


JAVA Certification Track Summary
2008-10-16T06:40:00.000-07:00
JAVA Certification Track


1. Sun Certified Associate for the Java Platform, Exam Version  1.0 (CX-310-019)
Delivered at: Authorized Prometric Testing Centers  
Prerequisites: None  
Other exams/assignments required for this certification: None  
Exam type: Multiple choice and Drag and Drop  
Number of questions: 51  
Pass score: 68% (35 of 51 questions)  
Time limit: 115 
2. Sun Certified Java Programmer, Standard Edition 6 (CX-310-065)
Delivered at: Authorized Worldwide Prometric Testing Centers  
Prerequisites: None  
Other exams/assignments required for this certification: None  
Exam type: Multiple choice and drag and drop  
Number of questions: 72  
Pass score: 65% (47 of 72 questions)  
Time limit: 210 minutes 
3.  Sun Certified Web Component Developer (SCWCD)
Delivered at: Delivered at: Authorized Worldwide Prometric Testing Centers
Prerequisites: Sun Certified Programmer for the Java Platform (any edition)
Exam type: Multiple Choice and Drag and Drop
Number of questions: 69
Pass score: 70% (49 of 69 questions)
Time limit: 180 minutes
4. Sun Certified Business Component Developer (SCWCD)
Delivered at: Authorized Worldwide Prometric Testing Centers
Prerequisites: Sun Certified Programmer for the Java 2 Platform (any edition)
Exam type: Multiple-Choice, Scenario-based questions and Drag-and-Drop questions
Number of questions: 61
Pass score: 59% (36 of 61 questions)
Time limit: 145 minutes
5. Sun Certified Developer for Java Web Services (SCDJWS)
Delivered at: Authorized Worldwide Prometric Testing Centers
Prerequisites: Sun Certified Programmer for the Java 2 Platform (any edition)
Other exams/assignments required for this certification: None
Exam type: Multiple choice, drag and drop
Number of questions: 69
Pass score: 68% (47 items of 69 questions)
Time limit: 150 minutes
6. Sun Certified Mobile Application Developer (SCMAD)
Delivered at: Authorized Worldwide Prometric Testing Centers
Prerequisites: Sun Certified Programmer for the Java 2 Platform (any edition)
Exam type: Multiple choice, drag and drop
Number of questions: 68
Pass score: 55% (38 items of 68)
Time limit: 150 minutes
7. Sun certified Java Developer (SCJD)

This exam consists of two parts first part is an programming assignment. The scale of the assignment can be imagined by the lines of code; roughly this assignment consists of 3500 lines of code.

The second part of this exam is an essay type consisting of four different questions that are related from your programming assignment of part one.

PART ONE:
Delivered at: CertManager database
Prerequisites: Must be Sun Certified Programmer for the Java Platform (any edition)
Other exams/assignments required for this certification: Step 2 (CX-310-027)
Exam type: Programming assignment
Number of questions: N/A
Pass score: 320 points out of 400 possible points *
Time limit: None
Categories - Maximum points

 General Considerations - 80
  Documentation - 50
  Object-Oriented Design - 50
  GUI - 70
  Locking - 80
  Language Fluency - 70

APIs relevant to the assignment
Thread handling and synchronization
Swing (and AWT to the extent necessary to support Swing)
Standard file IO (java.io, not java.nio)
Either: Socket-based network programming and serialization _or_ Java RMI (Java Remote Method Invocation) (your choice of one or the other, not both)
APIs and facilities may not be used:  Enterprise JavaBeans
Servlets, JSP technology, or any other web-oriented APIs
NIO, the New IO facilities
Java DataBase Connectivity (JDBC) and SQL
Java IDL API and CORBA
Third party software libraries or tools (such as browsers)
PART TWO:
Delivered at: Authorized Prometric testing centers
Prerequisites: Must be Sun Certified Programmer for the Java Platform (any edition) Completion of Step 1 (CX-310-252A)
Other exams/assignments required for this certification: Step 1 (CX-310-252A)
Exam type: Essay
Number of questions: 4
Pass score: Subject to the evaluation of the essay exam and validation of the
Time limit: 120 minutes
Sabah u Din Irfan


JavaScript: Ways to Hit Server Side using JavaScript
2008-09-01T09:32:00.000-07:00
There are three ways to hit the server side application using JavaScript that may be some servlet/JSP/CGI Script. Following are the ways:

Use AJAX to hit the Server Side. You can get the details on this from following post: http://www.codeproject.com/KB/ajax/SimpleAJAX.aspx
Second way is to submit the form data using the JavaScript. Following sample JavaScript function will perform the required task. Make sure you place this function in your HEAD tag of HTML in a script tag.



    function goForward()     {
        // alert ("Go Forward ..... ");
        frm=document.forms[0];
        frm.method="GET"; // POST
          
        frm.action="ServerSidePage.jsp";//Some servlet/Some CGI Script/URL        
         frm.submit();    
      }

        3. You can use the "document.location.href", and you can specify the server side path of any servlet/JSP/ CGI Script/ Other URL.

Example No:1
The following code segment will display an button on your page and when u will click on it, it will open the Google page.

"< i n p u t name="myButt" value="Call Server Side" onclick="document.location.href='http://www.google.com'" type="button" >

This  example will look like this:


Example No:2

In this example, we select the an item from the drop down list and it will go to the page that you have specified in the value of selected option.

Place the following method in your HEAD section of HTML:

function callURL()
  {
      document.location.href= document.formName.SelectListID.options[document.formName.SelectListID.selectedIndex].value
  }


Andplace the following code in body section of your HTML:

"
< f o r m name="formName">
< s e l e c t name="SelectListID" onchange="callURL();"> < o p t i o n value="http://www.sabahmyrsh.blogspost.com" select e d="selected">select an item from List:< o p t i o n value="http://www.alislam.org">AlIslam

Javascript function similar to Sleep of JAVA
2008-08-22T11:02:00.000-07:00
Here is a Javascript function that works similar to the Thread.sleep(milliseconds) method of JAVA.

The code of the JavaScript function is as under:

         function pause(numberMillis) 
         {
             var now = new Date();
             var exitTime = now.getTime() + numberMillis;
             while (true) 
             {
                 now = new Date();
                 if (now.getTime() > exitTime)
                     return;
             }
         } 

You need to call this function like
pause(1000) ;
to wait a second!Sabah u Din Irfan


JavaScript: Print Button on Your Web Page
2008-08-18T09:54:00.000-07:00
It is fairly simple to add a PRINT Button on your web pages using JavaScript. The best practise to provide the facility of printing on web page is to provide a page that does not contain the banners/headers/footers/menus etc.
For this just create another web page containing only the data you actually need to print; For this make sure the background is not dark or does not contains the darked background image. etc

You can use simple JavaScript built in method window.print(). For example the following code segment will place a print link on your webpage using the img tag of HTML.

< i m g  onclick="window.print();" src="/images/PrinterIcon.gif"
style="cursor:hand;" />

(Replace the text /images/PrinterIcon.gif with the location of an icon in your site.)Sabah u Din Irfan


JAVA: Method That Removes Specified Characters From String
2008-08-13T02:20:00.000-07:00
I needed a method that can remove specified set of characters from a given string. I came up with this solution. This method takes two parameters.

1. First parameter is original String from which you want to remove the characters.
2. Second parameter is a string containing the characters that we want to remove from the original string.

EXAMPLE:

If we provide the following input:

removeFromString("MYRSH Blogs by Sabah u Din Irfan","asi");

The method will return the followin output:

MYRSH Blog by Sbh u Dn Irfn
///////////////////////////////////////////


     public static String removeFromString(String str,String rem)
     {
         StringBuffer result=new StringBuffer();
        
        char[] s = str.toCharArray();
        char [] r = rem.toCharArray();
       
        boolean [] flags =new boolean[128];
       
        int len=str.length();
        int src, dest;
       
        for(src = 0 ; src < r.length; ++src )
        {
              //System.out.println("src="+src);
            flags[r[src]]=true;
        }
       
        src = 0 ; dest = 0 ;
        while(src < len)
        {
            if( !flags[(int)s[src]] )
            {
                result.append(s[src]);
            }
            ++src;
        }
         return result.toString();
     }
Sabah u Din Irfan


JSP: Save As Pop Up in JSP Another way
2008-08-08T06:11:00.000-07:00
Place the following code segment in your scriptlet tag of JSP page.

                                response.setContentType("application/vnd.ms-excel");
                                response.setHeader("Content-Disposition","attachment; filename=abc.xls"); 
                                ServletOutputStream so = response.getOutputStream();
                                String filename = "c:\\reports\myreport.xls";
                                String mimetype = "application/vnd.ms-excel";
                                ByteArrayOutputStream output = new ByteArrayOutputStream();
                                InputStream in = new BufferedInputStream(new FileInputStream(filename));
                                byte bytebuff[] = new byte[500];
                                for(int lengthread = 0; (lengthread = in.read(bytebuff)) != -1;){
                                output.write(bytebuff, 0, lengthread);
                                }
                                byte data[] = output.toByteArray();
                                response.setContentType(mimetype);
                                so.write(data);
                                in.close();
                                so.close();


WHERE:


abc.xls
is the file name that will automatically appear in the file Name box of SaveAs Pop Up.

and

 filename
is the actual file path on your server machine. It may be outside of your WEB-INF directory. 
Sabah u Din Irfan


JSP: Save As Pop Up in JSP
2008-08-08T06:00:00.000-07:00
Step First:

Add the following method in the declaration tag of your JSP page.

<%!

        void returnFile(String filename, OutputStream out)throws Exception
        {
            //    open file here using File object
             File inputFile =new File(filename);
            //    open stream from that file
             FileReader in = new FileReader(inputFile);
            int c;
            while ((c = in.read()) != -1)
               out.write(c);
               
            //    close the stream
             in.close();
            //    close the file
           
        }
%>

Step Two:

Add the following code segment in scriptlet tag.

                 response.setContentType("application/octet-stream");
                 response.setHeader("Content-Disposition", "attachment; filename=ASPTransBreakOut.txt");
               
                //  Send the file.
                 OutputStream outstr = response.getOutputStream(  );        
                 returnFile(fileLocation, outstr);  // Method implemented in declarative tag in step first
                 outstr.flush();

WHERE:

ASPTransBreakOut.txt
is the name that will automatically show you up in SaveAs Popup menu

and

fileLocation

is the location of the actual fine on your server.Sabah u Din Irfan


SQL Server: Lising all the Databses Names and Their Size
2008-07-09T09:08:00.000-07:00
Following stored procedure lists all of the data bases names along with their sizes and remarks/

exec sp_databases

   Column name  Data type  Description 
   DATABASE_NAME   sysname   Name of the database. In the Database Engine, this column represents the  database name as stored in the sys.databases catalog view.
   DATABASE_SIZE   int   Size of database, in kilobytes.
   REMARKS   varchar(254)   For the Database Engine, this field always returns  NULL.
Sabah u Din Irfan


ON LIVE PERSON
2008-04-16T14:28:00.001-07:00
Sabah u Din Irfan


DOS Command To Delete Those Files Having Attribute Other than A
2008-04-16T14:17:00.000-07:00
If you want to delete the files that have their Attribute value equal to "-A"(Other than A), Use the following Command:

DEL /Q /A:-A *.*

Where:

/A is a switch that selects files to delete based on attributes

-A means that only those files that have attribute value other than A

/Q is a switch for Quiet mode, do not ask if ok to delete on global wildcard

and

*.*  means all files.

For further details you can visit the following reference page.
http://www.computerhope.com/delhlp.htm




Sabah u Din Irfan


JAvaScript function to Count no Of Specific Fields( Like TextBoxes)
2008-04-08T11:47:00.000-07:00
Sometimes, you create textboxes or othe form fields dynamically using some server side scripting language. Then you may need to count the number of fields using some JAvaScript. The following javascript function will return the no of specific fields of a form passed in parameters:

It has two parameters:
1- formName:- It is the attribute name of the form
2- inputtype:- Type of Field as a String argument.

For Example if you would like to count the number of textBoxes in the HTML form, the following call will work.

var noOfTextBoxes = countElement(formName,"text");

Similarly, to count no of buttons in HTML form, call the function like:

var noOfTextBoxes = countElement(formName,"button");


Here is the implementation of JavaScript function:

function countElement(formName,inputtype)
{
    var count =0;
    for(i=0; i < formName.elements.length ; i++ )
    {
    if(formName.elements[i].type==inputtype)
    {
      //
      alert(formName.elements[i].value);
      count=count+1;
      
    }
    }
    return count;
}







Sabah u Din Irfan


JAVA@ Removing Duplicate Records from ArrayList
2008-04-07T12:52:00.000-07:00
The following code removes the duplicate records from the ArrayList of Java.

//////////////////////////////////////

import java.util.ArrayList;

public class RemoveDuplicateArrayElement {
   public static void main(String [] as)
   {  
            // String [] temp={"sqqa","as","sa","sd","sa","fd","sa","sa","sa"};
             ArrayList aryDuplicate=new ArrayList();
     
             aryDuplicate.add(new String("sabah"));
             aryDuplicate.add(new String("irfan"));
             aryDuplicate.add(new String("waqas"));
             aryDuplicate.add(new String("sabah"));
             aryDuplicate.add(new String("sabah"));
             aryDuplicate.add(new String("Ahmad"));
//              for(int i=0;i
//              {
//                      if(listContains(aryL,temp[i]))
//                      {
//                          // This is already in the List, Don't push it.
//                          //System.out.println("List already contains"+temp[i]);
//                      }
//                      else
//                      {
//                          aryL.add(new String(temp[i]));
//                      }
//              }
//              aryDuplicate1=aryDuplicate;//
//            
//              for(int j=0;j
//              {
//                  //System.out.println(j+":"+(String)aryDuplicate1.get(j));
//              }
           
             aryDuplicate=RemoveDuplicates(aryDuplicate);
             System.out.println(aryDuplicate.size());
             for(int j=0;j
             {
                 System.out.println(j+":"+(String)aryDuplicate.get(j));
             }
             //System.out.println("List contains = "+listContains(aryL,"sfa") );
   }
  /////////////////////////////////////

   public static ArrayList RemoveDuplicates(ArrayList aryLst)
   {
       ArrayList noDuplicate=new ArrayList();
        for(int i=0;i
        {
         
            if(listContains(noDuplicate,(String)aryLst.get(i)))
                    {
                        //This is already in the List, Don't push it.
                        //    System.out.println((String)aryLst.get(i));
                    }
            else
            {
                noDuplicate.add(new String((String)aryLst.get(i)));
              
            }
        }
     
       return noDuplicate;
   }
  /////////////////////////
   public static boolean listContains(ArrayList aryList, String str)
   {
       boolean result=false;
     
       for(int i=0;i
       {
           // System.out.println((String)aryList.get(i));
           if(str.equalsIgnoreCase((String)aryList.get(i)))
           {
               result= true;
               break;
           }
           else
           {
               result= false;
           }
         
       }
     
       return result;
   }
   ///////////////////////////////////

   public static boolean listContains(String[] aryList, String str)
   {
       boolean result=false;
     
       for(int i=0;i
       {
           // System.out.println((String)aryList.get(i));
           if(str.equalsIgnoreCase((String)aryList[i]))
           {
               result= true;
               break;
           }
           else
           {
               result= false;
           }
         
       }
     
       return result;
   }


} // end classSabah u Din Irfan


JAVAScript: Function To Validate UK ZipCodes
2008-03-14T09:48:00.000-07:00
// Method that validates the Basic Business Rules for UK Zip codes.

function  checkPostCode(pc) { //check postcode format is valid
       var test = pc;
       var size = test.length
       test = test.toUpperCase(); //Change to uppercase
       while (test.slice(0,1) == " ") { //Strip leading spaces
           test = test.substr(1,size-1);size = test.length
       }
       while(test.slice(size-1,size) == " ") { //Strip trailing spaces
           test = test.substr(0,size-1);size = test.length
       }
       if (size == 0) {
           return "please enter a valid postcode";
       }
       //document.details.pcode.value = test; //write back to form field
       if (size <> 8){ //Code length rule
           //return "please enter a valid postcode";
           return test + " is not a valid postcode - wrong length";
       }
       if (!(isNaN(test.charAt(0)))){ //leftmost character must be alpha character rule
           //return "please enter a valid postcode";
           return   test + " is not a valid postcode - cannot start with a number";
       }
       if (isNaN(test.charAt(size-3))){ //first character of inward code must be numeric rule
          // return "please enter a valid postcode";
           return test + " is not a valid postcode - alpha character in wrong position";
          
       }
       if (!(isNaN(test.charAt(size-2)))){ //second character of inward code must be alpha rule
           //return "please enter a valid postcode";
           return test + " is not a valid postcode - number in wrong position";
       }
       if (!(isNaN(test.charAt(size-1)))){ //third character of inward code must be alpha rule
           //return "please enter a valid postcode";
           return test + " is not a valid postcode - number in wrong position";
       }
       if (!(test.charAt(size-4) == " ")){//space in position length-3 rule
           //return "please enter a valid postcode";
           return test + " is not a valid postcode -   space in wrong position";
          
       }
       count1 = test.indexOf(" ");count2 = test.lastIndexOf(" ");
       if (count1 != count2){//only one space rule
           return "please enter a valid postcode";
           return test + " is not a valid postcode - only one space allowed";
       }
       return "OK";
   }Sabah u Din Irfan


JAVAScript: StringTokenizer Function
2008-03-12T05:51:00.000-07:00
String.prototype.tokenize = tokenize;

function tokenize()
 {
    var input             = "";
    var separator         = " ";
    var trim              = "";
    var ignoreEmptyTokens = true;

    try {
      String(this.toLowerCase());
    }
    catch(e) {
      window.alert("Tokenizer Usage: string myTokens[] = myString.tokenize(string separator, string trim, boolean ignoreEmptyTokens);");
      return;
    }

    if(typeof(this) != "undefined")
      {
         input = String(this);
      }

    if(typeof(tokenize.arguments[0]) != "undefined")
      {
         separator = String(tokenize.arguments[0]);
      }

    if(typeof(tokenize.arguments[1]) != "undefined")
      {
         trim = String(tokenize.arguments[1]);
      }

    if(typeof(tokenize.arguments[2]) != "undefined")
      {
         if(!tokenize.arguments[2])
           ignoreEmptyTokens = false;
      }

    var array = input.split(separator);

    if(trim)
      for(var i=0; i
        {
          while(array[i].slice(0, trim.length) == trim)
            array[i] = array[i].slice(trim.length);
          while(array[i].slice(array[i].length-trim.length) == trim)
            array[i] = array[i].slice(0, array[i].length-trim.length);
        }

    var token = new Array();
    if(ignoreEmptyTokens)
      {
         for(var i=0; i
           if(array[i] != "")
             token.push(array[i]);
      }
    else
      {
         token = array;
      }

    return token;
 }
/////////////////////////////////Sabah u Din Irfan


Profile on Linked In
2008-01-31T09:02:00.000-08:00
Sabah u Din Irfan


Final Release of VS 2008 and .NET 3.5 Now Available
2007-11-30T13:33:00.000-08:00
   
    Final Release of VS 2008 and   .NET 3.5 Now Available
  Monday, November 19, 2007
  Experience the latest release of the most productive   and powerful development tool and user interface platform on the planet. Learn about the new features in Visual Studio 2008   and the .NET Framework 3.5, from built-in ASP.NET AJAX support, to the new   Visual Studio Web page designer, to the enhanced JavaScript support; then watch   the ASP.NET 3.5 video series and the LINQ video series; and then download a free copy   of Visual Web Developer 2008 to try it out   yourself.
Go to the link: http://asp.net/downloads/vs2008/

Sabah u Din Irfan


What's new in Visual Studio 2008 and .NET Fx 3.5 for the Web Developer
2007-11-30T13:27:00.000-08:00
Kindly visit the following link, it is very useful:

http://msdn2.microsoft.com/en-gb/bb905504.aspx?id=108Sabah u Din Irfan


SQL Server 2005: Using NULLIF
2007-11-30T13:22:00.001-08:00
It takes two parametes like,
NULLIF (param1,param2)
and returns NULL if both param1 and param2 are equal.

NULLIF returns the first parameter if the two parameters are not   equivalent

NOTE:
param1 and param2 can be a constant, column name, function, subquery, or any combination of   arithmetic, bitwise, and string operators.

NULLIF is somehow similar to CASE function.


http://www.bloglines.com/blog/sabah-irfan?id=41Sabah u Din Irfan


SQL Server 2005: Using NULLIF
2007-11-30T13:22:00.000-08:00
It takes two parametes like,
NULLIF (param1,param2)
and returns NULL if both param1 and param2 are equal.

NULLIF returns the first parameter if the two parameters are not   equivalent

NOTE:
param1 and param2 can be a constant, column name, function, subquery, or any combination of   arithmetic, bitwise, and string operators.

NULLIF is somehow similar to CASE function.


http://www.bloglines.com/blog/sabah-irfan?id=41Sabah u Din Irfan


JavaScript: Some Useful Functions
2007-10-29T14:00:00.000-07:00
toUpperFirstChar:    
Accepts an object of type "Text" and converts the first character of the string to upper case.
Parameters:            Object
Returns:             n/a

Here is the defination:

function toUpperFirstChar(obj)
{
    LTrimObj(obj);
    obj.value = obj.value.substr(0,1).toUpperCase()+obj.value.substr(1,obj.value.length-1);
}


checkDateValidity:-
This method checks if the fDt is less than tDt or not.
Parameters:            FromDate, ToDate
Returns:             Boolean

Here is the defination..


function checkDateValidity(fDT,tDT)
{
    var fyear=fDT.charAt(7)+fDT.charAt(8)+fDT.charAt(9)+fDT.charAt(10);   
    var tyear=tDT.charAt(7)+tDT.charAt(8)+tDT.charAt(9)+tDT.charAt(10);   

    var fm=fDT.charAt(3)+fDT.charAt(4)+fDT.charAt(5);   
    var tm=tDT.charAt(3)+tDT.charAt(4)+tDT.charAt(5);   
    var fmonth=MonthReplace(fm);
    var tmonth=MonthReplace(tm);

    var fday=fDT.charAt(0)+fDT.charAt(1);   
    var tday=tDT.charAt(0)+tDT.charAt(1);   

    fDate = new Date(fyear,fmonth-1,fday);
    tDate = new Date(tyear,tmonth-1,tday);

    if(fDate > tDate)
    {
        alert("From date must not be greater than to date");
        return false;
    }
    else
    {
        return true;
    }   
}


varifyPassword:-
varifies if the password is more than 6 char long and it contains atleast one digit and 4 distinct characters.

Here is the defination of the function:

 function varifyPassword(pass)
  {
      pass=Trim(pass);
      var validFlag = 1;
       if(pass.length < 6)
       {
           validFlag = 0;
       }
       else
       {
           alphaList=new Array();
           numList=new Array();
           var flag=0;
        for(var i=0; i< pass.length; i++)
        {
            var oneChar=pass.charAt(i)
            if(isAlphabet(oneChar))
            {
                var charFlag=1;
                for(var p=0; p                {
                     if(oneChar==alphaList[p])
                     {
                         charFlag=0;
                         break;
                     }
                }
                if(charFlag)
                {
                    alphaList[alphaList.length]=oneChar;
                }   
            }
            else if(oneChar>=0 && oneChar <=9)
            {
                var numFlag=1;
                for(var p=0; p                {
                     if(oneChar==numList[p])
                     {
                         numFlag=0;
                         break;
                     }
                }
                if(numFlag)
                {
                    numList[numList.length]=oneChar;
                }   
            }
            else
            {
                validFlag = 0;
                break;
            }

           
            if ((alphaList.length >= 1) && (numList.length>= 1) && ((alphaList.length + numList.length) >= 4))
            {
                flag = 1;
                break;
            }       
              }
       
        if(flag)
        {
            return true;
        }   
        else
        {   
            validFlag = 0;
        }   
           }
          
           if (! validFlag)
           {
            alert("The password is not valid, or needs to be updated. Consult the help page for instructions about choosing a valid password.")
            return false;
           }
   }Sabah u Din Irfan


JSP: sendRedirect() vs. getRequestDispatcher()
2007-10-29T13:53:00.000-07:00
    Today my other team member was facing a problem and the request objects were destroed when he was using request.sendRedirect().  He was struggling with it and came to me.  Actually there is other method to use when you want to pass the origional request objects, that is getRequestDispatcher();

When you want to preserve the current    request/response objects and transfer them to another resource WITHIN the    context, you must use getRequestDispatcher or getNamedDispatcher.    
 
  
      If you want to dispatch to resources OUTSIDE    the context, then you must use sendRedirect. In this case you won't be sending    the original request/response objects, but you will be sending a header asking    to the browser to issue a request to the new URL. 
 
  
        
NOTE: If you don't need to preserve the    request/response objects, you can use either.Sabah u Din Irfan


JavaScript@ Validation Functions
2007-09-28T02:35:00.000-07:00
1- Empty Field Validation:- (To check whether a text field is empty or not)
function IsEmpty(aTextField) {
   if ((aTextField.value.length==0)
   (aTextField.value==null)) {
      return true;
   }
   else { return false; }
}
////////////////////////////////////////////////
 
2- Numeric Validation:- (To check whether a text field contains Numeric Values)

function IsNumeric(sText)
{
   var ValidChars = "0123456789.";
   var IsNumber=true;
   var Char;


   for (i = 0; i < sText.length && IsNumber == true; i++)
      {
      Char = sText.charAt(i);
      if (ValidChars.indexOf(Char) == -1)
         {
         IsNumber = false;
         }
      }
   return IsNumber;
  
   }
////////////////////////////////////////////////
 
3- Aplphabet Validation:- (To check whether a text field contains Alphabetic Values)

function IsAlphabet(sText)
{
   var ValidChars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
   var IsAlpha=true;
   var Char;


   for (i = 0; i < sText.length && IsAlpha == true; i++)
      {
      Char = sText.charAt(i);
      if (ValidChars.indexOf(Char) == -1)
         {
         IsAlpha= false;
         }
      }
   return IsAlpha;
  
   }
/////////////////////////////////////////////////////////////////////////
 3- Email Address Validation:- (To check whether a text field contains valid email value)

function isValidEmail(str) {
   return (str.indexOf(".") > 2) && (str.indexOf("@") > 0);

}
 
Sabah u Din Irfan


SQL Server @ To List The Database Names along with their Size
2007-09-24T11:22:00.000-07:00
The following system stored procedure is helpful to list the all database names along with their size in KiloBytes:

EXEC sp_databases

Results:
--------------------------------
DataBase_Name         DataBase_Size      REMARKS
HighFall_Rockin            3712                        NULL
master                                4608                         NULL
model                                  1728                         NULL
msdb                                    7360                        NULL
tempdb    19456    NULL
TLSPFX    4689152    NULL
TLSPFX_BK    987008    NULL
Sabah u Din Irfan


SQL Server @ Query To List Available Triggers On a DataBase
2007-09-24T10:48:00.001-07:00
The following query is helpful to enlist all the available triggers on a specific database.  sys.triggers is a view that contains a row for each object that is a trigger.

Here is the query:

USE MSDB -- Database Name Here 
SELECT name,type,type_desc,create_date,modify_date 
FROM sys.triggers 


Results:
---------------------------------------------------------
name                                          type        type_desc            create_date                                modify_date

trig_sysmail_profile_delete    TR    SQL_TRIGGER    2005-10-14 01:55:32.520    2005-10-14 02:02:31.787
trig_sysmail_servertype    TR    SQL_TRIGGER    2005-10-14 01:55:32.740    2005-10-14 02:02:31.850
trig_sysmail_server    TR    SQL_TRIGGER    2005-10-14 01:55:33.067    2005-10-14 02:02:31.910
trig_sysmail_configuration    TR    SQL_TRIGGER    2005-10-14 01:55:33.287    2005-10-14 02:02:31.943
trig_sysmail_mailitems    TR    SQL_TRIGGER    2005-10-14 01:55:33.507    2005-10-14 02:02:31.990
trig_backupset_delete    TR    SQL_TRIGGER    2005-10-14 01:55:16.113    2005-10-14 02:02:32.007
trig_sysmail_attachments    TR    SQL_TRIGGER    2005-10-14 01:55:33.723    2005-10-14 02:02:32.050
trig_sysmail_log    TR    SQL_TRIGGER    2005-10-14 01:55:33.943    2005-10-14 02:02:32.100
trig_sysoriginatingservers_delete    TR    SQL_TRIGGER    2005-10-14 01:54:09.833    2005-10-14 02:02:32.397
trig_sysjobs_insert_update    TR    SQL_TRIGGER    2005-10-14 01:54:10.490    2005-10-14 02:02:32.520
trig_sysschedules_insert_update    TR    SQL_TRIGGER    2005-10-14 01:54:12.677    2005-10-14 02:02:33.210
trig_targetserver_insert    TR    SQL_TRIGGER    2005-10-14 01:55:08.570    2005-10-14 02:02:34.740
trig_notification_ins_or_upd    TR    SQL_TRIGGER    2005-10-14 01:55:14.583    2005-10-14 02:02:35.333
trig_notification_delete    TR    SQL_TRIGGER    2005-10-14 01:55:14.910    2005-10-14 02:02:35.363
trig_sysmail_profile    TR    SQL_TRIGGER    2005-10-14 01:55:31.647    2005-10-14 02:02:35.787
trig_principalprofile    TR    SQL_TRIGGER    2005-10-14 01:55:31.867    2005-10-14 02:02:35.833
trig_sysmail_account    TR    SQL_TRIGGER    2005-10-14 01:55:32.083    2005-10-14 02:02:35.863
trig_sysmail_profileaccount    TR    SQL_TRIGGER    2005-10-14 01:55:32.303    2005-10-14 02:02:35.910Sabah u Din Irfan


SQL Server @ Query To List The available SQL JOBS
2007-09-24T10:06:00.001-07:00
The following query is helpful to enlist the name, created date, modified date and description of the Sql Jobs available. You can add the mre column in the result set if needed.

USE MSDB

SELECT name,enabled,date_created,date_modified,description
FROM  sysjobs 

Results:
-------------------------------------------------------------
Name                        Enabled         Date Created                      Date Modified
GEServiceEntries    1    2007-04-11 11:25:49.897    2007-04-11 11:54:05.503
CDW_CORFXSQL01_CORFXSQL01_0    1    2006-02-28 19:51:08.967    2006-02-28 19:51:09.217
DataEntryHHReports    1    2006-11-03 13:25:36.230    2007-09-20 11:43:29.297

Sabah u Din Irfan


SQL Server@ Query To See the Execution History of SQL JOBS
2007-09-24T09:53:00.000-07:00
I have made a couple of SQL jobs that are scheduled accordingly to perform some specific tasks. I wanted to know whether the jobs are executed accordingly or not? And what are the results of the execution? Means success or failure. And finally, I created a query for this purpose after looking into the MSDB. Here is it:

USE MSDB

SELECT j.name,h.run_status,h.run_date,h.run_time, h.run_duration,h.server, h.message
FROM sysjobhistory h,sysjobs j
WHERE h.job_id=j.job_id
ORDER BY run_date desc ,run_time desc

Here are the results: (NOTE: I have omitted the Message column here)
-----------------------------------------------------------------------------
DataEntryHHReports    1    20070921    121000    0    CORFXSQL01
DataEntryHHReports    1    20070921    121000    1    CORFXSQL01
DataEntryHHReports    0    20070914    121301    0    CORFXSQL01
DataEntryHHReports    2    20070914    121001    0    CORFXSQL01
DataEntryHHReports    0    20070914    121000    301    CORFXSQL01
GEServiceEntries    1    20070911    0    0    CORFXSQL01
GEServiceEntries    1    20070911    0    1    CORFXSQL01
DataEntryHHReports    1    20070907    121000    1    CORFXSQL01
DataEntryHHReports    1    20070907    121000    1    CORFXSQL01
DataEntryHHReports    1    20070831    121001    0    CORFXSQL01
DataEntryHHReports    1    20070831    121000    1    CORFXSQL01
DataEntryHHReports    1    20070824    121001    0    CORFXSQL01
DataEntryHHReports    1    20070824    121000    1    CORFXSQL01
DataEntryHHReports    1    20070817    121000    0    CORFXSQL01
DataEntryHHReports    1    20070817    121000    0    CORFXSQL01
GEServiceEntries    1    20070811    0    0    CORFXSQL01
GEServiceEntries    1    20070811    0    0    CORFXSQL01

Sabah u Din Irfan


SQL Server@ List Stored Procedure Names using specific table
2007-09-03T12:52:00.000-07:00
Sometimes you need to drop some table or needs to modify the name of the table, and before doing that you want to make sure which are the stored procedures that are using this table?

Secondly, you just want to update the table by deleting it's some column, and you want to make sure which are the stored procedures that are using this column?

The following query gives you the list of Stored procedures that are using some specific table name "CDRMaster".

SELECT Name, create_date,modify_date
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%CDRMaster%'

The following query will give you the list of the stored procedures using some specific column name(CDRID in this case)of the table CDRMaster:

SELECT Name, create_date,modify_date
 FROM sys.procedures
 WHERE OBJECT_DEFINITION(object_id) LIKE '%CDRMaster%'
AND OBJECT_DEFINITION(object_id) LIKE '%CDRID%'


Sabah u Din Irfan


SQL Server@ List Stored Procedure Names Created in Specific Date Range
2007-09-03T12:42:00.000-07:00
This simple query returns the list of stored procedure names that are created with in the specific data range given in where clause.

SELECT Name,create_date,modify_date 
FROM  sys.procedures 
WHERE  create_date between '07/14/2007' and '08/20/2007'


Sabah u Din Irfan


Java 1.4: ASSERTIONS
2007-08-29T13:50:00.000-07:00
Assertions provide a convenient mechanism for verifying that a class's methods are called correctly. This mechanism can be enabled or disabled at runtime. The intention is that assertions typically be enabled during development and disabled in the field.

Assertions  has the following syntax:

assert Expression1;
assert Expression1 : Expression2;

Expression1 must be boolean type.
Expression2 may have any type.
If assertions are disables at runtime (default state)  then assert statement does nothing.
If assertions are enabled at runtime( using command line argument to JVM) then Expression1 is evaluated. If it is true, no further action is taken. If it is false then AssertionError is thrown. If Expression2 is present, it is passed to constructor of the AssertionError where it is converted to String and used as a error message.
Sabah u Din Irfan


Inserting rows with default values in a Table
2007-08-16T14:04:00.000-07:00
The following simple query will insert a row into the table name specified with the default values for each column:

INSERT INTO TableName DEFAULT VALUES
Sabah u Din Irfan


JAVA 5.0 Autoboxing/Unboxing
2007-08-07T12:40:00.000-07:00
What is Boxing?

       Converting a primitive type to it's wrapper class is known as Boxing. For example converting from int to Integer, float to Float, double to Double etc.



What is unboxing?

         The reciprocal of Boxing is called unboxing, means converting from some wrapper class to it's respective primitive type is known as unboxing. For example converting from Integer to int, Float to float, Double to double etc.



In the earlier versions from JDK 1.5 ,  boxing and unboxing  was manual.  You have to explicitly convert from one into another. But in JDK 1.5 boxing  and unboxing is automatic and the compiler will do this itself on your behalf.



Example of Manual Boxing/unboxing:



 int a = 2;

 int b;

 Integer aW = Integer(a);  // This is example of boxing



 b =aW.intValue(); // This is an example of unboxing.



If you want to store int values of some range say 0-100 in an ArrayList, then what you need to do ? Certainly you will make the wrapper objects of Integer class and will add them into an array list like here 



          ArrayList list = new ArrayList();

          for(int i = 0; i <100;i++)

             list.add(new Integer(i));// You can pass only Objects into add  method                                       // not primitives

          }



This is basically boxing. Similarly if you want to add the elements of the ArrayList into some int variable then you need to do the unboxing like shown here:



  sum += ((Integer)list.get(i)).intValue(); 



But if you are using JAVA 5.0, all of these will be done automatically by the compiler on your behalf like shown here:



         ArrayList list = new ArrayList();

           for(int i = 0; i <100;i++)

           {

              list.add(i); // AutoBoxing is done here

           }

          

         int sum = 0;           

         for ( Integer j : list)

            {

                sum += j; // Auto-unboxing is done here.. 

            }



For further reference Read the SUN DOCUMENTATION from the following link:



http://java.sun.com/j2se/1.5.0/docs/guide/language/autoboxing.html







Sabah u Din Irfan


JAVA 5.0 Enhanced For- Loop
2007-08-06T14:12:00.000-07:00
Enhanced FOR-LOOP is a new addition in JAVA 5.0. If you have worked in Visual Basic then you have used FOR-EACH loop in VB.  Enhanced For-loop in JAVA5.0 is very similar to For-Each Loop of Visual Basic.  

Enhanced for-loop is used to iterate arrays and collections. 

Iteration over Arrays : 
 The  syntax for iteration over arrays is as following :

for (type variable : array)
{
 body-of-loop
}
First we make a function that uses  simple/conventional For Loop to add an array of int  and returns its sum: 

int sumArray( int [] arr )
{
       int sumArray=0;
       for ( int i=0;i
       {
          sumArray+=arr[i];
        }
   return  sumArray;
}

If we want to utilize the new Enhanced for-loop( sometimes called For-Each loop or For-In loop) the above function will be like. 

int sumArray( int [] arr )
 {
        int sumArray=0;
        for ( int i : arr )
       {
          sumArray+=i;   //  here i gets successively each value in array a    
     }
    return  sumArray;
 }

Iteration over Collections : 
  The  syntax for iteration over collections is as following :

for (type variable : collection )
{
 body-of-loop
}

For example we have a collection of books in a List and we retrieve it using Iterators using the
conventional for- loop like:

List books = ......  
 for (Iterator i = books.iterator(); i.hasNext(); )
{
   Book  book= (Book) i.next();
   //..... body of loop  .... 
}

Its reciprocal syntax using enhanced-for loop  will look like,
// Assume there is a List of books available like
List books = ...... 

 for (Book  book : books)
{
  // /now book has the value for each iteration of list 
}
 
Restrictions of Enhanced For-Loop:
It is not possible to traverse  more than one structures at the same time. For example  two arrays.
You can only access only single element at each iteration. You can not have access to more than one elements. Like in case of comparing successive elements in an array.
You can not iterate an array backwards. It is forward-only and single step increment.
It is not compatible for the earlier versions of the JAVA 5.0.
For more details visit the following link of SUN DOCOMENTATIONSabah u Din Irfan


JAVA: A Method to Get Current Day of Week
2007-08-03T08:47:00.000-07:00
Hello everybody, here is the method that returns the current day of week. 

public static String getCurrentDayofWeek()
    {
          String DAY="";
          Calendar cal =Calendar.getInstance();
          int dayOfWeek = cal.get(Calendar.DAY_OF_WEEK);        
          switch (dayOfWeek)
          {
          case 1:
              DAY="SUNDAY";
              break;
          case 2:
              DAY="MONDAY";
              break;
          case 3:
              DAY="TUESDAY";
              break;
          case 4:
              DAY="WEDNESDAY";
              break;
          case 5:
              DAY="THRUSDAY";
              break;
          case 6:
              DAY="FRIDAY";
              break;
          case 7:
              DAY="SATURDAY";
              break;
          }
        return DAY;
    }Sabah u Din Irfan


New Features in JAVA 5.0
2007-08-02T14:42:00.000-07:00
The following is the list of new features added on in version 5.0 of JAVA.
Generics
Enhanced "for" loop  ( Click Here for Detail )
Autoboxing/Unboxing ( Click Here for Detail )
Typesafe Enums
Varargs
Static Import ( Click Here for Detail )
Metadata( Annotations)
Sabah u Din Irfan


SCJP Hand outs Part-1
2007-08-02T14:07:00.001-07:00
The      floating-point numbers did not throw divide by zero ArithmeticException.      They will give a result that is Not A Number NAN. 
The      case argument must be either an int literal , or an int-compatible      variable which is a constant (i.e static or final)
Assume      byte a=3; byte b=2;  byte c=      a+b;   à      Compile time error because the addition operator will wide the byte to int      before addition and result should be stored in int variable. 
An      abstract class can have a constructor.
It is      legal to access a static method using an instance of the class. But it is      preferred way to use the class name to access. 
Methods      can be overridden Attributes/member variables can not. 
If a      try/catch block calls System.exit() then finally block will not execute. 
A member      variable can not be native. 
Constructors      are not inherited. 
You      can not automatically/implicitly convert a char to short. There is same      bit depth but since char are unsigned they might have higher positive      value than a short can accept.
Arithmetic      Exception is not a checked exception. 
An      interface can extend multiple interfaces however a class can extend only      one class.
A      member variable can not be declared synchronized. 
Math.round(-3.22)      = -3 
You      can not make a final abstract class. 
A      constructor of a class can not be declared static.
Inner      classes can not be defined in a class outside of its methods like where      declaring member variables.
A      class can not be declared transient. 
A      method can not be declared transient. 
static      methods of a class can not be accessed using this.MethodName(). 
Only      variables can be declared as volatile. 
A      floating point literal (like 3.45) in java will be treated as double      unless you specify an f at the end like (3.45f).
A top      level class can not be marked as private.
An      overloaded method can change the return type, but return type alone is not      enough—it also must change the argument list. 
If      there is a return statement in try/catch block then finally block will      also be executed. 
int      iArray[5] = new int[] {1,2,3,4,5}; will       not compile but int iArray[] = new int[] {1,2,3,4,5}; will compile.      
An      anonymous inner class can not have a constructor.
Result      of System.out.println(Math.sqrt(-4)); is equal to NAN.
A top      level class can not be marked as protected.
cast      is not a keyword in JAVA. 
Sabah u Din Irfan


STATIC Import, A new feature in JAVA 5.0
2007-07-31T06:23:00.000-07:00
Static Import statement is the new addition in JDK 5.0. This statement is used to import the static variables/fields  and  static members of some class.

Let's take an example, like if we need to use the "PI" static  field of Math class in java.lang then  we need to write something like :

double a=10;
double res = Math.sin(Math.PI * a);

But if you use the static import in your program then it will be like:

import static java.lang.Math.PI;

double a=10;
double res = Math.sin(PI * a);
you noticed that we have no need to write the fully qualified  name of the PI but still we need to write the fully qualified name of the static method "sin" like Math.sin(..).

There is a second form of the static import that imports all of the static  fields and members of a class .i.e by using  the * notation.


import static java.lang.Math.*;

double a=10;
double res = sin(PI * a);
Sabah u Din Irfan


Visual Studio .NET 2008 Beta Available to Download Now
2007-07-27T13:24:00.000-07:00
Visual Studio .NET 2008 Beta Available to Download Now on the Microsoft website:
Here are the Links:

You can download the Visual Studio 2008 product here.  You can alternatively download the smaller VS 2008 Express Editions here. 


Enjoy!!!!!!Sabah u Din Irfan


Visual Studio .NET 2008 First Look Video
2007-07-27T13:17:00.000-07:00
I was surfing on the net today and came across a link for the first look video of Visual Studio .NET 2008. I would like to share it with you people.

Here  is the link:

http://www.xmlforasp.net/codebank/download/blog/video/LinqDataSource.wmv

Enjoy!!!!!!Sabah u Din Irfan


UDF to Get Day of Week in SQL Server 2005
2007-07-27T12:37:00.000-07:00
The following UDF can be used to get the Day of Week by passing it a specific date:

CREATE FUNCTION dbo.udf_Day_Of_Week(@p_Date DATETIME)
RETURNS VARCHAR(10)
AS
BEGIN
DECLARE @return_DayofWeek VARCHAR(10)
SELECT @return_DayofWeek = CASE DATEPART(dw,@p_Date)
WHEN 1 THEN 'SUNDAY'
WHEN 2 THEN 'MONDAY'
WHEN 3 THEN 'TUESDAY'
WHEN 4 THEN 'WEDNESDAY'
WHEN 5 THEN 'THURSDAY'
WHEN 6 THEN 'FRIDAY'
WHEN 7 THEN 'SATURDAY'
END
RETURN (@return_DayofWeek)
END


Sabah u Din Irfan


How To Take Database Schema Backup in SQL Server 2005
2007-07-25T07:03:00.000-07:00
How To Take Database Schema Backup in SQL Server 2005

Go to OBJECT EXPLORER of the SQL Server 2005 and expand the Databases tree node, you can see the available databases in your server.




 
     
   
  
   
  Then      Right Click on the specific Database you wish to make the schema backup.      And go to TASKSà GENERATE SCRIPTS like      shown in the figure below:
  



 
  After      selecting the GENERATE SCRIPTS you will see a welcome screen like shown      below.




   
  Click      on NEXT button of the Wizard and you will be asked to select the database      you wish to generate schema backup like below in figure(TestDB is the      database in this case):





   
  If you      want to take the full schema back up of the database then check the      checkbox “Script all objects in the selected database” like shown here in the figure and      click Next button of the wizard. 




   
  In the      next screen you can play with the different properties. Just need to      change one of the property if you need to use this schema on SQL Server      2000 version, that is “Script for Server Version” and      select the appropriate version you needed.




 
  
   
  After      selecting the appropriate SQL Server version for which you are preparing      the schema backup click Next Button and you will reach at the OUTPUT      OPTION and then select the appropriate output option. In my case I am      saving the script of schema in a File of Unicode Text like:





  Then      Click Next and you will reach on the Script wizard Summary screen, Simply      Click Finish to execute your requested job.




    
   
  After      clicking the Finish button you will reach at the Generate Script progress      Wizard. It will take a little time depending upon the number of      objects in your selected database. After completing its job it will show      you the success status. 




  If you      want to see the Report of the whole process, just select from the options      of Report button just up from the Close and select the output option of      the report. Otherwise click Close. That’s it and you are Done. 
  
Sabah u Din Irfan


A UDF To Get Previous Working Day in SQL Server 2005
2007-07-24T09:05:00.000-07:00
It has pretty similar logic as we done with the UDF of Next Working Day. You can read the  earlier post on "How to get the Week Day"  for better understanding. Here is the self explanatory code. 

CREATE FUNCTION dbo.udf_GetPreviousWorkingDay (@p_Date DATETIME )
RETURNS DATETIME
AS
BEGIN
DECLARE @m_WeekDay INT
DECLARE @rt_Prev_Working_Day DATETIME
SET @m_WeekDay = DATEPART(weekday,@p_Date)

IF @m_WeekDay = 1      -- IF SUNDAY then subtract 2 fromsunday to get friday that is working day
SET @rt_Prev_Working_Day = DATEADD(d,-2,@p_Date)
ELSE IF @m_WeekDay = 2 -- IF MONDAY then subtract 3 fromsunday to get friday that is working day
SET @rt_Prev_Working_Day = DATEADD(d,-3,@p_Date)
ELSE  -- ELSE subtract one to get the prev date
SET @rt_Prev_Working_Day = DATEADD(d,-1,@p_Date)

RETURN @rt_Prev_Working_Day
END

Here are some of the test cases having the same result:

SELECT dbo.udf_GetPreviousWorkingDay  ( '07/21/2007')
SELECT dbo.udf_GetPreviousWorkingDay  ( '07/22/2007')
SELECT dbo.udf_GetPreviousWorkingDay  ( '07/23/2007')

Result:

2007-07-20 00:00:00.000
Sabah u Din Irfan


A UDF  To Get The Next Working Day  @ SQL Server 2005
2007-07-24T08:54:00.000-07:00
The following scalar valued function will return the next working day of the week.  Here is the code:

CREATE FUNCTION dbo.udf_GetNextWorkingDay (@p_Date DATETIME )
RETURNS DATETIME
AS
BEGIN
DECLARE @m_WeekDay INT
DECLARE @rt_Next_Working_Day DATETIME
SET @m_WeekDay = DATEPART(weekday,@p_Date)

IF @m_WeekDay = 6      -- Friday
SET @rt_Next_Working_Day = DATEADD(d,3,@p_Date)
ELSE IF @m_WeekDay = 7 -- Saturday 
SET @rt_Next_Working_Day = DATEADD(d,2,@p_Date)
ELSE
SET @rt_Next_Working_Day = DATEADD(d,1,@p_Date)

RETURN @rt_Next_Working_Day
END

To test this UDF you can use the following example:

SELECT dbo.udf_GetNextWorkingDay  ( '07/20/2007')
SELECT dbo.udf_GetNextWorkingDay  ( '07/21/2007')
SELECT dbo.udf_GetNextWorkingDay  ( '07/22/2007')

The result of all of the above test cases will be as following:
 2007-07-23 00:00:00.000Sabah u Din Irfan


How to Get Week-Day and Quarter of year  in SQL Server 2005
2007-07-24T07:31:00.000-07:00
You can get the week-day by using the DATEPART scalar valued function of the SQL Server 2005.  For example the following statement returns 1 (one) as it is default value for Sunday.
SELECT  DATEPART(weekday,'07/22/2007' )
or
                                       SELECT  DATEPART(dw,'07/22/2007' )
                                   
                                     Result = 1
-------------------------------------------------------
The following are the default values for the week days:

SUNDAY =         1 
MONDAY=         2
TUESDAY =       3
WEDNESDAY=4
THURSDAY=    5
FRIDAY    =       6
SATURDAY =   7

Similarly you can check the quarter of the year by using one of the following query. SELECT  DATEPART(quarter,'07/22/2007' ) or
SELECT  DATEPART(qq,'07/22/2007' )   or 
SELECT  DATEPART(q,'07/22/2007' )
        Result: 3 ( as this is 3rd quarter of the year)

You can get the details from MSDN online, Here is the reference of the MSDN:
MSDN ONLINESabah u Din Irfan


Hibernate Plugin for Eclipse (HibernateSynchronizer)
2007-07-20T12:34:00.000-07:00
Hibernate is used for  database object/relational persistence and it is a very cool. It is available for both JAVA and .NET but is most popular for JAVA.

I was working with the Hibernate using eclipse. I was looking for some plugin of Eclipse and I found one with the name of "HibernateSynchronizer"

It is an Eclipse plugin code generation tool which, by default, binds to *.hbm files and automatically generates business objects when your hibernate schema configuration file is modified.

Here is the link to download it:
http://hibernatesynch.sourceforge.net/
http://sourceforge.net/project/showfiles.php?group_id=99370Sabah u Din Irfan


String Functions @ SQL Server 2005
2007-07-20T10:12:00.000-07:00
There are number of  scalar function to manipulate the strings in SQL server. I will just discuss the most common used scalar functions available for string manipulation:

1- REVERSE
                                    This scalar function is used to reverse  the character string provided. The input parameter may be constant string, variable or column name of character or binary type.
     EXAMPLE:-  SELECT REVERSE('SABAH') , REVERSE('IRFAN') 
     RESULT:- HABAS    NAFRI

2- LEN
                                It returns the number of characters in the input parameter provided. Input parameter may be constant char string, variable or column name. Please note it will not count the trailing spaces.
     EXAMPLE:-  SELECT LEN('SABAH U DIN') , LEN('IRFAN        ') 
     RESULT:-  11    5

3- SPACE
                           It returns the number of spaces according to the integer parameter provided as input.  It takes integer_expression as input. if the integer expression is negative then it returns null string.
     EXAMPLE:-  SELECT 'Sabah' +SPACE(10)+'Irfan'
     RESULT:-     Sabah          Irfan

4- REPLACE
                         This function has three parameters all of character type. It finds the 2nd parameter_string from 1st_parameter string and replaces all occurrence with the 3rd parameter_string.
     EXAMPLE:- SELECT REPLACE('abcdefghicde','cde','xxx')
     RESULT:-    abxxxfghixxx

5- ASCII
                   It returns the integer ASCII code of the left most character of the input string.
    EXAMPLE:- SELECT ASCII('A'),ASCII('ABCDEF')
    RESULT:-    65          65

6- CHAR
                   It converts the integer ASCII code into char.
          EXAMPLE:- SELECT CHAR(65),CHAR(78)
            RESULT:- A    N

7- LOWER
                       It  returns the lower case character string after converting the upper case characters present into the input string.

        EXAMPLE:-          SELECT LOWER('SAbah U Din')
        RESULT:-                sabah u din

8- UPPER
                       It  returns the upper case character string after converting the lower case characters present into the input string.

        EXAMPLE:-          SELECT UPPER('SAbah U Din')
         RESULT:-                 SABAH U DIN

9- LEFT
                      It returns the left part of the string with the number of characters provided.
        EXAMPLE:- SELECT LEFT('Sabah-u-Din',7)
        RESULT:- Sabah-u

10- RIGHT
                        It returns the right part of the character string with the number/count of characters provided in its 2nd parameter.
      EXAMPLE:- SELECT RIGHT('Sabah-u-Din',7)
      RESULT:- h-u-Din

11- RTRIM
                    It returns a character string after truncating all trailing blanks(blanks at the end of string).
      EXAMPLE:- SELECT RTRIM('Sabah                      ')
       RESULT:- Sabah

12- LTRIM
                    It returns a character string after truncating all leading blanks(blanks at the start of string).
      EXAMPLE:- SELECT LTRIM('              Sabah')
       RESULT:- Sabah

13- CHARINDEX
                                    It returns the starting position of the specified expression in a character string.  Its syntax is 
CHARINDEX ( expression1 ,expression2 [ , start_location ] )

 EXAMPLE:-  SELECT CHARINDEX('r','rSaba-u-din-irfan',3)
 RESULT:- 14

NOTE: There are a couple of more scalar functions available in SQL Server but the above
are the mostly used ones.

Sabah u Din Irfan


Listing Specific Objects From the DB @ SQL Server  2005
2007-07-11T06:32:00.000-07:00
There are always situations when you need to check/find the specific object like table/stored procedure from the database and usually for enterprize  level applications there are hundreds  or even thousands of  user tables  and stored procedures. 

Following are some of the queries  that  will help to list the complete details of some specific
Object whose type you are providing in the WHERE clause. You can filter out the results as you needed just by adding couple of more conditions.

select * from sys.objects where type = 'D' -- DEFAULT_CONSTRAINT 
select * from sys.objects where type = 'F' -- FOREIGN_KEY_CONSTRAINT
select * from sys.objects where type = 'FN'-- SQL_SCALAR_FUNCTION
select * from sys.objects where type = 'IT'-- INTERNAL_TABLE
select * from sys.objects where type = 'P' -- SQL_STORED_PROCEDURE
select * from sys.objects where type = 'PK'-- PRIMARY_KEY_CONSTRAINT
select * from sys.objects where type = 'S' -- SYSTEM_TABLE 
select * from sys.objects where type = 'SQ'-- SERVICE_QUEUE
select * from sys.objects where type = 'U' -- USER_TABLE
select * from sys.objects where type = 'UQ'-- UNIQUE_CONSTRAINT

The following query will result you with the available types of Objects of the database:

select distinct(type) from  sys.objects order by type ascSabah u Din Irfan


UDF to parse the numeric values from a String
2007-07-09T07:27:00.000-07:00
This UDF will parse a string and will return the numeric values that are present in the string in the same sequence that they have in string.

CREATE FUNCTION dbo.UDF_ParseNumeric  
(  
@string VARCHAR(8000)  
)  
RETURNS VARCHAR(8000)  
AS  
BEGIN  
DECLARE    @IncorrectCharLoc SMALLINT  
SET @IncorrectCharLoc = PATINDEX('%[^0-9]%', @string)  
WHILE @IncorrectCharLoc > 0  
BEGIN  
SET @string = STUFF(@string, @IncorrectCharLoc, 1, '')  
SET @IncorrectCharLoc = PATINDEX('%[^0-9]%', @string)  
END  
SET @string = @string  
RETURN @string  
END

TEST:
SELECT dbo.UDF_ParseNumeric('san1as2,.?"< \{4}[]6>:')
Result:
1246
Sabah u Din Irfan


PATINDEX and STUFF @ SQL Server 2005
2007-07-09T07:01:00.000-07:00
1- PATINDEX:-  

                     It returns the starting index/position of the first occurrence of the pattern provided. If no match is found then it will return zero.
Syntax: 
PATINDEX( '%pattern%', expression )

where
pattern: is the pattern to find.
expression: is the string or usually the column name that will be
searched to find the specified pattern.
--------------------------------------------------------

2- STUFF:-
Deletes a specified length of characters and inserts another set of  characters
at a specified starting point.
Syntax:
STUFF ( character_expression , start , length ,
     character_expression )

where:
character_expression:  can be a constant, variable, or column
   of either   character or binary data.
start: is the start location for the deletion and insertion.
 It is  an integer value. If its value is negative or
 longer than character_expression then null string is
 returned.
length: is the length of the character to be deleted.

Example:

SELECT STUFF('abcdefgh', 2, 3, 'SABAH')

Result: aSABAHefgh





Sabah u Din Irfan


New Features in C# .NET 2.0
2007-07-05T14:48:00.001-07:00
There are couple of new features/concepts that are introduced in the version 2.0 of C#.NET. These are listed below:
Generics
Partial Classes
Iterators
NULLABLE  Value Types
Anonymous Methods
Coalesce operator: (??)
Anonymous delegates providing closure functionality
A yield return similar to yield in Python
Will explain one by one in different blogs for simplicity.Sabah u Din Irfan


SQL Server @ WHERE vs  HAVING Clause
2007-07-05T14:21:00.000-07:00
WHERE vs  HAVING Clause

Both are used  to filter out the records but have coupe of differences:
HAVING can only be used with SELECT statement, while WHERE can be used for SELECT, UPDATE and DELETE.
HAVING specifies a search condition on group or aggregate function, while WHERE specifies the search condition on the individual rows.
HAVING is typically used with GROUP BY clause. If GROUP BY is not used then HAVING behaves like WHERE clause. 
Sabah u Din Irfan


sp_rename @ SQL Server 2005
2007-07-03T15:43:00.000-07:00
It Changes the name of a user-created object in the current database. This object  can be a table, index, column, alias data type, or Microsoft .NET Framework  common language runtime (CLR) user-defined type.

Syntax:

sp_rename @ObjectName, @ObjectNewName, @ObjectType

WHERE:

@ObjectName: is the name of the user object etc.
@ObjectNewName: is the new name of the user object. It has no defaults.
@ObjectType: defines the type of the user object to be renamed. The following types are supported:
A column
A database
An Index
UserDataType ( Alias type, objects created using CREATE statement and CLR user defined types)
Sabah u Din Irfan


CREATE STORED PROCEDURE And UDF  WITH  ENCRYPTION
2007-07-02T15:14:00.000-07:00
You can create encrypted stored procedures, so that no one can  see the source code of the stored procedure. Even if you will try to see its text using  sp_helptext procedure; it will show the following message

The text for object '[sptst_Test]' is encrypted.

Syntax:
             Just add WITH ENCRYPTION Clause after the parameter's list of the stored procedure or UDF.

Example:

CREATE PROCEDURE [dbo].[sptst_Test]
 -- Add the parameters for the stored procedure here  
WITH ENCRYPTION
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from  
 -- interfering with SELECT statements.  
SET NOCOUNT ON;

   -- Insert statements for procedure here  
   SELECT * FROM sys.tables

END

NOTE:
You can not decrypt the Encrypted stored procedure or UDF. So it is good practice not to use this security. Rather use the user permissions if you need to restrict some one.
CLR UDF and Stored Procedures can not be Encrypted. 


Sabah u Din Irfan

Column name	Data type	Description
DATABASE_NAME	sysname	Name of the database. In the Database Engine, this column represents the database name as stored in the sys.databases catalog view.
DATABASE_SIZE	int	Size of database, in kilobytes.
REMARKS	varchar(254)	For the Database Engine, this field always returns NULL.