import java.sql.BaseQuery;

import java.sql.DataSet;

import java.sql.Select;

public interface UserQueries extends BaseQuery {

    // Select all users

    @Select (sql ="SELECT userId, firstName, lastName FROM Users",

             readOnly=false, connected=false, tableName="Users")

    DataSet getAllUsers ();

    // Select user by name */

    @Select (sql ="SELECT userId, firstName, lastName FROM Users"

             + "WHERE userName=?", readOnly=false, connected=false,

             tableName ="Users")

    DataSet getUserByName(String userName);

}