Beispiel #1
0
 public boolean load(int id) throws SQLException {
   boolean ret = true;
   Connection conn = Site.getDataBaseConnection();
   PreparedStatement pstat =
       conn.prepareStatement(
           "SELECT id,Name,Address,Telephone,MapURL,Description FROM Hotel Where id=?",
           ResultSet.TYPE_FORWARD_ONLY,
           ResultSet.CONCUR_READ_ONLY,
           ResultSet.CLOSE_CURSORS_AT_COMMIT);
   pstat.setInt(1, id);
   pstat.execute();
   ResultSet rs = pstat.getResultSet();
   if (!rs.next()) {
     ret = false;
   } else {
     this.id = rs.getInt("id");
     name = rs.getString("Name");
     address = rs.getString("Address");
     telephone = rs.getString("Telephone");
     mapURL = rs.getString("MapURL");
     description = rs.getString("Description");
   }
   rs.close();
   pstat.close();
   conn.close();
   return ret;
 }
Beispiel #2
0
 /**
  * 返回所有酒店
  *
  * @return
  * @throws SQLException
  */
 public static List<Hotel> getAllHotels() throws SQLException {
   Connection conn = Site.getDataBaseConnection();
   PreparedStatement pstat =
       conn.prepareStatement(
           "SELECT id,Name,Address,Telephone,MapURL,Description FROM Hotel ",
           ResultSet.TYPE_FORWARD_ONLY,
           ResultSet.CONCUR_READ_ONLY,
           ResultSet.CLOSE_CURSORS_AT_COMMIT);
   pstat.execute();
   ResultSet rs = pstat.getResultSet();
   ArrayList<Hotel> hotels = new ArrayList<Hotel>();
   while (rs.next()) {
     hotels.add(
         new Hotel(
             rs.getInt("id"),
             rs.getString("Name"),
             rs.getString("Address"),
             rs.getString("Telephone"),
             rs.getString("MapURL"),
             rs.getString("Description")));
   }
   rs.close();
   pstat.close();
   conn.close();
   return hotels;
 }
Beispiel #3
0
 public void update() throws SQLException {
   Connection conn = Site.getDataBaseConnection();
   PreparedStatement pstat =
       conn.prepareStatement(
           "UPDATE Hotel SET Name=?,Address=?,Telephone=?,MapURL=?,Description=? WHERE id=?",
           ResultSet.TYPE_FORWARD_ONLY,
           ResultSet.CONCUR_UPDATABLE,
           ResultSet.CLOSE_CURSORS_AT_COMMIT);
   pstat.setString(1, name);
   pstat.setString(2, address);
   pstat.setString(3, telephone);
   pstat.setString(4, mapURL);
   pstat.setString(5, description);
   pstat.setInt(6, id);
   pstat.execute();
   pstat.close();
   conn.close();
 }
Beispiel #4
0
 public void add() throws SQLException {
   Connection conn = Site.getDataBaseConnection();
   PreparedStatement pstat =
       conn.prepareStatement(
           "INSERT INTO Hotel(Name,Address,Telephone,MapURL,Description) VALUES(?,?,?,?,?)",
           Statement.RETURN_GENERATED_KEYS);
   pstat.setString(1, name);
   pstat.setString(2, address);
   pstat.setString(3, telephone);
   pstat.setString(4, mapURL);
   pstat.setString(5, description);
   pstat.execute();
   ResultSet rs = pstat.getGeneratedKeys();
   if (rs.next()) {
     this.id = rs.getInt(1);
   }
   rs.close();
   pstat.close();
   conn.close();
 }
Beispiel #5
0
 public static void delete(int id) throws SQLException {
   Connection conn = Site.getDataBaseConnection();
   conn.createStatement().executeUpdate("DELETE FROM Hotel WHERE id=" + id);
   conn.close();
 }