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