java——mybatis——Mybatis的CRUD——获取返回自增id

墨蓝 2023-09-28 23:44 13阅读 0赞

![a0f9ad4fccd9400f3a4fca62402b13e5.png][]

![cd168535e34f8c67117917dd41127a62.png][]

![27899fa4ee59dd3706c814dcc46fdb56.png][]

![a951bd70a9bb09b88dc08f5dabd7584b.png][]

![13e543f4aa9e88637dc84e311ee4146c.png][]

![0cdd627e0a5e7bb3399a84db9f0a91f8.png][]

========================================================================================================

![aedbc316bd1d3ccc1800117576414fe6.png][]

![5b2bb8ced6072fc31cc3cc69f1df17cd.png][]

![cbc8a06f08f9e09e6a62ae8dc942d583.png][]

===================================================================================================================

在第一个xml示例项目的基础上，进行操作：

mybatis-config.xml文件：

<?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">
            <environment id="development">
                
                <transactionManager type="JDBC" />
                <dataSource type="POOLED">
                    
                    <property name="driver" value="com.mysql.jdbc.Driver" />
                    
                    <property name="url" value="jdbc:mysql://localhost:3306/mysql8?characterEncoding=utf8" />
                    <property name="username" value="root" />
                    <property name="password" value="123456" />
                </dataSource>
            </environment>
        </environments>
        
        <mappers>
            <mapper resource="com/sunxl/dao/UserDao.xml"/>
        </mappers>
    </configuration>

![6ec12b39be6cf2fc7c00b7e2ec05f8ba.png][]

POJO类不变：

package com.sunxl.pojo;
    
    public class User {
    
        Integer id;
        String name;
        Integer age;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public Integer getAge() {
            return age;
        }
    
        public void setAge(Integer age) {
            this.age = age;
        }
    
        @Override
        public String toString() {
            return "Users{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", age=" + age +
                    '}';
        }
    
    }

![472084667c5009d7a1da7f9784033af6.png][]

修改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.sunxl.dao.UserDao">
        
        <select id="findAll" resultType="com.sunxl.pojo.User">
            select * from USERs
        </select>
    
        <insert id="saveUser" parameterType="com.sunxl.pojo.User">
                insert into users(id,name,age) values(#{id},#{name},#{age})
        </insert>
    
        <update id="updateUser" parameterType="com.sunxl.pojo.User">
                update users set name = #{name},age = #{age} where id = #{id}
        </update>
    
        <delete id="deleteUser" parameterType="java.lang.Integer">
                delete from users where id = #{id}
        </delete>
    
        <select id="findById" parameterType="java.lang.Integer" resultType="com.sunxl.pojo.User">
            select * from USERs where id = #{id}
        </select>
    
        <select id="findByName" parameterType="java.lang.String" resultType="com.sunxl.pojo.User">
            select * from USERs where name like '%${value}%';
        </select>
    
        <select id="findTotal" resultType="int">
            select count(id) from USERs
        </select>
    
    
        <insert id="saveInsertUser" parameterType="com.sunxl.pojo.User">
            <selectKey keyProperty="id" keyColumn="id" order="AFTER" resultType="int">
                SELECT LAST_INSERT_ID();
            </selectKey>
            insert into users(id,name,age) values(#{id},#{name},#{age})
        </insert>
    
    </mapper>

![9c7ad819e27075e23d974a61e95e2607.png][]

![f2f99fdcec4dd3ae02a3703a3442def7.png][]

修改DAO接口文件：

package com.sunxl.dao;
    
    import com.sunxl.pojo.User;
    import org.apache.ibatis.annotations.Select;
    
    import java.util.List;
    
    public interface UserDao {
    
        List<User> findAll();
    
        int saveUser(User user);
    
        int updateUser(User user);
    
        int deleteUser(Integer id);
    
        User findById(Integer id);
    
        List<User> findByName(String name);
    
        int findTotal();
    
        int saveInsertUser(User user);
    
    }

![69d442fa031544aad21c35b15038e633.png][]

执行：

import com.sunxl.dao.UserDao;
    import com.sunxl.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 java.io.IOException;
    import java.io.InputStream;
    import java.util.List;
    
    public class MybatisTest {
    
        public static void main(String[] args) throws IOException {
    
    //        InputStream config = Resources.getResourceAsStream("mybatis-config.xml");
    //
    //        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    //
    //        SqlSessionFactory factory = builder.build(config);
    //
    //        SqlSession ss = factory.openSession();
    //
    //        UserDao userdao = ss.getMapper(UserDao.class);
    //
    //        List<User> users = userdao.findAll();
    //
    //        for (User user: users){
    //            System.out.println(user);
    //        }
    //
    //        ss.commit();
    //
    //        //4. 释放资源
    //        ss.close();
    //
    //        config.close();
    
            InputStream config = Resources.getResourceAsStream("mybatis-config.xml");
    
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    
            SqlSessionFactory factory = builder.build(config);
    
            SqlSession ss = factory.openSession();
    
    
            User user = new User();
            user.setName("s-s-x-1002");
            user.setAge(1002);
    
    
            System.out.println(user);
    
    
            UserDao userdao = ss.getMapper(UserDao.class);
    
            userdao.saveInsertUser(user);
    
            System.out.println(user);
    
            ss.commit();
    
            //4. 释放资源
            ss.close();
    
            config.close();
    
        }
    }

![d3699e4dd95d7b1a991205233994e179.png][]

![7744e5db05e8cf3121ab7eb2d46e87b5.png][]

[a0f9ad4fccd9400f3a4fca62402b13e5.png]: https://img-blog.csdnimg.cn/img_convert/a0f9ad4fccd9400f3a4fca62402b13e5.png
[cd168535e34f8c67117917dd41127a62.png]: https://img-blog.csdnimg.cn/img_convert/cd168535e34f8c67117917dd41127a62.png
[27899fa4ee59dd3706c814dcc46fdb56.png]: https://img-blog.csdnimg.cn/img_convert/27899fa4ee59dd3706c814dcc46fdb56.png
[a951bd70a9bb09b88dc08f5dabd7584b.png]: https://img-blog.csdnimg.cn/img_convert/a951bd70a9bb09b88dc08f5dabd7584b.png
[13e543f4aa9e88637dc84e311ee4146c.png]: https://img-blog.csdnimg.cn/img_convert/13e543f4aa9e88637dc84e311ee4146c.png
[0cdd627e0a5e7bb3399a84db9f0a91f8.png]: https://img-blog.csdnimg.cn/img_convert/0cdd627e0a5e7bb3399a84db9f0a91f8.png
[aedbc316bd1d3ccc1800117576414fe6.png]: https://img-blog.csdnimg.cn/img_convert/aedbc316bd1d3ccc1800117576414fe6.png
[5b2bb8ced6072fc31cc3cc69f1df17cd.png]: https://img-blog.csdnimg.cn/img_convert/5b2bb8ced6072fc31cc3cc69f1df17cd.png
[cbc8a06f08f9e09e6a62ae8dc942d583.png]: https://img-blog.csdnimg.cn/img_convert/cbc8a06f08f9e09e6a62ae8dc942d583.png
[6ec12b39be6cf2fc7c00b7e2ec05f8ba.png]: https://img-blog.csdnimg.cn/img_convert/6ec12b39be6cf2fc7c00b7e2ec05f8ba.png
[472084667c5009d7a1da7f9784033af6.png]: https://img-blog.csdnimg.cn/img_convert/472084667c5009d7a1da7f9784033af6.png
[9c7ad819e27075e23d974a61e95e2607.png]: https://img-blog.csdnimg.cn/img_convert/9c7ad819e27075e23d974a61e95e2607.png
[f2f99fdcec4dd3ae02a3703a3442def7.png]: https://img-blog.csdnimg.cn/img_convert/f2f99fdcec4dd3ae02a3703a3442def7.png
[69d442fa031544aad21c35b15038e633.png]: https://img-blog.csdnimg.cn/img_convert/69d442fa031544aad21c35b15038e633.png
[d3699e4dd95d7b1a991205233994e179.png]: https://img-blog.csdnimg.cn/img_convert/d3699e4dd95d7b1a991205233994e179.png
[7744e5db05e8cf3121ab7eb2d46e87b5.png]: https://img-blog.csdnimg.cn/img_convert/7744e5db05e8cf3121ab7eb2d46e87b5.png