public List<Project> Search_file(String projectName, String fileName,
			String format) {
		String query1 = "SELECT distinct e.projID from project e WHERE e.projName='"
				+ projectName + "'";
		EntityManagerFactory emf = Persistence
				.createEntityManagerFactory("PersistenceUnit");
		EntityManager manager = emf.createEntityManager();
		EntityTransaction transaction = manager.getTransaction();
		TypedQuery<Object> q = manager.createQuery(query1, Object.class);
		List<Object> result = q.getResultList();
		String projectID = "";
		for (Object data : result) {
			projectID = (String) data;
		}
		System.out.println(projectID);
		String query = "SELECT e from project_files e WHERE";
		String clause = query.substring(query.lastIndexOf(" ") + 1);
		try {
			if (!projectID.isEmpty()) {
				if (clause.equals("WHERE")) {
					query += " e.projID = '" + projectID + "'";
				} else
					query += " AND e.projID = '" + projectID + "'";
			}
			if (!fileName.isEmpty()) {
				clause = query.substring(query.lastIndexOf(" ") + 1);
				if (clause.equals("WHERE"))
					query += " e.fileName = '" + fileName + "'";
				else
					query += " AND e.fileName = '" + fileName + "'";
			}
			if (!format.isEmpty()) {
				clause = query.substring(query.lastIndexOf(" ") + 1);
				if (clause.equals("WHERE"))
					query += " e.format = '" + format + "'";
				else
					query += " AND e.format = '" + format + "'";
			}

			TypedQuery<Project> qp = manager.createQuery(query, Project.class);
			List<Project> results = qp.getResultList();

			System.out.println(result);
			return results;
		} catch (Exception e) {
			System.out.println(e.getMessage());
			List<Project> results = null;
			return results;
		}

	}