Create XML File

Here is the method using which you can create XML file from your ResultSet

public String xmlCreation(ResultSet rSet, ResultSetMetaData rsMData){
  try{
   DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
      DocumentBuilder parser = factory.newDocumentBuilder();
      Document doc = parser.newDocument();
         Element root = doc.createElement("ListData");
         doc.appendChild(root);
         if(rSet!=null){
          while(rSet.next()){
           Element row = doc.createElement("Row");
              root.appendChild(row);
           int totColumns = rsMData.getColumnCount();
           for(int i=1;i<=totColumns;i++){
            String columnName = rsMData.getColumnName(i);
            Object columnValue = rSet.getObject(i);
            Element childElement = doc.createElement(columnName);
            childElement.appendChild(doc.createTextNode(columnValue.toString()));
            row.appendChild(childElement);
           }
          }
         }
         TransformerFactory tranFactory = TransformerFactory.newInstance(); 
         Transformer aTransformer = tranFactory.newTransformer(); 
         Source src = new DOMSource(doc);
         StringWriter writer = new StringWriter();
         Result dest = new StreamResult(writer);
         aTransformer.transform(src, dest);
         StringBuffer strBuf = writer.getBuffer();
         System.out.println(strBuf.toString());
         return strBuf.toString();
  }catch(Exception e){
   System.out.println("Opps Error: "+e.toString());
   return null;
  }
 }

Read More

Generate XML for jqGrid

 public String generateXMLforjqGrid(ResultSet rSet,int Page,int tPage,int Count){
  String returnString = "";
  ResultSet rs = null;
  ResultSetMetaData rsMetaData = null;
  try{
   rs = rSet;
   rsMetaData = rs.getMetaData();
   if(rs!=null){
    returnString = "";
    returnString += "";
    returnString += ""+Page+"";
    returnString += ""+tPage+"";
    returnString += ""+Count+"";
    while(rSet.next()){
     returnString += "";
     int totColumns = rsMetaData.getColumnCount();
           for(int i=1;i<=totColumns;i++){
            if("INT".equalsIgnoreCase(rsMetaData.getColumnTypeName(i))){
             returnString += "<![CDATA["+rs.getInt(rsMetaData.getColumnName(i))+"]]>";
            }
            else if("VARCHAR".equalsIgnoreCase(rsMetaData.getColumnTypeName(i))){
             returnString += "<![CDATA["+rs.getString(rsMetaData.getColumnName(i))+"]]>";
            }
            else{
             returnString += "<![CDATA["+rs.getString(rsMetaData.getColumnName(i))+"]]>";
            }
           }
     returnString += "";
    }
    returnString += "";
   }
  }catch(Exception e){
   System.out.println("Opps Error Occur: "+e.toString());
  }
  return returnString;
 }

Read More

Random Number Generation

Here You can find how to generate random number in java.
Step-1:
Create Class RandomString.java

Step-2:
Copy and paste following code to your Class.

Step-3:
Now you can use generate(int length) method to create random string.(i.e. 'int length' parameter is use for random number length)

package com.test;

import static java.lang.Math.round;
import static java.lang.Math.random;
import static java.lang.Math.pow;
import static java.lang.Math.abs;
import static java.lang.Math.min;
import static org.apache.commons.lang.StringUtils.leftPad;

public class RandomString {
  public static String generate(int length) {
    StringBuffer sb = new StringBuffer();
    for (int i = length; i > 0; i -= 12) {
      int n = min(12, abs(i));
      sb.append(leftPad(Long.toString(round(random() * pow(36, n)), 36), n, '0'));
    }
    System.out.println("Random String: "+sb.toString());
    return sb.toString();
  }
}

Read More