public DbHotel(HotelBean hb) { this.hotelId1 = hb.getHotelId(); this.hotelName1 = hb.getHotelName(); this.description1 = hb.getDescription(); this.location1 = hb.getLocation(); this.rating1 = hb.getRating(); this.roomType1 = hb.getRoomType(); this.costPerRoom1 = hb.getCostPerRoom(); }
public void DeleteHotelDb(HotelBean bean) { System.out.println(bean.getHotelId()); int id = bean.getHotelId(); System.out.println(id); Connection connection1 = null; try { System.out.println("yes"); Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); System.out.println("yes"); connection1 = DriverManager.getConnection( "jdbc:oracle:thin:@172.16.68.55:1521:orcl1", "team5", "collabera"); System.out.println("yes"); PreparedStatement preparedStatementDelete = connection1.prepareStatement("DELETE FROM hotels WHERE hotel_id=?"); preparedStatementDelete.setInt(1, id); int n = preparedStatementDelete.executeUpdate(); System.out.println(n); if (n != 0) { bean.setFlag(true); System.out.println(bean.isFlag()); } else { bean.setFlag(false); System.out.println(bean.isFlag()); } } catch (Exception exception) { System.out.println(exception); } }
public void bookkHotel(HotelBean hb) throws ClassNotFoundException, SQLException { this.hotelId1 = hb.getHotelId(); Class.forName("oracle.jdbc.driver.OracleDriver"); Connection connection = DriverManager.getConnection( "jdbc:oracle:thin:@172.16.68.55:1521:orcl1", "team5", "collabera"); // String str="select * from Hotelss where HOTEL_LOCATION=? and HOTEL_RATING=? and ROOM_TYPE=?"; PreparedStatement stmt = connection.prepareStatement("select * from Hotels where HOTEL_ID=?"); stmt.setInt(1, hotelId1); // int n=stmt.executeUpdate(); // System.out.println(n); ResultSet rs1; rs1 = stmt.executeQuery(); rs1.next(); // System.out.println(rs1.getString(2)); hb.setHotelName(rs1.getString(2)); hb.setLocation(rs1.getString(3)); hb.setRating(rs1.getInt(5)); hb.setCostPerRoom(rs1.getInt(7)); rs1.close(); stmt.close(); connection.close(); }
public void EditedHotelDb(HotelBean bean) { int id = bean.getHotelId(); // System.out.println("Id = " + id); System.out.println("yup"); Connection connection = null; try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); connection = DriverManager.getConnection( "jdbc:oracle:thin:@172.16.68.55:1521:orcl1", "team5", "collabera"); System.out.println("yup"); PreparedStatement preparedStatementAdd = connection.prepareStatement( "update hotels set hotel_name = ?," + "hotel_location=?,hotel_description=?,hotel_rating=?,room_type=?, cost_per_room=? where hotel_id = " + id); /* System.out.println(bean.getPackageName()); System.out.println(bean.getDestination()); System.out.println(bean.getDescription()); System.out.println(bean.getHotelId()); System.out.println(bean.getNumOfDays()); System.out.println(bean.getHolidayType()); System.out.println(bean.getCostPerPerson()); System.out.println(bean.getPackageId());*/ preparedStatementAdd.setString(1, bean.getHotelName()); preparedStatementAdd.setString(2, bean.getDescription()); preparedStatementAdd.setString(3, (bean.getLocation())); preparedStatementAdd.setInt(4, (bean.getRating())); preparedStatementAdd.setString(5, bean.getRoomType()); preparedStatementAdd.setInt(6, (bean.getCostPerRoom())); // System.out.println("yup"); int n = preparedStatementAdd.executeUpdate(); System.out.println(n); System.out.println("yup"); if (n != 0) { System.out.println("true"); } else { System.out.println("true"); } preparedStatementAdd.close(); } catch (Exception exception) { System.out.println(exception); } }
public void viewHotels(HotelBean hb) throws ClassNotFoundException, SQLException { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection connection = DriverManager.getConnection( "jdbc:oracle:thin:@172.16.68.55:1521:orcl1", "team5", "collabera"); // String str="select * from Hotelss where HOTEL_LOCATION=? and HOTEL_RATING=? and ROOM_TYPE=?"; PreparedStatement stmt = connection.prepareStatement("select * from Hotels"); ArrayList a1 = new ArrayList(); ArrayList a2 = new ArrayList(); ArrayList a3 = new ArrayList(); ArrayList a4 = new ArrayList(); ArrayList a5 = new ArrayList(); ArrayList a6 = new ArrayList(); ArrayList a7 = new ArrayList(); ResultSet rs1; rs1 = stmt.executeQuery(); int n = rs1.getRow(); System.out.println(n); // rs1.next(); // System.out.println(rs1.getString(2)); while (rs1.next()) { a2.add(rs1.getString(2)); a3.add(rs1.getString(3)); a4.add(rs1.getString(4)); Integer i1 = new Integer(rs1.getInt(5)); a5.add(i1); a6.add(rs1.getString(6)); Integer i2 = new Integer(rs1.getInt(7)); a5.add(i2); } hb.setHotelName1(a2); hb.setLocation1(a3); hb.setDescription1(a4); hb.setRating1(a5); hb.setRoomType1(a6); hb.setCostPerRoom1(a7); rs1.close(); stmt.close(); connection.close(); }
public void EditHotelDb(HotelBean bean) { int id = bean.getHotelId(); // System.out.println(bean.getHotelId()); Connection connection; try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); connection = DriverManager.getConnection( "jdbc:oracle:thin:@172.16.68.55:1521:orcl1", "team5", "collabera"); ResultSet rset; System.out.println("executed1"); PreparedStatement preparedStatementEdit = connection.prepareStatement("SELECT * FROM hotels WHERE hotel_id=?"); preparedStatementEdit.setInt(1, id); System.out.println("executed2"); rset = preparedStatementEdit.executeQuery(); System.out.println("executed3"); if (rset == null) { bean.setFlag(false); System.out.println(bean.isFlag()); } else if (rset != null) { while (rset.next()) { bean.setHotelId(rset.getInt(1)); // bean.setHotelName(rset.getString(2)); bean.setDescription(rset.getString(3)); bean.setLocation(rset.getString(4)); bean.setRating(rset.getInt(5)); bean.setRoomType(rset.getString(6)); bean.setCostPerRoom(rset.getInt(7)); bean.setFlag(true); System.out.println(bean.isFlag()); System.out.println(bean.getHotelId()); System.out.println(bean.getHotelName()); System.out.println(bean.isFlag()); } } } catch (Exception exception) { System.out.println(exception); } }