Lune2018的博客

//Controller:把camera状态值不等于4的camera_id传回后台condMap.put("cameraIds", cameraIds); //XML文件:sql语句select * from t where t.id in <foreach collection="cameraIds" index="index" item="item" open=...

select a2.area_id as parent_id, a2.area_name as parent_name, a1.area_id as child_id, a1.area_name as child_namefrom area as a1 left join area as a2 on a1.parent_id = a2.are...

insert into table_a (name,address,longitude,latitude,area_id)(select name,address,longitude,latitude,area_id from table_b)