/TypeScript/If exists certain line in sql table java condition

If exists certain line in sql table java condition

public void ftpTableCheck(String host, String port, String username, String password) {
    try {
        String query = "SELECT (count(*) > 0) as found FROM ftp WHERE Host LIKE ? AND Username LIKE ?";
        PreparedStatement pst = conn.prepareStatement(query);
        pst.setString(1, host);
        pst.setString(2, username);

        try (ResultSet rs = pst.executeQuery()) {
            // Only expecting a single result
            if (rs.next()) {
                boolean found = rs.getBoolean(1); // "found" column
                if (found) {
                    // You have rows
                } else {
                    // You have no rows
                }
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Source: stackoverflow.com

Similar codes

0 vote201 views2 answers
_swapbatch.foreach multiple statements c#
TypeScript
1 vote200 views1 answer
Whats harry potter's house
TypeScript
0 vote202 views1 answer
Apply function to all elements with a class name
TypeScript
1 vote191 views1 answer
React protected routes typescript
TypeScript
8 votes200 views1 answer
Python find the number of elements in a list
TypeScript
8 votes209 views2 answers
Install material icons for react
TypeScript
-1 vote179 views1 answer
What was in Rome that helped Renaissance artists achieve their goal of Humanism?
TypeScript
2 votes173 views1 answer
Validation maxlength angular
TypeScript
1 vote183 views1 answer
Nodejs exec exit code
TypeScript
0 vote186 views1 answer
Benefits of ginger juice
TypeScript