/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 vote263 views1 answer
Google fonts icons size classes
TypeScript
0 vote251 views1 answer
Admin_enqueue_scripts specific page
TypeScript
0 vote273 views1 answer
Tes ssh gitlab
TypeScript
0 vote281 views1 answer
First k digits of n*n
TypeScript
0 vote279 views1 answer
Run a python module with imports from parent
TypeScript
4 votes270 views2 answers
Push in typescript
TypeScript
0 vote254 views1 answer
Not able to use fonts awesome in react
TypeScript
1 vote295 views1 answer
E_MISSING_NAMED_MIDDLEWARE: Cannot find a middleware named "auth"
TypeScript
1 vote268 views1 answer
No provider for ChildrenOutletContexts Angular
TypeScript
5 votes295 views4 answers
Wget
TypeScript