Mybatis实现向数据库中添加信息-----Mybatis框架

最新推荐文章于 2024-09-14 19:55:29 发布

旧约Alatus

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量98

点赞数 1

分类专栏： # Mybatis框架 JAVA 文章标签：数据库 spring 后端开发语言 java mybatis log4j

本文链接：https://blog.csdn.net/2201_75960169/article/details/132424788

版权

JAVA 同时被 2 个专栏收录

541 篇文章 3 订阅

订阅专栏

Mybatis框架

132 篇文章 0 订阅

订阅专栏

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 org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.io.IOException;
import java.io.InputStream;

public class Test
{
    private static final Logger logger = LoggerFactory.getLogger(Test.class);
    public static void main(String[] args) throws IOException {
        //获取SqlSessionFactory对象
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        //这个输入流指向config核心配置文件
//        InputStream is = new FileInputStream("mybatis文件路径");自己new一个流
//        InputStream resourceAsStream = ClassLoader.getSystemClassLoader().getResourceAsStream("mybatis-config.xml");
        //默认从类的根路径下加载资源
        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
        //获取SqlSessionFactoryBuilder对象
        SqlSessionFactory SqlSessionFactory = sqlSessionFactoryBuilder.build(is);
        //获取SQLSession对象
        SqlSession sqlSession = SqlSessionFactory.openSession();
        //执行SQL语句
//        sqlSession.insert(sql语句的id);
        int insertCar = sqlSession.insert("insertCar");
        logger.info("执行条数" + insertCar);
        logger.info(insertCar == 1 ? "成功" : "失败");
        //mybatis自动获取的这个Session对象是不支持自动提交Commit到数据库的
        //手动提交
        sqlSession.commit();
    }
}

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 org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.io.IOException;
import java.io.InputStream;

public class Test
{
    private static final Logger logger = LoggerFactory.getLogger(Test.class);
    public static void main(String[] args) throws IOException {
        //获取SqlSessionFactory对象
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        //这个输入流指向config核心配置文件
//        InputStream is = new FileInputStream("mybatis文件路径");自己new一个流
//        InputStream resourceAsStream = ClassLoader.getSystemClassLoader().getResourceAsStream("mybatis-config.xml");
        //默认从类的根路径下加载资源
        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
        //获取SqlSessionFactoryBuilder对象
        SqlSessionFactory SqlSessionFactory = sqlSessionFactoryBuilder.build(is);
        //获取SQLSession对象
        SqlSession sqlSession = SqlSessionFactory.openSession();
        //执行SQL语句
//        sqlSession.insert(sql语句的id);
        int insertCar = sqlSession.insert("insertCar");
        logger.info("执行条数" + insertCar);
        logger.info(insertCar == 1 ? "成功" : "失败");
        //mybatis自动获取的这个Session对象是不支持自动提交Commit到数据库的
        //手动提交
        sqlSession.commit();
    }
}