Junjian junjiantech

## linux_java_druid_connect_oracle_SQLRecoverableException_Connection-reset.sh
# 启动时使用 -Djava.security.egd=file:/dev/urandom 修复该问题
nohup java -Djava.security.egd=file:/dev/urandom -jar $runjarfile >lc-pet.log &

## query_closest_person_by_latitude_longitude.sql
--- $lng 为待查询的经度 $lat 为待查询的纬度
SELECT *
FROM (
	SELECT T_POI.*
		, POWER(MOD(ABS(T_POI.LNG - $lng), 360), 2) + POWER(ABS(T_POI.LAT - $lat), 2) AS distance
	FROM T_POI
	ORDER BY distance ASC
)
WHERE ROWNUM <= 10;
	# 启动时使用 -Djava.security.egd=file:/dev/urandom 修复该问题
	nohup java -Djava.security.egd=file:/dev/urandom -jar $runjarfile >lc-pet.log &
	--- $lng 为待查询的经度 $lat 为待查询的纬度
	SELECT *
	FROM (
	SELECT T_POI.*
	, POWER(MOD(ABS(T_POI.LNG - $lng), 360), 2) + POWER(ABS(T_POI.LAT - $lat), 2) AS distance
	FROM T_POI
	ORDER BY distance ASC
	)
	WHERE ROWNUM <= 10;