public static void removeMeetingRoom(int meetingID){
			
			try {
				   if(conn == null || conn.isClosed()){
				    conn = DatabaseConnection.getConnection();
				   }
				  } catch (SQLException e1) {
				   // TODO Auto-generated catch block
				   e1.printStackTrace();
				  }
			
			try{
				conn.setAutoCommit(false);
				PreparedStatement stmnt = conn.prepareStatement("DELETE FROM MeetingRooms WHERE room_id = ?");
				stmnt.setInt(1, meetingID);
				
			
				
				stmnt.execute();
				conn.commit();
				conn.setAutoCommit(true);
				
			}catch(SQLException e){
				System.out.println("Remove fail: " + e);
			}
			
		}