case when 连表查询根据2表值修改1表字段显示值

<select id="getProjectList" resultMap="BaseResultMap" parameterType="com.health.medical.core.pojo.entity.basic.BasicProject">
  select p.id, p.hospital_code, p.hospital_name, p.project_code, p.project_name, p.spel_code, p.fv_code,
  p.project_class, p.class_name, p.project_price, p.project_spec, p.sex_flag, p.marr_flag, p.age_limit,
  p.project_unit, p.reference_range, p.short_name, p.introduce, appropriate_crowd, discomfort_crowd,
  p.memory_class, p.memory_name, p.project_label, p.`state`, p.remark, p.create_user, p.create_time,
  p.modify_user, p.modify_time, p.datetime_stamp,p.class_code,
  (CASE WHEN (s.state = '0' OR s.state IS NULL) THEN 0 ELSE p.sort_number END) sort_number
  FROM basic_project p
  left JOIN basic_sort s
  on s.sort_number = p.sort_number
  <where>
    p.state = 1
    <if test="hospitalCode != null and hospitalCode != '' ">
      and p.hospital_code = #{hospitalCode,jdbcType=VARCHAR}
    </if>
  </where>
</select>

 

java定义Date类型字段返回格式： 

对象属性的get方法上添加注解

@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
public Date getScheduDate() {
    return scheduDate;
}