@RestController
@RequestMapping("/lookup/{tableName}")
public class LookupController {

@Autowired
private GenericRepository repository;

@GetMapping
public List<?> list(@PathVariable String tableName) {
    return repository.findAll(tableName);
}

@GetMapping("/{id}")
public Object get(@PathVariable String tableName, @PathVariable Long id) {
    return repository.findById(tableName, id);
}

@PutMapping("/{id}")
public void update(@PathVariable String tableName, @PathVariable Long id, @RequestBody Object entity) {
    repository.save(tableName, entity);
}

@GetMapping("/findBy/{property}/{value}")
public List<?> findByProperty(@PathVariable String tableName, @PathVariable String property, @PathVariable String value) {
    return repository.findByProperty(tableName, property, value);
}

字符串
}

@Repository
public class GenericRepository {

@PersistenceContext
private EntityManager entityManager;

public List<?> findAll(String tableName) {
    return entityManager.createQuery("SELECT e FROM " + tableName + " e").getResultList();
}

public Object findById(String tableName, Long id) {
    return entityManager.find(tableName, id);
}

public void save(String tableName, Object entity) {
    entityManager.merge(entity);
}

public List<?> findByProperty(String tableName, String property, String value) {
    String query = "SELECT e FROM " + tableName + " e WHERE e." + property + " = :value";
    TypedQuery<?> typedQuery = entityManager.createQuery(query, Object.class);
    typedQuery.setParameter("value", value);
    return typedQuery.getResultList();
}

型
上面的引用是一种方式或通用实体类，可用于表示所有查找表。并创建一个扩展JPA存储库的通用存储库，将其注入控制器，并使用它执行查找实体的各种CRUD操作。

public interface GenericRepository <T, ID extends Serializable> extends JpaRepository<T, ID> {

型
}