NEAREST LOCATION FINDING

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(13.033460 ) ) * cos( radians(govtrto.latitude ) ) * cos( radians(govtrto.longitude ) - radians(80.2340608) ) + sin( radians(   13.033460 ) ) * sin( radians(govtrto.latitude ) ) ) ) AS distance from govtrto order by distance limit 5;";

        

         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("");

        

    }

    }

}

OUTPUT:

listRTO, Chennai(West)
- K K NagarRegional Transport Office,
Chennai (West), No.1
Bharathidasan colony,
K.K.Nagar, Chennai-600078

listRTO, Chennai(South
East)Regional Transport Office,
Chennai (South- East),
No.4 VC Garden II Street,
Mandaveli, Chennai-600028