Jpa跨库查询数据

壹修_Java

已于 2022-12-09 14:06:39 修改

阅读量1k

点赞数

分类专栏： Java 文章标签： java 开发语言 hibernate

于 2022-12-08 14:28:52 首次发布

本文链接：https://blog.csdn.net/qq_43707203/article/details/128236150

版权

Java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

方法的一、使用原生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();
}