public void updateTicketQueue(int id, int queueType) {
		PreparedStatement statement = null;
		try {
			switch (queueType) {
				case 0:
					statement = conn.prepareStatement("update Tickets set Pending=true,Active=false,Closed=false where TicketID=?");
					break;
				case 1:
					statement = conn.prepareStatement("update Tickets set Pending=false,Active=true,Closed=false where TicketID=?");
					break;
				case 2:
					statement = conn.prepareStatement("update Tickets set Pending=false,Active=false,Closed=true where TicketID=?");
					break;
				default:
					statement = conn.prepareStatement("update Tickets set Pending=true,Active=false,Closed=false where TicketID=?");
					break;
			}
		
			statement.setInt(1, id);
			statement.executeUpdate();
		} catch(SQLException e){
			e.printStackTrace();
		} finally {
			try { if (statement != null) statement.close(); } catch (Exception e) {}
		}
	}