Examples with DAOException org.eweb4j.orm.dao.DAOException used on opensource projects

Example 16 with DAOException

use of org.eweb4j.orm.dao.DAOException in project eweb4j-framework by laiweiwei.

the class UpdateDAOImpl method batchUpdate.

public <T> Number[] batchUpdate(T[] ts, String[] fields, Object[] values) throws DAOException {
    Number[] ids = null;
    if (ts != null && ts.length > 0) {
        Connection con = null;
        ids = new Number[ts.length];
        try {
            con = ds.getConnection();
            Sql[] sqls = SqlFactory.getUpdateSql(ts).update(fields, values);
            List<Object[]> argList = new ArrayList<Object[]>(ts.length);
            for (Sql sql : sqls) {
                argList.add(sql.args.toArray());
            }
            Object[][] args = new Object[argList.size()][];
            for (int i = 0; i < argList.size(); i++) {
                args[i] = argList.get(i);
            }
            ids = JdbcUtil.batchUpdateWithArgs(con, sqls[0].sql, args);
        } catch (Exception e) {
            throw new DAOException("batchUpdate exception ", e);
        }
    }
    return ids;
}

Example 17 with DAOException

use of org.eweb4j.orm.dao.DAOException in project eweb4j-framework by laiweiwei.

the class DivPageDAOImpl method nextOne.

public <T> T nextOne(T t) throws DAOException {
    if (t != null) {
        @SuppressWarnings("unchecked") Class<T> clazz = (Class<T>) t.getClass();
        Connection con = null;
        try {
            con = ds.getConnection();
            List<T> list = JdbcUtil.getList(con, clazz, SqlFactory.getSelectSql(t, dbType).nextOne());
            return list != null && !list.isEmpty() ? list.get(0) : null;
        } catch (Exception e) {
            throw new DAOException("nextOne exception ", e);
        }
    }
    return null;
}

Example 18 with DAOException

use of org.eweb4j.orm.dao.DAOException in project eweb4j-framework by laiweiwei.

the class DivPageDAOImpl method preOne.

public <T> T preOne(T t) throws DAOException {
    if (t != null) {
        Connection con = null;
        try {
            con = ds.getConnection();
            @SuppressWarnings("unchecked") List<T> list = JdbcUtil.getList(con, (Class<T>) t.getClass(), SqlFactory.getSelectSql(t, dbType).preOne());
            return list != null && !list.isEmpty() ? list.get(0) : null;
        } catch (Exception e) {
            throw new DAOException("preOne exception ", e);
        }
    }
    return null;
}

Example 19 with DAOException

use of org.eweb4j.orm.dao.DAOException in project eweb4j-framework by laiweiwei.

the class DivPageDAOImpl method divPageByFieldNotLikeValue.

public <T> List<T> divPageByFieldNotLikeValue(Class<T> clazz, String[] fields, String[] values, int likeType, String orderField, int orderType, int currPage, int numPerPage, boolean isOR) throws DAOException {
    List<T> list = null;
    if (clazz != null) {
        Connection con = null;
        try {
            con = ds.getConnection();
            String sql = SqlFactory.getSelectSql(clazz.newInstance(), dbType).selectWhere(fields, values, likeType, true, true, isOR, orderField, orderType, currPage, numPerPage);
            list = JdbcUtil.getList(con, clazz, sql);
        } catch (Exception e) {
            throw new DAOException("divPageByFieldNotLikeValue exception ", e);
        }
    }
    return list;
}

Example 20 with DAOException

use of org.eweb4j.orm.dao.DAOException in project eweb4j-framework by laiweiwei.

the class DivPageDAOImpl method divPageByFieldIsValue.

public <T> List<T> divPageByFieldIsValue(Class<T> clazz, String[] fields, String[] values, String orderField, int orderType, int currPage, int numPerPage, boolean isOR) throws DAOException {
    List<T> list = null;
    if (clazz != null) {
        Connection con = null;
        try {
            con = ds.getConnection();
            String sql = SqlFactory.getSelectSql(clazz.newInstance(), dbType).selectWhere(fields, values, -2, false, false, isOR, orderField, orderType, currPage, numPerPage);
            list = JdbcUtil.getList(con, clazz, sql);
        } catch (Exception e) {
            throw new DAOException("divPageByFieldIsValue exception ", e);
        }
    }
    return list;
}