(a) Build your own Springboot back-end framework integration MyBatis

One: Building the infrastructure with the idea tool

1. Open idea, upper left corner file→new→project,

2. Click Next

3. Click Next, configure as, here we select database MySQL and persistent layer framework MyBatis

4. Click Next, select Working directory, click Finish to start building

5. After the creation is complete, the project directory structure is as follows

Second: Configure database information

Add the following database configuration in the Application.properties file

　　

Spring.datasource.url=jdbc:mysql://localhost:3306/demo? usessl=false&useunicode=true&characterencoding=utf-8&zerodatetimebehavior=converttonull& Transformedbitisboolean=true&autoreconnect=true&failoverreadonly=falsespring.datasource.username= Database user name spring.datasource.password= database password Spring.datasource.driverclassname=com.mysql.jdbc.driver

　　

Three: Create a database UserInfo table

CREATE TABLE ' user_info ' (  ' id ' int (+) NOT NULL auto_increment,  ' user_name ' varchar (255) ' DEFAULT NULL,  

　　

Four: Create a project base directory structure

Model Storage Entity Class

Package Com.example.demo.model;import javax.persistence.column;import javax.persistence.id;/** * @author  * @ Description: * @time 2018/4/18 11:55 */public class UserInfo {    /**     * PRIMARY KEY */    @Id    private String id;
   
    /**     * User name     *    /@Column (name = "user_name")    private String userName;    private String password;    Public String getId () {        return ID;    }    public void SetId (String id) {        this.id = ID;    }    Public String GetUserName () {        return userName;    }    public void Setusername (String userName) {        this.username = userName;    }    Public String GetPassword () {        return password;    }    public void SetPassword (String password) {        this.password = password;    }}
   

Mapper

<?xml version= "1.0" encoding= "UTF-8"? ><! DOCTYPE Mapper Public "-//mybatis.org//dtd mapper 3.0//en" "Http://mybatis.org/dtd/mybatis-3-mapper.dtd" >< Mapper namespace= "Com.example.demo.dao.UserInfoMapper" >    <resultmap id= "Baseresultmap" type= " Com.example.demo.model.UserInfo ">        <id column=" id "jdbctype=" INTEGER "property=" id "/>        <result column= "user_name" jdbctype= "VARCHAR" property= "UserName"/>    </resultMap>    <sql id= "Base_column _list ">      id,user_name    </sql>    <select id=" Selectbyid "parametertype=" Java.lang.Integer " resultmap= "Baseresultmap" >        select        <include refid= "Base_column_list"/> from        user_info        WHERE id = #{id,jdbctype=varchar}    </select></mapper>

DAO layer

Package Com.example.demo.dao;import Com.example.demo.model.userinfo;import org.apache.ibatis.annotations.param;/* * * @author  * @Description: * @time 2018/4/18 11:54 */public interface Userinfomapper {    UserInfo Selectbyid (@Param ("id") Integer ID);}

Service

Package Com.example.demo.service;import com.example.demo.model.userinfo;/** * @author  * @Description: * @time 2018 /4/18 11:56 */public interface Userinfoservice {    UserInfo Selectbyid (Integer ID);}

Serviceimpl

Package Com.example.demo.service.impl;import Com.example.demo.dao.userinfomapper;import Com.example.demo.model.userinfo;import Com.example.demo.service.userinfoservice;import Org.springframework.stereotype.service;import javax.annotation.resource;/** * @author  * @Description: * @time 2018/4/18 11:56 */@Servicepublic class Userinfoserviceimpl implements userinfoservice{    @Resource    Private Userinfomapper Userinfomapper;    Public UserInfo Selectbyid (Integer id) {        return Userinfomapper.selectbyid (ID);}    }

Controller

Package Com.example.demo.controller;import Com.example.demo.model.userinfo;import Com.example.demo.service.userinfoservice;import Org.springframework.web.bind.annotation.postmapping;import Org.springframework.web.bind.annotation.requestmapping;import Org.springframework.web.bind.annotation.restcontroller;import javax.annotation.resource;/** * @author  * @ Description: * @time 2018/4/18 11:39 */@RestController @requestmapping ("UserInfo") public class Userinfocontroller {    @Resource    private userinfoservice userinfoservice;    @PostMapping ("/hello") public    String Hello () {        return "Hello Springboot";    }    @PostMapping ("/selectbyid") public    UserInfo Selectbyid (Integer id) {        return Userinfoservice.selectbyid (ID);}    }

Configuration Java class for MyBatis

Package Com.example.demo.core.configurer;import Org.apache.ibatis.session.sqlsessionfactory;import Org.mybatis.spring.sqlsessionfactorybean;import Org.mybatis.spring.mapper.mapperscannerconfigurer;import Org.springframework.context.annotation.bean;import Org.springframework.context.annotation.configuration;import Org.springframework.core.io.support.pathmatchingresourcepatternresolver;import Org.springframework.core.io.support.resourcepatternresolver;import javax.sql.datasource;/** * @ClassName: Mybatisconfigurer * @Description: Mybatis configuration * @author * @date January 20, 2018 PM 4:03:46 * */@Configurationpublic class Mybatis Configurer {@Bean public sqlsessionfactory Sqlsessionfactorybean (DataSource DataSource) throws Exception {Sqlse      Ssionfactorybean factory = new Sqlsessionfactorybean ();      Factory.setdatasource (DataSource);      Factory.settypealiasespackage ("Com.example.demo.model"); Add XML directory Resourcepatternresolver resolver = new Pathmatchingresourcepatternresolver ();      Factory.setmapperlocations (Resolver.getresources ("Classpath:mapper/*.xml"));   return Factory.getobject (); } @Bean Public Mapperscannerconfigurer mapperscannerconfigurer () {Mapperscannerconfigurer mapperscannerconfigure      R = new Mapperscannerconfigurer ();      Mapperscannerconfigurer.setsqlsessionfactorybeanname ("Sqlsessionfactorybean");      Mapperscannerconfigurer.setbasepackage ("Com.example.demo.dao");   return mapperscannerconfigurer; }}

　　

@Configuration indicates that the file is a configuration file

@Bean indicates that the method is a <bean id= "" In a traditional XML configuration file ></Bean>

where Factory.settypealiasespackage ("Com.example.demo.model") represents the storage path of the model in the project;

Factory.setmapperlocations (Resolver.getresources ("Classpath:mapper/*.xml")); indicates the mapper.xml storage path;

Mapperscannerconfigurer.setbasepackage ("Com.example.demo.dao"); represents the storage path of the DAO layer

Five: Run the project

Find DemoApplication, right-click, select Run DemoApplication

Above content source online, if there is infringement please contact me!!!

(a) Build your own Springboot back-end framework integration MyBatis