struts2示例（包含源代码）

package com.dabing.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import com.dabing.entity.MapUrl; ; public class MapUrlDao { public static int addMapUrl(MapUrl mapUrl) { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); int result = 0; try { PreparedStatement prst = con .prepareStatement("insert into FL_District_Url values(?,?,?)"); prst.setString(1, mapUrl.getTreeLayer()); prst.setInt(2, mapUrl.getChannelId()); prst.setString(3, mapUrl.getUrl()); result = prst.executeUpdate(); } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return result; } public static int updateMapUrl(MapUrl mapUrl) { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); int result = 0; try { PreparedStatement prst = con .prepareStatement("update FL_District_Url set TreeLayer=?,ChannelId=?,url=? where id=?"); prst.setString(1, mapUrl.getTreeLayer()); prst.setInt(2, mapUrl.getChannelId()); prst.setString(3, mapUrl.getUrl()); prst.setInt(4, mapUrl.getId()); result = prst.executeUpdate(); } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return result; } public static int deleteMapUrl(int id) { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); int result = 0; try { PreparedStatement prst = con .prepareStatement("delete from FL_District_Url where id=?"); prst.setInt(1, id); result = prst.executeUpdate(); } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return result; } public static MapUrl getMapUrlById(int id) { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); MapUrl mapUrl = new MapUrl(); try { PreparedStatement prst = con .prepareStatement("select url.id,url.TreeLayer,url.channelId,url.Url,d.name,c.name" + " from FL_District_Url as url,District as d,ChannelColumns as c " + " where url.TreeLayer=d.TreeLayer and url.channelId=c.id and url.id=? "); prst.setInt(1, id); ResultSet result = prst.executeQuery(); if (result.next()) { mapUrl.setId(result.getInt(1)); mapUrl.setTreeLayer(result.getString(2)); mapUrl.setChannelId(result.getInt(3)); mapUrl.setUrl(result.getString(4)); mapUrl.setDistrictName(result.getString(5)); mapUrl.setChannelName(result.getString(6)); } } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return mapUrl; } public static MapUrl getDistrictByTreeLayer(String treeLayer) { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); MapUrl mapUrl = new MapUrl(); try { PreparedStatement prst = con .prepareStatement("select Name from District where TreeLayer=?"); prst.setString(1, treeLayer); ResultSet result = prst.executeQuery(); if (result.next()) { mapUrl.setTreeLayer(treeLayer); mapUrl.setDistrictName(result.getString(1)); } } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return mapUrl; } public static ArrayList<MapUrl> getUrlByTreeLayer(String treeLayer) { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); ArrayList<MapUrl> mapList = new ArrayList<MapUrl>(); try { PreparedStatement prst = con .prepareStatement("select * from FL_District_Url where TreeLayer=?"); prst.setString(1, treeLayer); ResultSet result = prst.executeQuery(); while (result.next()) { // 每一条记录对应一个javabean对象 MapUrl mapUrl = new MapUrl(); mapUrl.setId(result.getInt(1)); mapList.add(mapUrl); } } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return mapList; } public static ArrayList<MapUrl> getAllTreeLayer() { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); ArrayList<MapUrl> mapList = new ArrayList<MapUrl>(); try { PreparedStatement prst = con .prepareStatement("select TreeLayer,Name from District"); ResultSet result = prst.executeQuery(); while (result.next()) { // 每一条记录对应一个javabean对象 MapUrl mapUrl = new MapUrl(); mapUrl.setTreeLayer(result.getString(1)); mapUrl.setDistrictName(result.getString(2)); mapList.add(mapUrl); } } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return mapList; } public static ArrayList<MapUrl> getAllChannel() { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); ArrayList<MapUrl> mapList = new ArrayList<MapUrl>(); try { PreparedStatement prst = con .prepareStatement("select id,name from ChannelColumns"); ResultSet result = prst.executeQuery(); while (result.next()) { MapUrl mapUrl = new MapUrl(); mapUrl.setChannelId(result.getInt(1)); mapUrl.setChannelName(result.getString(2)); mapList.add(mapUrl); } } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return mapList; } public static ArrayList<MapUrl> getAllProvince() { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); ArrayList<MapUrl> mapList = new ArrayList<MapUrl>(); try { PreparedStatement prst = con .prepareStatement("select TreeLayer,Name from District where len(TreeLayer)=4"); ResultSet result = prst.executeQuery(); while (result.next()) { MapUrl mapUrl = new MapUrl(); mapUrl.setTreeLayer(result.getString(1)); mapUrl.setDistrictName(result.getString(2)); mapList.add(mapUrl); } } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return mapList; } public static ArrayList<MapUrl> getCitysByProvince(String provinceId) { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); ArrayList<MapUrl> mapList = new ArrayList<MapUrl>(); try { // PreparedStatement prst = con // .prepareStatement("select TreeLayer,Name from District where TreeLayer like '" // + provinceId + "____'"); // // ResultSet result = prst.executeQuery(); Statement prst = con.createStatement(); ResultSet result = prst .executeQuery("select TreeLayer,Name from District where TreeLayer like '" + provinceId + "____'"); while (result.next()) { MapUrl mapUrl = new MapUrl(); mapUrl.setTreeLayer(result.getString(1)); mapUrl.setDistrictName(result.getString(2)); mapList.add(mapUrl); } } catch (SQLException ex) { ex.printStackTrace(); } finally { // 关闭数据库连接 ConnectionManager.closeConnection(con); } return mapList; } public static ArrayList<MapUrl> getRootChannels() { // 打开数据库连接 Connection con = ConnectionManager.getConnction(); ArrayList<MapUrl> mapList = new ArrayList<MapUrl>(); try { PreparedStatement prst = con .prepareStatement("select id,Name from ChannelColumns where len(TreeLayer)=4"); ResultSet result = prst.executeQuery(); while (result.next()) { MapUrl mapUrl = new MapUrl(); mapUrl.setChannelId(result.getInt