/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

2 votes289 views1 answer
Validation maxlength angular
TypeScript
0 vote312 views1 answer
R merge list
TypeScript
0 vote304 views1 answer
Inno add exe in service
TypeScript
1 vote318 views1 answer
Using log how can we find number of digits for a number in java
TypeScript
0 vote299 views1 answer
Let say your Project Manager tell you that your database requests are consume a lot of memory, you need to do something to improve the performance. How would you do it in hibernate ?
TypeScript
10 votes348 views2 answers
Add class to all child elements jquery
TypeScript
4 votes379 views2 answers
Initialize empty array typescript
TypeScript
0 vote657 views2 answers
Multiple hosts in same role
TypeScript
2 votes325 views1 answer
Adding headers to httpclient angular
TypeScript
0 vote341 views1 answer
Clean broken shortcuts in windows start menu
TypeScript