国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 開發(fā) > Java > 正文

SpringBoot項(xiàng)目整合mybatis的方法步驟與實(shí)例

2024-07-14 08:43:41
字體:
供稿:網(wǎng)友

1. 導(dǎo)入依賴的jar包

springboot項(xiàng)目整合mybatis之前首先要導(dǎo)入依賴的jar包,配置pom.xml文件如下:

<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0"     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>com.u</groupId>  <artifactId>springboot-mybatis</artifactId>  <version>1.0-SNAPSHOT</version>  <parent>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-parent</artifactId>    <version>1.3.0.RELEASE</version>  </parent>  <properties>    <start-class>com.us.Application</start-class>    <mybatis.version>3.2.7</mybatis.version>    <mybatis-spring.version>1.2.2</mybatis-spring.version>    <maven.compiler.target>1.8</maven.compiler.target>    <maven.compiler.source>1.8</maven.compiler.source>  </properties>  <dependencies>    <!--springboot-->    <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-web</artifactId>    </dependency>    <!--db-->    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>6.0.5</version>    </dependency>    <dependency>      <groupId>com.mchange</groupId>      <artifactId>c3p0</artifactId>      <version>0.9.5.2</version>      <exclusions>        <exclusion>          <groupId>commons-logging</groupId>          <artifactId>commons-logging</artifactId>        </exclusion>      </exclusions>    </dependency>    <!--mybatis-->    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-jdbc</artifactId>    </dependency>    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis</artifactId>      <version>${mybatis.version}</version>    </dependency>    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis-spring</artifactId>      <version>${mybatis-spring.version}</version>    </dependency>    <!--util-->    <dependency>      <groupId>org.apache.commons</groupId>      <artifactId>commons-lang3</artifactId>      <version>3.4</version>    </dependency>  </dependencies></project>

2. 配置數(shù)據(jù)源

pom.xml配置完畢后需要配置數(shù)據(jù)源了。新建DBConfig類配置數(shù)據(jù)源,代碼如下:

import org.springframework.beans.factory.annotation.Autowired;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.core.env.Environment;import com.alibaba.druid.pool.DruidDataSource;import com.google.common.base.Preconditions;@Configurationpublic class DBConfig {  @Autowired  private Environment env;  @Bean(name = "dataSource")  public DruidDataSource dataSource() {    final String url = Preconditions.checkNotNull(env.getProperty("ms.db.url"));    final String username = Preconditions.checkNotNull(env.getProperty("ms.db.username"));    final String password = env.getProperty("ms.db.password");    final int maxActive = Integer.parseInt(env.getProperty("ms.db.maxActive", "200"));    DruidDataSource dataSource = new DruidDataSource();    dataSource.setUrl(url);    dataSource.setUsername(username);    dataSource.setPassword(password);    dataSource.setMaxActive(maxActive);    return dataSource;  }}

3. 添加數(shù)據(jù)庫連接信息

在配置文件application.properties中添加數(shù)據(jù)庫連接信息如下:

ms.db.url=jdbc:mysql://localhost:3306/dev?prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&characterEncoding=utf-8&allowMultiQueries=truems.db.username=rootms.db.password=adminms.db.maxActive=500

4. 配置mybatis的SqlSessionFactoryBean

數(shù)據(jù)源配置完以后要配置mybatis的SqlSessionFactoryBean進(jìn)行掃描mapper,新建MyBatisConfig類代碼如下(classpath*:mapper/*.xml為mapper.xml文件路徑):

import javax.sql.DataSource;import org.mybatis.spring.SqlSessionFactoryBean;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.context.ApplicationContext;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;@Configurationpublic class MyBatisConfig {  @Autowired  private DataSource dataSource;  @Bean(name = "sqlSessionFactory")  public SqlSessionFactoryBean sqlSessionFactory(ApplicationContext applicationContext) throws Exception {    SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();    sessionFactory.setDataSource(dataSource);    sessionFactory.setMapperLocations(applicationContext.getResources("classpath*:mapper/*.xml"));    return sessionFactory;  }}

5. 配置MapperScannerConfigurer掃描dao層

然后配置MapperScannerConfigurer掃描dao層,新建類MyBatisScannerConfig代碼如下(注意與MyBatisConfig不要寫在一個(gè)類里):

import org.mybatis.spring.mapper.MapperScannerConfigurer;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;@Configurationpublic class MyBatisScannerConfig {  @Bean  public MapperScannerConfigurer MapperScannerConfigurer() {    MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();    mapperScannerConfigurer.setBasePackage("com.example.*.dao");    mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory");    return mapperScannerConfigurer;  }}

6. 開啟數(shù)據(jù)庫事務(wù)(必須)代碼如下

import javax.sql.DataSource;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.jdbc.datasource.DataSourceTransactionManager;import org.springframework.transaction.PlatformTransactionManager;import org.springframework.transaction.annotation.TransactionManagementConfigurer;@Configurationpublic class TransactionConfig implements TransactionManagementConfigurer{  @Autowired  private DataSource dataSource;  @Bean(name = "transactionManager")  @Override  public PlatformTransactionManager annotationDrivenTransactionManager() {    return new DataSourceTransactionManager(dataSource);  }}

7. 實(shí)戰(zhàn)

配置大致就是如此,然后就是新建java bean(省略,文章底部有源碼地址)

新建mapper.xml文件(省略,文章底部有源碼地址,關(guān)于mapper.xml 文件編寫的疑問可以看我以前的springmvc+mybatis 系列文章)

新建dao層。代碼如下:

import java.util.List;import java.util.Map;import com.example.base.model.User;import com.example.config.MyBatisRepository;public interface UserDao {  public List<User> getList(Map<String,Object> map);}

service層要在實(shí)現(xiàn)類上添加@service注解,代碼如下:

import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.example.base.dao.UserDao;import com.example.base.service.UserService;@Servicepublic class UserServiceImpl implements UserService {  @Autowired  private UserDao userDao;  public Object getList(Map<String, Object> map) {    return userDao.getList(map);  }}

controller層也要加@controller注解代碼如下:

import javax.servlet.http.HttpServletRequest;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.http.HttpStatus;import org.springframework.http.ResponseEntity;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.ResponseBody;import com.example.base.service.UserService;import com.example.base.util.CommonUtil;import com.example.demo.ServiceEmail;@Controller@RequestMapping(value = "/users")public class UserController {  @Autowired  private UserService userService;  @Autowired  private ServiceEmail serviceEmail;  /***   * api :localhost:8099/users?id=99 localhost:8099/users   *    * @param request   * @return   */  @RequestMapping(method = RequestMethod.GET, produces = "application/json;charset=UTF-8")  @ResponseBody  public ResponseEntity<?> list(HttpServletRequest request) {    Map<String, Object> map = CommonUtil.getParameterMap(request);    return new ResponseEntity<Object>(userService.getList(map), HttpStatus.OK);  }  }

然后在啟動(dòng)入口類中掃描定義的這些配置累(配置包名可卻省只寫部分包名)如下:

import java.util.Arrays;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.boot.builder.SpringApplicationBuilder;import org.springframework.boot.context.web.SpringBootServletInitializer;import org.springframework.context.ApplicationContext;import org.springframework.context.annotation.ComponentScan;import org.springframework.scheduling.annotation.EnableScheduling;@ComponentScan(basePackages ="com.example")@SpringBootApplicationpublic class Application extends SpringBootServletInitializer{  @Override  protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {    return application.sources(Application.class);  }  public static void main(String[] args) throws Exception {    ApplicationContext ctx = SpringApplication.run(Application.class, args);    String[] beanNames = ctx.getBeanDefinitionNames();    Arrays.sort(beanNames);    for (String beanName : beanNames) {      System.out.println(beanName);    }  }}

總結(jié)

以上就是這篇文章的全部內(nèi)容了,希望本文的內(nèi)容對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,謝謝大家對(duì)VeVb武林網(wǎng)的支持。


注:相關(guān)教程知識(shí)閱讀請(qǐng)移步到JAVA教程頻道。
發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 靖边县| 东莞市| 南宁市| 安溪县| 习水县| 华亭县| 贵德县| 博爱县| 无为县| 榆林市| 齐齐哈尔市| 尉氏县| 浦北县| 佛山市| 华亭县| 岳阳市| 成安县| 阜城县| 成都市| 句容市| 额济纳旗| 广德县| 比如县| 临沭县| 黔东| 衡水市| 临清市| 景谷| 兴化市| 平湖市| 南康市| 汕尾市| 舒兰市| 葫芦岛市| 宁城县| 古蔺县| 礼泉县| 拜城县| 闻喜县| 孟津县| 海南省|