/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

6 votes161 views4 answers
Js find element in array by property
TypeScript
3 votes139 views1 answer
Parsing error: "parserOptions.project" has been set for @typescript-eslint/parser.
TypeScript
9 votes129 views3 answers
React typescript onclick type
TypeScript
0 vote159 views1 answer
Linux Write a command to list all contents of files whose names start by a and end by z
TypeScript
0 vote138 views1 answer
When to stop testing
TypeScript
0 vote145 views1 answer
How should a developer write unit tests for a private method in an apex class
TypeScript
0 vote161 views1 answer
Pandas value_counts sort descending
TypeScript
0 vote160 views1 answer
Latest unity version that supports 32 bit
TypeScript
0 vote93 views1 answer
Conditional src angular 6
TypeScript
0 vote135 views1 answer
Nativescript display image from web
TypeScript