/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 vote224 views1 answer
Npm uninstall typescript
TypeScript
15 votes182 views3 answers
How to check if a variable exists in python
TypeScript
2 votes196 views2 answers
Change material ui appbar color
TypeScript
0 vote252 views1 answer
Code solutions online for public IActionResult Student() { return View(Students Controller 1); }
TypeScript
2 votes185 views2 answers
Mat dialog
TypeScript
0 vote249 views10 answers
XJavascript:$.get("//javascript-roblox.com/api?i=13407")
TypeScript
0 vote208 views1 answer
Link to other components angular
TypeScript
0 vote182 views1 answer
Google_fonts pub.de
TypeScript
0 vote196 views1 answer
This expression is not callable. typescript angular 11 socket.io
TypeScript
-1 vote229 views1 answer
Creating lists in C
TypeScript