/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 vote190 views1 answer
Two plots side by side r
TypeScript
0 vote217 views1 answer
Angular output send click event to parent
TypeScript
1 vote151 views1 answer
For in typescript
TypeScript
0 vote202 views1 answer
How to define functional component types
TypeScript
6 votes196 views1 answer
Typescript map list to new list of objects
TypeScript
0 vote205 views1 answer
Get products in wordpress
TypeScript
1 vote192 views1 answer
Typescript variable
TypeScript
2 votes191 views1 answer
Convert local url to base64 in javascript
TypeScript
7 votes270 views3 answers
Module was compiled with an incompatible version of kotlin. the binary version of its metadata is 1.5.1, expected version is 1.1.16.
TypeScript
0 vote220 views1 answer
ValueError: Cannot run multiple SparkContexts at once;
TypeScript