/**
* <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:添加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;
}