1)公共的Dao接口

import java.io.Serializable;import java.util.List;public interface IBaseDao
    
     
      , PK extends Serializable> {        /**     * 新增(不会将序列生成的ID,注入)     * 效率较save(T t)高     * @param t     */    void create(T t);        /**     * 批量新增(不会将序列生成的ID,注入)     * 效率较saveOfBatch(List
      
        tList)高     * @param tList     */    void createOfBatch(List
       
         tList);        /**     * 新增(会将序列生成的ID,注入)     * @param t     */    void save(T t);        /**     * 批量新增(会将序列生成的ID,注入)     * @param tList     */    void saveOfBatch(List
        
          tList);        /**     * 根据ID进行删除     * @param id     */    void removeById(PK id);        /**     * 根据ids进行批量删除     * @param ids     */    void removeOfBatch(List
         
           ids);            void removeAll();        /**     * 更新,字段为空，则不进行更新     * @param t     */    void modify(T t);        /**     * 批量更新     * @param tList     */    void modifyOfBatch(List
          
            tList);        /**     * 根据ID获取对象     * @param id     * @return     */    T findOneById(PK id);        /**     * 获取所有的对象     * @return     */    List
           
             findAll();        /**     * 获取记录数     * @return     */    Long findAllCount();    }
           
          
         
        
       
      
     
    

2)公共的Dao接口实现类

import java.io.Serializable;import java.lang.reflect.Field;import java.util.ArrayList;import java.util.HashMap;import java.util.LinkedHashMap;import java.util.List;import java.util.Map;import javax.annotation.Resource;import org.apache.commons.lang.StringUtils;import org.mybatis.spring.SqlSessionTemplate;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.stereotype.Repository;import com.msd.ass.commons.util.GenericsUtils;import com.msd.ass.commons.util.ReflectionUtils;import com.msd.ass.core.anno.base.Ignore;import com.msd.ass.core.anno.base.PrimaryKey;import com.msd.ass.core.anno.base.Table;import com.msd.ass.core.anno.base.TableColumn;import com.msd.ass.core.constant.AssConstant;@Repository("BaseDao")public abstract class BaseDao
    
     
      , PK extends Serializable>        implements IBaseDao
      
        {        protected Logger                                        logger            = LoggerFactory                                                                                    .getLogger(this                                                                                            .getClass());        @Resource(name = "sqlSessionTemplateASS")    public SqlSessionTemplate                                sqlSessionTemplateASS;        private Class
       
                                                entityClass;    //实体类主键名称    private String                                            pkName;    //实体类ID字段名称    private String                                             idName;    //主键的序列    private String                                             seq;    private String                                            tableName;    /**     * 作cache 结构{T类的镜像,{数据库列名,实体字段名}}     */    private static final Map
        
         , Map
         
          >    classFieldMap    = new HashMap
          
           , Map
           
            >();    private Map
            
                                             currentColumnFieldNames;        private SQLGenerator
             
                                                  sqlGenerator;        /**     *      */    @SuppressWarnings("unchecked")    public BaseDao() {        super();        this.entityClass = (Class
              
               ) GenericsUtils                .getSuperClassGenricType(this.getClass());                currentColumnFieldNames = classFieldMap.get(entityClass);        if (null == currentColumnFieldNames) {            currentColumnFieldNames = new LinkedHashMap
               
                ();            classFieldMap.put(entityClass, currentColumnFieldNames);        }                // 作cache        Field[] fields = this.entityClass.getDeclaredFields();                String fieldName = null;        String columnName = null;        for (Field field : fields) {            if (field.isAnnotationPresent(Ignore.class)) {                continue;            }            fieldName = field.getName();            TableColumn tableColumn = field.getAnnotation(TableColumn.class);            if (null != tableColumn) {                columnName = tableColumn.value();            } else {                columnName = null;            }            // 如果未标识特殊的列名，默认取字段名            columnName = (StringUtils.isEmpty(columnName) ? StringUtils                    .upperCase(fieldName) : columnName);            currentColumnFieldNames.put(columnName, fieldName);            if (field.isAnnotationPresent(PrimaryKey.class)) {                // 取得ID的列名                idName = fieldName;                pkName = columnName;                PrimaryKey primaryKey = field.getAnnotation(PrimaryKey.class);                seq = primaryKey.seq();            }        }                Table table = this.entityClass.getAnnotation(Table.class);        if (null == table) { throw new RuntimeException("类-"                + this.entityClass + ",未用@Table注解标识!!"); }        tableName = table.value();                sqlGenerator = new SQLGenerator
                
                 (currentColumnFieldNames.keySet(),                tableName,pkName,seq);    }        @Override    public void create(T t) {        sqlSessionTemplateASS.insert("create",                sqlGenerator.sql_create(t, currentColumnFieldNames));    }        @Override    public void createOfBatch(List
                 
                   tList) {        if(null == tList || tList.isEmpty()){            return;        }        int len = tList.size(), i = 0;        List
                  
                    temp = new ArrayList
                   
                    ();        //获取列表的第一个对象的pk的value        Object pkVal = null;        for (; i < len; i++) {            T t = tList.get(i);            if(i==0){                pkVal = ReflectionUtils.invokeGetterMethod(t, idName);            }                        temp.add(t);            if (i > 0 && i % AssConstant.FLUSH_CRITICAL_VAL == 0) {                sqlSessionTemplateASS.insert("createOfBatch", sqlGenerator                        .sql_createOfBatch(temp, currentColumnFieldNames,pkVal));                sqlSessionTemplateASS.flushStatements();                temp = new ArrayList
                    
                     ();            }        }        sqlSessionTemplateASS.insert("createOfBatch", sqlGenerator                .sql_createOfBatch(temp, currentColumnFieldNames,pkVal));    }            @Override    public void save(T t) {        if(StringUtils.isEmpty(seq)){            this.create(t);        }        logger.info("生成序列开始:----------start----------");        Long nextval = sqlSessionTemplateASS.selectOne("fetchSeqNextval","SELECT ".concat(seq).concat(" FROM DUAL"));        ReflectionUtils.invokeSetterMethod(t, idName, nextval);        logger.info("生成序列结束:---------- end ----------");                this.create(t);    }    @Override    public void saveOfBatch(List
                     
                       tList) {        if(null == tList || tList.isEmpty()){            return;        }        if(StringUtils.isEmpty(seq)){            this.createOfBatch(tList);        }        logger.info("生成序列开始:----------start----------");        for(T t : tList){            Long nextval = sqlSessionTemplateASS.selectOne("fetchSeqNextval","SELECT ".concat(seq).concat(" FROM DUAL"));            ReflectionUtils.invokeSetterMethod(t, idName, nextval);        }        logger.info("生成序列结束:---------- end ----------");                this.createOfBatch(tList);    }    @Override    public void removeById(PK id) {        sqlSessionTemplateASS.delete("removeById",                sqlGenerator.sql_removeById(id));    }        @Override    public void removeOfBatch(List
                      
                        ids) {        if(null == ids || ids.isEmpty()){            return;        }        int len = ids.size(), i = 0;        List
                       
                         temp = new ArrayList
                        
                         ();        for (; i < len; i++) {            temp.add(ids.get(i));            if (i > 0 && i % AssConstant.FLUSH_CRITICAL_VAL == 0) {                sqlSessionTemplateASS.delete("removeOfBatch",                        sqlGenerator.sql_removeOfBatch(temp));                sqlSessionTemplateASS.flushStatements();                temp = new ArrayList
                         
                          ();            }        }        sqlSessionTemplateASS.delete("removeOfBatch",                sqlGenerator.sql_removeOfBatch(temp));    }        @Override    public void removeAll(){        sqlSessionTemplateASS.delete("removeAll",                sqlGenerator.sql_removeAll());    }            @Override    public void modify(T t) {        sqlSessionTemplateASS.update("modify",                sqlGenerator.sql_modify(t, currentColumnFieldNames));            }        @Override    public void modifyOfBatch(List
                          
                            tList) {        if(null == tList || tList.isEmpty()){            return;        }        int len = tList.size(),i=0;        for(;i
                           
                             0 && i % AssConstant.FLUSH_CRITICAL_VAL == 0) {                sqlSessionTemplateASS.flushStatements();            }        }    }        @Override    public T findOneById(PK id) {        Map
                            
                              resultMap = sqlSessionTemplateASS.selectOne(                "findOneById", sqlGenerator.sql_findOneById(id));                return handleResult(resultMap, this.entityClass);    }        @Override    public List
                             
                               findAll() {        List
                              
                             
                            
                           
                          
                         
                        
                       
                      
                     
                    
                   
                  
                 
                
               
              
             
            
           
          
         
        
       
      
     
    

3)xml配置

    
    
         
         
     
              ${value}        
          
      
               ${value}        
           
       
                ${value}        
            
        
                 ${value}        
             
         
                  ${value}        
              
          
           ${value}        
               
           
                    ${value}        
                
            
                     ${value}        
                 
             
                      ${value}            
                  
              
                       ${value}    
              
             
            
           
          
         
        
       
      
     
    

4)两个工具类

4.1)生成SQL的工具类

import java.util.Date;import java.util.LinkedList;import java.util.List;import java.util.Map;import java.util.Set;import org.apache.commons.lang.StringUtils;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import com.msd.ass.commons.util.DateUtil;import com.msd.ass.commons.util.ReflectionUtils;import com.msd.ass.core.constant.AssConstant;/** * Description: 生成查询数量的SQL */public class SQLGenerator
    
      {        protected Logger    logger    = LoggerFactory.getLogger(this.getClass());    private Set
     
          columns;    private String        tableName;    private String        columnsStr;    private String        pkName;    private String        seq;        public SQLGenerator(Set
      
        columns, String tableName, String pkName,            String seq) {        super();        this.columns = columns;        this.tableName = tableName;        this.pkName = pkName;        this.seq = seq;        this.columnsStr = StringUtils.join(this.columns, ",");    }        /**     * 生成新增的SQL     *      * @param t     * @param currentColumnFieldNames     * @return     */    public String sql_create(T t, Map
       
         currentColumnFieldNames) {        List
        
       
      
     
    

4.1)反射的工具类

import java.lang.reflect.Field;import java.lang.reflect.InvocationTargetException;import java.lang.reflect.Method;import java.math.BigDecimal;import java.math.BigInteger;import java.sql.Timestamp;import java.text.ParseException;import java.util.Date;import java.util.HashMap;import java.util.Map;import org.apache.commons.lang.StringUtils;import org.slf4j.Logger;import org.slf4j.LoggerFactory;/** * Description:反射工具类 */public abstract class ReflectionUtils {        private static final Logger    logger    = LoggerFactory            .getLogger(ReflectionUtils.class);    /**     * 缓存方法     */    private static final Map
    
     , Method[]>    METHODS_CACHEMAP    = new HashMap
     
      , Method[]>();        /**     * 反射 取值、设值,合并两个对象(Field same only )     *      * @param from     * @param to     */    public static 
      
        void copyProperties(T fromobj, T toobj,            String... fieldspec) {        for (String filename : fieldspec) {            Object val = ReflectionUtils.invokeGetterMethod(fromobj, filename);            ReflectionUtils.invokeSetterMethod(toobj, filename, val);        }            }        /**     * 调用Getter方法     *      * @param obj     *            对象     * @param propertyName     *            属性名     * @return     */    public static Object invokeGetterMethod(Object obj, String propertyName) {        String getterMethodName = "get" + StringUtils.capitalize(propertyName);        return invokeMethod(obj, getterMethodName, null, null);    }        /**     * 调用Setter方法,不指定参数的类型     *      * @param obj     * @param propertyName     * @param value     */    public static void invokeSetterMethod(Object obj, String propertyName,            Object value) {        invokeSetterMethod(obj, propertyName, value, null);    }        /**     * 调用Setter方法,指定参数的类型     *      * @param obj     * @param propertyName  字段名     * @param value     * @param propertyType     *            为空，则取value的Class     */    public static void invokeSetterMethod(Object obj, String propertyName,            Object value, Class
        propertyType) {        value = handleValueType(obj,propertyName,value);        propertyType = propertyType != null ? propertyType : value.getClass();        String setterMethodName = "set" + StringUtils.capitalize(propertyName);        invokeMethod(obj, setterMethodName, new Class
       [] { propertyType },                new Object[] { value });    }        private static Object handleValueType(Object obj, String propertyName,            Object value){        String getterMethodName = "get" + StringUtils.capitalize(propertyName);        Class
        argsType = value.getClass();;        Class
        returnType = obtainAccessibleMethod(obj, getterMethodName).getReturnType();        if(argsType == returnType){            return value;        }                if (returnType == Boolean.class) {            String temp = value.toString();            value = (StringUtils.isNotBlank(temp) && Long.valueOf(temp) > 0) ? true : false;        } else if (returnType == Long.class) {            value = Long.valueOf(value.toString());        }else if(returnType == Date.class){            try {                value = SimpleDateFormatFactory.getInstance(DateUtil.FULL_TIME_FORMAT).parse(value.toString());            } catch (ParseException e) {                logger.error("类型转型Timpestap-->Date时，发生错误! " + e.getMessage() + "("+value.toString()+")");            }        } else if (returnType == Short.class) {            value = Short.valueOf(value.toString());        } else if (returnType == BigDecimal.class) {            value = BigDecimal.valueOf(Long.valueOf(value.toString()));        } else if (returnType == BigInteger.class) {            value = BigInteger.valueOf(Long.valueOf(value.toString()));        } else if(returnType == String.class){            value = String.valueOf(value);        }else if(returnType == Integer.class){            value = Integer.valueOf(value.toString());        }        return value;    }        public static void main(String[] args) throws Exception {        Timestamp ts = new Timestamp(System.currentTimeMillis());        System.out.println(SimpleDateFormatFactory.getInstance(DateUtil.FULL_TIME_FORMAT).parse(ts.toString()));    }        /**     * 直接调用对象方法，忽视private/protected修饰符     *      * @param obj     * @param methodName     * @param parameterTypes     * @param params     * @return     */    public static Object invokeMethod(final Object obj,            final String methodName, final Class
       [] parameterTypes,            final Object[] args) {        Method method = obtainAccessibleMethod(obj, methodName, parameterTypes);        if (method == null) { throw new IllegalArgumentException(                "Devkit: Could not find method [" + methodName                        + "] on target [" + obj + "]."); }        try {            return method.invoke(obj, args);        } catch (IllegalAccessException e) {            e.printStackTrace();        } catch (IllegalArgumentException e) {            e.printStackTrace();        } catch (InvocationTargetException e) {            e.printStackTrace();        }        return null;    }        /**     * 循环向上转型，获取对象的DeclaredMethod,并强制设置为可访问 如向上转型到Object仍无法找到，返回null     *      * 用于方法需要被多次调用的情况，先使用本函数先取得Method,然后调用Method.invoke(Object obj,Object...     * args)     *      * @param obj     * @param methodName     * @param parameterTypes     * @return     */    public static Method obtainAccessibleMethod(final Object obj,            final String methodName, final Class
       ... parameterTypes) {        Class
        superClass = obj.getClass();        Class
       
      
     
    

懒得写持久层的话，，建议转向使用

http://www.oschina.net/p/mybatis-plus