org.apache.ibatis.io.Resources#getResourceAsStream

Source File: BlogLimitPluginMain.java From blog with BSD 2-Clause "Simplified" License

6 votes

public static void main(String[] args) throws IOException {
	String resource = "mybatis-config.xml";
	InputStream inputStream = Resources.getResourceAsStream(resource);
	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

	SqlSession session2 = sqlSessionFactory.openSession();
	try {
		Blog blog = new Blog();
		blog.setTitle("new_java");
		blog.setId(101);
		BlogMapper mapper = session2.getMapper(BlogMapper.class);
		mapper.updateBlog(blog);

		session2.commit();
	} finally {
		session2.close();
	}

}

Source File: MybatisTest.java From springdream with Apache License 2.0

6 votes

public static void main(String[] args) throws IOException {
    // 获取SqlSessionFactory
    String resource = "MyBatis-Configuration.xml";
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

    // 获取SqlSession
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        User user = userMapper.selectUser(1);
        System.out.println("\nprint user info --> " + user.toString());
    } finally {
        sqlSession.close();
    }
}

Source File: MybatisUtil.java From code with Apache License 2.0

6 votes

public static void template(Callback callback) {
    SqlSession session = null;
    //1.读取配置文件
    try (InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");) {
        //2.创建构建者对象
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        //3.创建 SqlSession 工厂对象
        factory = builder.build(in);
        //4.创建 SqlSession 对象
        session = factory.openSession();
        //5.执行操作
        callback.execute(session);
        //6.提交或回滚事务
        session.commit();
    } catch (IOException e) {
        if (session != null) {
            session.rollback();
        }
        e.printStackTrace();
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

Source File: MybatisUtil.java From code with Apache License 2.0

6 votes

public static void template(Callback callback) {
    SqlSession session = null;
    //1.读取配置文件
    try (InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");) {
        //2.创建构建者对象
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        //3.创建 SqlSession 工厂对象
        factory = builder.build(in);
        //4.创建 SqlSession 对象
        session = factory.openSession();
        //5.执行操作
        callback.execute(session);
        //6.提交或回滚事务
        session.commit();
    } catch (IOException e) {
        if (session != null) {
            session.rollback();
        }
        e.printStackTrace();
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

Source File: BlogMain.java From blog with BSD 2-Clause "Simplified" License

6 votes

public static void main(String[] args) throws IOException {
		String resource = "mybatis-config-sourceCode.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

		SqlSession session = sqlSessionFactory.openSession();
		try {
			 select(session);
//			selectHandler(session, sqlSessionFactory.getConfiguration());
//			selectMyHandler(session);
			// insert(session);
			// update(session);
		} finally {
			session.close();
		}
	}

Source File: FlowerTest.java From Project with Apache License 2.0

6 votes

public static void main(String[] args) throws IOException {
      // 加载 xml 文件流
      InputStream is = Resources.getResourceAsStream("MyBatis.xml");
      //使用工厂设计模式
      SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
      //生产SqlSession
      SqlSession session=factory.openSession();

      List<Flower> list = session.selectList("a.b.selAll");
      for (Flower flower : list) {
          System.out.println(flower.toString());
      }

      int count = session.selectOne("a.b.selById");
System.out.println(count);

      //把数据库中哪个列的值当作map的key
      Map<Object, Object> map = session.selectMap("a.b.selectMap", "name");
      System.out.println(map);

      session.close();
  }

Source File: BlogPluginMain.java From blog with BSD 2-Clause "Simplified" License

6 votes

public static void main(String[] args) throws IOException {
	String resource = "mybatis-config.xml";
	InputStream inputStream = Resources.getResourceAsStream(resource);
	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

	SqlSession session2 = sqlSessionFactory.openSession();
	try {
		BlogMapper mapper = session2.getMapper(BlogMapper.class);
		List<Blog> blogs = mapper.selectBlogs("ksfzhaohui");
		//最大只会查出50条  select * from (select * from blog where author = ?) limit_table_name_blog limit 50 
		System.out.println(blogs.size());
	} finally {
		session2.close();
	}

}

Source File: BlogRowBoundsMain.java From blog with BSD 2-Clause "Simplified" License

6 votes

public static void main(String[] args) throws IOException {
	String resource = "mybatis-config-sourceCode.xml";
	InputStream inputStream = Resources.getResourceAsStream(resource);
	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

	SqlSession session = sqlSessionFactory.openSession();
	try {
		BlogMapper<Blog> mapper = session.getMapper(BlogMapper.class);
		int pageSize = 50;
		int totalCount = 55;
		int loopCount = (totalCount % pageSize == 0) ? totalCount / pageSize : totalCount / pageSize + 1;
		for (int i = 1; i <= loopCount; i++) {
			List<Blog> blogs = mapper.selectBlogs("ksfzhaohui", new RowBounds(i, pageSize));
			for (Blog b : blogs) {
				System.out.println(b);
			}
			System.out.println("============================");
		}
	} finally {
		session.close();
	}
}

Source File: CeshiMyBatis.java From cg-blog with MIT License

6 votes

@Test
public void testInsert(){
    String resource = "sqlMapConfig.xml";           //定位核心配置文件
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        // 创建 SqlSessionFactory

    SqlSession sqlSession = sqlSessionFactory.openSession();            //获取到 SqlSession

    Person p = new Person();
    p.setId(5);
    p.setName("gavin");
    p.setAge(12);

    sqlSession.insert("yeepay.payplus.mapper.UserMapper.insert", p);
    sqlSession.commit();            //默认是不自动提交，必须手工提交
}

Source File: CeshiMyBatis.java From cg-blog with MIT License

5 votes

@Test
public void testUpdate() {   // 修改方法
    String resource = "sqlMapConfig.xml";            //定位核心配置文件
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        // 创建 SqlSessionFactory

    SqlSession sqlSession = sqlSessionFactory.openSession();            // 获取到 SqlSession

    Person p = new Person();
    p.setId(1);
    p.setAge(12);

    sqlSession.insert("yeepay.payplus.mapper.UserMapper.update", p);
    sqlSession.commit();            //默认是不自动提交，必须手工提交
}

Source File: OneToOneTest.java From mybatis-test with Apache License 2.0

5 votes

@Before
public void prepare() throws IOException {
    String resource = "chapter4/mybatis-config.xml";
    InputStream inputStream = Resources.getResourceAsStream(resource);
    sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    inputStream.close();
}

Source File: TransactionalCacheTest.java From mybatis-test with Apache License 2.0

5 votes

@Before
public void prepare() throws IOException {
    String resource = "chapter6/mybatis-config.xml";
    InputStream inputStream = Resources.getResourceAsStream(resource);
    sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    inputStream.close();
}

Source File: PeopleServiceImpl.java From Project with Apache License 2.0

5 votes

public List<People> selectAll() throws IOException {
    // MyBatis 默认不加载配置文件，因此需要先加载配置文件，返回整个配置文件的流对象
    // 在数据访问层处理异常和在控制器中处理异常，一般在 service 中只抛出异常；
    InputStream inputStream = Resources.getResourceAsStream("MyBatis.xml");
    // 前面是工厂       实例化工厂对象时使用的是构建者设计模式   它的名称标志:后面有Builder
    // 构建者设计模式意义: 简化对象实例化过程
    SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
    // 整个 sqlsession 就是 MyBatis 中 API 封装的对象,增删改查都在里面
    SqlSession session = factory.openSession();
    List<People> list = session.selectList("com.gjxaiou.mapper.PeopleMapper.selAll");
    session.close();
    return list;
}

Source File: XmlMapperBuilderTest.java From mybatis with Apache License 2.0

5 votes

@Test
public void shouldSuccessfullyLoadXMLMapperFile() throws Exception {
  Configuration configuration = new Configuration();
  String resource = "org/apache/ibatis/builder/AuthorMapper.xml";
  InputStream inputStream = Resources.getResourceAsStream(resource);
  XMLMapperBuilder builder = new XMLMapperBuilder(inputStream, configuration, resource, configuration.getSqlFragments());
  builder.parse();
}

Source File: MybatisCacheTest.java From code with Apache License 2.0

5 votes

@Before//在测试方法执行之前执行
public void init() throws Exception {
    //1.读取配置文件
    in = Resources.getResourceAsStream("SqlMapConfig.xml");
    //2.创建构建者对象
    SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    //3.创建 SqlSession 工厂对象
    factory = builder.build(in);
    //4.创建 SqlSession 对象
    session = factory.openSession();
    //5.创建 Dao 的代理对象
    userMapper = session.getMapper(UserMapper.class);
}

Source File: XmlConfigBuilderTest.java From mybaties with Apache License 2.0

5 votes

@Test
public void shouldSuccessfullyLoadMinimalXMLConfigFile() throws Exception {
  String resource = "org/apache/ibatis/builder/MinimalMapperConfig.xml";
  InputStream inputStream = Resources.getResourceAsStream(resource);
  XMLConfigBuilder builder = new XMLConfigBuilder(inputStream);
  Configuration config = builder.parse();
  assertNotNull(config);
}

Source File: MybatisDynamicSqlTest.java From code with Apache License 2.0

5 votes

@Before//在测试方法执行之前执行
public void init() throws Exception {
    //1.读取配置文件
    in = Resources.getResourceAsStream("SqlMapConfig.xml");
    //2.创建构建者对象
    SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    //3.创建 SqlSession 工厂对象
    SqlSessionFactory factory = builder.build(in);
    //4.创建 SqlSession 对象
    session = factory.openSession();
    //5.创建 Dao 的代理对象
    userMapper = session.getMapper(UserMapper.class);
}

Source File: CeshiMyBatis.java From cg-blog with MIT License

5 votes

@Test
public void testDeleteArray() {   // 批量删除
    String resource = "sqlMapConfig.xml";            //定位核心配置文件
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        // 创建 SqlSessionFactory

    SqlSession sqlSession = sqlSessionFactory.openSession();            // 获取到 SqlSession

    sqlSession.delete("yeepay.payplus.mapper.UserMapper.deleteArray", new Integer[]{2, 3, 4});
    sqlSession.commit();            //默认是不自动提交，必须手工提交
}

Source File: XmlConfigBuilderTest.java From mybatis with Apache License 2.0

5 votes

@Test
public void shouldSuccessfullyLoadMinimalXMLConfigFile() throws Exception {
  String resource = "org/apache/ibatis/builder/MinimalMapperConfig.xml";
  InputStream inputStream = Resources.getResourceAsStream(resource);
  XMLConfigBuilder builder = new XMLConfigBuilder(inputStream);
  Configuration config = builder.parse();
  assertNotNull(config);
}

Source File: Test.java From Project with Apache License 2.0

4 votes

public static void main(String[] args) throws IOException {

        // 首先加载配置文件
        InputStream resourceAsStream = Resources.getResourceAsStream("MyBatis.xml");

        // 使用工厂设计模式，创建工厂对象
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);

        // 生产 sqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();

//        Flower flower = new Flower();
//        flower.setId(2);
//
//        // 接收根据 Id 返回的对象
//        List<Flower> flowerList = sqlSession.selectList("MyFlower.selectAll");
//        Iterator<Flower> iterator = flowerList.iterator();
//        while (iterator.hasNext()){
//            System.out.println(((Flower)iterator.next()).toString());
//        }
//
//         // 获取同样 Id 数据数目
//        int countFlower = sqlSession.selectOne("MyFlower.countSelectById", flower);
//        System.out.println(countFlower);
//
//        //
//        Map<Object, Object> newNameMap = sqlSession.selectMap("MyFlower.selectByColumn", "newName");
//        System.out.println(newNameMap);
//
//
//
//        int insert = sqlSession.insert("MyFlower.insert", flower);
//        if (insert != 0){
//            System.out.println("插入成功");
//        }
//
//
//        flower.setId(3);
//        flower.setName("白玉兰");
//        int update = sqlSession.update("MyFlower.update", flower);
//        sqlSession.commit();


        PeopleMapper peopleMapper = sqlSession.getMapper(PeopleMapper.class);
        List<People> peopleList = peopleMapper.selectAll();
        Iterator<People> peopleIterator = peopleList.iterator();
        if (peopleIterator.hasNext()){
            System.out.println((People) peopleIterator.next());
        }
        System.out.println("------");


        // 多参数
        PeopleMapper mapper = sqlSession.getMapper(PeopleMapper.class);
        List<People> peopleList1 = mapper.selectByGenderAndScore("男", 99);
        Iterator<People> iterator2 = peopleList1.iterator();
        if (iterator2.hasNext()) {
            System.out.println(iterator2.next());
        }
        System.out.println("----------");


        // 动态 SQL
        List<People> peopleList2 = mapper.DynamicSelect("男", 76);
        Iterator<People> iterator3 = peopleList2.iterator();
        if (iterator3.hasNext()){
            System.out.println((People)iterator3.next());
        }
        System.out.println("------------");

        for (People people : peopleList2) {
            System.out.println(people);
        }


        sqlSession.close();

    }

Java Code Examples for org.apache.ibatis.io.Resources#getResourceAsStream()