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

Introduction

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

Prototype

<T> T selectOne(String statement, Object parameter);

Source Link

Document

Retrieve a single row mapped from the statement key and parameter.

Usage

From source file:cn.songxinqiang.study.mybatis.test.HelloMyBatis.java

License:Apache License

public static void main(String[] args) throws IOException {
    // mybatis?//from  w w w .j  a  v  a2s .c  o m
    String resource = "conf.xml";
    // mybatis??
    // InputStream is = HelloMyBatis.class.getClassLoader().getResourceAsStream(resource);
    // sqlSession
    // SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);
    // MyBatis??Resourcesmybatis??
    Reader reader = Resources.getResourceAsReader(resource);
    // sqlSession
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    // sqlsqlSession
    SqlSession session = sessionFactory.openSession();
    /**
     * sql
     * mapper.userMapperuserMapper.xmlmappernamespace
     * getUserselectidselectid??SQL
     */
    String statement = "mapper.userMapper.getUser";// sql
    // usersql
    User user = session.selectOne(statement, 2);
    System.out.println(user);

    statement = "mapper.userMapper.listUser";// sql
    List<User> users = session.selectList(statement);
    System.out.println(users);
}

---

From source file:com.albertzhe.mybatis_helloworld.mapper.impl.AdminMapperImpl.java

public Admin getAdminByID(Long id) {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    Admin admin = null;//from www .j  av  a  2 s .  c o  m

    try {
        admin = sqlSession.selectOne("com.albertzhe.mybatis_helloworld.mapper.AdminMapper.getAdminByID", id);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        sqlSession.close();
    }

    return admin;
}

---

From source file:com.company.project.service.UserMapperImpl.java

License:Apache License

@Override
public Map get(String username) {
    // note standard MyBatis API usage - opening and closing the session manually
    SqlSession session = sqlSessionFactory.openSession();
    try {//from  w  w w.  j a  v a  2 s .c  o  m
        return session.selectOne("com.company.project.persistence.UserMapper.get", username);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }

    return null;
}

---

From source file:com.DAO.VehicleDAOImpl.java

@Override
public Vehicle getVehicle(String license) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from w  w  w .jav  a2s. com
        Vehicle vehicle = session.selectOne("Vehicle.getVehicle", license);
        return vehicle;
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return null;
}

---

From source file:com.github.hexsmith.spring.boot.mybatis.demo.MybatisXmlConfigurationDemo.java

License:Apache License

public static void main(String[] args) throws IOException {
    ResourceLoader resourceLoader = new DefaultResourceLoader();
    Resource resource = resourceLoader.getResource("classpath:mybatis/mybatis-config.xml");
    EncodedResource encodedResource = new EncodedResource(resource, "UTF-8");
    Reader reader = encodedResource.getReader();
    SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    SqlSessionFactory sqlSessionFactory = builder.build(reader, "development", new Properties());
    SqlSession sqlSession = sqlSessionFactory.openSession();
    User user = sqlSession.selectOne("com.github.hexsmith.spring.boot.mybatis.mapper.UserMapper.selectOneUser",
            3);//from w w w  .ja  va 2s. c  o m
    System.out.println(user);
}

---

From source file:com.glaf.base.test.UserTest2.java

License:Apache License

public static void main(String[] args) {
    long start = System.currentTimeMillis();
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from ww  w . ja  v a 2 s.co  m*/
        User user = session.selectOne("getUserById", "root");
        System.out.println(user.toJsonObject().toJSONString());
    } finally {
        session.close();
    }
    long time = System.currentTimeMillis() - start;
    System.out.println("" + (time));
}

---

From source file:com.glaf.core.dao.MyBatisEntityDAO.java

License:Apache License

public int getCount(String statementId, Object parameterObject) {
    int totalCount = 0;
    SqlSession session = getSqlSession();

    Object object = null;/* www  . j ava2 s.com*/
    if (parameterObject != null) {
        object = session.selectOne(statementId, parameterObject);
    } else {
        object = session.selectOne(statementId);
    }

    if (object instanceof Integer) {
        Integer iCount = (Integer) object;
        totalCount = iCount.intValue();
    } else if (object instanceof Long) {
        Long iCount = (Long) object;
        totalCount = iCount.intValue();
    } else if (object instanceof BigDecimal) {
        BigDecimal bg = (BigDecimal) object;
        totalCount = bg.intValue();
    } else if (object instanceof BigInteger) {
        BigInteger bi = (BigInteger) object;
        totalCount = bi.intValue();
    } else {
        String value = object.toString();
        totalCount = Integer.parseInt(value);
    }
    return totalCount;
}

---

From source file:com.glaf.core.dao.MyBatisEntityDAO.java

License:Apache License

public Paging getPage(int pageNo, int pageSize, SqlExecutor countExecutor, SqlExecutor queryExecutor) {
    if (pageSize <= 0) {
        pageSize = Paging.DEFAULT_PAGE_SIZE;
    }//  w  w  w .ja  va2s .  co  m
    if (pageNo <= 0) {
        pageNo = 1;
    }

    Object object = null;
    int totalCount = 0;
    Paging page = new Paging();
    SqlSession session = getSqlSession();

    Object parameter = countExecutor.getParameter();
    if (parameter != null) {
        object = session.selectOne(countExecutor.getStatementId(), parameter);
    } else {
        object = session.selectOne(countExecutor.getStatementId());
    }

    if (object instanceof Integer) {
        Integer iCount = (Integer) object;
        totalCount = iCount.intValue();
    } else if (object instanceof Long) {
        Long iCount = (Long) object;
        totalCount = iCount.intValue();
    } else if (object instanceof BigDecimal) {
        BigDecimal bg = (BigDecimal) object;
        totalCount = bg.intValue();
    } else if (object instanceof BigInteger) {
        BigInteger bi = (BigInteger) object;
        totalCount = bi.intValue();
    } else {
        String value = object.toString();
        totalCount = Integer.parseInt(value);
    }

    if (totalCount == 0) {
        page.setRows(new java.util.ArrayList<Object>());
        page.setCurrentPage(0);
        page.setPageSize(0);
        page.setTotal(0);
        return page;
    }

    page.setTotal(totalCount);

    int maxPageNo = (page.getTotal() + (pageSize - 1)) / pageSize;
    if (pageNo > maxPageNo) {
        pageNo = maxPageNo;
    }

    List<Object> rows = null;

    Object queryParams = queryExecutor.getParameter();

    int begin = (pageNo - 1) * pageSize;

    RowBounds rowBounds = new RowBounds(begin, pageSize);

    if (queryParams != null) {
        rows = session.selectList(queryExecutor.getStatementId(), queryParams, rowBounds);
    } else {
        rows = session.selectList(queryExecutor.getStatementId(), null, rowBounds);
    }

    page.setRows(rows);
    page.setPageSize(pageSize);
    page.setCurrentPage(pageNo);

    logger.debug("params:" + queryParams);
    logger.debug("rows size:" + rows.size());

    return page;
}

---

From source file:com.glaf.core.entity.mybatis.MyBatisEntityDAOImpl.java

License:Apache License

public Paging getPage(int pageNo, int pageSize, SqlExecutor countExecutor, SqlExecutor queryExecutor) {
    if (pageNo < 1) {
        pageNo = 1;/*from   w  ww . j  ava2  s  . co m*/
    }
    if (pageSize <= 0) {
        pageSize = Paging.DEFAULT_PAGE_SIZE;
    }

    Object object = null;
    int totalCount = 0;
    Paging page = new Paging();
    SqlSession session = getSqlSession();

    Object parameter = countExecutor.getParameter();
    if (parameter != null) {
        object = session.selectOne(countExecutor.getStatementId(), parameter);
    } else {
        object = session.selectOne(countExecutor.getStatementId());
    }

    if (object instanceof Integer) {
        Integer iCount = (Integer) object;
        totalCount = iCount.intValue();
    } else if (object instanceof Long) {
        Long iCount = (Long) object;
        totalCount = iCount.intValue();
    } else if (object instanceof BigDecimal) {
        BigDecimal bg = (BigDecimal) object;
        totalCount = bg.intValue();
    } else if (object instanceof BigInteger) {
        BigInteger bi = (BigInteger) object;
        totalCount = bi.intValue();
    } else {
        String value = object.toString();
        totalCount = Integer.parseInt(value);
    }

    if (totalCount == 0) {
        page.setRows(new java.util.ArrayList<Object>());
        page.setCurrentPage(0);
        page.setPageSize(0);
        page.setTotal(0);
        return page;
    }

    page.setTotal(totalCount);

    int maxPageNo = (page.getTotal() + (pageSize - 1)) / pageSize;
    if (pageNo > maxPageNo) {
        pageNo = maxPageNo;
    }

    List<Object> rows = null;

    Object queryParams = queryExecutor.getParameter();

    int begin = (pageNo - 1) * pageSize;

    logger.debug("begin:" + begin);
    logger.debug("pageSize:" + pageSize);

    RowBounds rowBounds = new RowBounds(begin, pageSize);

    if (queryParams != null) {
        rows = session.selectList(queryExecutor.getStatementId(), queryParams, rowBounds);
    } else {
        rows = session.selectList(queryExecutor.getStatementId(), null, rowBounds);
    }

    page.setRows(rows);
    page.setPageSize(pageSize);
    page.setCurrentPage(pageNo);

    if (LogUtils.isDebug()) {
        logger.debug("params:" + queryParams);
        logger.debug("rows size:" + rows.size());
    }

    return page;
}

---

From source file:com.glaf.core.test.MyBatisMultiConnectionTest.java

License:Apache License

public static void main(String[] args) {
    long start = System.currentTimeMillis();
    SqlSession session = null;
    Connection conn = null;/* w  w w  .j  av  a2 s  . c om*/
    try {
        conn = DBConnectionFactory.getConnection();
        session = sqlSessionFactory.openSession(conn);
        User user = session.selectOne("getUserById", "root");
        System.out.println(user.toJsonObject().toJSONString());
    } catch (Exception ex) {
        ex.printStackTrace();
    } finally {
        if (session != null) {
            session.close();
        }
        JdbcUtils.close(conn);
    }
    long time = System.currentTimeMillis() - start;
    System.out.println("" + (time));

    for (int i = 0; i < 100; i++) {
        start = System.currentTimeMillis();
        session = null;
        conn = null;
        try {
            conn = DBConnectionFactory.getConnection("yz");
            session = sqlSessionFactory.openSession(conn);
            TreeModel tree = session.selectOne("getTreeModelByCode", "SYS000");
            System.out.println(tree.toJsonObject().toJSONString());
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            if (session != null) {
                session.close();
            }
            JdbcUtils.close(conn);
        }
        time = System.currentTimeMillis() - start;
        System.out.println("" + (time));
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• »