/**
* <br>
* Description:根据Id返回mapservice, 如果不存在，生成一个mapservice <br>
* Author:黎春行 <br>
* Date:2012-7-17
*
* @param id
* @return
*/
public MapServiceBean getMapServiceById(String id) {
MapServiceBean mapServiceBean = new MapServiceBean();
mapServiceBean.setServerId(id);
String sql = "select * from GIS_MAPSERVICES t where t.serverid=?";
Object args[] = {id};
List<Map<String, Object>> resultList = query(sql, CORE, args);
if (resultList.size() >= 1) {
Map<String, Object> resultMap = resultList.get(0);
mapServiceBean.buildBean(resultMap);
} else {
addMapService(mapServiceBean);
}
return mapServiceBean;
}
/**
* <br>
* Description:添加mapServcie <br>
* Author:黎春行 <br>
* Date:2012-7-17
*
* @param mapServiceBean
* @return
*/
public int addMapService(MapServiceBean mapServiceBean) {
String sql =
"insert into GIS_MAPSERVICES(id, alias, url, type, opacity, defaulton, format, flag, ranking, serverid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
String args[] = {
mapServiceBean.getId(),
mapServiceBean.getAlias(),
mapServiceBean.getUrl(),
mapServiceBean.getType(),
mapServiceBean.getOpacity(),
mapServiceBean.getDefaulton(),
mapServiceBean.getFormat(),
mapServiceBean.getFlag(),
mapServiceBean.getRanking(),
mapServiceBean.getServerId()
};
int result = update(sql, CORE, args);
return result;
}
/**
* <br>
* Description:添加mapServcie <br>
* Author:黎春行 <br>
* Date:2012-7-17
*
* @param mapServiceBean
* @return
*/
public int updateMapService(MapServiceBean mapServiceBean, String id) {
String sql =
"update GIS_MAPSERVICES t set t.id = ?, t.alias=?, t.url=?, t.type=?, t.opacity=?, t.defaulton=?, t.format=?, t.flag=?, t.ranking=? where t.serverid=?";
String args[] = {
mapServiceBean.getId(),
mapServiceBean.getAlias(),
mapServiceBean.getUrl(),
mapServiceBean.getType(),
mapServiceBean.getOpacity(),
mapServiceBean.getDefaulton(),
mapServiceBean.getFormat(),
mapServiceBean.getFlag(),
mapServiceBean.getRanking(),
id
};
int result = update(sql, CORE, args);
return result;
}
/**
* <br>
* Description:删除mapService <br>
* Author:黎春行 <br>
* Date:2012-7-17
*
* @param mapServiceBean
* @return
*/
public int deleteMapService(MapServiceBean mapServiceBean) {
String sql = "delete GIS_MAPSERVICES t where t.serverid=? ";
String args[] = {mapServiceBean.getServerId()};
int result = update(sql, CORE, args);
return result;
}
