package hello;

import java.sql.ResultSet;

/**
 * Class that selects from the database
 * @author Zach Panzarino
 * @version 1.0.0
 */
public class Selector extends Worker {
    /**
     * Creates a new Selector with a database connection
     * @param url The database URL
     * @param username The database username
     * @param password The database password
     */
    public Selector(String url, String username, String password){
        super(url, username, password);
    }
    /**
     * Select from database
     * @param select What to be selected
     * @param from What table to use
     * @return Results of executed query
     */
    public ResultSet select(String select, String from){
        String query = "SELECT `"+select+"` FROM  `"+from+"`";
        return execute(query);
    }
    /**
     * Select from database
     * @param select What to be selected
     * @param from What table to use
     * @param where Condition for selection
     * @return Results of executed query
     */
    public ResultSet select(String select, String from, String where){
        String query = "SELECT `"+select+"` FROM  `"+from+"` WHERE "+where;
        return execute(query);
    }
    /**
     * Select from database
     * @param select What to be selected
     * @param from What table to use
     * @param where Condition for selection
     * @param limit Limit for selection
     * @return Results of executed query
     */
    public ResultSet select(String select, String from, String where, String limit){
        String query = "SELECT `"+select+"` FROM  `"+from+"` WHERE "+where+" LIMIT "+limit;
        return execute(query);
    }
}
@@ -722,33 +722,32 @@
 query = %22SELECT 
-%60
 %22+select+%22%60 FROM
@@ -732,33 +732,32 @@
 ELECT %22+select+%22
-%60
  FROM  %60%22+from+%22
@@ -1098,33 +1098,32 @@
 query = %22SELECT 
-%60
 %22+select+%22%60 FROM
@@ -1108,33 +1108,32 @@
 ELECT %22+select+%22
-%60
  FROM  %60%22+from+%22
@@ -1549,17 +1549,16 @@
 %22SELECT 
-%60
 %22+select
@@ -1559,17 +1559,16 @@
 select+%22
-%60
  FROM  %60

Fix select error