public DbHotel(BeanSearchHotel hb) { this.location1 = hb.getLocation(); this.rating1 = hb.getRating(); this.roomType1 = hb.getRoomType(); /*System.out.println(location1); System.out.println(rating1); System.out.println(roomType1);*/ }
public void DbSearchHotel(BeanSearchHotel hb) throws Exception { System.out.println("In DB Function"); 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_LOCATION=? and HOTEL_RATING=? and ROOM_TYPE=?"); stmt.setString(1, location1); stmt.setInt(2, rating1); stmt.setString(3, roomType1); System.out.println(location1); System.out.println(rating1); System.out.println(roomType1); // int n=stmt.executeUpdate(); // System.out.println(n); System.out.println("After Prepared"); 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(); /*System.out.println(location1); System.out.println(rating1); System.out.println(roomType1);*/ // int n=rs1.getRow(); // System.out.println(n); // rs1.next(); // System.out.println(rs1.getString(2)); while (rs1.next()) { Integer i = new Integer(rs1.getInt(1)); System.out.println(rs1.getInt(1)); a1.add(i); a2.add(rs1.getString(2)); System.out.println(rs1.getString(2)); a3.add(rs1.getString(3)); System.out.println(rs1.getString(3)); a4.add(rs1.getString(4)); System.out.println(rs1.getString(4)); System.out.println(rs1.getInt(5)); System.out.println(rs1.getString(6)); System.out.println(rs1.getInt(7)); int i9 = rs1.getInt(5); Integer i5 = new Integer(i9); a5.add(i5); a6.add(rs1.getString(6)); int i7 = rs1.getInt(7); Integer i8 = new Integer(i7); a7.add(i8); } System.out.println(a1.size()); System.out.println(a2.size()); System.out.println(a3.size()); System.out.println(a4.size()); System.out.println(a5.size()); System.out.println(a6.size()); System.out.println(a7.size()); hb.setHotelId(a1); hb.setHotelName(a2); hb.setLocation1(a3); hb.setDescription(a4); hb.setRating1(a5); hb.setRoomType1(a6); hb.setCostPerRoom(a7); stmt.close(); connection.close(); }