/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 vote229 views1 answer
Can blue jays tickets still be printed
TypeScript
0 vote245 views1 answer
Java lambda list of objects cast
TypeScript
2 votes256 views2 answers
Cannot use JSX unless the '--jsx' flag is provided.ts(17004)
TypeScript
0 vote235 views1 answer
Pipe angular typescript
TypeScript
1 vote243 views1 answer
Cannot read property 'slideTo' of undefined TypeError: Cannot read property 'slideTo' of undefined
TypeScript
0 vote238 views1 answer
Ionic iosa app not making requests to server
TypeScript
0 vote277 views1 answer
Conventional commits cheat sheet
TypeScript
0 vote262 views1 answer
In order to allow non-dict objects to be serialized set the safe parameter to False.
TypeScript
1 vote239 views1 answer
Font type css system
TypeScript
0 vote247 views1 answer
Requests session next page python
TypeScript