/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 vote163 views1 answer
Try out the enumerate function for yourself in this quick exercise. Complete the skip_elements function to return every other element from the list, this time using the enumerate function to check if an element is on an even position or an odd positi
TypeScript
0 vote104 views1 answer
3 parts of apptitude
TypeScript
0 vote105 views1 answer
Yarn run commands in parallel
TypeScript
0 vote105 views1 answer
Mysqli_real_escape_string() expects parameter 1 to be mysqli
TypeScript
0 vote108 views2 answers
Li elements horizontally css
TypeScript
0 vote101 views1 answer
Embed python in html
TypeScript
0 vote107 views1 answer
Can ts object be strongly typed?
TypeScript
-1 vote119 views2 answers
Javascript:
TypeScript
0 vote110 views3 answers
Check table exists in db laravel
TypeScript
0 vote131 views1 answer
Typescript assert non null
TypeScript