/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

1 vote223 views2 answers
Subplots in seaborn python
TypeScript
0 vote237 views1 answer
Products = product.object.all() python
TypeScript
0 vote226 views1 answer
Pptxgenjs table
TypeScript
0 vote227 views1 answer
Python create dir when not exsit
TypeScript
0 vote217 views1 answer
Curl -s "http://google.com?[1-1000]"
TypeScript
2 votes298 views1 answer
'mat-checkbox' is not a known element
TypeScript
0 vote266 views1 answer
How to delete a struct in a arra of strcts c
TypeScript
1 vote215 views1 answer
Typescript add property if not exist, merge if it exists
TypeScript
8 votes232 views2 answers
Remove duplicates objects from array angular
TypeScript
1 vote218 views1 answer
Typescript space between capital letters
TypeScript