文章目录

前言一、遇到的问题二、实现过程1.数据库设计2.实体类3.医生添加排班或修改排班方法4.患者预约方法5.患者修改预约6.患者取消预约

3、如果多为患者同时预约需要使用redis做支撑解决并发问题。

1.数据库设计

字段名字段类型长度注释guidance_time_idint11排班IDdatedate日期starttimetime开始时间点endtimetime结束时间点numint2可预约次数residueint2剩余可预约次数doctor_idint11医生ID

预约详情表

字段名字段类型长度注释reservation_idint11预约关系IDguidance_time_idint11排班IDpatient_idint11患者IDremarkstext病情描述file_idvarchar256附件IDreservation_typeint11预约类型IDdoctor_idint11医生IDreplytext回复reply_files_idvarchar256回复附件IDstatusint1状态IDisfinishint1是否已完成咨询finish_timedatetime完成咨询的时间create_timedatetime创建时间

2.实体类

医生可预约时间id*/IdGeneratedValue(strategy

GenerationType.IDENTITY)ApiModelProperty(value

required

剩余可预约次数*/ApiModelProperty(value

required

预约关系id*/IdGeneratedValue(strategy

GenerationType.IDENTITY)ApiModelProperty(value

预约关系id,

是否已完成咨询1是0否*/ApiModelProperty(value

required

完成咨询的时间*/ApiModelProperty(value

required

addOrUpdateList(ListRqriGuidanceTime

list)

SimpleDateFormat(HH:mm);SimpleDateFormat

simpleDateFormat

SimpleDateFormat(yyyy-MM-dd);ArrayListString

collect

{collect.add(simpleDateFormat.format(rqriGuidanceTime.getDate()));}ListString

list_date

collect.stream().distinct().collect(Collectors.toList());ListRqriGuidanceTime

rqriGuidanceTimes

rqriGuidanceTimeMapper.selectByDateList(list_date);//

ListRqriGuidanceTime

(simpleDateFormat.format(rqriGuidanceTimes.get(j).getDate()).equals(item))

{list_update.add(rqriGuidanceTimes.get(j));}}//

修改已有排班for

(simpleDateFormat.format(rqriGuidanceTime.getDate()).equals(item)

rqriGuidanceTime.getGuidanceTimeId()

null)

(rqriGuidanceTime.getGuidanceTimeId().equals(list_update.get(k).getGuidanceTimeId()))

{//

(!Objects.equals(list_update.get(k).getNum(),

list_update.get(k).getResidue()))

{String

simpleDateFormat1.format(rqriGuidanceTime.getStarttime());String

format1

simpleDateFormat1.format(rqriGuidanceTime.getEndtime());throw

new

rqriGuidanceTime);}}}}}hashMap_update.put(item,

list_update);}//

(simpleDateFormat.format(rqriGuidanceTime.getDate()).equals(value)

rqriGuidanceTime.getGuidanceTimeId()

null)

{list_add.add(rqriGuidanceTime);}}hashMap_add.put(value,

list_add);}//

已有的排班与修改的排班ListRqriGuidanceTime

(RqriGuidanceTime

sdf.format(guidanceTime.getStarttime());String

endtime

sdf.format(guidanceTime.getEndtime());int

start

Integer.parseInt(starttime.replace(:,

));int

Integer.parseInt(endtime.replace(:,

));if

sdf.format(rqriGuidanceTime.getStarttime());String

endtime

sdf.format(rqriGuidanceTime.getEndtime());int

start

Integer.parseInt(starttime.replace(:,

));int

Integer.parseInt(endtime.replace(:,

));if

0);}}}}ArrayListRqriGuidanceTime

list_update

{list_update.addAll(update);}for

(RqriGuidanceTime

{rqriGuidanceTime.setResidue(rqriGuidanceTime.getNum());rqriGuidanceTimeMapper.updateByPrimaryKey(rqriGuidanceTime);//插入到redisresidueAddRedis(rqriGuidanceTime.getDate(),

rqriGuidanceTime.getGuidanceTimeId().toString(),

rqriGuidanceTime.getResidue());}ArrayListRqriGuidanceTime

list_add

{rqriGuidanceTime.setResidue(rqriGuidanceTime.getNum());}if

(list_add.size()

{rqriGuidanceTimeMapper.insertList(list_add);for

(RqriGuidanceTime

{//插入到redisresidueAddRedis(guidanceTime.getDate(),

guidanceTime.getGuidanceTimeId().toString(),

guidanceTime.getResidue());}}}private

static

SimpleDateFormat(yyyy-MM-dd);//

Date

dateFormat.format(date).split(-);int

year

duration.getSeconds();//初始化到redisredisUtils.set(RESERVATION

guidanceTimeId,

reservationService.makeReservation(rqriGuidanceTimeRelation.getGuidanceTimeId());if

(!b)

BusinessException(该时段已无预约次数);}RqriGuidanceTime

rqriGuidanceTime

rqriGuidanceTimelMapper.selectByPrimaryKey(rqriGuidanceTimeRelation.getGuidanceTimeId());Integer

residue

rqriGuidanceTime.getResidue();//

可预约次数减1rqriGuidanceTime.setResidue(residue

1);rqriGuidanceTimelMapper.updateByPrimaryKey(rqriGuidanceTime);Integer

guidanceTimeId

rqriGuidanceTime.getGuidanceTimeId();redisUtils.decr(RESERVATION

guidanceTimeId,

添加预约信息rqriGuidanceTimeRelation.setIsfinish(0);rqriGuidanceTimeRelation.setCreateTime(new

Date());rqriGuidanceTimeRelationMapper.insertSelective(rqriGuidanceTimeRelation);}public

boolean

redissonClient.getLock(RESERVATION_LOCK);try

{//

redisTemplate.opsForValue().decrement(key);if

(availableTickets

预约已满预约失败需要将可预约数量还原redisTemplate.opsForValue().increment(key);return

false;}//

reservationService.makeReservation(guidanceTimeId);if

(!b)

Exception(该时段已无预约次数);}//查询新的时段是RqriGuidanceTime

newGuidanceTime

rqriGuidanceTimelMapper.selectByPrimaryKey(guidanceTimeId);

Integer

查询原预约时段idRqriGuidanceTimeRelation

rqriGuidanceTimeRelationMapper.selectByPrimaryKey(reservationId);//根据原预约时段id获取原预约时段数据RqriGuidanceTime

old

rqriGuidanceTimelMapper.selectByPrimaryKey(rqriGuidanceTimeRelation.getGuidanceTimeId());//原预约时段次数

1);old.setResidue(old.getResidue()

1);//更新原时段rqriGuidanceTimelMapper.updateByPrimaryKey(old);//新预约时段剩余次数-1newGuidanceTime.setResidue(newGuidanceTime.getResidue()

1);rqriGuidanceTimelMapper.updateByPrimaryKey(newGuidanceTime);//更新预约详情rqriGuidanceTimeRelation.setGuidanceTimeId(guidanceTimeId);rqriGuidanceTimeRelationMapper.updateByPrimaryKey(rqriGuidanceTimeRelation);}

6.患者取消预约

delete(RqriGuidanceTimeRelation

throws

rqriGuidanceTimelMapper.selectByPrimaryKey(rqriGuidanceTimeRelation.getGuidanceTimeId());rqriGuidanceTime.setResidue(rqriGuidanceTime.getResidue()

1);rqriGuidanceTimelMapper.updateByPrimaryKey(rqriGuidanceTime);rqriGuidanceTimeRelationMapper.delete(rqriGuidanceTimeRelation);redisUtils.incr(RESERVATION

rqriGuidanceTimeRelation.getGuidanceTimeId(),

1);}