/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 vote170 views1 answer
Smooth scroll in viewportscroller
TypeScript
2 votes181 views1 answer
How to write a class with inputs in python
TypeScript
2 votes161 views1 answer
Subtracting two date objects in javacript
TypeScript
0 vote185 views1 answer
Whats a typedef in c++
TypeScript
0 vote187 views1 answer
Error Extracting tar content of undefined failed, the file appears to be corrupt: "EBUSY: resource busy or locked,
TypeScript
0 vote254 views1 answer
How to register a static assets folder spring boot
TypeScript
0 vote150 views1 answer
Typescript "variable?: type" notation
TypeScript
0 vote183 views1 answer
Mongodb move documents to another collection
TypeScript
0 vote170 views1 answer
Array of linked lists in cpp
TypeScript
3 votes162 views3 answers
Import images angular
TypeScript