advancedsearchmanager.java

This is a project used to find a corresondin location from place

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.gecb.mcompanion.web.db;

import java.sql.ResultSet;
/**
 *
 * @author Administrator
 */
public class AdvancedSearchManager extends DBManager
{
  public AdvancedSearchManager()
  {
        super();
  }
 public String SearchResources(String Query,String type)
 {
        String res ="";
        String finalres="";
        try
        {
            ResultSet rs=getStatement().executeQuery(Query);
            
            while(rs.next())
            {
                System.out.println("distance="+rs.getString(1));
                res+=type+":";
                res+= rs.getString(2) + ":" + rs.getString(3) +":" + rs.getString(4) + ":" + rs.getString(5) + ":"+rs.getString(6)+":"+rs.getString(7)+":" ;
                res+="#";
            }
            if(rs.equals(""))
            {
                res+="notfound#";
            }
        }
        
        catch(Exception ie)
        {
            ie.printStackTrace();
        }
        System.out.println(res);
        return res;
  }
}
    /*public String SearchRestaurant(String Query)
    {
        String res ="";
        System.out.println(Query);
        int[] address=new int[20];
        String finalres="";
        int i=0;
        try
        {
            
       ResultSet rs1 = getStatement().executeQuery(Query)  ;
      // rs.next();
        while(rs1.next())
            {
             address[i]=Integer.parseInt(rs1.getString(2)); 
       i++;
              //res+="Restaurant:";
             // res += rs1.getString(3)+":"+rs1.getString(4)+":"+rs1.getString(5)+"&" ;
             
           }
       String [] res1=res.split("&");
      for(int k=0;k<res1.length;k++)
      {
          System.out.println("res1"+res1[k]);
      }
     /* for(int n=0;n<=i;n++)
      {
           //String query ="SELECT ((ACOS(SIN("+ latitude+"* PI() / 180) * SIN(lat * PI() / 180) + COS("+latitude+" * PI() / 180) * COS(lat * PI() / 180) * COS(("+longitude+"- log) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance,resturant.name,description,place,lat,log FROM resturant,address where resturant.address_id=address.address_id HAVING distance<='10' ORDER BY distance ASC";
         // String query="select city,latitude,longitude from address where address_id="+address[n];
           System.out.println("inside query="+query);
          rs1=getStatement().executeQuery(query);
          while(rs1.next())
          {
             finalres+=res1[n]+":"+rs1.getString(1)+":"+rs1.getString(2)+":"+rs1.getString(3)+":";
             finalres+="#";
          }
      }  */          
   //  }
       /* try
        {
            String query1="select latitude,longitude from address,hospital where address.address_id=hospital.address_id and hospital_name='SCTIMST'";
            ResultSet rs=getStatement().executeQuery(query1);
            while(rs.next())
            {
                String latitude=rs.getString(1);
                System.out.println("lati="+latitude);
            }
        }
    catch(Exception ie)
    {
           ie.printStackTrace();
    }
        System.out.println("QUERY OUT");
        System.out.println(finalres);
        return finalres;
    }
      
     public String SearchInstitution(String Query)
    {
        String res ="";
        try
        {
        ResultSet rs = getStatement().executeQuery(Query)  ;
        
        while(rs.next())
        {
            res+="Institution:";
            res += rs.getString(1) + ":" + rs.getString(4) + ":" + rs.getString(7) +":" + rs.getString(8) + ":" + rs.getString(9) + ":" ;
                        res += "#";
        }
        }
        catch(Exception ie)
        {
            ie.printStackTrace();
        }
        System.out.println(res);
        return res;
    }        
     
     
    public String SearchReligiousSpot(String Query)
    {
        String res ="";
        try
        {
        ResultSet rs = getStatement().executeQuery(Query)  ;
        
        while(rs.next())
        {
            res+="Religious_spots:";
            res += rs.getString(1) + ":" + rs.getString(2) + ":" + rs.getString(5) +":" + rs.getString(7) + ":" + rs.getString(6) + ":" ;
                        res += "#";
        }
        }
        catch(Exception ie)
        {
            ie.printStackTrace();
        }
        System.out.println(res);
        return res;
    }  */   
    
  /*   public String SearchLocation(String Query)
    {
        String res ="";
        try
        {
        ResultSet rs = getStatement().executeQuery(Query)  ;
        
        while(rs.next())
        {
            res+="Location:";
            res += rs.getString(1) + ":" + rs.getString(2) + ":" + rs.getString(5) +":" + rs.getString(6) + ":" + rs.getString(7) + ":" ;
                        res += "#";
        }
        }
        catch(Exception ie)
        {
            ie.printStackTrace();
        }
        System.out.println(res);
        return res;
    }       
    
}*/