String variable activity to set color as red to display on jtextarea

Asked May 09 '18 at 07:18

Active Jul 27 '18 at 10:59

Viewed 58 times

I want to display value from variable "activity" to red color, "activity" value I got form MySQL database. Is that possible to set color on String Activity? If it is possible can you show me how to make it?

public void Select()
{
    int n = 1;

    for (int i = 0; i < numberRow; i++) {
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/atm?zeroDateTimeBehavior=convertToNull", "root", "");
            String validate = "SELECT * FROM history WHERE UserActivityID LIKE '" + n +  "'";
            PreparedStatement smtm = con.prepareStatement(validate);
            ResultSet rs = smtm.executeQuery();
            if (rs.next()) {
                String Time = rs.getString("UserTimeActivity");
                String activity = rs.getString("UserActivity");
                n++;
                jTextAreaActivity.append(activity + " - " + Time + "\n");
            }
        } catch (SQLException | HeadlessException | ClassCastException  ex) {
            JOptionPane.showMessageDialog(this, ex);
        }
    }
}

edited Jul 27 '18 at 10:59

KikTurbo

asked May 09 '18 at 07:18

Ariff Naj

Possible duplicate of [How to change text color in the JtextArea?](https://stackoverflow.com/questions/9650992/how-to-change-text-color-in-the-jtextarea) – Michu93 May 09 '18 at 07:22
you use prepared statement and `'" + n + "'` ? – Youcef LAIDANI May 09 '18 at 07:29
oh that one,, i do looping , just for counter – Ariff Naj May 09 '18 at 11:43
@AriffNaj inefficient, it will result in multiple SQL plan being parsed. A bind parameter for `n` should reuse the plan if the driver caches correctly. – Karol Dowbecki Jul 16 '18 at 16:07

String variable activity to set color as red to display on jtextarea

0 Answers0