java - 从特定 sql 语句获取 true(1) 或 false(0)

Question

我需要有关以下代码的帮助并使其返回 true 或 false 值。任何和所有帮助将不胜感激。

    public synchronized static boolean checkCompanyName(String companyName,
        Statement statement) {
    try {

        ResultSet res = statement
                .executeQuery("SELECT `companyName` FROM `companys` WHERE companyName = '"
                        + companyName + "';");
        boolean containsCompany = res.next();

        res.close();

        return containsCompany;

    } catch (Exception e) {
        e.printStackTrace();
        return false;
    }

}

Answer 1

尝试像这样进行查询:

ResultSet res = statement.executeQuery("SELECT companyName FROM companys WHERE companyName = " + companyName);

或者你可以使用PreparedStatement，这比你之前做的更好