1、mysql数据库字段
2、实体类
@Data
@EqualsAndHashCode(callSuper=false)
public class UserManager {
private long id;
private String name;
private UserEnum userType;
}
3、枚举
public enum UserEnum{
MANAGER_USER_TYPE("管理员"),
NORMAL_USER_TYPE("普通用户");
private String userType;
private UserEnum(String userType){
this.userType = userType;
}
public String getEnumName(){
return this.name();
}
public String getTypeName(){
return this.userType;
}
}
4、测试类
public class TestEnumMapper {
InputStream inp ;
SqlSessionFactory build;
SqlSession openSession;
@Before
public void before() throws IOException{
inp = Resources.getResourceAsStream("SqlMapConfig.xml");
build = new SqlSessionFactoryBuilder().build(inp);
openSession = build.openSession(true);//设置自动提交
}
//测试映射枚举
@Test
public void testEnum(){
UserManagerMapper userManagerMapper = openSession.getMapper(UserManagerMapper.class);
List<UserManager> queryAll = userManagerMapper.queryAll();
for (UserManager userManager : queryAll) {
System.out.println(userManager.getName());
System.out.println(userManager.getUserType().getTypeName());
}
}
5、结果