java——mybatis——Mybatis注解开发——@Insert——更新数据——@SelectKey返回自增主键...

拼搏现实的明天。 2024-03-31 14:58 50阅读 0赞

DAO接口：

package com.sunxl.dao;
    
    import com.sunxl.pojo.User;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Select;
    import org.apache.ibatis.annotations.SelectKey;
    
    import java.util.List;
    
    public interface UserDao {
    
        @Select("select * from users")
        List<User> findAll();
    
        @Insert("insert into users (name,age) values(#{name},#{age})")
        @SelectKey(statement = "select last_insert_id()", keyProperty = "id", keyColumn = "id", resultType = int.class ,before = false)
        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);
    
    }

![32f3b2fb3fe594c93f09f2d8184ba722.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();
    //        ss.close();
    //        config.close();
    
    
    
            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);
    
            User as = new User();
            as.setName("zhon_guo");
            as.setAge(1005);
    
            int a = userdao.saveUser(as);
            System.out.println(a);
            System.out.println(as.getId());
    
    
    
            ss.commit();
            ss.close();
            config.close();
    
    
        }
    }

![f2a49c3bdbac8c071c354766908a3da2.png][]

![ccac56cd78bb5989e656bcc9cb56d4fe.png][]

![d87d4cbf98b678476396c1531d450970.png][]

[32f3b2fb3fe594c93f09f2d8184ba722.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/1a004c081abf49ee828d35f50bb282d8.png
[f2a49c3bdbac8c071c354766908a3da2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/c3666cb71729405abfcedd5f629585ff.png
[ccac56cd78bb5989e656bcc9cb56d4fe.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/a0b827b3d898416bab7f29d4a12ffcf2.png
[d87d4cbf98b678476396c1531d450970.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/aa4e8ac885da47bd8efb156692d22c0d.png