/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 vote118 views1 answer
How to join all url segments to make a url in javascipt 30seconds of code
TypeScript
21 votes130 views6 answers
How to concatenate two lists in python
TypeScript
0 vote125 views1 answer
How to display an image in flutter using its filepath
TypeScript
0 vote137 views2 answers
Setstate do not update emidiatly
TypeScript
0 vote120 views1 answer
Mat card api
TypeScript
18 votes118 views1 answer
Lts stands for
TypeScript
1 vote91 views1 answer
Jquery selector id starts with and ends with
TypeScript
2 votes120 views1 answer
Check subnets docker
TypeScript
0 vote150 views1 answer
How to label points in scatter plot in python
TypeScript
0 vote139 views1 answer
How were sonnets used in rennaisance litireture
TypeScript