package advancedsql.query;

import advancedsql.ISQL;

import advancedsql.table.ITable;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

public abstract class Query<T extends IQuery> implements IQuery {

protected ISQL sql = null;

protected String table = null;

protected List<Object> execute = new ArrayList<>();

protected PreparedStatement prepare = null;

protected String where = null;

protected int limit = 0;

private T instance;

public Query(ITable table) {

this.sql = table.getSQL();

this.table = table.getName();

}

public Boolean executeStatement() throws SQLException {

prepare = this.sql.prepare(this);

ISQL.setStatementParameters(this.prepare, this.execute);

return prepare.execute();

}

public ResultSet executeQuery() throws SQLException {

prepare = this.sql.prepare(this);

ISQL.setStatementParameters(this.prepare, this.execute);

return prepare.executeQuery();

}

public int executeUpdate() throws SQLException {

prepare = this.sql.prepare(this);

ISQL.setStatementParameters(this.prepare, this.execute);

return prepare.executeUpdate();

}

public abstract String toQuery();

public PreparedStatement getPrepare() {

return prepare;

}

@Override

public String toString() {

return this.toQuery();

}

}