如何用spring引导在xml中定义命名本机查询

Question

我使用spring引导，我想在xml文件中定义本机查询。这是一个实体：

@NamedNativeQuery(name = "findAllUsers",query = "select * from user")
@Entity
@Table(name="user")
public class User implements Serializable {
    @Id
    @GeneratedValue
    @Column(name = "UserId")
    private Integer userId;
}

和库房：

@Repository
public interface UserDao extends CrudRepository<User, Integer>, JpaSpecificationExecutor<User> {
    @Query(name="findAllUsers")
    List<User> findAllUsers();
}

我希望在本机- sql -oracle.xml和本机-SQL-mysql.xml之间快速切换本机sql。

Answer 1

只要在资源目录中添加一个.hbm.xml文件，它就会在春季被自动扫描。

一个示例xml：

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd" version="1.0">
    <package>com.xxx.auth</package>
    <entity class="User">
        <named-native-query name="searchUser" result-class="User">
            <query>
                <![CDATA[
                SELECT * FROM User
                ]]>
            </query>
        </named-native-query>
    </entity>
</entity-mappings>