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

叁歲伎倆 2024-03-24 19:44 35阅读 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();
>         }
>     }