The database in the data table has a users column with an enum data type that contains an enumeration. How to enter data in this column?

Request example:

String sql = "UPDATE data SET `users`=? WHERE `name`=?"; PreparedStatement stmt = connect().prepareStatement(sql); stmt.setЧТО-ТО() //На этом моменте ступор stmt.setString(2, user.toLowerCase()); stmt.executeUpdate(); 

To an existing or empty enum column, add an enumeration. I can not figure it out.

  • also setString, or create your own enum Users and execute stmt.setString(1, Users.USER1.toString()) - Senior Pomidor

0