/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 vote210 views2 answers
Window.print div
TypeScript
0 vote192 views1 answer
Elements without corner css
TypeScript
1 vote169 views1 answer
What is test management review
TypeScript
5 votes198 views4 answers
Element implicitly has an 'any' type because expression of type 'string' can't be used to index type
TypeScript
1 vote237 views1 answer
Eslint missing file extension ts
TypeScript
2 votes208 views1 answer
Serenity-is hide column
TypeScript
1 vote194 views1 answer
Jasmine angular contains expression
TypeScript
17 votes192 views3 answers
Router params angular
TypeScript
1 vote190 views1 answer
Typescript filter list by property
TypeScript
0 vote199 views1 answer
Error: running homebrew as root is extremely dangerous and no longer supported. as homebrew does not drop privileges on installation you would be giving all build scripts full access to your system.
TypeScript