SpringBoot项目整合mybatis的方法步骤与实例

<?xml version= "1.0" encoding= "utf-8" ?>

<project xmlns= "http://maven.apache.org/pom/4.0.0"

      xmlns:xsi= "http://HdhCmsTestw3.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测试数据piler.target> 1.8 </maven测试数据piler.target>

     <maven测试数据piler.source> 1.8 </maven测试数据piler.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测试数据mons</groupid>

       <artifactid>commons-lang3</artifactid>

       <version> 3.4 </version>

     </dependency>

   </dependencies>

</project>

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测试数据mon.base.preconditions;

@configuration

public 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;

   }

}

ms.db.url=jdbc:mysql: //localhost:3306/dev?prepstmtcachesize=517&cacheprepstmts=true&autoreconnect=true&characterencoding=utf-8&allowmultiqueries=true

ms.db.username=root

ms.db.password=admin

ms.db.maxactive= 500

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;

@configuration

public 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;

   }

}

import org.mybatis.spring.mapper.mapperscannerconfigurer;

import org.springframework.context.annotation.bean;

import org.springframework.context.annotation.configuration;

@configuration

public class mybatisscannerconfig {

   @bean

   public mapperscannerconfigurer mapperscannerconfigurer() {

     mapperscannerconfigurer mapperscannerconfigurer = new mapperscannerconfigurer();

     mapperscannerconfigurer.setbasepackage( "com.example.*.dao" );

     mapperscannerconfigurer.setsqlsessionfactorybeanname( "sqlsessionfactory" );

     return mapperscannerconfigurer;

   }

}

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;

@configuration

public class transactionconfig implements transactionmanagementconfigurer{

   @autowired

   private datasource datasource;

   @bean (name = "transactionmanager" )

   @override

   public platformtransactionmanager annotationdriventransactionmanager() {

     return new datasourcetransactionmanager(datasource);

   }

}

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);

}

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;

@service

public class userserviceimpl implements userservice {

   @autowired

   private userdao userdao;

   public object getlist(map<string, object> map) {

     return userdao.getlist(map);

   }

}

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测试数据monutil;

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);

   }

   }

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测试数据ponentscan;

import org.springframework.scheduling.annotation.enablescheduling;

@componentscan (basepackages = "com.example" )

@springbootapplication

public 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);

     }

   }

}