All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.smallaswater.easysql.mysql.data.SqlDataList Maven / Gradle / Ivy

Go to download

EasyMySQL -- MySQL tool for Nukkit

There is a newer version: 3.0.7
Show newest version
package com.smallaswater.easysql.mysql.data;

import com.smallaswater.easysql.mysql.utils.ChunkSqlType;

import java.util.LinkedList;

/**
 * @author SmallasWater
 */
public class SqlDataList extends LinkedList {

    private final String sql;

    private final ChunkSqlType[] types;


    public SqlDataList(String sql, ChunkSqlType... types) {
        this.types = types;
        this.sql = sql;
    }

    /**
     * 获取同一字段全部数据
     */
    public LinkedList getValueList(String column) {
        LinkedList objects = new LinkedList<>();
        for (SqlData data : this) {
            objects.add(data.get(column.toLowerCase(), null));
        }
        return objects;
    }


    public SqlData get() {
        if (size() == 0) {
            return new SqlData("", "");
        }
        return getFirst();
    }


    public String getSql() {
        return replace(sql, types);
    }

    private String replace(String s, ChunkSqlType... args) {
        char[] list = s.toCharArray();
        int size = 0;
        StringBuilder stringBuffer = new StringBuilder();
        for (char c : list) {
            if (String.valueOf(c).contains("?")) {
                stringBuffer.append(args[size].getValue());
                ++size;
            } else {
                stringBuffer.append(c);
            }
        }

        return stringBuffer.toString();
    }

}
    

    

    

                
 
            

    

                
 
            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy