{"id":775,"date":"2020-03-03T10:13:07","date_gmt":"2020-03-03T02:13:07","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=775"},"modified":"2020-03-03T10:13:07","modified_gmt":"2020-03-03T02:13:07","slug":"spring%e4%b8%ad%e4%bd%bf%e7%94%a8mybatis-mybatis-plus%e8%bf%9e%e6%8e%a5sqlserver","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=775","title":{"rendered":"spring\u4e2d\u4f7f\u7528mybatis\/mybatis plus\u8fde\u63a5sqlserver"},"content":{"rendered":"

\u672c\u6587\u4e3b\u8981\u5173\u6ce8\u5982\u4f55\u4f7f\u7528mybatis\/mybatis plus\u8fde\u63a5SQL Server\u6570\u636e\u5e93\uff0c\u56e0\u6b64\u5c06\u7701\u7565\u5176\u4ed6\u9879\u76ee\u914d\u7f6e\u3001\u4ee3\u7801\u3002<\/p>\n

\u6846\u67b6\u9009\u62e9<\/h1>\n

\u5e94\u7528\u6846\u67b6\uff1aspring boot
\nORM\u6846\u67b6\uff1amybatis plus\uff08\u5bf9\u4e8e\u8fde\u63a5\u6570\u636e\u5e93\u800c\u8a00\uff0cmybatis\u548cmybatis plus\u5176\u5b9e\u90fd\u4e00\u6837\uff09
\n\u6570\u636e\u5e93\u8fde\u63a5\u6c60\uff1adruid<\/p>\n

pom\u4f9d\u8d56<\/h1>\n

\u6b64\u5904\u4ec5\u7ed9\u51fa\u6211\u7684\u914d\u7f6e\uff0cmybatis\/druid\u8bf7\u4f9d\u636e\u81ea\u5df1\u9879\u76ee\u7684\u9700\u8981\u8fdb\u884c\u9009\u62e9\u3002
\n\u65b9\u4fbf\u8d77\u89c1\u6211\u7528\u7684\u662fmybatis plus<\/p>\n

        <!--mybatis plus -->\r\n        <dependency>\r\n            <groupId>com.baomidou<\/groupId>\r\n            <artifactId>mybatis-plus-boot-starter<\/artifactId>\r\n            <version>3.1.0<\/version>\r\n        <\/dependency>\r\n        \r\n        <dependency>\r\n            <groupId>org.mybatis.generator<\/groupId>\r\n            <artifactId>mybatis-generator-core<\/artifactId>\r\n            <version>1.3.7<\/version>\r\n        <\/dependency>\r\n        <dependency>\r\n            <groupId>org.mybatis<\/groupId>\r\n            <artifactId>mybatis-spring<\/artifactId>\r\n            <version>2.0.0<\/version>\r\n        <\/dependency>\r\n\r\n        <!-- druid \u8fde\u63a5\u6c60 -->\r\n        <dependency>\r\n            <groupId>com.alibaba<\/groupId>\r\n            <artifactId>druid<\/artifactId>\r\n            <version>1.1.12<\/version>\r\n        <\/dependency>\r\n\r\n        <!--for SqlServer-->\r\n        <dependency>\r\n            <groupId>com.microsoft.sqlserver<\/groupId>\r\n            <artifactId>sqljdbc4<\/artifactId>\r\n            <version>4.0<\/version>\r\n        <\/dependency>\r\n\r\n<\/code><\/pre>\n
\u914d\u7f6e\u6570\u636e\u6e90<\/h1>\n
\u6dfb\u52a0\u6570\u636e\u5e93\u914d\u7f6e<\/h2>\n
YAML\u6587\u4ef6\u4e2d\u6dfb\u52a0\u81ea\u5df1\u6570\u636e\u5e93\u7684\u5730\u5740<\/p>\n
# SQL Server\u6570\u636e\u5e93\r\nspring.datasource.xx.url: jdbc:sqlserver:\/\/\u4f60\u7684\u6570\u636e\u5e93\u5730\u5740:1433;databaseName=\u4f60\u7684\u6570\u636e\u5e93\u540d\u79f0\r\nspring.datasource.xx.username: xxxx\r\nspring.datasource.xx.password: xxxx\r\nspring.datasource.xx.driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver\r\n<\/code><\/pre>\n
\u6dfb\u52a0\u6570\u636e\u6e90<\/h2>\n
\u6b64\u5904\u548c\u5e73\u65f6\u6211\u4eec\u5728spring boot\u4e2d\u96c6\u6210mybatis\/mybatis plus\u4e00\u6837\uff0c\u6dfb\u52a0bean\u5373\u53ef\u3002
\n\u7531\u4e8e\u5e73\u65f6\u7ecf\u5e38\u7528\u5230\u591a\u4e2a\u6570\u636e\u5e93\uff0c\u6b64\u5904\u5c55\u793a\u4e00\u4e2a\u591a\u6570\u636e\u6e90\u7684\u4f8b\u5b50\uff1a\u4e00\u4e2a\u662fmysql\uff0c\u4e00\u4e2a\u662fSQL Server
\n\u6709\u5173mybatis plus\u914d\u7f6e\u6570\u636e\u6e90\u7684\u6ce8\u610f\u4e8b\u9879\uff0c\u6bd4\u5982\u914d\u7f6emapper\u6587\u4ef6\u5939\u7b49\uff0c\u8bf7\u81ea\u884c\u95ee\u5ea6\u5a18\uff0c\u6b64\u5904\u4e0d\u518d\u4e00\u4e00\u6307\u51fa\u3002
\n\u6ce8\u610f\uff1a\u4e0b\u9762\u4ee3\u7801\u6765\u81ea\u5b9e\u9645\u4ee3\u7801\uff0c\u4f46\u6279\u91cf\u5220\u9664\u4e86\u654f\u611f\u4fe1\u606f\u3001\u91cd\u65b0\u547d\u540d\uff0c\u56e0\u800c\u53ef\u80fd\u5b58\u5728\u4e0e\u524d\u9762\u914d\u7f6e\u4fe1\u606f\u4e0d\u4e00\u81f4\u7684\u5730\u65b9\uff0c\u4ec5\u4ec5\u662f\u4e00\u4e2a\u793a\u4f8b<\/p>\n
Mysql\u6570\u636e\u6e90<\/h3>\n
mysql\u6570\u636e\u6e90\u914d\u7f6e\uff0c\u6ce8\u610f\uff0c\u7531\u4e8e\u662f\u591a\u6570\u636e\u6e90\uff0c\u9700\u8981\u6709\u4e00\u4e2a\u6570\u636e\u6e90\u914d\u7f6e\u4e2d\u52a0\u4e0a@Primary\u6ce8\u89e3<\/p>\n
@Configuration\r\n@MapperScan(basePackages = \"com.xxx.mapper\", sqlSessionFactoryRef = \"mysqlSqlSessionFactory\")\r\npublic class MySQLMybatisPlusConfig {\r\n\r\n    @Autowired\r\n    private MybatisPlusProperties properties;\r\n\r\n    @Autowired\r\n    private ResourceLoader resourceLoader = new DefaultResourceLoader();\r\n\r\n    @Autowired(required = false)\r\n    private Interceptor[] interceptors;\r\n\r\n    @Autowired(required = false)\r\n    private DatabaseIdProvider databaseIdProvider;\r\n\r\n    @Autowired\r\n    private Environment env;\r\n\r\n    @Bean(name = \"mysqlDataSource\")\r\n    @Primary\r\n    public DataSource getRecruitDataSource() throws Exception {\r\n        Properties props = new Properties();\r\n        props.put(\"driverClassName\", env.getProperty(\"spring.datasource.mysqlData.driver-class-name\"));\r\n        props.put(\"url\", env.getProperty(\"spring.datasource.mysqlData.url\"));\r\n        props.put(\"username\", env.getProperty(\"spring.datasource.mysqlData.username\"));\r\n        props.put(\"password\", env.getProperty(\"spring.datasource.mysqlData.password\"));\r\n        return DruidDataSourceFactory.createDataSource(props);\r\n    }\r\n\r\n    \/**\r\n     * mybatis-plus\u5206\u9875\u63d2\u4ef6\r\n     *\/\r\n    @Bean\r\n    public PaginationInterceptor paginationInterceptor() {\r\n        PaginationInterceptor page = new PaginationInterceptor();\r\n        page.setDialectType(\"mysql\");\r\n        return page;\r\n    }\r\n\r\n    @Bean(name = \"mysqlSqlSessionFactory\")\r\n    @Primary\r\n    public MybatisSqlSessionFactoryBean mybatisSqlSessionFactoryBean(@Qualifier(\"mysqlDataSource\") DataSource mysqlDataSource) throws IOException {\r\n        MybatisSqlSessionFactoryBean mybatisPlus = new MybatisSqlSessionFactoryBean();\r\n        try {\r\n            mybatisPlus.setDataSource(mysqlDataSource);\r\n        } catch (Exception e) {\r\n            e.printStackTrace();\r\n        }\r\n        mybatisPlus.setVfs(SpringBootVFS.class);\r\n        \/\/ \u8bbe\u7f6e\u5206\u9875\u63d2\u4ef6\r\n        MybatisConfiguration mc = new MybatisConfiguration();\r\n        mc.setDefaultScriptingLanguage(MybatisXMLLanguageDriver.class);\r\n        mc.setMapUnderscoreToCamelCase(true);\/\/ \u6570\u636e\u5e93\u548cjava\u90fd\u662f\u9a7c\u5cf0\uff0c\u5c31\u4e0d\u9700\u8981\r\n        mybatisPlus.setConfiguration(mc);\r\n        if (this.databaseIdProvider != null) {\r\n            mybatisPlus.setDatabaseIdProvider(this.databaseIdProvider);\r\n        }\r\n        mybatisPlus.setTypeAliasesPackage(\"com.xxx.mysql.bean.model\");\r\n        mybatisPlus.setTypeHandlersPackage(this.properties.getTypeHandlersPackage());\r\n        mybatisPlus.setMapperLocations(this.properties.resolveMapperLocations());\r\n        \/\/ \u8bbe\u7f6emapper.xml\u6587\u4ef6\u7684\u8def\u5f84\r\n        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();\r\n        Resource[] resource = resolver.getResources(\"classpath:mapper\/*.xml\");\r\n        mybatisPlus.setMapperLocations(resource);\r\n\r\n        return mybatisPlus;\r\n    }\r\n}\r\n\r\n<\/code><\/pre>\n
SQL Server\u6570\u636e\u6e90<\/h3>\n
@Configuration\r\n@MapperScan(basePackages = \"com.xxx.survey.mapper\", sqlSessionFactoryRef = \"xxSqlSessionFactory\")\r\npublic class SqlServerMybatisConfig {\r\n\r\n    @Autowired\r\n    private MybatisPlusProperties properties;\r\n\r\n    @Autowired\r\n    private ResourceLoader resourceLoader = new DefaultResourceLoader();\r\n\r\n    @Autowired(required = false)\r\n    private Interceptor[] interceptors;\r\n\r\n    @Autowired(required = false)\r\n    private DatabaseIdProvider databaseIdProvider;\r\n\r\n    @Autowired\r\n    private Environment env;\r\n\r\n    @Bean(name = \"xxDataSource\")\r\n    public DataSource getAttendanceDataSource() throws Exception {\r\n        Properties props = new Properties();\r\n        props.put(\"driverClassName\", env.getProperty(\"spring.datasource.xx.driver-class-name\"));\r\n        props.put(\"url\", env.getProperty(\"spring.datasource.xx.url\"));\r\n        props.put(\"username\", env.getProperty(\"spring.datasource.xx.username\"));\r\n        props.put(\"password\", env.getProperty(\"spring.datasource.xx.password\"));\r\n        return DruidDataSourceFactory.createDataSource(props);\r\n    }\r\n\r\n\r\n    @Bean(name = \"xxSqlSessionFactory\")\r\n    public MybatisSqlSessionFactoryBean mybatisSqlSessionFactoryBean(@Qualifier(\"xxDataSource\") DataSource xxDataSource) throws IOException {\r\n        MybatisSqlSessionFactoryBean mybatisPlus = new MybatisSqlSessionFactoryBean();\r\n        try {\r\n            mybatisPlus.setDataSource(xxDataSource);\r\n        } catch (Exception e) {\r\n            e.printStackTrace();\r\n        }\r\n        mybatisPlus.setVfs(SpringBootVFS.class);\r\n        \/\/ \u8bbe\u7f6e\u5206\u9875\u63d2\u4ef6\r\n        MybatisConfiguration mc = new MybatisConfiguration();\r\n        mc.setDefaultScriptingLanguage(MybatisXMLLanguageDriver.class);\r\n        mc.setMapUnderscoreToCamelCase(true);\/\/ \u6570\u636e\u5e93\u548cjava\u90fd\u662f\u9a7c\u5cf0\uff0c\u5c31\u4e0d\u9700\u8981\r\n        mybatisPlus.setConfiguration(mc);\r\n        if (this.databaseIdProvider != null) {\r\n            mybatisPlus.setDatabaseIdProvider(this.databaseIdProvider);\r\n        }\r\n        mybatisPlus.setTypeAliasesPackage(\"com.xxx.survey.bean.model\");\r\n        mybatisPlus.setTypeHandlersPackage(this.properties.getTypeHandlersPackage());\r\n        mybatisPlus.setMapperLocations(this.properties.resolveMapperLocations());\r\n        \/\/ \u8bbe\u7f6emapper.xml\u6587\u4ef6\u7684\u8def\u5f84\r\n        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();\r\n        Resource[] resource = resolver.getResources(\"classpath:mapper\/*.xml\");\r\n        mybatisPlus.setMapperLocations(resource);\r\n\r\n        return mybatisPlus;\r\n    }\r\n}\r\n<\/code><\/pre>\n
\u751f\u6210ORM\u4ee3\u7801<\/h1>\n
\u5230\u8fd9\u91cc\uff0c\u7a0b\u5e8f\u542f\u52a8\u5e94\u8be5\u6ca1\u4ec0\u4e48\u95ee\u9898\uff0c\u63a5\u7740\u5c31\u5e94\u8be5\u751f\u6210DAO\u5c42\u3001Service\u5c42\u4ee3\u7801\u4e86
\nmybatis\u548cmybatis plus\u5728\u6b64\u5904\u6309\u7167\u548c\u8fde\u63a5mysql\u65f6\u4e00\u6837\u7684\u65b9\u6cd5\uff0c\u6839\u636e\u9700\u8981\u5199\u4ee3\u7801\u5373\u53ef\u3002
\n\u6bd4\u5982\u5bf9\u4e8emybatis plus\uff0c\u9700\u8981\u51993\u5904\u4ee3\u7801\uff1a<\/p>\n
    \n
  1. \u5b9e\u4f53bean\uff0c\u53ef\u4ee5\u5229\u7528Spring Boot Code Generator!<\/a>\u6765\u6839\u636eSQL\u8868\u7ed3\u6784\u81ea\u52a8\u751f\u6210<\/li>\n
  2. Mapper\u4ee3\u7801\uff1a\u90fd\u6709\u6a21\u677f\uff0cmybatis plus\u81ea\u5df1\u5c01\u88c5\u7684\u65b9\u6cd5\u5df2\u7ecf\u5f88\u591f\u7528\uff0c\u6709\u5355\u72ec\u9700\u6c42\u53ef\u4ee5\u81ea\u5df1\u5199xml\u6765\u81ea\u5b9a\u4e49SQL<\/li>\n<\/ol>\n
    @Mapper\r\npublic interface XXXMapper extends BaseMapper<XXX> {\r\n\r\n}\r\n<\/code><\/pre>\n
      \n
    1. Service\u4ee3\u7801
      \n\u597d\u50cf\u4e5f\u6709\u73b0\u6210\u7684\u5de5\u5177\u53ef\u4ee5\u81ea\u52a8\u751f\u6210mapper service\u4ee3\u7801\u6765\u7740\u3002
      \nService\u63a5\u53e3<\/li>\n<\/ol>\n
      public interface XXXService extends IService<XXX> {\r\n}\r\n\r\n<\/code><\/pre>\n
      ServiceImpl<\/p>\n
      @Service\r\npublic class XXXServiceImpl extends ServiceImpl<XXXMapper, XXX>\r\n    implements XXXService {\r\n\r\n}\r\n<\/code><\/pre>\n
      \u53c2\u8003\u8d44\u6599<\/h1>\n