2019獨(dú)角獸企業(yè)重金招聘Python工程師標(biāo)準(zhǔn)>>>

新建spring-boot項(xiàng)目，相關(guān)依賴

<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-jpa</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>1.3.2</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><scope>runtime</scope></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency>

使用Druid 連接池 引入依賴

<!--引入druid--><!-- https://mvnrepository.com/artifact/com.alibaba/druid --><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>1.1.10</version></dependency>

編寫Druid配置類

也可以在配置文件中直接配置@Configuration public class DruidConfig {//關(guān)聯(lián)yml文件中的配置項(xiàng)@ConfigurationProperties(prefix = "spring.datasource")@Beanpublic DataSource druid() {return DruidDataSourceBuilder.create().build();}//配置druid 的監(jiān)控 // 1.配置管理后臺(tái)的servlet@Beanpublic ServletRegistrationBean startViewServlet() {ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");Map<String, String> map = new HashMap<>();map.put("loginUsername", "admin");map.put("loginPassword", "123456");map.put("allow", "");//默認(rèn)允許所有訪問 // map.put("deny" , "192.168.11.72");bean.setInitParameters(map);return bean;}//2.配置一個(gè)web監(jiān)控的filter@Beanpublic FilterRegistrationBean webStatFilter() {FilterRegistrationBean bean = new FilterRegistrationBean();bean.setFilter(new WebStatFilter());Map<String, String> map = new HashMap<>();map.put("exclusions", "*.js,*.css,/druid/*");bean.setInitParameters(map);bean.setUrlPatterns(Arrays.asList("/*"));return bean;}}

配置文件中配置的相關(guān)屬性

# application.yml文件采用yml文件格式配置spring:datasource: # 數(shù)據(jù)源基本配置username: rootpassword: 123456driver-class-name: com.mysql.jdbc.Driverurl: jdbc:mysql://192.168.11.72:3306/boot08 # type: com.alibaba.druid.pool.DruidDataSource # 數(shù)據(jù)源其他配置initialSize: 5minIdle: 5maxActive: 20maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 1 FROM DUALtestWhileIdle: truetestOnBorrow: falsetestOnReturn: falsepoolPreparedStatements: true # 配置監(jiān)控統(tǒng)計(jì)攔截的filters，去掉后監(jiān)控界面sql無法統(tǒng)計(jì)，'wall'用于防火墻filters: stat,wall,log4jmaxPoolPreparedStatementPerConnectionSize: 20useGlobalDataSourceStat: trueconnectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

mybatis相關(guān)配置可以使用配置類或者配置文件

public class MybtisConfig {//開啟駝峰public ConfigurationCustomizer configurationCustomizer(){return new ConfigurationCustomizer() {@Overridepublic void customize(Configuration configuration) {configuration.setMapUnderscoreToCamelCase(true);}};} }

mapper.class文件

//@Mapper public interface DepartmentMapper {@Select("select * from department")public List<Department> getList();}@MapperScan(value = "com.wgm") @SpringBootApplication public class BootmybatisApplication {

注意，使用@Mapper注解掃描當(dāng)前接口 ，或者是使用@MapperScan注解掃描包 都會(huì)添加到容器中

這種方式，sql語句可以直接寫在方法上

或者使用配置文件相關(guān)方式，即傳統(tǒng)的配置mybatis-config.xml ,/mapper/*.xml

配置文件中需要修改

mybatis:config-location: classpath:mybatis/mybatis-config.xmlmapper-locations: classpath:mybatis/mapper/*.xml

文件目錄

?

?

轉(zhuǎn)載于:https://my.oschina.net/u/3293802/blog/1927468

總結(jié)

以上是生活随笔為你收集整理的Spring Boot 整合Mybatis (一)的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。