String sql="SELECT *,( 6371 * acos ( cos ( radians("+lon+") ) * cos( radians( POINT_Y ) ) * cos( radians( POINT_X ) - radians("+lat+") ) + sin ( radians("+lon+") ) * sin( radians( POINT_Y ) ) ) ) AS distance FROM dijishi ORDER BY distance LIMIT 0 , 20";
构造出来的sql语句是:select * from dijishi where name like '%111,20%'