Jpa跨库查询数据

方法的一、使用原生SQL语句

1、添加实体类

@Entity()
@Data
public class User implements Serializable {
    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    @Column(name = "name")
    private String name;
    @Column(name = "age")
    public String age;
}

2、创建Repository类

@Repository
public interface TestUserRepository extends JpaRepository<User, Long> {

    @Query(nativeQuery = true, value = "SELECT u.name FROM test_user.user AS u")
    List<String> findUser();
}

2.1  nativeQuery

        true：表示使用原生SQL查询

2.2  test_user.user：库名.表名

方法二、使用对象查询

1、添加实体类

@Entity()
@Data
@Table(name = "user", catalog = "test_user")
// name是表名， catalog是库名
public class User implements Serializable {
    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    @Column(name = "name")
    private String name;
    @Column(name = "age")
    public String age;
}

2、创建Repository类

@Repository
public interface TestUserRepository extends JpaRepository<User, Long> {

    @Query(nativeQuery = false, value = "SELECT u FROM User AS u")
    List<User> findUser();
}

最后

以上就是耍酷小丸子最近收集整理的关于Jpa跨库查询数据的全部内容，更多相关Jpa跨库查询数据内容请搜索靠谱客的其他文章。