/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 vote150 views2 answers
Enum next value angular
TypeScript
1 vote130 views1 answer
Typescript check if string is base64 or not path to src
TypeScript
0 vote134 views1 answer
Merge enum typescript
TypeScript
0 vote135 views1 answer
Fjnction by parts latex
TypeScript
5 votes92 views3 answers
: mysqli_fetch_array() expects parameter 1 to be mysqli_result, array given
TypeScript
17 votes126 views3 answers
Js null ==
TypeScript
1 vote132 views1 answer
Regex ts
TypeScript
1 vote167 views1 answer
Mongodb array size greater than
TypeScript
0 vote125 views1 answer
TypeError: autodiscover_tasks() takes at least 2 arguments (1 given) celery
TypeScript
4 votes137 views1 answer
Typescript string interpolation
TypeScript