详解springboot集成mybatis xml方式

springboot集成mybatis

关键代码如下：

1，添加pom引用

 <dependency>
  <groupid>org.mybatis.spring.boot</groupid>
  <artifactid>mybatis-spring-boot-starter</artifactid>
  <version>1.1.1</version>
 </dependency>
   <dependency>
     <groupid>mysql</groupid>
     <artifactid>mysql-connector-java</artifactid>
   </dependency>

2 application.properties

mybatis.config-locations=classpath:mybatis/mybatis-config.xml
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
mybatis.type-aliases-package=com.kerry.model
 
spring.datasource.driverclassname = com.mysql.jdbc.driver
spring.datasource.url = jdbc:mysql://localhost:3306/test?useunicode=true&characterencoding=utf-8
spring.datasource.username = root
spring.datasource.password = 123456

3 在resource目录下创建mybatis目录并创建mybatis-config.xml文件

<?xml version="1.0" encoding="utf-8" ?>
<!doctype configuration public "-//mybatis.org//dtd config 3.0//en" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
 <settings>
 <setting name="callsettersonnulls" value="true"/>
 
 <setting name="cacheenabled" value="true"/>
 
 <setting name="lazyloadingenabled" value="true"/>
 
 <setting name="aggressivelazyloading" value="true"/>
 
 <setting name="multipleresultsetsenabled" value="true"/>
 
 <setting name="usecolumnlabel" value="true"/>
 
 <setting name="usegeneratedkeys" value="false"/>
 
 <setting name="automappingbehavior" value="partial"/>
 
 <setting name="defaultexecutortype" value="simple"/>
 
 <setting name="mapunderscoretocamelcase" value="true"/>
 
    <setting name="localcachescope" value="session"/>
 
    <setting name="jdbctypefornull" value="null"/>
 
 </settings>
 
 <typealiases>
 <typealias alias="integer" type="java.lang.integer" />
 <typealias alias="long" type="java.lang.long" />
 <typealias alias="hashmap" type="java.util.hashmap" />
 <typealias alias="linkedhashmap" type="java.util.linkedhashmap" />
 <typealias alias="arraylist" type="java.util.arraylist" />
 <typealias alias="linkedlist" type="java.util.linkedlist" />
 </typealiases>
</configuration>

mybatis目录下创建mapper目录存放mapper类接口文件

package com.kerry.mapper; 
import java.util.list; 
import com.kerry.model.user; 
public interface usermapper { 
 list<user> getall(); 
 user getone(integer id); 
 void insert(user user); 
 void update(user user); 
 void delete(integer id);
 }

model类文件

package com.kerry.mapper; 
import java.util.list;
import com.kerry.model.user; 
public interface usermapper { 
 list<user> getall(); 
 user getone(integer id); 
 void insert(user user); 
 void update(user user); 
 void delete(integer id);
}

usermapper.xml

<?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.kerry.mapper.usermapper" >
  <resultmap id="baseresultmap" type="com.kerry.model.user" >
    <id column="id" property="id" jdbctype="integer" />
    <result column="name" property="name" jdbctype="varchar" />
    <result column="age" property="age" jdbctype="varchar" />
    <result column="address" property="address" jdbctype="varchar"/>
  </resultmap>
  
  <sql id="base_column_list" >
    id, name, age, address
  </sql>
 
  <select id="getall" resultmap="baseresultmap" >
    select 
    <include refid="base_column_list" />
  from user
  </select>
 
  <select id="getone" parametertype="java.lang.integer" resultmap="baseresultmap" >
    select 
    <include refid="base_column_list" />
  from user
  where id = #{id}
  </select>
 
  <insert id="insert" parametertype="com.kerry.model.user" >
    insert into 
     user
     (id,name,age,address) 
    values
     (#{id},#{name}, #{age}, #{address})
  </insert>
  
  <update id="update" parametertype="com.kerry.model.user" >
    update 
     user 
    set 
    <if test="name != null">name = #{name},</if>
    <if test="age != null">age = #{age},</if>
    address = #{address}
    where 
     id = #{id}
  </update>
  
  <delete id="delete" parametertype="java.lang.integer" >
    delete from
     user 
    where 
     id =#{id}
  </delete> 
</mapper>

controller：

package com.kerry.web;
import java.util.list;
import org.springframework.beans.factory.annotation.autowired;
import org.springframework.web.bind.annotation.pathvariable;
import org.springframework.web.bind.annotation.requestmapping;
import org.springframework.web.bind.annotation.restcontroller; 
import com.kerry.model.user;
import com.kerry.mapper.usermapper; 
@restcontroller
public class usercontroller { 
 @autowired
 private usermapper usermapper;
 
 @requestmapping("/getusers")
 public list<user> getusers() {
 list<user> users=usermapper.getall();
 return users;
 }
 
  @requestmapping("/getuser")
  public user getuser(integer id) {
   user user=usermapper.getone(id);
    return user;
  }
  
  @requestmapping("/add")
  public void save(user user) {
   usermapper.insert(user);
  }
  
  @requestmapping(value="update")
  public void update(user user) {
   usermapper.update(user);
  }
  
  @requestmapping(value="/delete/{id}")
  public void delete(@pathvariable("id") integer id) {
   usermapper.delete(id);
  }  
}

最后在启动类上加上 扫描maper interface注解

@springbootapplication
@mapperscan("com.kerry.mapper")
public class application {
 
 public static void main(string[] args) {
 springapplication.run(application.class, args);
 }
}

或者在每个xxmapper类上加上@mapper注解也行  二选一即可

比如

package com.kerry.mapper; 
import java.util.list;
import org.apache.ibatis.annotations.mapper;
import com.kerry.model.user;
 @mapper
public interface usermapper { 
 list<user> getall(); 
 user getone(integer id); 
 void insert(user user); 
 void update(user user); 
 void delete(integer id); 
}

个人建议使用直接在启动类上application上@mapperscan方便，一次搞定，不必每写一个mapper类都加上@mapper注解

附上项目结构目录 选中的类以及文件

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。