MyBatis01-IDEA快速搭建Mybatis实现简单增删改查_idea mybatis自动生成update语句-优快云博客

本文链接：https://blog.youkuaiyun.com/m0_49293192/article/details/121570758

这篇博客介绍了如何在Java项目中配置并使用MyBatis。首先，展示了引入Maven依赖，包括MyBatis、MySQL驱动和JUnit。接着，详细讲解了Mybatis-config.xml的配置，包括数据库连接信息和环境设置。然后，定义了User实体类和UserInterface接口，以及对应的UserMapper.xml映射文件，包含了增删查改的SQL操作。最后，给出了测试类的代码，演示了如何通过SqlSession执行CRUD操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.导入mybatis所需的Maven依赖

<dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
        </dependency>
    </dependencies>

2.创建Mybatis核心文件：Mybatis-config.xml

<?xml version="1.0" encoding="UTF8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/lzs"/>
                <property name="username" value="root"/>
                <property name="password" value="123"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

3.编写实体类（字段名与数据库对应）

public class User {
    private int number;
    private String name;
    private int age;

    public User() {
    }

    public User(int number, String name, int age) {
        this.number = number;
        this.name = name;
        this.age = age;
    }

    public int getNumber() {
        return number;
    }

    public void setNumber(int number) {
        this.number = number;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "User{" +
                "number=" + number +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }
}

4.编写接口

public interface UserInterface {
    //根据用户number查询用户
    public User SelectUser(int number);
    //修改用户数据（参数是一个User对象）
    public void UpdateUser(User user);
    //插入一个新用户（参数是一个对象）
    public boolean InsertNewUser(User user);
    //根据用户number删除一个用户
    public boolean DelectUser(int number);
}

5.编写UserMapper.xml

<?xml version="1.0" encoding="UTF8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--指定为接口全类名-->
<mapper namespace="com.as.dao.UserInterface">
<!--id对应接口里的方法-->
 <select id="SelectUser" resultType="com.as.pojo.User">
    select * from stu where number=#{number}
</select>
    <!--没有返回值不用parameterType-->
    <update id="UpdateUser" >
        update stu set name=#{name},age=#{age} where number=#{number}
    </update>

    <insert id="InsertNewUser" parameterType="com.as.pojo.User">
        insert into stu(number,name,age) value(#{number},#{name},#{age})
    </insert>
    <delete id="DelectUser" parameterType="com.as.pojo.User">
        delete from stu where number=#{number}
    </delete>

</mapper>

6.编写测试类

 @Test
    public void Test01() throws IOException {
        String resource = "Mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //在这里设true是自动提交
        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        UserInterface mapper = sqlSession.getMapper(UserInterface.class);
        mapper.UpdateUser(new User(111,"周志庆",23));
        System.out.println(mapper.InsertNewUser(new User(103, "周凯文", 23)));
        System.out.println(mapper.SelectUser(101));
        System.out.println(mapper.DelectUser(103));
        sqlSession.close();
        //事务得提交
        //sqlSession.commit();
    }