Question

I have a linked server in SQL Server so when I query something, it has to be something like this:

SELECT * FROM [SERVERNAME].[DBNAME].[SCHEMA].[TABLE]

现在,我必须采用这一方式,向现有项目查询<编码>servername 、dbname和sschema<>/code>,载于我的代码<>application.properties。

是否有办法从我的Maper(xml)获取这些财产?

Answer 1

You can use properties.
With MyBatis-Spring-Boot, you can define properties in your application.properties with the prefix mybatis.configuration.variables. [1].

mybatis.configuration.variables.db_servername=YOUR_SERVER_NAME
mybatis.configuration.variables.db_dbname=YOUR_DB_NAME
mybatis.configuration.variables.db_schema=YOUR_SCHEMA

也可参考同一份<代码>应用.properties所确定的变量。

mybatis.configuration.variables.db_servername=${servername}
mybatis.configuration.variables.db_dbname=${dbname}
mybatis.configuration.variables.db_schema=${schema}

然后,你可以使用<代码>{}在地图上使用这些变量。

SELECT * FROM [${db_servername}].[${db_dbname}].[${db_schema}].[TABLE]

注:<代码>#{} 赢得t work。 See this FAQ/2005/ for the differences。

*** 准则指出,序号为mybatis.configuration-properties.,但我刚刚测试了该编号,并且做了一些工作。然而,这可能是我的错误。我计划在我有一定时间时进行调查。

Answer 2

申请。特性

mybatis.1. 组合繁荣.tablesSchema=foo

In mapper.xml

select * from ${tablesSchema}.bar

1. 组合繁荣

Externalized properties for MyBatis configuration. Specified properties can be used as placeholder on MyBatis config file and Mapper file. For detail see the MyBatis reference page.

配置。 * E/CN.6/2009/1。

Property keys for Configuration bean provided by MyBatis Core. About available nested properties see the MyBatis reference page. NOTE: This property cannot be used at the same time with the config-location.

See https://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/

[Troublefireing Tips]

Check the bean of MybatisProperties.configurationProperties to make sure your property has been loaded.
If you create your own SqlSessionFactory bean, don t forget to call SqlSessionFactoryBean.setConfigurationProperties(MybatisProperties) in that bean method.

友情链接