maven
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.example</groupId>
<artifactId>mybatistest</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>mybatistest</name>
<description>mybatistest</description>
<properties>
<java.version>1.8</java.version>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<spring-boot.version>2.6.13</spring-boot.version>
</properties>
<dependencies>
<!-- mybatis策略-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.2</version>
</dependency>
<!-- mysql依赖-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-dependencies</artifactId>
<version>${spring-boot.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
</project>
目录结构
配置文件
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/vuedata?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8
username: root
password: 123456789
application:
name: mybatis-test
server:
port: 8080
mybatis:
mapper-locations: classpath:mapper/*Mapper.xml
type-aliases-package: com.example.mybatistest.dao
dao包
package com.example.mybatistest.dao;
public class User {
private Integer id,age;
private String name;
@Override
public String toString() {
return "User{" +
"id=" + id +
", age=" + age +
", name='" + name + '\'' +
'}';
}
public void setId(Integer id) {
this.id = id;
}
public void setAge(Integer age) {
this.age = age;
}
public void setName(String name) {
this.name = name;
}
public Integer getId() {
return id;
}
public Integer getAge() {
return age;
}
public String getName() {
return name;
}
}
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">
<!-- 会以namespace 和 id 在mapper 中查询具体的方法
resultType 表示返回对象的数据类型
parameterType 表示传入的数据对象
id 唯一标识,要与命名空间(抽象方法)中定义的方法名称一致
-->
<mapper namespace="com.example.mybatistest.mapper.UserMapper">
<select id="selectAll" resultType="com.example.mybatistest.dao.User">
select * from user;
</select>
<select id="selcetById" parameterType="java.lang.Integer" resultType="com.example.mybatistest.dao.User">
select * from user
<where>
id=#{id}
</where>
</select>
<select id="selcetBymap" parameterType="java.util.Map" resultType="com.example.mybatistest.dao.User">
select * from user
<where>
id=#{id} and age =#{age}
</where>
</select>
</mapper>
UserMapper.java
package com.example.mybatistest.mapper;
import com.example.mybatistest.dao.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.mybatis.spring.annotation.MapperScan;
import java.util.List;
import java.util.Map;
@Mapper
public interface UserMapper {
List<User> selectAll();
User selcetById(@Param("id")Integer id);
User selcetBymap(Map<String,Object> map);
}
测试
class MybatistestApplicationTests {
@Autowired
UserMapper testMapper;
@Test
void contextLoads() {
List<User> selectall = testMapper.selectAll();
System.out.println(selectall);
User user = testMapper.selcetById(1);
System.out.println(user);
Map<String,Object> map=new HashMap<>();
map.put("id",2);
map.put("age",123);
User user1 = testMapper.selcetBymap(map);
System.out.println(user1);
}
}
结果
[User{id=1, age=121, name=‘nana’}, User{id=2, age=123, name=‘dd’}, User{id=31, age=21, name=‘wwe’}]
User{id=1, age=121, name=‘nana’}
User{id=2, age=123, name=‘dd’}