Example usage for org.apache.ibatis.session SqlSession selectList

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession selectList.

Prototype

<E> List<E> selectList(String statement, Object parameter);

Source Link

Document

Retrieve a list of mapped objects from the statement key and parameter.

Usage

From source file:org.sonar.core.user.AuthorizationDao.java

License:Open Source License

public List<String> selectGlobalPermissions(@Nullable String userLogin) {
    SqlSession session = mybatis.openSession(false);
    try {/*from ww  w.j  a va2s  .  c om*/
        Map<String, Object> params = newHashMap();
        params.put("userLogin", userLogin);
        return session.selectList("selectGlobalPermissions", params);
    } finally {
        MyBatis.closeQuietly(session);
    }
}

From source file:pecosa.daoImpl.ListasGeneralesDaoImpl.java

@Override
public List<String> getNombrePersonas(Integer codigo) {
    List<String> lista = null;
    SqlSession session = sqlSessionFactory.openSession();
    try {//from   w  w  w  .j  ava 2 s  . c  o  m
        lista = session.selectList("ListasGenerales.getPersonas", codigo);
    } catch (Exception e) {
        System.out.println(e.getMessage());
        e.printStackTrace();
        System.out.println("ERROR EN EL IMPL GET PV");
    } finally {
        session.close();
    }
    return lista;
}

From source file:py.pol.una.ii.pw.data.ProductoRepository.java

License:Apache License

public List<Producto> findAllOrderedByName() {

    SqlSession session = MyBatisSqlSessionFactory.getSqlSessionFactory().openSession();
    List<Producto> productos = session.selectList("selectAll", null);
    return productos;
}

From source file:py.pol.una.ii.pw.data.ProveedorRepository.java

License:Apache License

public List<Proveedor> findAllOrderedByName() {
    SqlSession session = MyBatisSqlSessionFactory.getSqlSessionFactory().openSession();
    List<Proveedor> proveedores = session.selectList("selectAllProveedores", null);
    return proveedores;
    //        CriteriaBuilder cb = em.getCriteriaBuilder();
    //        CriteriaQuery<Proveedor> criteria = cb.createQuery(Proveedor.class);
    //        Root<Proveedor> producto = criteria.from(Proveedor.class);
    //        criteria.select(producto).orderBy(cb.asc(producto.get("nombre")));
    //        return em.createQuery(criteria).getResultList();
}

From source file:shfq.composite_column.ClerkTest.java

License:Apache License

private static void queryClerk() {
    try {/*w ww  . j ava 2 s. c  o  m*/
        Reader reader = Resources.getResourceAsReader("shfq/composite_column/scripts/mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = sqlSessionFactory.openSession();
        //            Object clerk = session.selectList("shfq.composite_column.Clerk.selectClerk", 1);
        Object clerk = session.selectList("shfq.composite_column.composite.Clerk.selectClerk", 1);
        System.out.println("record queried successfully");
        session.commit();
        session.close();
        System.out.println("");
    } catch (IOException e) {
        e.printStackTrace();
    }
}

From source file:shfq.composite_column.ClerkTest.java

License:Apache License

private static void queryClerkAddress() {
    try {/* w w w. j  a  v a2s .  c  o  m*/
        Reader reader = Resources.getResourceAsReader("shfq/mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = sqlSessionFactory.openSession();
        // query student data
        ClerkAddress queryParameter = new ClerkAddress();
        queryParameter.setHouseNo(18);
        queryParameter.setStreetNo(20);
        Object clerkAddress = session.selectList("shfq.composite_column.ClerkAddress.selectClerkAddress",
                queryParameter);
        System.out.println("record queried successfully");
        session.commit();
        session.close();
        System.out.println("");
    } catch (IOException e) {
        e.printStackTrace();
    }
}

From source file:shfq.lazy_load.Test.java

License:Apache License

private static void selectBlog() throws Exception {
    SqlSession session = SessionUtil.getSessionByConfigXmlPath("shfq/lazy_load/mybatis-config.xml");
    Object o = session.selectList("shfq.lazy_load.vo.Blog.selectBlog", 1);
    System.out.println("1 " + System.currentTimeMillis());
    System.out.println("");
    List<Blog> blogs = (List<Blog>) o;
    Blog blog = blogs.get(0);/*from w  w w.j  a va 2s . c  o m*/
    String content = blog.getContent();
    System.out.println(content);
    System.out.println("2 " + System.currentTimeMillis());

    Author author = blog.getAuthor();
    System.out.println(author.getName());
}

From source file:shfq.multiple_resultset.MultipleResultSetTest.java

License:Apache License

private static void queryPeople() {
    try {/*from ww  w  . j  a  v a 2  s  . co  m*/
        Reader reader = Resources.getResourceAsReader("shfq/multiple_resultset/xml/mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = sqlSessionFactory.openSession();
        Object people = session.selectList("shfq.multiple_resultset.xml.caller.callProcedure", 1);
        System.out.println("record queried successfully");
        session.commit();
        session.close();

        System.out.println("dd");
    } catch (IOException e) {
        e.printStackTrace();
    }
}

From source file:shfq.one_many_annotation.PeopleTest.java

License:Apache License

public static void testQuery() {
    try {/*w w  w .j a  v  a  2 s .  com*/
        Reader reader = Resources.getResourceAsReader("shfq/mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = sqlSessionFactory.openSession();
        // query student data
        Object people = session.selectList("shfq.one_many_annotation.People.selectPeople", 1);
        System.out.println("record queried successfully");
        session.commit();
        session.close();
        System.out.println("");
    } catch (IOException e) {
        e.printStackTrace();
    }
}

From source file:shfq.one_to_many.OneToManyTest.java

License:Apache License

public static void main(String[] args) throws Exception {
    SqlSession session = SessionUtil.getSessionByConfigXmlPath("shfq/one_to_many/mybatis-config.xml");
    Object o = session.selectList("shfq.one_many_annotation.People.selectPeople", 1);
    System.out.println("");
}