/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

5 votes116 views3 answers
Typescript check type of variable
TypeScript
0 vote126 views1 answer
Run an applescript
TypeScript
1 vote101 views1 answer
Handling ajax requests in django
TypeScript
0 vote105 views1 answer
Combine 2 lists to dataframe python
TypeScript
0 vote99 views1 answer
Ts enum string' can't be used to index type
TypeScript
0 vote98 views1 answer
How can I create an array with a range of decimal increments in SwiftUI ?
TypeScript
0 vote100 views1 answer
Yarn run commands in parallel
TypeScript
0 vote108 views1 answer
R merge lists with common elements
TypeScript
0 vote97 views1 answer
Python create dir when not exsit
TypeScript
47 votes137 views6 answers
Angular date pipe
TypeScript