作业十二

最新推荐文章于 2024-08-14 04:38:02 发布

原创最新推荐文章于 2024-08-14 04:38:02 发布 · 164 阅读

0 ·

CC 4.0 BY-SA版权

实践专栏收录该内容

13 篇文章

订阅专栏

本文介绍了一个使用MyBatis实现的医疗信息系统部分功能，包括添加、修改、删除和查询病人信息及收费信息的方法。通过XML映射文件详细展示了SQL语句的编写，并提供了对应的Java接口定义。

在这里插入图片描述
ManagerStaffMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ping.inpatient.managerStaff.mapper.ManagerStaffMapper">

    <!--   添加病人信息-->
    <insert id="addSickInfo" parameterType="Sick">
        insert into sickinfo(sickId,hospId,sickRegistType,sickName,sickSex,sickAge,sickData,registerId)
        values (#{sickId},#{hospId},#{sickRegistType},#{sickName},#{sickSex},#{sickAge},#{sickData},#{registerId})
    </insert>

    <!--修改病人信息 -->
    <update id="updateSickInfo">
        update sickinfo set sickId=#{sickId},hospId=#{hospId},sickRegistType=#{sickRegistType},sickName=#{sickName},sickSex=#{sickSex},sickAge=#{sickAge},sickData=#{sickData},registerId=#{registerId}
    </update>

    <!--  删除病人信息-->
    <delete id="deleteSickInfo">
        delete into sickinfo(#{sickId},#{hospId},#{sickRegistType},#{sickName},#{sickSex},#{sickAge},#{sickData},#{registerId}) where sickId=#{sickId}
    </delete>

    <!-- 查询病人信息-->
    <select id="getSickInfo" resultMap="info1">
        select si.sickId,d.departmentType,s.staffName,si.sickData from departmentinfo d,staffinfo s,sickinfo si
        where s.departmentId=d.departmentId
        <if test="sickId=!null">
            and si.sickId like concat('%',#{sickId},'%')
        </if>
        <if test="staffName！=null">
            and s.staffName like concat('%',#{staffName},'%')
        </if>
        <if test="departmentType!=null">
            and d.departmentType like concat('%',#{departmentType},'%')
        </if>
        <if test="startTime!=null &amp;&amp; endTime!=null">
            and si.sickData between year(#{startTime}) and year(#{endTime})
        </if>
    </select>
    <resultMap id="info1" type="Sick">
        <result property="s.staffName" column="staffName"/>
        <result property="d.departmentType" column="departmentType"/>
    </resultMap>

    <!--  添加收费信息-->
    <insert id="addChargs">
        insert into charges(chargesId,chargesName,sickIdb,chargesDate,chargesPersonId,chargesPay)
        values(#{chargesId},#{chargesName},#{sickIdb},#{chargesDate},#{chargesPersonId},#{chargesPay})
    </insert>

    <!--  修改收费信息-->
    <update id="updateChargs">
        update charges set chargesId=#{chargesId},chargesName=#{chargesName},sickIdb=#{sickIdb},chargesDate=#{chargesDate},chargesPersonId=#{chargesPersonId},chargesPay=#{chargesPay}
    </update>

    <!--  删除信息-->
    <delete id="deleteChargs">
        delete into charges(#{chargesId},#{chargesName},#{sickIdb},#{chargesDate},#{chargesPersonId},#{chargesPay}) where sickIdb=#{sickIdb}
    </delete>

    <!--  查询收费信息-->
    <select id="getChargs" resultType="Charges">
        select chargesId,chargesName,sickIdb,chargesDate,chargesPersonId,chargesPay from charges
        <where>
            <if test="sickId!=null">
                sickId like concat('%',#{sickId},'%')
            </if>
            <if test="userName!=null">
                and userName like concat('%',#{userName},'%')
            </if>
        </where>
    </select>

</mapper>

ManagerStaffMapper

package com.ping.inpatient.managerStaff.mapper;

import com.ping.pojo.Charges;
import com.ping.pojo.Sick;
import org.springframework.stereotype.Repository;

import java.util.Date;

@Repository
public interface ManagerStaffMapper {

    //病人信息管理
//    添加病人信息
    public Boolean addSickInfo(Sick sick);

    //    修改病人信息
    public Boolean updateSickInfo(Sick sick);//, int staffId, int sickRoomId

    //    删除病人信息
    public Boolean deleteSickInfo(String sickId);

    //    查询病人信息
    public Sick getSickInfo(String sickId, String staffName, String departmentType, Date startTime, Date endTime);

    // 住院收费信息
    //    添加收费信息
    public Boolean addChargs(Charges charges);

    //    修改收费信息
    public Boolean updateChargs(Charges charges);

    //    删除收费信息
    public Boolean deleteChargs(int chargesId);

    //    查询收费信息
    public Charges getChargs(String sickId, String userName);
//    添加医嘱信息
    //public
//    添加催款信息
    //    public
//    查询催款信息

}