/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

7 votes306 views1 answer
Error: "prettier/@typescript-eslint" has been merged into "prettier" in eslint-config-prettier 8.0.0
TypeScript
0 vote331 views1 answer
How to remove second square brackets in an array
TypeScript
0 vote331 views3 answers
How to compare two lists element by element in python and return matched element
TypeScript
0 vote291 views1 answer
Nativescript display image from web
TypeScript
1 vote311 views3 answers
Roperty 'form' has no initializer and is not definitely assigned in the constructor.
TypeScript
0 vote333 views2 answers
Parameter 'event' implicitly has an 'any' type.ts(7006)
TypeScript
0 vote292 views1 answer
Running same tests against different data
TypeScript
0 vote286 views1 answer
Copying the contents of a file to another in terminal
TypeScript
5 votes307 views1 answer
Fontawesome , font
TypeScript
0 vote345 views1 answer
Laravel validation exists multiple tables laravel
TypeScript