枚举类虽然很简单,但是却往往是系统中业务逻辑最集中最复杂的地方.本文将会分享我们项目中基于hibernate的枚举类使用规范,包含数据库中枚举列数据类型.注释.枚举列与枚举类的映射等. 一.枚举类定义规范 package org.jframe.data.enums; /** * Created by leo on 2017-05-31. */ public enum Gender { unknown(0), male(11), female(12); public final static St
字符字段转整型查询: SELECT mon_id as staTime,SUM (CAST ( index_value AS INT )) AS totalCount FROM aidata.rep_index_values_m SELECT ext_dim1 sex, sum(index_value::NUMERIC) total FROM aidata.rep_index_values_y T mybatis in 查询: <if test="orgIdList != null&quo