• Home
• com.gitee.l0km
• facelog-db-orm
• 2.2.0
• source code
• TableManager.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

net.gdface.facelog.dborm.TableManager Maven / Gradle / Ivy

// ______________________________________________________
// Generated by sql2java - https://github.com/10km/sql2java-2-6-7 (custom branch) 
// modified by guyadong from
// sql2java original version https://sourceforge.net/projects/sql2java/ 
// JDBC driver used at code generation time: com.mysql.jdbc.Driver
// template: tablemanager.java.vm
// ______________________________________________________
package net.gdface.facelog.dborm;
import java.util.List;
import java.util.LinkedList;
import java.util.Collection;
import java.util.concurrent.Callable;
import net.gdface.facelog.dborm.exception.DaoException;
import net.gdface.facelog.dborm.exception.ObjectRetrievalException;
/**
 * Interface to handle database calls (save, load, count, etc...) for table.
 * @author guyadong
 */
public interface TableManager> extends Constant {

    public interface Action{
        public abstract class BaseAdapter implements Action{
            @Override
            public B getBean() {return null;}            
        }
        /**
         * do action for {@code bean}
         * @param bean input bean
         * @throws DaoException
         */
        void call(B bean)throws DaoException;
        /**
         * return a B instance
         * @return B bean
         */
        B getBean();
    }
    public abstract static class BaseAdapter> implements TableManager{
        /**
         * return the B bean class
         * @return 
         */
        protected abstract Class beanType();
        //13
        /**
         * Insert the B bean into the database.
         * 
         * @param bean the B bean to be saved
         * @return the inserted bean
         * @throws DaoException
         */
        protected abstract B insert(B bean)throws DaoException;
        //14
        /**
         * Update the B bean record in the database according to the changes.
         *
         * @param bean the B bean to be updated
         * @return the updated bean
         * @throws DaoException
         */
        protected abstract B update(B bean)throws DaoException;
        
        public class ListAction implements Action {
            final List list;
            public ListAction() {
                list=new LinkedList();
            }

            public List getList() {
                return list;
            }

            @Override
            public void call(B bean) {
                list.add(bean);
            }

            @Override
            public B getBean() {
                return null;
            }
        }
        @Override
        public int countAll()throws DaoException{
            return this.countWhere("");
        }

        @Override
        public int countUsingTemplate(B bean)throws DaoException{
            return this.countUsingTemplate(bean, SEARCH_EXACT);
        }

        @Override
        public int deleteAll()throws DaoException{
            return this.deleteByWhere("");
        }


        @Override
        public B[] loadAll()throws DaoException{
            return this.loadUsingTemplate(null, 1, -1, SEARCH_EXACT);
        }

        @Override
        public int loadAll(Action action)throws DaoException{
            return this.loadUsingTemplate(null,null,1,-1, SEARCH_EXACT, action);
        }

        @Override
        public B[] loadAll(int startRow, int numRows)throws DaoException{
            return this.loadUsingTemplate(null, startRow, numRows, SEARCH_EXACT);
        }

        @Override
        public int loadAll(int startRow, int numRows, Action action)throws DaoException{
            return this.loadUsingTemplate(null, null, startRow, numRows, SEARCH_EXACT, action);
        }

        @Override
        public List loadAllAsList()throws DaoException{
            return this.loadUsingTemplateAsList(null,1, -1, SEARCH_EXACT);
        }

        @Override
        public List loadAllAsList(int startRow, int numRows)throws DaoException{
            return this.loadUsingTemplateAsList(null, startRow, numRows, SEARCH_EXACT);
        }

        @Override
        public boolean existsByPrimaryKey(B bean)throws DaoException{
            return null!=loadByPrimaryKey(bean);
        }
        @Override
        public B checkDuplicate(B bean)throws DaoException,ObjectRetrievalException{
            throw new UnsupportedOperationException();
        }
        @Override
        public boolean existsPrimaryKey(Object ...keys)throws DaoException{
            return null!=loadByPrimaryKey(keys);
        }
        
        @Override
        public B[] loadByWhere(String where)throws DaoException{
            return this.loadByWhere(where, (int[])null);
        }

        @Override
        public int loadByWhere(String where, Action action)throws DaoException{
            return this.loadByWhere(where, null, action);
        }

        @Override
        public B[] loadByWhere(String where, int[] fieldList)throws DaoException{
            return this.loadByWhere(where, fieldList, 1, -1);
        }

        @Override
        public int loadByWhere(String where, int[] fieldList, Action action)throws DaoException{
            return this.loadByWhere(where, fieldList, 1, -1, action);
        }

        @SuppressWarnings("unchecked")
        @Override
        public B[] loadByWhere(String where, int[] fieldList, int startRow, int numRows)throws DaoException{
            return this.loadByWhereAsList(where, fieldList, startRow, numRows).toArray((B[])java.lang.reflect.Array.newInstance(beanType(),0));
        }

        @Override
        public int loadByWhere(String where, int[] fieldList, int startRow, int numRows,
                Action action)throws DaoException{
            return this.loadByWhereForAction(where, fieldList, startRow, numRows, action);
        }

        @Override
        public List loadByWhereAsList(String where)throws DaoException{
            return this.loadByWhereAsList(where, null, 1, -1);
        }

        @Override
        public List loadByWhereAsList(String where, int[] fieldList)throws DaoException{
            return this.loadByWhereAsList(where, fieldList, 1, -1);
        }

        @Override
        public List loadByWhereAsList(String where, int[] fieldList, int startRow, int numRows)throws DaoException{
            ListAction action = new ListAction();
            loadByWhereForAction(where, fieldList, startRow, numRows, action);              
            return action.getList();
        }
    
        @Override
        public int loadByWhereForAction(String where, int[] fieldList, int startRow, int numRows,Action action)throws DaoException{
            String sql=createSelectSql(fieldList, where);
            // System.out.println("loadByWhere: " + sql);
            return this.loadBySqlForAction(sql, null, fieldList, startRow, numRows, action);
        }
    
        @Override
        public B[] loadUsingTemplate(B bean)throws DaoException{
            return this.loadUsingTemplate(bean, 1, -1, SEARCH_EXACT);
        }

        @Override
        public int loadUsingTemplate(B bean, Action action)throws DaoException{
            return this.loadUsingTemplate(bean, null, 1, -1, SEARCH_EXACT, action);
        }

        @Override
        public B[] loadUsingTemplate(B bean, int startRow, int numRows)throws DaoException{
            return this.loadUsingTemplate(bean, startRow, numRows, SEARCH_EXACT);
        }

        @Override
        public int loadUsingTemplate(B bean, int startRow, int numRows,
                Action action)throws DaoException{
            return this.loadUsingTemplate(bean, null, startRow, numRows,SEARCH_EXACT, action);
        }

        @SuppressWarnings("unchecked")
        @Override
        public B[] loadUsingTemplate(B bean, int startRow, int numRows, int searchType)throws DaoException{
            return this.loadUsingTemplateAsList(bean, startRow, numRows, searchType).toArray((B[])java.lang.reflect.Array.newInstance(beanType(),0));
        }

        @Override
        public List loadUsingTemplateAsList(B bean)throws DaoException{
            return this.loadUsingTemplateAsList(bean, 1, -1, SEARCH_EXACT);
        }

        @Override
        public List loadUsingTemplateAsList(B bean, int startRow, int numRows)throws DaoException{
            return this.loadUsingTemplateAsList(bean, startRow, numRows, SEARCH_EXACT);
        }

        @Override
        public List loadUsingTemplateAsList(B bean, int startRow, int numRows, int searchType)throws DaoException{
            ListAction action = new ListAction();
            loadUsingTemplate(bean,null,startRow,numRows,searchType, action);
            return action.getList();
        }
        
        @Override
        public B save(B bean)throws DaoException{
            if(null != bean){
                if (bean.isNew()) {
                    this.insert(bean);
                } else {
                    this.update(bean);
                }
            }
            return bean;
        }
        
        @Override
        public B[] save(B[] beans)throws DaoException{
            if(null != beans){
                for (B bean : beans) 
                {
                    this.save(bean);
                }
            }
            return beans;
        }

        @Override
        public > C save(C beans)throws DaoException{
            if(null != beans){
                for (B bean : beans) 
                {
                    this.save(bean);
                }
            }
            return beans;
        }
        
        @Override
        public > C saveAsTransaction(final C beans)throws DaoException{
            return this.runAsTransaction(new Callable(){
                @Override
                public C call() throws Exception {
                    return save(beans);
                }});
        }

        @Override
        public B[] saveAsTransaction(final B[] beans)throws DaoException{
            return this.runAsTransaction(new Callable(){
                @Override
                public B[] call() throws Exception {
                    return save(beans);
                }});
        }

        @SuppressWarnings("unchecked")
        @Override
        public B[] loadBySql(String sql, Object[] argList, int[] fieldList)throws DaoException{
            return loadBySqlAsList(sql, argList, fieldList).toArray((B[])java.lang.reflect.Array.newInstance(beanType(),0));
        }

        @Override
        public List loadBySqlAsList(String sql, Object[] argList, int[] fieldList)throws DaoException{
            ListAction action = new ListAction();
            loadBySqlForAction(sql,argList,fieldList,1,-1,action);
            return action.getList();
        }
        
        /**
         * generate SQL query(SELECT) statement,such as: 'SELECT id,name from mytable WHERE id=1'
         * @param fieldList
         * @param where where condition expression statement that start with 'WHERE',or {@code null},or empty string
         * @return SQL statement string
         * @throws IllegalArgumentException where condition expression don't start with 'WHERE'
         */
        protected String createSelectSql(int[] fieldList, String where){
            StringBuffer sql = new StringBuffer(128);
            String fullFields = this.getFullFields();
            if(null == fieldList || 0 == fieldList.length) {
                sql.append("SELECT ").append(fullFields);
            } else{
                sql.append("SELECT ");
                String[] names=fullFields.split(",");
                for(int i = 0; i < fieldList.length; ++i){
                    if(i > 0) {
                        sql.append(",");
                    }
                    sql.append(names[fieldList[i]]);
                }      
            }
            sql.append(" FROM " + this.getTableName() + " ");
            if(null != where && where.length() > 0){
                if( ! where.trim().toUpperCase().startsWith("WHERE")){
                    throw new IllegalArgumentException("WHERE expression must start with 'WHERE'(case insensitive):[" + where + "]");
                }
                sql.append(where);
            }
            return sql.toString();
        }

        @Override
        public int delete(B bean)throws DaoException{
            throw new UnsupportedOperationException();
        }
        
        @Override
        public > T getReferencedBean(B bean, int fkIndex)throws DaoException{
            throw new UnsupportedOperationException();
        }

        @Override
        public > T setReferencedBean(B bean, T beanToSet, int fkIndex)throws DaoException{
            throw new UnsupportedOperationException();
        }

        @Override
        public > T[] getImportedBeans(B bean, int ikIndex)throws DaoException{
            throw new UnsupportedOperationException();
        }

        @Override
        public > List getImportedBeansAsList(B bean, int ikIndex)throws DaoException{
            throw new UnsupportedOperationException();
        }

        @Override
        public > T[] setImportedBeans(B bean, T[] importedBeans, int ikIndex)throws DaoException{
            throw new UnsupportedOperationException();
        }

        @Override
        public , C extends Collection> C setImportedBeans(B bean, C importedBeans,
                int ikIndex)throws DaoException{
            throw new UnsupportedOperationException();
        }

        @Override
        public B loadByPrimaryKey(B bean)throws DaoException{
            throw new UnsupportedOperationException();
        }
        @Override
        public B loadByPrimaryKeyChecked(B bean)throws DaoException,ObjectRetrievalException{
            throw new UnsupportedOperationException();
        }
        @Override
        public B loadByPrimaryKey(Object ...keys)throws DaoException{
            throw new UnsupportedOperationException();
        }
        @Override
        public B loadByPrimaryKeyChecked(Object ...keys)throws DaoException,ObjectRetrievalException{
            throw new UnsupportedOperationException();
        }
        @Override
        public int deleteByPrimaryKey(Object ...keys)throws DaoException{
            throw new UnsupportedOperationException();
        }
        
        @SuppressWarnings("unchecked")
        @Override
        public B[] loadByIndex(int keyIndex,Object ...keys)throws DaoException{
            return this.loadByIndexAsList(keyIndex,keys).toArray((B[])java.lang.reflect.Array.newInstance(beanType(),0));
        }
        
        @Override
        public List loadByIndexAsList(int keyIndex,Object ...keys)throws DaoException{
            throw new UnsupportedOperationException();
        }
        
        @Override
        public int deleteByIndex(int keyIndex,Object ...keys)throws DaoException{
            throw new UnsupportedOperationException();
        }
        
        @Override
        public B save(B bean,Object ...args)throws DaoException{
            throw new UnsupportedOperationException();
        }
        
        @Override
        public B saveCollection(B bean,Object ...args)throws DaoException{
            throw new UnsupportedOperationException();
        }
        
        @Override
        public B saveAsTransaction(final B bean,final Object ...args)throws DaoException{
            return this.runAsTransaction(new Callable(){
                @Override
                public B call() throws Exception {
                    return save(bean , args );
                }});
        }
        
        @Override
        public B saveCollectionAsTransaction(final B bean,final Object ...args)throws DaoException{
            return this.runAsTransaction(new Callable(){
                @Override
                public B call() throws Exception {
                    return saveCollection(bean , args );
                }});
        }
        
        @Override
        public void runAsTransaction(final Runnable fun)throws DaoException{
            this.runAsTransaction(new Callable