package bridge;
 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
 
public class SQLCommand extends CommandImpl {
	Statement  stmt;
	String query;
 
	public SQLCommand(Statement stmt, String query) {
		super();
		this.stmt = stmt;
		this.query = query;
	}
 
	@Override
	public boolean Exec() {
		super.Exec();
		try {
			stmt.execute(query);
			stmt.close();
		} catch (SQLException e) {
			errMess = e.getMessage();
			return false;
		}
		return true;
	}
 
	@Override
	public List GetGeneratedKeys() {
		List<Integer> res;
		try {
			ResultSet keys = stmt.getGeneratedKeys();
			res = new ArrayList<Integer>();
			while (keys.next()) {
				res.add(keys.getInt(1));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}
 
}