Mybatis的增删改查（根据id查询）完整代码

最新推荐文章于 2023-06-29 10:05:45 发布

Java在开发

最新推荐文章于 2023-06-29 10:05:45 发布

阅读量318

点赞数

分类专栏： mybatis 文章标签： mybatis java mysql

本文链接：https://blog.csdn.net/weixin_47641362/article/details/125782632

版权

mybatis 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

controller

 @GetMapping("/selectById/{id}")
    @ApiOperation(value = "指挥中心-根据病历id查询患者病历", notes = "指挥中心-根据病历id查询患者病历", httpMethod = "GET")
    public PatientRegisterDomain selectById(@PathVariable Integer id) {
        return patientRegisterImpl.selectById(id);
    }

service

  //根据病历id查询患者病历
    PatientRegisterDomain selectById(Integer id);

serviceImpl

   @Override
    public PatientRegisterDomain selectById(Integer id) {
        PatientRegisterDomain patientRegisterDomain = patientRegisterDao.selectById(id);
        return patientRegisterDomain;
    }

dao

    PatientRegisterDomain selectById(Integer id);

mapper

<!-- 通用查询结果列 -->
    <sql id="Base_Column_List" >
    ID, RECORD_NUM, NAME, ID_CARD, GENDER, AGE, PHONE, NATIONALITY, NATION, PROFESSION,
    SITE_LOCATION, HOME_ADDRESS, CALL_TIME, VISIT_TIME, ARRIVAL_TIME, DEPARTURE_TIME,
    CHIEF_COMPLAINT, HPI, PAST_HISTORY, ALLERGIC_HISTORY, POSITIVE_SIGN, NEGATIVE_SYMPTOMS,
    MEDICALHISTORY_PROVIDER, PATIENT_RELATION, CHECK_T, CHECK_P, CHECK_R, CHECK_SYS,
    CHECK_DIA, CONSCIOUSNESS, PUPIL, LIGHT_REFLEX, HEAD_NECK, THORACIC_DORSAL, HEART_LUNG,
    ABDOMEN, SPINE_LIMBS, NERVOUS_SYSTEM, RECORD_OTHER, REFLEX_SKIN, HOSPITAL_DIAGNOSIS,
    THERAPEUTIC_MEASURES, AUXILIARY_EXAMINATION, MEASURES_OTHER, MEASURES_SPO2H, MEASURES_GLU,
    MEASURES_THERAPY, DOCTOR_NAME, VISIT_RESULT, VISIT_DOCTOR, VISIT_NURSE, VISIT_DRIVER,
    PATIENT_TO, PATIENT_OTHER, DELIVERY_ADDRESS, DELIVERY_TIME, ILLNESS_P, ILLNESS_T,
    ILLNESS_SYS, ILLNESS_DIA, DELIVERY_CONSCIOUSNESS, DISEASE_CLASSIFY, REMEDY_RESULT,
    PATIENT_COOPERATION, MEDICAL_STAFF, HOSPITAL_OUTCOME, DEATH_CERTIFICATE, FIRSTAID_STATUS,
    HOSP_NAME, NOTIFICATION_OTHER, PATIENT_RELATION2, DUTY_SIGNATURE, NUNCIATOR_SIGNATURE,
    NUNCIATOR_TIME, CREATE_BY, UPDATE_BY, CREATE_TIME, UPDATE_TIME, ORG_CODE, FIRSTAID_ID
  </sql>


<select id="selectById" parameterType="string" resultType="com.xyhsoft.ygt.yqjj.api.patient.domain.PatientRegisterDomain">
        select
        <include refid="Base_Column_List" />
        from yqjj_patient
        <where>
            <if test="id != null" >
                ID = #{id,jdbcType=INTEGER}
            </if>
        </where>
    </select>