自定义表数据操作

最新推荐文章于 2022-07-18 10:40:22 发布
最新推荐文章于 2022-07-18 10:40:22 发布
阅读量229 收藏 1
点赞数 1
分类专栏： 自定义sql表数据操作 文章标签： java sql mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_41271428/article/details/106714922
版权

自定义表数据操作

参数实体类

自定义Db实例

public class CustomizeDbExamle {

    /**
     * 更新数据参数
     */
    private Map<String,Object> updateParameter;

    /**
     * 插入数据参数
     */
    private Map<String,Object> insertParameter;

    /**
     * 表名称
     */
    private String tableName;

    /**
     * 条件参数 and
     */
    private CustomizeConditionArr conditionParameters;

    /**
     * 当具有or的条件参数时使用 or (and) 情况使用
     */
    private List<CustomizeConditionArr> orParameters;

    /**
     * 当具有or的条件参数时使用 and (or) 情况使用
     */
    private List<CustomizeConditionArr> andParameters;

    public CustomizeDbExamle() {
        orParameters = new ArrayList<>();
        andParameters = new ArrayList<>();
    }

    public Map<String, Object> getUpdateParameter() {
        return updateParameter;
    }

    public void setUpdateParameter(Map<String, Object> updateParameter) {
        this.updateParameter = updateParameter;
    }

    public Map<String, Object> getInsertParameter() {
        return insertParameter;
    }

    public void setInsertParameter(Map<String, Object> insertParameter) {
        this.insertParameter = insertParameter;
    }

    public String getTableName() {
        return tableName;
    }

    public void setTableName(String tableName) {
        this.tableName = tableName;
    }

    public CustomizeConditionArr getConditionParameters() {
        return conditionParameters;
    }

    public void setConditionParameters(CustomizeConditionArr conditionParameters) {
        this.conditionParameters = conditionParameters;
    }

    public void setOrParameters(List<CustomizeConditionArr> orParameters) {
        this.orParameters = orParameters;
    }

    public List<CustomizeConditionArr> getOrParameters() {
        return orParameters;
    }

    public List<CustomizeConditionArr> getAndParameters() {
        return andParameters;
    }

    public void setAndParameters(List<CustomizeConditionArr> andParameters) {
        this.andParameters = andParameters;
    }

    public void or(CustomizeConditionArr orParameters) {
        this.orParameters.add(orParameters);
    }

    public void and(CustomizeConditionArr andParameters) {
        this.andParameters.add(andParameters);
    }

    public CustomizeConditionArr createCustomizeConditionArr(){
        CustomizeConditionArr conditionParameters = new CustomizeConditionArr();
        if(this.conditionParameters==null){
            this.conditionParameters = conditionParameters;
        }
        return conditionParameters;
    }

    public static void main(String[] args){
        CustomizeDbExamle customizeDbExamle = new CustomizeDbExamle();
        customizeDbExamle.setTableName("test");
        CustomizeConditionArr customizeConditionArr = customizeDbExamle.createCustomizeConditionArr();
        customizeConditionArr.addEqualTo("test","condition","value");
        customizeConditionArr.addEqualTo("test","condition1","value1");
        CustomizeConditionArr customizeConditionArr1 = customizeDbExamle.createCustomizeConditionArr();
        customizeConditionArr1.addEqualTo("test","conditionOr","conditionOr");
        customizeConditionArr1.addEqualTo("test","conditionOr1","conditionOr1");
        customizeDbExamle.or(customizeConditionArr1);
        CustomizeConditionArr customizeConditionArr2 = customizeDbExamle.createCustomizeConditionArr();
        customizeConditionArr2.addEqualTo("test","conditionOrTwo","conditionOrTwo");
        customizeConditionArr2.addEqualTo("test","conditionOrTwo1","conditionOrTwo1");
        customizeDbExamle.and(customizeConditionArr2);
        System.out.println(JSONObject.toJSONString(param));
    }
}

封装自定义条件组

public class CustomizeConditionArr {

    private static Properties properties = ResourceUtils.getDefaultResourceAsProperties("condition.properties");

    private List<CustomizeCondition> customizeConditions;

    public CustomizeConditionArr() {
        this.customizeConditions = new ArrayList<>();
    }

    public List<CustomizeCondition> getCustomizeConditions() {
        return customizeConditions;
    }

    public void setCustomizeConditions(List<CustomizeCondition> customizeConditions) {
        this.customizeConditions = customizeConditions;
    }
    /**
     * @author:zyp
     * @description 值为null
     * @date: 2020/8/21 10:24
     * @return
     */
    public void addIsNull(String tableName,String condition){
        customizeConditions.add(new CustomizeCondition(tableName,condition,null,properties.getProperty("IsNull")));
    }

    /**
     * @author:zyp
     * @description 值不为null
     * @date: 2020/8/21 10:24
     * @return
     */
    public void addIsNotNull(String tableName,String condition){
        customizeConditions.add(new CustomizeCondition(tableName,condition,null,properties.getProperty("IsNotNull")));
    }

    /**
     * @author:zyp
     * @description 等于
     * @date: 2020/8/21 10:21
     * @return 
     */
    public void addEqualTo(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("EqualTo")));
    }

   /**
     * @author:zyp
     * @description 不等于
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addNotEqualTo(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("NotEqualTo")));
    }

   /**
     * @author:zyp
     * @description 大于
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addGreaterThan(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("GreaterThan")));
    }

   /**
     * @author:zyp
     * @description 大于或等于
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addGreaterThanOrEqualTo(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("GreaterThanOrEqualTo")));
    }

   /**
     * @author:zyp
     * @description 小于
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addLessThan(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("LessThan")));
    }

   /**
     * @author:zyp
     * @description 小于或等于
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addLessThanOrEqualTo(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("LessThanOrEqualTo")));
    }

   /**
     * @author:zyp
     * @description in
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addIn(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("In")));
    }

   /**
     * @author:zyp
     * @description not in
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addNotIn(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("NotIn")));
    }

   /**
     * @author:zyp
     * @description 在两者之间
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addBetween(String tableName,String condition,Object value,Object secondValue){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,secondValue,properties.getProperty("Between")));
    }

   /**
     * @author:zyp
     * @description 不在两者之间
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addNotBetween(String tableName,String condition,Object value,Object secondValue){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,secondValue,properties.getProperty("NotBetween")));
    }

   /**
     * @author:zyp
     * @description 排序
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addOrderBy(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("OrderBy")));
    }

   /**
     * @author:zyp
     * @description Limit
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addLimit(String tableName,String condition,Object value,Object secondValue){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,secondValue,properties.getProperty("Limit")));
    }

   /**
     * @author:zyp
     * @description Like
     * @date: 2020/8/21 10:21
     * @return
     */
    public void addLike(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("Like")));
    }

   /**
     * @author:zyp
     * @description NotLike
     * @date: 2020/8/21 10:21
     * @return
     */
    public void NotLike(String tableName,String condition,Object value){
        customizeConditions.add(new CustomizeCondition(tableName,condition,value,properties.getProperty("NotLike")));
    }
}

CustomizeCondition自定义条件对象

public class CustomizeCondition {

    private String tableName;

    //字段  对该字段进行查询
    private String condition;

    //查询数值1  针对于查询时只需要一个参数的条件使用  入> = <
    private Object value;

    //查询数值1  针对于查询时需要两个参数的条件使用  入between
    private Object secondValue;

    //查询方式  > = < in等等
    private String type;

    public CustomizeCondition() {
    }

    public CustomizeCondition(String tableName, String condition, Object value, String type) {
        this(tableName,condition,value,null,type);
    }

    public CustomizeCondition(String tableName, String condition, Object value, Object secondValue, String type) {
        this.tableName = tableName;
        this.condition = condition;
        this.value = value;
        this.secondValue = secondValue;
        this.type = type;
    }

    public String getTableName() {
        return tableName;
    }

    public void setTableName(String tableName) {
        this.tableName = tableName;
    }

    public String getCondition() {
        return condition;
    }

    public void setCondition(String condition) {
        this.condition = condition;
    }

    public Object getValue() {
        return value;
    }

    public void setValue(Object value) {
        this.value = value;
    }

    public Object getSecondValue() {
        return secondValue;
    }

    public void setSecondValue(Object secondValue) {
        this.secondValue = secondValue;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }
}

共用方法

 	/**
     * @author:zyp
     * @description 根据表名获取表的所有字段
     * @date: 2020/4/1 9:12
     * @return
     */
    private List<TbTableColDefine> getTbTableColDefines(String tableName){
        List<TbTableColDefine> tbTableColDefines;
        TbTableDefineExample tbTableDefineExample = new TbTableDefineExample();
        TbTableDefineExample.Criteria criteria = tbTableDefineExample.createCriteria();
        criteria.andTableNmEqualTo(tableName);
        List<TbTableDefine> tbTableDefines = clusterTbTableDefineMapper.selectByExample(tbTableDefineExample);
        if(tbTableDefines!=null && tbTableDefines.size()>0){
            TbTableDefine tbTableDefine = tbTableDefines.get(0);
            Integer id = tbTableDefine.getId();
            TbTableColDefineExample tbTableColDefineExample = new TbTableColDefineExample();
            TbTableColDefineExample.Criteria criteria1 = tbTableColDefineExample.createCriteria();
            criteria1.andTableidEqualTo(id);
            tbTableColDefines = clusterTbTableColDefineMapper.selectByExample(tbTableColDefineExample);
        }else{
            tbTableColDefines = new ArrayList<>();
        }
        return tbTableColDefines;
    }

	/**
     * @author:zyp
     * @description 获取所有表字段，以及其外键关系
     * @return List<List<String>> 内部list为包装的每个表字段的转义返回方式以及关联关系  0：当前表字段  1：关联表名 2:关联表字段 3:转义后的字段
     * @date: 2020/4/24 14:01
     * @return 
     */
    public static List<List<String>> getTableColRelate(List<TbTableColDefine> tbTableColDefines){
        List<List<String>> selectList = new ArrayList<>();
        tbTableColDefines.forEach((TbTableColDefine tbTableColDefine) ->{
            List<String> templist = new ArrayList<>();
            String fieldName = tbTableColDefine.getFieldName();
            Integer relateType = tbTableColDefine.getRelateType();
            //当字典时使用，该字段在join中使用
            String dictCode = tbTableColDefine.getDictCode();
            if(relateType!=null&&relateType!=0){
                switch (relateType){
                    //字典
                    case 1:
                        templist.add(fieldName);
                        templist.add("tb_dictionary");
                        String relateColDic = tbTableColDefine.getRelateCol();
                        String relateShowValueDic = tbTableColDefine.getRelateShowValue();
                        templist.add(relateColDic);
                        templist.add(relateShowValueDic);
                        templist.add(dictCode);
                        break;
                    case 2:
                        String relateTb = tbTableColDefine.getRelateTb();
                        String relateCol = tbTableColDefine.getRelateCol();
                        String relateShowValue = tbTableColDefine.getRelateShowValue();
                        templist.add(fieldName);
                        templist.add(relateTb);
                        templist.add(relateCol);
                        templist.add(relateShowValue);
                        break;
                    default :
                        templist.add(fieldName);
                }
            }else{
                templist.add(fieldName);
            }
            selectList.add(templist);
        });
        return selectList;
    }
    
	/**
     * @author:zyp
     * @description 编写sql(简单查询)
     * @date: 2020/3/18 15:46
     * @return
     */
    public static String compileSelectSQL(List<List<String>> selectList,String tableName, CustomizeDbExamle customizeDbExamle){
        StringBuffer relateString = new StringBuffer();
        StringBuffer stringBuffer = new StringBuffer();
        stringBuffer.append("select ");
        if(selectList!=null&&selectList.size()>0){
            int index = 0;
            for(List<String> selects : selectList){
                //selects!=0 说明此表字段在数据库中可查，为字段名的集合
                if(selects.size()!=0){
                    //当list大于一时，证明该字段需要与外表关联转义
                    if (selects.size()>1){
                        String fieldName = selects.get(0);
                        String relateTb = selects.get(1);
                        String relateCol = selects.get(2);
                        String relateShowValue = selects.get(3);
                        if(selects.size()!=5){
                            stringBuffer.append(relateTb+"."+relateShowValue + " as "+ fieldName +",");
                            relateString.append(" left join "+ relateTb + " as " + relateTb + " ON " + tableName+"."+fieldName+"="+relateTb+"."+relateCol);
                        }else{
                            //如果当前为字典表（字典表的数组长度为5），需要将字典表的表名加数据
                            String dictCode = selects.get(4);
                            stringBuffer.append(relateTb + index + "."+relateShowValue + " as "+ fieldName +",");
                            relateString.append(" left join "+ relateTb + " as " + relateTb + index + " ON " + tableName+"."+fieldName+"="+relateTb + index +"."+relateCol+" and " + relateTb + index + ".pid="+dictCode);
                        }
                    }else{
                        stringBuffer.append(tableName+"."+selects.get(0) + ",");
                    }
                    index++;
                }else{
                    //如果无关联 则查询增加 * 符号，但只能增加一个
                    if(stringBuffer.indexOf("*")==-1){
                        stringBuffer.append(" * ");
                    }
                }
            }
        }else{
            stringBuffer.append(" * ");
        }
        stringBuffer.deleteCharAt(stringBuffer.length()-1);
        stringBuffer.append(" from " + tableName + " as " + tableName);
        stringBuffer.append(relateString);
        //条件编写
        String conditionString = conditionSql(customizeDbExamle);
        String sql = stringBuffer.append(conditionString).toString();
        System.out.println(sql);
        return sql;
    }
	/**
     * @author:zyp
     * @description 条件sql编写
     * @date: 2020/4/2 17:19
     * @return
     */
    public static String conditionSql(CustomizeDbExamle customizeDbExamle){
        //条件添加
        CustomizeConditionArr conditionParameters = customizeDbExamle.getConditionParameters();
        List<CustomizeConditionArr> orParameters = customizeDbExamle.getOrParameters();
        List<CustomizeConditionArr> andParameters = customizeDbExamle.getAndParameters();
        //针对条件、分页 以及 顺序排列 单独列出
        StringBuffer conditionBuffer = new StringBuffer();
        StringBuffer limitBuffer = new StringBuffer();
        StringBuffer orderByBuffer = new StringBuffer();
        //当条件参数的长度大于零时，则代表当前具有条件查询
        if (conditionParameters != null&& conditionParameters.getCustomizeConditions()!=null&& conditionParameters.getCustomizeConditions().size() > 0) {
            conditionParameters.getCustomizeConditions().forEach(condition -> {
                //当前数据查询条件方式
                String type = condition.getType();
                ConditionExample conditionExample = (ConditionExample) ConditionUtil.STRATEGYMAP.get(condition.getType());
                String handleSql = conditionExample.handleSql(condition);
                if ("OrderBy".equals(type)) {
                    orderByBuffer.append(" " + handleSql + " ");
                } else if ("Limit".equals(type)) {
                    if((databaseIndex != EcloudLibraryTableConstans.DATABASE_INDEX.JILEI.getValue())){
                        limitBuffer.append(" " + handleSql + " ");
                    }else{
                        limitBuffer.append(" LIMIT "+condition.getSecondValue()+" OFFSET "+condition.getValue()+" ");
                    }
                } else {
                    conditionBuffer.append(" " + handleSql + " and ");
                }
            });
        }
        if(StringUtils.isBlank(conditionBuffer)){
            conditionBuffer.append("1 = 1 and ");
        }
        //或的逻辑处理  or (and)
        if(orParameters != null && orParameters.size() > 0){
            //当将之前的最后一个and 删除
            if (conditionBuffer.length() != 0&&conditionBuffer.indexOf("or",0)==-1) {
                conditionBuffer.delete(conditionBuffer.lastIndexOf("and"), conditionBuffer.length());
            }

            //遍历或的数组，获取每个或的数组数据
            orParameters.forEach(orParameter->{
                List<CustomizeCondition> customizeConditions = orParameter.getCustomizeConditions();
                if(customizeConditions!=null&&customizeConditions.size()>0){
                    conditionBuffer.append("or (");
                    //遍历每个或数组的数据
                    customizeConditions.forEach(customizeCondition -> {
                        ConditionExample conditionExample = (ConditionExample) ConditionUtil.STRATEGYMAP.get(customizeCondition.getType());
                        String handleSql = conditionExample.handleSql(customizeCondition);
                        conditionBuffer.append(" " + handleSql + " and ");
                    });
                    //在最后收尾时，把最后一个and删除
                    conditionBuffer.delete(conditionBuffer.lastIndexOf("and"), conditionBuffer.length()).toString();
                    conditionBuffer.append(" ) ");
                }
            });
        }
        //and的逻辑处理  and (or)
        if(andParameters != null && andParameters.size() > 0){
            //因为开头即为and进行内容获取  故不需要删除，但需要判断是否已经进行了或逻辑处理，如果或逻辑处理了，那么这里就需要增加and
            if (conditionBuffer.length() != 0&&conditionBuffer.lastIndexOf(")")!=conditionBuffer.length()-2) {
                conditionBuffer.delete(conditionBuffer.lastIndexOf("and"), conditionBuffer.length());
            }
            //遍历或的数组，获取每个或的数组数据
            andParameters.forEach(andParameter->{
                List<CustomizeCondition> customizeConditions = andParameter.getCustomizeConditions();
                if(customizeConditions!=null&&customizeConditions.size()>0){
                    conditionBuffer.append("and (");
                    //遍历每个或数组的数据
                    customizeConditions.forEach(customizeCondition -> {
                        ConditionExample conditionExample = (ConditionExample) ConditionUtil.STRATEGYMAP.get(customizeCondition.getType());
                        String handleSql = conditionExample.handleSql(customizeCondition);
                        conditionBuffer.append(" " + handleSql + " or ");
                    });
                    //在最后收尾时，把最后一个and删除
                    conditionBuffer.delete(conditionBuffer.lastIndexOf("or"), conditionBuffer.length()).toString();
                    conditionBuffer.append(" ) ");
                }
            });
        }else{
            if(conditionBuffer.indexOf("and")!=-1&&conditionBuffer.lastIndexOf(")")!=conditionBuffer.length()-2){
                conditionBuffer.delete(conditionBuffer.lastIndexOf("and"), conditionBuffer.length());
            }
        }
        //完成逻辑处理之后的条件查询数据
        String finishConditionBuffer = "";
        if(conditionBuffer!=null&&conditionBuffer.length()!=0){
            finishConditionBuffer = " where " + conditionBuffer.toString();
        }
        String conditionString = finishConditionBuffer + orderByBuffer.toString() + limitBuffer.toString();
        return conditionString;
    }

拼接sql条件时使用（仿照逆向工程中的Criteria写法去做）

public interface ConditionExample {

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

    String handleSql(CustomizeCondition customizeCondition);

}

/**
 * @author:zyp
 * @description isNull条件
 * @date: 2020/3/20 11:52
 * @return
 */
class IsNullCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":(StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+"."))+customizeCondition.getCondition() + " Is Null";
    }
}

/**
 * @author:zyp
 * @description isNotNull条件
 * @date: 2020/3/20 11:52
 * @return
 */
class IsNotNullCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":(StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+"."))+customizeCondition.getCondition() + " Is Not Null";
    }
}

/**
 * @author:zyp
 * @description 相等条件
 * @date: 2020/3/20 11:52
 * @return
 */
class EqualToCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":(StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+"."))+customizeCondition.getCondition() + " = '" + customizeCondition.getValue()+"'";
    }
}

/**
 * @author:zyp
 * @description 不相等条件
 * @date: 2020/3/20 11:52
 * @return
 */
class NotEqualToCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":(StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+"."))+customizeCondition.getCondition() + " <> '" + customizeCondition.getValue()+"'";
    }
}

/**
 * @author:zyp
 * @description 大于条件
 * @date: 2020/3/20 11:52
 * @return
 */
class GreaterThanCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":(StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+"."))+customizeCondition.getCondition() + " > '" + customizeCondition.getValue()+"'";
    }
}

/**
 * @author:zyp
 * @description 大于或等于条件
 * @date: 2020/3/20 11:52
 * @return
 */
class GreaterThanOrEqualToCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":(StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+"."))+customizeCondition.getCondition() + " >= '" + customizeCondition.getValue()+"'";
    }
}

/**
 * @author:zyp
 * @description 小于条件
 * @date: 2020/3/20 11:52
 * @return
 */
class LessThanCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " < '" + customizeCondition.getValue()+"'";
    }
}

/**
 * @author:zyp
 * @description 小于或等于条件
 * @date: 2020/3/20 11:52
 * @return
 */
class LessThanOrEqualToCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " <= '" + customizeCondition.getValue()+"'";
    }
}

/**
 * @author:zyp
 * @description in条件
 * @date: 2020/3/20 11:52
 * @return
 */
class InCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        List<Object> list = (List<Object>) customizeCondition.getValue();
        StringBuffer sb = new StringBuffer();
        list.forEach(obj->{
            if(obj instanceof Date){
                String format = sdf.format(obj);
                sb.append("'"+format + "',");
            }else{
                sb.append("'"+obj + "',");
            }
        });
        sb.deleteCharAt(sb.length()-1);
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " in (" + sb.toString()+")";
    }
}

/**
 * @author:zyp
 * @description notin条件
 * @date: 2020/3/20 11:52
 * @return
 */
class NotInCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        List<Object> list = (List<Object>) customizeCondition.getValue();
        StringBuffer sb = new StringBuffer();
        list.forEach(obj->{
            if(obj instanceof Date){
                String format = sdf.format(obj);
                sb.append("'"+format + "',");
            }else{
                sb.append("'"+obj + "',");
            }
        });
        sb.deleteCharAt(sb.length()-1);
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " not in (" + sb.toString()+")";
    }
}

/**
 * @author:zyp
 * @description Like条件
 * @date: 2020/3/20 11:52
 * @return
 */
class LikeCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " Like " +" '%" + customizeCondition.getValue() +"%' ";
    }
}

/**
 * @author:zyp
 * @description NotLike条件
 * @date: 2020/3/20 11:52
 * @return
 */
class NotLikeCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " not Like " +" '%" + customizeCondition.getValue() +"%' ";
    }
}

/**
 * @author:zyp
 * @description between条件
 * @date: 2020/3/20 11:52
 * @return
 */
class BetweenCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getSecondValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " between '" + customizeCondition.getValue() +"' and '" + customizeCondition.getSecondValue()+"'";
    }
}

/**
 * @author:zyp
 * @description notBetween条件
 * @date: 2020/3/20 11:52
 * @return
 */
class NotBetweenCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        ConditionUtil.checkoutConditionParameter(customizeCondition.getCondition(),customizeCondition.getValue(),customizeCondition.getSecondValue(),customizeCondition.getCondition());
        return (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " not between '" + customizeCondition.getValue() +"' and '" + customizeCondition.getSecondValue()+"'";
    }
}

/**
 * @author:zyp
 * @description 排序条件
 * @date: 2020/3/20 11:52
 * @return
 */
class OrderByCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        return " order by " + (StringUtils.isBlank(customizeCondition.getTableName())?"":customizeCondition.getTableName()+".")+customizeCondition.getCondition() + " " + customizeCondition.getValue();
    }
}


/**
 * @author:zyp
 * @description limit分页条件
 * @date: 2020/3/20 11:52
 * @return
 */
class LimitCondition implements ConditionExample {

    @Override
    public String handleSql(CustomizeCondition customizeCondition) {
        return " limit " + customizeCondition.getValue()+","+customizeCondition.getSecondValue();
    }
}

条件工具类

public class ConditionUtil {

    public final static Map<String,Object> STRATEGYMAP = new HashMap();

    static {
        STRATEGYMAP.put("IsNull",new IsNullCondition());
        STRATEGYMAP.put("IsNotNull",new IsNotNullCondition());
        STRATEGYMAP.put("EqualTo",new EqualToCondition());
        STRATEGYMAP.put("NotEqualTo",new NotEqualToCondition());
        STRATEGYMAP.put("GreaterThan",new GreaterThanCondition());
        STRATEGYMAP.put("GreaterThanOrEqualTo",new GreaterThanOrEqualToCondition());
        STRATEGYMAP.put("LessThan",new LessThanCondition());
        STRATEGYMAP.put("LessThanOrEqualTo",new LessThanOrEqualToCondition());
        STRATEGYMAP.put("In",new InCondition());
        STRATEGYMAP.put("NotIn",new NotInCondition());
        STRATEGYMAP.put("Between",new BetweenCondition());
        STRATEGYMAP.put("NotBetween",new NotBetweenCondition());
        STRATEGYMAP.put("Like",new LikeCondition());
        STRATEGYMAP.put("NotLike",new NotLikeCondition());
        STRATEGYMAP.put("OrderBy",new OrderByCondition());
        STRATEGYMAP.put("Limit",new LimitCondition());
    }

    /**
     * @author:zyp
     * @description 检验字段是否有值
     * @date: 2020/3/20 14:09
     * @return 
     */
    public static void checkoutConditionParameter(String condition){
        if (condition == null) {
            throw new RuntimeException("Value for condition cannot be null");
        }
    }
    /**
     * @author:zyp
     * @description 检验字段是否有值
     * @date: 2020/3/20 14:09
     * @return
     */
    public static void checkoutConditionParameter(String condition, Object value, String property){
        if (value == null) {
            throw new RuntimeException("Value for " + property + " cannot be null");
        }
    }
    /**
     * @author:zyp
     * @description 检验字段是否有值
     * @date: 2020/3/20 14:09
     * @return
     */
    public static void checkoutConditionParameter(String condition, Object value1, Object value2, String property){
        if (value1 == null || value2 == null) {
            throw new RuntimeException("Between values for " + property + " cannot be null");
        }
    }
}

查询表数据（已知表、未知表皆可以）已转义

	/**
     * @author:zyp
     * @description 查询表数据（查询自定义的表）
     * @date: 2020/4/2 17:17
     * @return
     */
    @Override
    public List<Map<String, Object>> selectTable(CustomizeDbExamle customizeDbExamle) {
    	//查询是否存在该表
        int i = clusterTableMapperVo.existTable(customizeDbExamle.getTableName());
        if(i==0){
            return null;
        }
        List<TbTableColDefine> tbTableColDefines = getTbTableColDefines(customizeDbExamle.getTableName());
        List<List<String>> selectList = getTableColRelate(tbTableColDefines);
        String sql = compileSelectSQL(selectList, customizeDbExamle.getTableName(),customizeDbExamle);
        List<Map<String,Object>> stringObjectMap = clusterTableMapperVo.selectWriteSQL(sql);
        return stringObjectMap;
    }

查询表数据通过表id（已转义）

	/**
     * @author:zyp
     * @description 查询表数据通过表id（已转义）
     * @date: 2020/4/24 13:53
     * @return
     */
    @Override
    public List<Map<String, Object>> selectTableDataById(CustomizeDbExamle customizeDbExamle) {
        //当前文件名为table的id 根据tableId查找该表名
        String tableName = customizeDbExamle.getTableName();
        TbTableDefine tbTableDefine = clusterTbTableDefineMapper.selectByPrimaryKey(Integer.valueOf(tableName));
        int i = clusterTableMapperVo.existTable(tbTableDefine.getTableNm());
        if(i==0){
            return null;
        }
        customizeDbExamle.setTableName(tbTableDefine.getTableNm());
        List<TbTableColDefine> tbTableColDefines = getTbTableColDefines(customizeDbExamle.getTableName());
        List<List<String>> selectList = getTableColRelate(tbTableColDefines);
        CustomizeConditionArr conditionParameters = customizeDbExamle.getConditionParameters();
        //将参数里的条件tableName全部转化为表名
        conditionParameters.getCustomizeConditions().forEach(conditionParameter->{
            conditionParameter.setTableName(tbTableDefine.getTableNm());
        });
        String sql = compileSelectSQL(selectList, customizeDbExamle.getTableName(),customizeDbExamle);
        List<Map<String,Object>> stringObjectMap = clusterTableMapperVo.selectWriteSQL(sql);
        return stringObjectMap;
    }

查询表数据（查询自定义的表）未转义

	/**
     * @author:zyp
     * @description 查询表数据（查询自定义的表）未转义
     * @date: 2020/4/3 11:39
     * @return
     */
    @Override
    public List<Map<String, Object>> selectTableDataNoTransferred(CustomizeDbExamle customizeDbExamle) {
        int i = clusterTableMapperVo.existTable(customizeDbExamle.getTableName());
        if(i==0){
            return new ArrayList<Map<String,Object>>();
        }
        String sql = compileSelectSQL(null, customizeDbExamle.getTableName(),customizeDbExamle);
        List<Map<String,Object>> stringObjectMap = clusterTableMapperVo.selectWriteSQL(sql);
        return stringObjectMap;
    }

查询表数据数量（查询自定义的表）

	/**
     * @author:zyp
     * @description 查询表数据数量（查询自定义的表）
     * @date: 2020/4/2 17:58
     * @return
     */
    @Override
    public Integer selectTableDataCount(CustomizeDbExamle customizeDbExamle) {
        int i = clusterTableMapperVo.existTable(customizeDbExamle.getTableName());
        if(i==0){
            return null;
        }
        List<TbTableColDefine> tbTableColDefines = getTbTableColDefines(customizeDbExamle.getTableName());
        List<List<String>> selectList = getTableColRelate(tbTableColDefines);
        String countSql = "SELECT COUNT(1) FROM (";
        String sql = compileSelectSQL(selectList, customizeDbExamle.getTableName(),customizeDbExamle);
        countSql = countSql + sql + ") temp";
        int countWriteSQL = clusterTableMapperVo.selectCountWriteSQL(countSql);
        return countWriteSQL;
    }

插入表数据

/**
     * @author:zyp
     * @description 插入表数据
     * @date: 2020/4/3 8:57
     * @return
     */
    @Override
    public Integer insertTableData(CustomizeDbExamle customizeDbExamle) {
        int i = clusterTableMapperVo.existTable(customizeDbExamle.getTableName());
        if(i==0){
            return null;
        }
        Map<String, Object> insertParameter = customizeDbExamle.getInsertParameter();
        StringBuffer insertField = new StringBuffer();
        StringBuffer insertValue = new StringBuffer();
        StringBuffer sqlBuffer = new StringBuffer();
        sqlBuffer.append("insert into " + customizeDbExamle.getTableName() + "(");
        for(Map.Entry<String, Object> entry : insertParameter.entrySet() ){
            String key = entry.getKey();
            Object value = entry.getValue();
            insertField.append(key + ",");
            if(value==null||StringUtils.isBlank(value.toString())){
                insertValue.append(" null ,");
            }else{
                insertValue.append("'"+value.toString() + "',");
            }
        }
        insertField.deleteCharAt(insertField.length()-1);
        insertValue.deleteCharAt(insertValue.length()-1);
        sqlBuffer.append(insertField + ") values (");
        sqlBuffer.append(insertValue + ");select last_insert_id();");
        int id = masterTableMapperVo.insertWriteSQL(sqlBuffer.toString());
        System.out.println("插入表数据id...."+id);
        return id;
    }

更新表数据

/**
     * @author:zyp
     * @description 更新表数据
     * @date: 2020/4/3 9:12
     * @return
     */
    @Override
    public Integer updateTableData(CustomizeDbExamle customizeDbExamle) {
        int i = clusterTableMapperVo.existTable(customizeDbExamle.getTableName());
        if(i==0){
            return null;
        }
        Map<String, Object> updateParameter = customizeDbExamle.getUpdateParameter();
        StringBuffer updateBuffer = new StringBuffer();
        StringBuffer sqlBuffer = new StringBuffer();
        sqlBuffer.append("update " + customizeDbExamle.getTableName()+" as "+customizeDbExamle.getTableName() + " set ");
        for(Map.Entry<String, Object> entry : updateParameter.entrySet() ){
            String key = entry.getKey();
            Object value = entry.getValue();
            if(value==null||StringUtils.isBlank(value.toString())){
                updateBuffer.append(key + "= null ,");
            }else{
                updateBuffer.append(key + "='" + value +"',");
            }
        }
        updateBuffer.deleteCharAt(updateBuffer.length()-1);
        sqlBuffer.append(updateBuffer);
        //条件编写
        String conditionString = conditionSql(customizeDbExamle);
        sqlBuffer.append(conditionString);
        int count = masterTableMapperVo.updateWriteSQL(sqlBuffer.toString());
        System.out.println("更新表数据个数...."+count);
        return count;
    }

删除表数据

/**
     * @author:zyp
     * @description 删除表数据
     * @date: 2020/4/3 9:28
     * @return
     */
    @Override
    public Integer deleteTableData(CustomizeDbExamle customizeDbExamle ) {
        int i = clusterTableMapperVo.existTable(customizeDbExamle .getTableName());
        if(i==0){
            return null;
        }
        //条件编写
        String conditionString = conditionSql(customizeDbExamle);
        //再删除之前先把其查出
        StringBuffer selectBuf = new StringBuffer();
        selectBuf.append("select * from " + customizeDbExamle.getTableName() + " ");
        selectBuf.append(conditionString);
        List<Map<String,Object>> stringObjectMap = clusterTableMapperVo.selectWriteSQL(selectBuf.toString());
        StringBuffer sqlBuffer = new StringBuffer();
        sqlBuffer.append("delete from " + customizeDbExamle.getTableName());
        sqlBuffer.append(conditionString);
        System.out.println(sqlBuffer.toString());
        int count = masterTableMapperVo.deleteWriteSQL(sqlBuffer.toString());
        System.out.println("删除个数......."+count);
        return count;
    }
顽固的bug
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
自定义数据表格的列
等什么丫的博客
06-27 459
开发工具与关键技术：VS , ASP.NET.MVC; 作者：吴维杰 撰写时间：2019.06.26 自定义数据表格的列是在使用插件初始化数据表格中,由于布尔类型的数据直接显示出来而显得比较不符合美观. 而自定义数据表格列可以改变数据在数据表格里的显示. 首先把 { field: " StopOpen ", title: "停开", align: "center" }, 改为...
自定义数据表格&跳转页面
weixin_44538411的博客
07-27 290
开发工具与关键技术：VS软件，自定义数据表格&跳转页面 作者：陈隆 撰写时间：2019年07月27日 说到数据表格就一定回想到是用什么插件生成的数据表格，现在的时代都是为了追求打代码的速度，所以就出现了许许多多的插件，这些插件就是为了让程序员更好的更快的开发项目，任何的插件存在都是为了给程序员的使用的，我现在正在做的数据表格也是使用一种插件来实现的，插件的用处是非常的大的，可以使用插件来...
【SWT】自定义数据表格
最新发布
小子宝丁的博客
07-18 591
本文使用 SWT 中的 `ScrolledComposite` 、 `GridLayout` 和 SWT 事件实现了一个简单的数据表格实现，表格功能相对比较简单，但有足够的启发性，读者可据此实现更复杂的表格。
数据分析---excel自定义操作
weixin_30621711的博客
11-26 80
自定义排序： 操作：文件--选项--高级--常规---编辑自定义列表 单击确定按钮，回到excel首页 选定要排序的单元格，后期会报错 点击数据--排序 其中，主要关键字是栏目，选择自定义序列，如下图所示： 完成时出现了错误 点击你要运用的某个单元格，再从数据--排序开始 方法二：（暂时有点问题） 单击某一列，自定义排序，点击导入 转载于:https://w...
创建自定义数据表（再示例）
浤济的专栏
09-25 1247
原博客已经有例子，这里再示例，并采用强类型读取数据表列资料。 http://msdn.microsoft.com/zh-cn/library/vstudio/360dye2a.aspx XML创建保存读取 读取条件设定.WriteXml("XmlDocument.xml");/*保存*/ 读取条件设定.Dispose(); DataSet newD
Thinkphp3.2.3自定义添加数据表及表中字段
09-13
在ThinkPHP3.2.3中，自定义添加数据表是通过模型(Model)类和数据库操作类(DB)来实现的。首先，你需要创建一个新的模型类，这个类将代表你要创建的数据表。模型类通常继承自ThinkPHP的基础模型类，例如`Think\Model`...
易语言内存自定义数据类型
07-21
结合提供的压缩包文件"易语言内存自定义数据类型源码"，我们可以期待学习到如何在易语言中定义、创建、使用和管理内存自定义数据类型，以及如何利用上述Windows API函数进行跨进程操作。这些源码可能会展示如何封装...
易语言自定义数据类型变量保存
07-22
在易语言中，自定义数据类型是实现复杂数据结构和逻辑的关键部分。自定义数据类型允许用户根据需求定义自己的数据结构，比如组合多个基本数据类型，形成新的复合类型。 本案例"易语言自定义数据类型变量保存"主要...
java Base64自定义码表
12-03
2. 替换编码算法：在编码过程中，原本将6位二进制数映射到标准编码表的操作需要替换为你自定义的编码表。这意味着在编码时，你需要用自定义的字符替换原有的`Base64.encodeInt()`方法。 3. 替换解码算法：解码时，...
Oracle将查询的结果放入一张自定义表中并再查询数据
09-10
这里，`AA`就是我们自定义的临时表，它由两部分构成：第一部分是选取`REPORT_PERFORMANCEOFANALYZER`表中`DTANALYZED`为空的记录，第二部分是通过`UNION ALL`操作合并`REPORT_PERFORMANCEOFANALYZER`表自身的所有...
连接各种数据库自定义报表
03-12
可以连接各种数据库如SQL SERVER ,Oracle,MySql,Access 可以自定义开发各式报表 1. 可以让公司內部MIS人员按各部门需求,快速开发客制查询程式/报表,大量节省开发及维护成本. 2. 所开发客制查询程式/报表具备云端计算功能,可于互联网上执行,并可提升原系统的查询/报表扩充能力. 3. 报表自定义:可于Excel模式操作下自行设置报表范本,产生Excel报表及Excel档案,方便快速 4. 透过ODBC可掛接多种资料库. 5. 可于网上下载标准BI程式码,易于学习扩充 . 6. 內含BI程式及报表开发功能(MIS人员可自行开发)
如何自定义数据表及字段对应关系
summer_grass的专栏
06-13 1209
有时我们会希望在将数据置入DataSet对象后，数据表的名称或字段的名称与数据源不同，假设我们希望其对应关系如下： 数据源 置入DataSet对象后
mysql用户自定义表类型_mssql2008 自定义表类型实现(批量插入或者修改)
weixin_30438795的博客
01-19 121
在做大型网站或者系统的时候，经常会遇到个问题就是批量插入或者修改数据库。如果遇到这个问题，还是一条条记录来处理，这样的效率太低了，所以要考虑批量插入或者修改今天这边不讲SqlBulkCopy，只简单讲sql自定义表类型。因为目前的项目我用到了分表的方式，用存储过程比较方便自动创建分表。现在把我目前写的功能简单做个记录，也方便以后自己查阅第一步，在数据库里点击 新建查询 创建相应的sql复制代码 代...
更新自定义表时的通用锁对象
少年休闲海
06-18 1634
更新自定义表时，可以使用通用的锁对象，而不用再为每一个自定义表创建锁对象（尽管SAP支持这种做法），当然解锁也有通用的解锁对象。代码如下：   * 给自定义表 ZCOL2001 加锁对象 CALL FUNCTION 'ENQUEUE_E_TABLE'   EXPORTING     mode_rstable= 'E'     tabname ='ZCOL2001'     x_ta
SQLServer添加UPDATE回滚日志(update/delete/insert)
Wikey_Zhang的博客
06-30 6928
上一篇文章我讲解了delete操作的回滚日志建立的方法，基于上一篇文章的基础，经过修改和增加，实现update操作的回滚日志的建立。首先要注意的是：这里的update并不只是表的update操作，它包含delete和insert操作，完全涵盖上一篇文章的内容。那上一篇文章岂不就多此一举，废话一堆啦？NO~NO~NO~前一篇文章是个启发，简单易懂。行了，废话就讲到这里了！ 下面直接上代码（copy
第 3 章 自定义数据库表结构
weixin_34245749的博客
06-17 197
第3章自定义数据库表结构 Spring Security默认提供的表结构太过简单了，其实就算默认提供的表结构很复杂，也无法满足所有企业内部对用户信息和权限信息管理的要求。基本上每个企业内部都有一套自己的用户信息管理结构，同时也会有一套对应的权限信息体系，如何让Spring Security在这些已有的数据结构之上运行呢？ 3.1.自定义...
关于SQL Server中修改“用户自定义表类型”的问题
xrr1227的博客
09-08 9136
本文出处：http://www.cnblogs.com/wy123/p/7282682.html  （保留出处并非什么原创作品权利，本人拙作还远远达不到，仅仅是为了链接到原文，因为后续对可能存在的一些错误进行修正或补充，无他）   SQL Server开发过程中，为了传入数据集类型的变量（比如接受C#中的DataTable类型变量），需要定义“用户自定义表类型”，通过“用户自定义表类
mysql面试必会基础（四）
一对儿程序猿
04-10 1万+
1.视图 1.       视图的定义 视图就是从一个或多个表中，导出来的表，是一个虚拟存在的表。视图就像一个窗口（数据展示的窗口），通过这个窗口，可以看到系统专门提供的数据（也可以查看到数据表的全部数据），使用视图就可以不用看到数据表中的所有数据，而是只想得到所需的数据。 在数据库中，只存放了视图的定义，并没有存放视图的数据，数据还是存储在原来的表里，视图的数据是依赖原
element table组件使用过程的一些问题记录（刷新，排序，扩展）
热门推荐
april_4的博客
05-14 1万+
UI给出的设计图是这样的1 扩展要求点击运单号，显示更多内容，element里面给出的例子是有扩展符号的一列，点击来展示这里我想了下，把这一列隐藏起来了然后点击的时候用rowClick 这个事件来进行展开，这里也借鉴了下网上搜来的思路vue代码见下generateUUID() { //生成唯一编码 var d = new Date().getTime(); var uuid = '...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值