mysql 枚举类型 jdbc,JDBC是否支持枚举？

I really can't find a nice enum JDBC mapping example.

Is enum actually supported by JDBC?

I am working with MySQL. I have an enum column, and would like to map to some Java enum.

解决方案

JDBC does not support enums.

You can convert a string to an enum though, so if you have a Java enum you can do something like

MyEnum enumVal = MyEnum.valueOf(rs.getString("EnumColumn"));

You'll have to keep your java enum and mysql enum in sync though. MyEnum.valueOf() can throw IllegalArgumentException if there's no mapping from the string, or NullPointerException if you get a null value from the db.