从零开始学Mybatis（三）——Mybatis添加

最新推荐文章于 2024-06-02 11:00:22 发布

原创

最新推荐文章于 2024-06-02 11:00:22 发布 · 672 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #java #mybatis

这篇博客介绍了如何使用Mybatis进行用户添加操作，包括创建domain类、编写插入SQL、配置SqlMappingConfig、编写测试类。同时，详细讲解了如何通过<selectKey>标签获取添加后自增的主键，以确保能正确获取到新插入数据的ID。

添加用户

编写customer表的domain类作映射

@Setter@Getter
public class Customer {
    private Integer cust_id;
    private String cust_name;
    private String cust_profession;
    private String cust_phone;
    private String email;

    @Override
    public String toString() {
        return "Customer{" +
                "cust_id=" + cust_id +
                ", cust_name='" + cust_name + '\'' +
                ", cust_profession='" + cust_profession + '\'' +
                ", cust_phone='" + cust_phone + '\'' +
                ", email='" + email + '\'' +
                '}';
    }
}

Mapping中添加插入的sql语句

 <?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="myTest">
    <!--添加用户-->
    <insert id="addCustomer" parameterType="demo1.Customer">
        INSERT  INTO customer (cust_name,cust_profession,cust_phone,email) VALUES
        (#{cust_name},#{cust_profession},#{cust_phone},#{email})
    </insert>
</mapper>

将Mapping配置到SqlMappingConfig中

<?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">
<configuration>
    <environments default="development"&g