java& Mysql where中in操作
五哥 2019-01-21 11:12:39 SELECT oper_state AS name, COUNT(1) AS cnt FROM test WHERE (longitude, latitude) in ( :lngLat )
GROUP BY oper_state ORDER BY NULL
如何注入lngLat
map.put("lngLat", poi) ;
其中poi为 lng, lat
toString(){
return "("+ lng + "," + lat+")" ;
}