Saturday, 13 December 2014

query processing withnearest location

package com.map;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class DB {
    static ResultSet rs;
    static PreparedStatement ps;
    static JavCon con=new JavCon();
    static Connection connection;
    public static void main(String[] args) throws SQLException
    {
        Double my_lot=13.033460;
        Double my_long=80.230608;
       
        connection=con.getcon();
        String sql = "select * from govtrto";
        String sql1 = "select *, ( 3959 * acos( cos( radians('"+my_lot+"' ) ) * cos( radians(govtrto.latitude ) ) * cos( radians(govtrto.longitude ) - radians('"+my_long+"') ) + sin( radians('"+my_lot+"' ) ) * sin( radians(govtrto.latitude ) ) ) ) AS distance from govtrto order by distance limit 2;";
       
         ps=connection.prepareStatement(sql1);
    //    ps.setDouble(1, my_lot);
    //    ps.setDouble(2, my_long);
        rs= ps.executeQuery();
        while (rs.next())
        {
       
            System.out.println("list"+rs.getString("RTO Name")+rs.getString("ADDRESS"));
            System.out.println("");
       
    }
    }
}

0 comments

Post a Comment