/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 votes320 views2 answers
Github:Module was compiled with an incompatible version of Kotlin. The binary version of its metadata is 1.5.1, expected version is 1.1.15 in android
TypeScript
0 vote262 views1 answer
Json2typescript ionic 5
TypeScript
19 votes273 views3 answers
Material ui svg icons
TypeScript
0 vote257 views1 answer
Compare two lists and remove duplicates java
TypeScript
1 vote286 views1 answer
Your image should have a src attribute that points to the kitten image. Your image element's alt attribute should not be empty.
TypeScript
2 votes263 views2 answers
Search an array of objects with specific object property value
TypeScript
0 vote255 views1 answer
Let variable name : any = () => { return new typescript fie}
TypeScript
0 vote297 views2 answers
Ng idle issue ERROR in node_modules/@ng-idle/core/lib/eventtargetinterruptsource.d.ts(29,9): error TS1086: An accessor cannot be declared in an ambient context.
TypeScript
0 vote294 views1 answer
Cats internet cafe 18 hr
TypeScript
3 votes314 views1 answer
Npm uninstall all
TypeScript