/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 vote176 views1 answer
Promise.all does not wait
TypeScript
1 vote194 views2 answers
Passport serializeUser
TypeScript
1 vote301 views1 answer
Ts date get minutes
TypeScript
1 vote171 views1 answer
Why are my component bindings undefined in its controller?
TypeScript
0 vote169 views1 answer
Object is possibly
TypeScript
1 vote169 views3 answers
An attempt was made to access a socket in a way forbidden by its access permissions
TypeScript
0 vote164 views1 answer
Window global typescript
TypeScript
12 votes186 views3 answers
Python count number of digits in integer
TypeScript
0 vote165 views1 answer
How to check if object is undefined in typescript
TypeScript
0 vote174 views3 answers
Get weights of a layer keras
TypeScript