java代码:
public Page queryReserveStore(User user,int pageNo) {
Kv kv = Kv.by("lattitude", user.getLatitude()).set("longitude", user.getLongitude());
return paginate(pageNo, Global.pageSize, getSqlPara("user.queryReserveStore",kv));
}
sql代码:
#sql("queryReserveStore")
SELECT id,store_name,province,city,area,address,
ROUND(6378.138*2*ASIN(SQRT(POW(SIN((#para(lattitude)*PI()/180-latitude*PI()/180)/2),2)+
COS(#para(lattitude)*PI()/180)*COS(latitude*PI()/180)*POW(SIN((#para(longitude)*PI()/180-longitude*PI()/180)/2),2)))*1000)
AS juli
FROM y_reserve_store WHERE is_publish = 1 AND del_flag = 0 ORDER BY juli Asc
#end
错误提示:
com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: Parameter index out of range (1 > number of parameters, whic