SpringBoot中利用MyBatis进行数据操作的示例

##数据库连接配置(部署到哪台，对应的ip需修改)

spring.datasource.url=jdbc:mysql: //127.0.0.1:3306/mybatis?connecttimeout=1000&usessl=false&useunicode=true&characterencoding=utf-8

spring.datasource.username=root

spring.datasource.password=root

spring.datasource.driver=com.mysql.jdbc.driver

package com.example.demo.model;

public class user {

  private int id;

  private string name;

  private string sex;

  private int age;

  public user() {

  }

  public user(string name, string sex, int age) {

   this .name = name;

   this .sex = sex;

   this .age = age;

  }

  public user( int id, string name, string sex, int age) {

   this .id = id;

   this .name = name;

   this .sex = sex;

   this .age = age;

  }

  public int getid() {

   return id;

  }

  public void setid( int id) {

   this .id = id;

  }

  public string getname() {

   return name;

  }

  public void setname(string name) {

   this .name = name;

  }

  public string getsex() {

   return sex;

  }

  public void setsex(string sex) {

   this .sex = sex;

  }

  public int getage() {

   return age;

  }

  public void setage( int age) {

   this .age = age;

  }

}

package com.example.demo.mapper;

import com.example.demo.model.user;

import org.apache.ibatis.annotations.mapper;

import org.apache.ibatis.annotations.param;

@mapper

public interface usermapper {

  user getbyname( @param ( "name" ) string name);

  boolean insert(user user);

  boolean update( @param ( "name" ) string name, @param ( "sex" ) string sex, @param ( "age" ) int age);

  void delete( @param ( "name" ) string name);

}

<?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.mapper.usermapper" >

  <select id= "getbyname" resulttype= "com.example.demo.model.user" parametertype= "java.lang.string" >

   select * from tb_user where name = #{name}

  </select>

  <insert id= "insert" parametertype= "com.example.demo.model.user" usegeneratedkeys= "true" >

   insert into tb_user(name, sex, age) values(#{name}, #{sex}, #{age})

  </insert>

  <update id= "update" parametertype= "com.example.demo.model.user" >

   update tb_user set sex=#{sex}, age=#{age} where name=#{name}

  </update>

  <delete id= "delete" parametertype= "java.lang.string" >

   delete from tb_user where name = #{name}

  </delete>

</mapper>

<build>

<resources>

  <!-- maven项目中src源代码下的xml等资源文件编译进classes文件夹，

   注意：如果没有这个，它会自动搜索resources下是否有mapper.xml文件，

   如果没有就会报org.apache.ibatis.binding.bindingexception: invalid bound statement (not found): ... -->

  <resource>

  <directory>src/main/java</directory>

  <includes>

   <include>**/*.xml</include>

  </includes>

  <filtering> true </filtering>

  </resource>

  <!--将resources目录下的配置文件编译进classes文件 -->

  <resource>

   <directory>src/main/resources</directory>

   <filtering> true </filtering>

  </resource>

</resources>

</build>

package com.example.demo.service;

import com.example.demo.model.user;

public interface userservice {

  user getuserbyname(string name);

  boolean adduser(user user);

  boolean updateuser(string name, string sex, int age);

  void deleteuser(string name);

}

package com.example.demo.service.impl;

import com.example.demo.mapper.usermapper;

import com.example.demo.model.user;

import com.example.demo.service.userservice;

import org.springframework.beans.factory.annotation.autowired;

import org.springframework.stereotype.service;

@service

public class userserviceimpl implements userservice{

  @autowired

  usermapper usermapper;

  @override

  public user getuserbyname(string name) {

   user user = usermapper.getbyname(name);

   if ( null != user){

    return user;

   }

   return null ;

  }

  @override

  public boolean adduser(user user) {

   return usermapper.insert(user);

  }

  @override

  public boolean updateuser(string name, string sex, int age) {

   return usermapper.update(name, sex, age);

  }

  @override

  public void deleteuser(string name) {

   usermapper.delete(name);

  }

}

package com.example.demo.controller;

import com.example.demo.model.user;

import com.example.demo.service.userservice;

import org.springframework.beans.factory.annotation.autowired;

import org.springframework.web.bind.annotation.requestmapping;

import org.springframework.web.bind.annotation.requestmethod;

import org.springframework.web.bind.annotation.restcontroller;

@restcontroller

public class usercontroller {

  @autowired

  userservice userservice;

  @requestmapping (value = "/index" , method = requestmethod.get)

  public string index(){

   user user = userservice.getuserbyname( "gyl" );

   return user.getname()+ "--" +user.getsex()+ "--" +user.getage();

  }

}

package com.example.demo.mapper;

import com.example.demo.model.user;

import org.apache.ibatis.annotations.*;

@mapper

public interface usermapper {

  @select ( "select * from tb_user where name = #{name}" )

  user getbyname( @param ( "name" ) string name);

  @insert ( "insert into tb_user(name, sex, age) values(#{name}, #{sex}, #{age})" )

  boolean insert(user user);

  @update ( "update tb_user set sex=#{sex}, age=#{age} where name=#{name}" )

  boolean update( @param ( "name" ) string name, @param ( "sex" ) string sex, @param ( "age" ) int age);

  @delete ( "delete from tb_user where name = #{name}" )

  void delete( @param ( "name" ) string name);

}