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

Categories: J2EE, Java, jqGrid, jQuery