public List <PairData> findTextScoreGreaterThen(double score)
{
SQLQueryExecutor executor = new SQLQueryExecutor();
SQLCommand command = new SQLCommand();
command.query = "SELECT * FROM TEXTS WHERE {SCORE > @score}";
command.parameters.Add("@score", score.ToString());
List <PairData> datas = executor.executeQuery(command);
return(datas);
}
public List <PairData> findTextWithWordContainsAndScoreLessEquals(string name, double score)
{
SQLQueryExecutor executor = new SQLQueryExecutor();
SQLCommand command = new SQLCommand();
command.query = "SELECT * FROM TEXTS WHERE CONTENT LIKE @content AND {SCORE <= @score}";
command.parameters.Add("@content", "%" + name + "%");
command.parameters.Add("@score", score.ToString());
List <PairData> datas = executor.executeQuery(command);
return(datas);
}
public List <PairData> findTextWithNameContainsAndScoreGreaterEquals(string name, double score)
{
SQLQueryExecutor executor = new SQLQueryExecutor();
SQLCommand command = new SQLCommand();
command.query = "SELECT * FROM TEXTS WHERE TITLE LIKE @title AND {SCORE >= @anotherscore}";
command.parameters.Add("@title", "%" + name + "%");
command.parameters.Add("@anotherscore", score.ToString());
List <PairData> datas = executor.executeQuery(command);
return(datas);
}
