基于Java Web的旅游网站设计与实现.rar

package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import util.DBUtil; import entity.ScenicSpot; public class ScenicSpotDAO { public List<ScenicSpot> findScenicspots()// 旅游景点数据库操作 { String sql = "select * from scenicspot"; Connection conn = null; List<ScenicSpot> spots = null; ResultSet rs = null; PreparedStatement stat = null; try { conn = DBUtil.getConnection(); stat = conn.prepareStatement(sql); rs = stat.executeQuery(); spots = new ArrayList<ScenicSpot>(); while (rs.next()) { ScenicSpot spot = new ScenicSpot(); spot.setScenicspotID(rs.getInt(1)); spot.setScenicspotName(rs.getString(2)); spot.setScenicspotPrice(rs.getDouble(3)); spot.setScenicspotAddress(rs.getString(4)); spot.setScenicspotPhone(rs.getString(5)); spot.setScenicspotInfo(rs.getString(6)); spot.setScenicspotPic(rs.getString(7)); spot.setScenicspotPlace(rs.getInt(8)); spots.add(spot); } return spots; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } finally { try { rs.close(); stat.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public ScenicSpot findScenicspotsByID(int id) { String sql = "select * from scenicspot where ScenicspotID=?"; Connection conn = null; ResultSet rs = null; PreparedStatement stat = null; try { conn = DBUtil.getConnection(); stat = conn.prepareStatement(sql); stat.setInt(1, id); rs = stat.executeQuery(); ScenicSpot spot = new ScenicSpot(); while (rs.next()) { spot.setScenicspotID(rs.getInt(1)); spot.setScenicspotName(rs.getString(2)); spot.setScenicspotPrice(rs.getDouble(3)); spot.setScenicspotAddress(rs.getString(4)); spot.setScenicspotPhone(rs.getString(5)); spot.setScenicspotInfo(rs.getString(6)); spot.setScenicspotPic(rs.getString(7)); spot.setScenicspotPlace(rs.getInt(8)); } return spot; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } finally { try { rs.close(); stat.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public List<ScenicSpot> findSpotByPlace(int id)// 旅游景点数据库操作 { String sql = "select * from scenicspot where ScenicspotPlace=?"; Connection conn = null; List<ScenicSpot> spots = null; ResultSet rs = null; PreparedStatement stat = null; try { conn = DBUtil.getConnection(); stat = conn.prepareStatement(sql); stat.setInt(1, id); rs = stat.executeQuery(); spots = new ArrayList<ScenicSpot>(); while (rs.next()) { ScenicSpot spot = new ScenicSpot(); spot.setScenicspotID(rs.getInt(1)); spot.setScenicspotName(rs.getString(2)); spot.setScenicspotPrice(rs.getDouble(3)); spot.setScenicspotAddress(rs.getString(4)); spot.setScenicspotPhone(rs.getString(5)); spot.setScenicspotInfo(rs.getString(6)); spot.setScenicspotPic(rs.getString(7)); spot.setScenicspotPlace(rs.getInt(8)); spots.add(spot); } return spots; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } finally { try { rs.close(); stat.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }