Spring 配置文件与 MyBatis 基础用法

Spring 配置文件与 MyBatis 基础用法 | 极客日志

#应用程序名称
spring.application.name=configuration
#应用程序端口号
server.port=8080
#数据库连接信息
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/database_name?characterEncoding=utf8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root

spring:
  application:
    #应用程序名称
    name: configuration
  #数据库连接信息
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/database_name?characterEncoding=utf8&useSSL=false
    username: root
    password: root
  #应用程序端口号
  server:
    port: 8080
mybatis:
  configuration:
    map-underscore-to-camel-case: true

package org.example.configuration.config;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Configuration;

@Configuration
public class Config {
    @Value("${spring.application.name}")
    private String applicationName;

    @Value("${server.port}")
    private Integer port;

    @Value("${spring.datasource.url}")
    private String url;

    @Value("${spring.datasource.username}")
    private String username;

    @Value("${spring.datasource.password}")
    private String password;

    public void print() {
        System.out.println("applicationName=" + applicationName);
        System.out.println("port=" + port);
        System.out.println("url=" + url);
        System.out.println("username=" + username);
        System.out.println("password=" + password);
    }
}

package org.example.configuration;

import org.example.configuration.config.Config;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.ApplicationContext;

@SpringBootApplication
public class ConfigurationApplication {
    public static void main(String[] args) {
        ApplicationContext context = SpringApplication.run(ConfigurationApplication.class, args);
        Config config = context.getBean(Config.class);
        config.print();
    }
}

#应用程序名称
spring.application.name=configuration
#应用程序端口号
server.port=8080
#数据库连接信息
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/database_name?characterEncoding=utf8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
#自动驼峰转换
mybatis.configuration.map-underscore-to-camel-case=true

spring:
  application:
    name: configuration
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/database_name?characterEncoding=utf8&useSSL=false
    username: root
    password: root
  server:
    port: 8080
mybatis:
  configuration:
    map-underscore-to-camel-case: true

import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface BlogMapper {
    //其他代码
}

create table blog (
    id int primary key auto_increment,
    name varchar(128),
    age int
);
insert into blog values (null,'刘备',30),(null,'关羽',28),(null,'张飞',25);

import lombok.Data;

@Data
public class PersonInfo {
    private Integer id;
    private String name;
    private Integer age;

    public PersonInfo(Integer id, String name, Integer age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }

    public PersonInfo() {
    }
}

import com.example.spring_mybatis.model.PersonInfo;
import org.apache.ibatis.annotations.*;

@Mapper
public interface BlogMapper {
    @Select("select * from blog")
    List<PersonInfo> getPersonInfoAll();

    @Insert("insert into blog values (#{id},#{name},#{age})")
    Integer addPerson(PersonInfo person);

    @Update("update blog set name = #{name},age = #{age} where id = #{id}")
    Integer updatePerson(PersonInfo personInfo);

    @Delete("delete from blog where id = #{id}")
    Integer deletePerson(Integer id);
}

import com.example.spring_mybatis.model.PersonInfo;
import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.List;

@SpringBootTest
@Slf4j
class BlogMapperTest {
    private final BlogMapper blogMapper;

    @Autowired
    public BlogMapperTest(BlogMapper blogMapper) {
        this.blogMapper = blogMapper;
    }

    @Test
    void getPersonInfoAll() {
        List<PersonInfo> personInfoAll = blogMapper.getPersonInfoAll();
        log.info("查询成功,personInfoAll:{}",personInfoAll.toString());
    }

    @Test
    void addPerson() {
        Integer ret = blogMapper.addPerson(new PersonInfo(null,"赵云",25));
        log.info("添加成功，影响行数:{}",ret.toString());
    }

    @Test
    void updatePerson() {
        Integer ret = blogMapper.updatePerson(new PersonInfo(1,"刘备",35));
        log.info("更新成功，影响行数:{}",ret.toString());
    }

    @Test
    void deletePerson() {
        Integer ret = blogMapper.deletePerson(4);
        log.info("删除成功，影响行数:{}",ret.toString());
    }
}

@Mapper
public interface BlogMapper {
    @Update("update blog set name = #{name},age = #{age} where id = #{id}")
    Integer updatePersonInfo(@Param("id")Integer userId,@Param("name")String userName,@Param("age")Integer userAge);
}

@SpringBootTest
@Slf4j
class BlogMapperTest {
    private final BlogMapper blogMapper;

    @Autowired
    public BlogMapperTest(BlogMapper blogMapper) {
        this.blogMapper = blogMapper;
    }

    @Test
    void updatePersonInfo() {
        Integer ret = blogMapper.updatePersonInfo(1,"刘玄德",30);
        log.info("更新成功，影响行数:{}",ret.toString());
    }
}

import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface BlogXMLMapper {
    //其他代码
}

mybatis:
  mapper-locations: classpath:mybatis/**Mapper.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.example.spring_mybatis.mapper_blog.BlogXMLMapper"></mapper>

import com.example.spring_mybatis.model_blog.PersonInfo;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;

@Mapper
public interface BlogXMLMapper {
    List<PersonInfo> getPersonInfoAll();
}

<mapper namespace="com.example.spring_mybatis.mapper_blog.BlogXMLMapper">
    <select id="getPersonInfoAll" resultType="com.example.spring_mybatis.model_blog.PersonInfo">
        select * from blog
    </select>
</mapper>

import com.example.spring_mybatis.model_blog.PersonInfo;
import lombok.extern.slf4j.Slf4j;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.List;

@SpringBootTest
@Slf4j
class BlogXMLMapperTest {
    private final BlogXMLMapper blogXMLMapper;

    @Autowired
    public BlogXMLMapperTest(BlogXMLMapper blogXMLMapper) {
        this.blogXMLMapper = blogXMLMapper;
    }

    @Test
    void getPersonInfoAll() {
        List<PersonInfo> personInfoAll = blogXMLMapper.getPersonInfoAll();
        log.info("查询成功,personInfoAll:{}",personInfoAll.toString());
    }
}

<insert id="addPersonInfo">
    insert into blog 
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="id != null"> id, </if>
        <if test="name != null"> name, </if>
        <if test="age != null"> age, </if>
    </trim> 
    values 
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="id != null"> #{id}, </if>
        <if test="name != null"> #{name}, </if>
        <if test="age != null"> #{age}, </if>
    </trim>
</insert>

<select id="getPersonInfoByNameAndAge">
    select * from blog 
    <where>
        <if test="name != null"> and name = #{name} </if>
        <if test="age != null"> and age = #{age} </if>
    </where>
</select>

<update id="updatePersonInfo">
    update blog 
    <set>
        <if test="name != null"> name = #{name}, </if>
        <if test="age != null"> age = #{age}, </if>
    </set>
    <where> and id = #{id} </where>
</update>

@Test
void getPersonInfoById(){
    ArrayList<Integer> ids = new ArrayList<>();
    ids.add(1); ids.add(2); ids.add(3);
    List<PersonInfo> personInfoById = blogXMLMapper.getPersonInfoById(ids);
    System.out.println(personInfoById);
}

<select id="getPersonInfoById" resultType="com.example.spring_mybatis.model_blog.PersonInfo">
    select * from blog where id in 
    <foreach collection="ids" item="id" open="(" close=")" separator=",">
        #{id} 
    </foreach>
</select>

<sql id="collection"> id,name,age </sql>
<select id="getPersonInfoAll" resultType="com.example.spring_mybatis.model_blog.PersonInfo">
    select <include refid="collection"></include> from blog 
</select>

@Mapper
public interface BlogMapper {
    @Options(useGeneratedKeys =true,keyProperty ="id")
    @Insert("insert into blog values (#{id},#{name},#{age})")
    Integer addPerson(PersonInfo person);
}

@SpringBootTest
@Slf4j
class BlogMapperTest {
    private final BlogMapper blogMapper;

    @Autowired
    public BlogMapperTest(BlogMapper blogMapper) {
        this.blogMapper = blogMapper;
    }

    @Test
    void addPerson(){
        PersonInfo personInfo = new PersonInfo(null,"黄忠",60);
        Integer ret = blogMapper.addPerson(personInfo);
        log.info("添加成功，影响行数:{},返回的主键值:{}",ret.toString(),personInfo.getId());
    }
}

@SpringBootTest
@Slf4j
class BlogXMLMapperTest {
    private final BlogXMLMapper blogXMLMapper;

    @Autowired
    public BlogXMLMapperTest(BlogXMLMapper blogXMLMapper) {
        this.blogXMLMapper = blogXMLMapper;
    }

    @Test
    void addPersonInfo(){
        PersonInfo personInfo = new PersonInfo();
        personInfo.setAge(40);
        personInfo.setName("曹操");
        Integer ret = blogXMLMapper.addPersonInfo(personInfo);
        log.info("添加成功，影响行数:{},返回的主键值:{}",ret.toString(),personInfo.getId());
    }
}

<insert id="addPersonInfo" useGeneratedKeys="true" keyProperty="id">
    insert into blog 
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="id != null"> id, </if>
        <if test="name != null"> name, </if>
        <if test="age != null"> age, </if>
    </trim> 
    values 
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="id != null"> #{id}, </if>
        <if test="name != null"> #{name}, </if>
        <if test="age != null"> #{age}, </if>
    </trim>
</insert>

@Select("select * from blog where name= #{name}")
List<UserInfo> queryByName(String name)

select * from blog where name = " 'or 1='1 ";

@Select("select * from blog where name= '${name}'")
List<UserInfo> queryByName(String name)

select * from blog where name =''or1='1';

Spring 配置文件与 MyBatis 基础用法

1. 配置文件

1.1 概述

1.2 properties

1.3 yml

1.4 优缺点对比

1.5 @Value 注解

2. MyBatis

2.1 概述

2.2 前置操作

2.3 注解

2.3.1 配置

2.3.2 CRUD

2.3.3 @Param

2.4 xml

2.4.1 配置

2.4.2 示例

2.5 动态 SQL

2.5.1 trim 标签

2.5.2 if 标签

2.5.3 where 标签

2.5.4 set 标签

2.5.5 foreach 标签

2.5.6 include 标签

2.6 主键返回

2.7 预编译/即时 SQL

更多推荐文章

相关免费在线工具

Spring 配置文件与 MyBatis 基础用法

1. 配置文件

1.1 概述

1.2 properties

1.3 yml

1.4 优缺点对比

1.5 @Value 注解

2. MyBatis

2.1 概述

2.2 前置操作

2.3 注解

2.3.1 配置

2.3.2 CRUD

2.3.3 @Param

2.4 xml

2.4.1 配置

2.4.2 示例

2.5 动态 SQL

2.5.1 trim 标签

2.5.2 if 标签

2.5.3 where 标签

2.5.4 set 标签

2.5.5 foreach 标签

2.5.6 include 标签

2.6 主键返回

2.7 预编译/即时 SQL

微信扫一扫，关注极客日志

更多推荐文章

相关免费在线工具