用resulType注意属性要和数据库字段一致(类型,下划线),如果不一致只有查到的条数,结果却是null
<select id="getShen" resultType="com.esteel.system.beanVo.TbBasAreaVo" >
select * from tb_bas_area t where t.area_level=1
</select>
用resulType注意属性要和数据库字段一致(类型,下划线),如果没有resultMap不能直接用生成的bean(resultMap相当于中间做了一次转化(数据库字段到实体属性))
为了使用resultType类中字段名与数据库一致
public class TbBasAreaVo implements Serializable{
/**
*
*/
private static final long serialVersionUID = -2444110313245901231L;
private String AREA_KEY;
private String AREA_LEVEL;
}
//直接生成的
@Table(name = "TB_BAS_AREA")
public class TbBasArea implements Serializable{
/**
*
*/
private static final long serialVersionUID = -2444110313245901231L;
@Id
@Column(name = "AREA_KEY")
private String areaKey;
@Column(name = "AREA_LEVEL")
private String areaLevel;}