仅使用mybatis框架，insert时返回了1，但是数据库数据没有更新

你的名字 2022-10-31 10:54 182阅读 0赞

参考：[https://blog.csdn.net/qq\_34474324/article/details/98480433][https_blog.csdn.net_qq_34474324_article_details_98480433]

# 测试代码： #

## 更正之前 ##

public class Test {
        public static void main(String[] args) throws IOException {
    //        getAll();
            insert();
        }
    
        public static void insert() throws IOException {
            String mybatisConfigPath = "mybatis.cfg.xml";
            //获取配置文件
            Reader resourceAsReader = Resources.getResourceAsReader(mybatisConfigPath);
    
            //获取会话工厂
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsReader);
            SqlSession sqlSession = sqlSessionFactory.openSession();
    
            String statement = "com.sunj.mapper.PersonMapper.insertPerson";
            Person p = new Person();
            p.setId(100);
            p.setCreateTime(LocalDate.now()+"");
            p.setEmail("123.com");
            p.setPhone("888888888");
            int insert = sqlSession.insert(statement, p);
            System.out.println("影响了"+insert+"行");
        }
    }

结果：返回正常结果但是数据库没有更新

原因是因为没有commit

### 更正之后： ###

import com.sunj.model.Person;
    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.Reader;
    import java.time.LocalDate;
    import java.time.LocalDateTime;
    import java.util.List;
    import java.util.UUID;
    
    public class Test {
        public static void main(String[] args) throws IOException {
    //        getAll();
            insert();
        }
    
        public static void insert() throws IOException {
            String mybatisConfigPath = "mybatis.cfg.xml";
            //获取配置文件
            Reader resourceAsReader = Resources.getResourceAsReader(mybatisConfigPath);
    
            //获取会话工厂
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsReader);
            SqlSession sqlSession = sqlSessionFactory.openSession();
    
            String statement = "com.sunj.mapper.PersonMapper.insertPerson";
            Person p = new Person();
            p.setId(100);
            p.setCreateTime(LocalDate.now()+"");
            p.setEmail("123.com");
            p.setPhone("888888888");
            try {
                int insert = sqlSession.insert(statement, p);
                System.out.println("影响了"+insert+"行");
                sqlSession.commit();
            } catch (Exception e) {
                e.printStackTrace();
                sqlSession.rollback();
            } finally {
                if(sqlSession != null){
                    sqlSession.close();
                }
            }
        }
    }

结果：插入数据库正常

参考：[https://blog.csdn.net/aphysia/article/details/80550001][https_blog.csdn.net_aphysia_article_details_80550001]

[https_blog.csdn.net_qq_34474324_article_details_98480433]: https://blog.csdn.net/qq_34474324/article/details/98480433
[https_blog.csdn.net_aphysia_article_details_80550001]: https://blog.csdn.net/aphysia/article/details/80550001