Method getMention

src/main/java/utils/DBHelper.java:29–46

(String mentionId)

    }

    public static String getMention(String mentionId) {
        StringBuilder mention = new StringBuilder();
        try {
            connection = DriverManager.getConnection(DATABASE);
            PreparedStatement ps = connection.prepareStatement("SELECT mention_id FROM tweet_records WHERE mention_id = ?");

            ps.setString(1, mentionId);

            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                mention.append(rs.getString("mention_id"));
            }
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return mention.toString();
    }

}