Mybatis入门案例

最新推荐文章于 2024-10-09 11:13:12 发布

liucj666

最新推荐文章于 2024-10-09 11:13:12 发布

阅读量61

点赞数

文章标签： java mybatis

本文链接：https://blog.csdn.net/qq_43951083/article/details/120382341

版权

文章目录

Mybatis入门案例

Mybatis入门案例

添加mybatis相关依赖

<dependency>
     <groupId>org.mybatis.spring.boot</groupId>
     <artifactId>mybatis-spring-boot-starter</artifactId>
     <version>2.2.0</version>
 </dependency>
 <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.32</version>
 </dependency>

创建User表

建表

CREATE TABLE `user` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `name` varchar(30) DEFAULT NULL,
   `addr` varchar(30) DEFAULT NULL,
   `age` int(11) DEFAULT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

插入数据

insert into user values(1,"hanmeimei","北京",28)
insert into user values(2,"xiongda","上海",20)
insert into user values(3,"xionger","上海",19)

创建User实体类

//Mybatis自动完成ORM,把表里的字段的值 查到 封装给 类里的属性
//要求:属性名要和字段名一样
@Data
public class User {
    private Integer id;
    private String name;
    private String addr;
    private Integer age;
}

创建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用来作为文件的唯一标识-->
<mapper namespace="UserMapper">
    <!--select标签表示要发起查询的SQL,
   id是SQL语句的唯一标识,
   resultType用来完成ORM,把表里的字段值 自动映射 类里的属性
   -->
    <select id="getAll" resultType="com.tedu.pojo.User">
        select * from user
    </select>
    <select id="selectById" resultType="com.tedu.pojo.User">
        select * from user where id=${id}
    </select>
     <!--select * from user where name = ${name}  -->
    <select id="selectByName" resultType="User">
        select *from user where name = #{name}
    </select>
    <!--查询上海有几个人    -->
    <select id="selectByAddr" resultType="int">
        select count(1) from user where addr = #{addr}
    </select>
</mapper>

创建mybatis核心配置文件

<?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">

<!-- mybatis的核心配置文件 -->
<configuration>

    <!--用来设置别名 type是类的全路径 alias是以后要用的别名   -->
    <typeAliases>
        <typeAlias type="com.tedu.pojo.User" alias="User"></typeAlias>
        <typeAlias type="com.tedu.pojo.Dept" alias="Dept"></typeAlias>
    </typeAliases>

    <!--配置分页插件-->
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
    </plugins>

    <!--可以配置多个数据库连接的环境，使用default指定默认用哪个-->
    <environments default="test">
        <!--配置了具体连接数据库的参数-->
        <environment id="test">
            <!--使用的事务管理器-->
            <transactionManager type="JDBC"></transactionManager>
            <!--数据源：就是制定了数据库连接时的参数-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatisdb?characterEncoding=utf8&amp;serverTimezone=Asia/Shanghai" />
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>

    <!--引入映射文件-->
    <mappers>
        <mapper resource="UserMapper.xml"></mapper>
    </mappers>
</configuration>

创建测试类

package com.tedu.test;

import com.tedu.pojo.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class Test1 {
    @Test
    public void get() throws Exception {
        //1.读取核心配置文件
        InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
        //2.创建会话工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
        //3.创建会话执行sql
        SqlSession session = factory.openSession();
        //4.执行sql
        //session.selectList("namespace的值.id的值");//唯一的定位了SQL
        List<User> list = session.selectList("UserMapper.getAll");//查询出多个结果
        //5.处理结果
        for (User user : list){
            System.out.println(user);
        }
        //按id查询
        User u = session.selectOne("UserMapper.selectById",2);
        System.out.println(u);
        //按name查询
        User u2 = session.selectOne("UserMapper.selectByName", "xiongda");
        System.out.println(u2);
        //查上海的人有几个
        int count = session.selectOne("UserMapper.selectByAddr", "上海");
        System.out.println(count);
    }
}