老年人能力评估系统web端#2
规划好数据库后定义了各个表对应的类，并完成了数据库接口和service类。
package com.xxx.mapper;
import com.xxx.pojo.Daliy;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface DaliyMapper {
@Insert("INSERT INTO daliy (id, eating, bathing, grooming, dressing, bowel_control, bladder_control, toileting, bed_chair_transfer, walking, stairs, total_score, activity_level) " +
"VALUES (#{id}, #{eating}, #{bathing}, #{grooming}, #{dressing}, #{bowel_control}, #{bladder_control}, #{toileting}, #{bed_chair_transfer}, #{walking}, #{stairs}, #{total_score}, #{activity_level})")
void insertDaliy(Daliy daliy);
@Select("SELECT * FROM daliy WHERE id = #{id}")
Daliy selectDaliyById(String id);
@Select("SELECT * FROM daliy")
List<Daliy> selectAllDaliy();
@Select("SELECT * FROM daliy WHERE activity_level = #{activity_level}")
List<Daliy> selectDaliyByActivityLevel(String activity_level);
@Update("UPDATE daliy SET eating = #{eating}, bathing = #{bathing}, grooming = #{grooming}, dressing = #{dressing}, bowel_control = #{bowel_control}, bladder_control = #{bladder_control}, " +
"toileting = #{toileting}, bed_chair_transfer = #{bed_chair_transfer}, walking = #{walking}, stairs = #{stairs}, total_score = #{total_score}, activity_level = #{activity_level} " +
"WHERE id = #{id}")
void updateDaliy(Daliy daliy);
@Delete("DELETE FROM daliy WHERE id = #{id}")
void deleteDaliy(String id);
}
package com.xxx.pojo;
public class Daliy {
private String id;
private String eating;
private String bathing;
private String grooming;
private String dressing;
private String bowel_control;
private String bladder_control;
private String toileting;
private String bed_chair_transfer;
private String walking;
private String stairs;
private String total_score;
private String activity_level;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getEating() {
return eating;
}
public void setEating(String eating) {
this.eating = eating;
}
public String getBathing() {
return bathing;
}
public void setBathing(String bathing) {
this.bathing = bathing;
}
public String getGrooming() {
return grooming;
}
public void setGrooming(String grooming) {
this.grooming = grooming;
}
public String getDressing() {
return dressing;
}
public void setDressing(String dressing) {
this.dressing = dressing;
}
public String getBowel_control() {
return bowel_control;
}
public void setBowel_control(String bowel_control) {
this.bowel_control = bowel_control;
}
public String getBladder_control() {
return bladder_control;
}
public void setBladder_control(String bladder_control) {
this.bladder_control = bladder_control;
}
public String getToileting() {
return toileting;
}
public void setToileting(String toileting) {
this.toileting = toileting;
}
public String getBed_chair_transfer() {
return bed_chair_transfer;
}
public void setBed_chair_transfer(String bed_chair_transfer) {
this.bed_chair_transfer = bed_chair_transfer;
}
public String getWalking() {
return walking;
}
public void setWalking(String walking) {
this.walking = walking;
}
public String getStairs() {
return stairs;
}
public void setStairs(String stairs) {
this.stairs = stairs;
}
public String getTotal_score() {
return total_score;
}
public void setTotal_score(String total_score) {
this.total_score = total_score;
}
public String getActivity_level() {
return activity_level;
}
public void setActivity_level(String activity_level) {
this.activity_level = activity_level;
}
@Override
public String toString() {
return "Daliy{" +
"id='" + id + '\'' +
", eating='" + eating + '\'' +
", bathing='" + bathing + '\'' +
", grooming='" + grooming + '\'' +
", dressing='" + dressing + '\'' +
", bowel_control='" + bowel_control + '\'' +
", bladder_control='" + bladder_control + '\'' +
", toileting='" + toileting + '\'' +
", bed_chair_transfer='" + bed_chair_transfer + '\'' +
", walking='" + walking + '\'' +
", stairs='" + stairs + '\'' +
", total_score='" + total_score + '\'' +
", activity_level='" + activity_level + '\'' +
'}';
}
}
package com.xxx.service;
import com.xxx.mapper.DaliyMapper;
import com.xxx.mapper.UserMapper;
import com.xxx.pojo.Daliy;
import com.xxx.pojo.User;
import com.xxx.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
public class DaliyService {
private SqlSessionFactory factory= SqlSessionFactoryUtils.getSqlSessionFactory();
public void add(Daliy daliy){
SqlSession session=factory.openSession();
DaliyMapper mapper=session.getMapper(DaliyMapper.class);
mapper.insertDaliy(daliy);
session.close();
}
public Daliy select(String id){
SqlSession session=factory.openSession();
DaliyMapper mapper=session.getMapper(DaliyMapper.class);
Daliy daliy=mapper.selectDaliyById(id);
session.close();
return daliy;
}
}
package com.xxx.mapper;
import com.xxx.pojo.Info_provider;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface Info_providerMapper {
@Insert("INSERT INTO info_provider (id, provider_name, relationship, name, phone) " +
"VALUES (#{id}, #{provider_name}, #{relationship}, #{name}, #{phone})")
void insertProvider(Info_provider provider);
// 查（所有提供者）
@Select("SELECT * FROM info_provider")
List<Info_provider> getAllProviders();
// 查（通过ID查单个提供者）
@Select("SELECT * FROM info_provider WHERE id = #{id}")
Info_provider getProviderById(String id);
// 改
@Update("UPDATE info_provider SET provider_name = #{provider_name}, relationship = #{relationship}, " +
"name = #{name}, phone = #{phone} WHERE id = #{id}")
void updateProvider(Info_provider provider);
// 删
@Delete("DELETE FROM info_provider WHERE id = #{id}")
void deleteProviderById(String id);
}
package com.xxx.pojo;
public class Info {
private String id;
private String social_security_card;
private String ethnicity;
private String education_level;
private String religion;
private String marital_status;
private String living_condition;
private String medical_payment_methods;
private String economic_source;
private String dementia;
private String psychiatric_disorder;
private String chronic_diseases;
private String fall;
private String wandering;
private String choking;
private String suicide_attempt;
private String other_incidents;
@Override
public String toString() {
return "Info{" +
"id='" + id + '\'' +
", social_security_card='" + social_security_card + '\'' +
", ethnicity='" + ethnicity + '\'' +
", education_level='" + education_level + '\'' +
", religion='" + religion + '\'' +
", marital_status='" + marital_status + '\'' +
", living_condition='" + living_condition + '\'' +
", medical_payment_methods='" + medical_payment_methods + '\'' +
", economic_source='" + economic_source + '\'' +
", dementia='" + dementia + '\'' +
", psychiatric_disorder='" + psychiatric_disorder + '\'' +
", chronic_diseases='" + chronic_diseases + '\'' +
", fall='" + fall + '\'' +
", wandering='" + wandering + '\'' +
", choking='" + choking + '\'' +
", suicide_attempt='" + suicide_attempt + '\'' +
", other_incidents='" + other_incidents + '\'' +
'}';
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getSocial_security_card() {
return social_security_card;
}
public void setSocial_security_card(String social_security_card) {
this.social_security_card = social_security_card;
}
public String getEthnicity() {
return ethnicity;
}
public void setEthnicity(String ethnicity) {
this.ethnicity = ethnicity;
}
public String getEducation_level() {
return education_level;
}
public void setEducation_level(String education_level) {
this.education_level = education_level;
}
public String getReligion() {
return religion;
}
public void setReligion(String religion) {
this.religion = religion;
}
public String getMarital_status() {
return marital_status;
}
public void setMarital_status(String marital_status) {
this.marital_status = marital_status;
}
public String getLiving_condition() {
return living_condition;
}
public void setLiving_condition(String living_condition) {
this.living_condition = living_condition;
}
public String getMedical_payment_methods() {
return medical_payment_methods;
}
public void setMedical_payment_methods(String medical_payment_methods) {
this.medical_payment_methods = medical_payment_methods;
}
public String getEconomic_source() {
return economic_source;
}
public void setEconomic_source(String economic_source) {
this.economic_source = economic_source;
}
public String getDementia() {
return dementia;
}
public void setDementia(String dementia) {
this.dementia = dementia;
}
public String getPsychiatric_disorder() {
return psychiatric_disorder;
}
public void setPsychiatric_disorder(String psychiatric_disorder) {
this.psychiatric_disorder = psychiatric_disorder;
}
public String getChronic_diseases() {
return chronic_diseases;
}
public void setChronic_diseases(String chronic_diseases) {
this.chronic_diseases = chronic_diseases;
}
public String getFall() {
return fall;
}
public void setFall(String fall) {
this.fall = fall;
}
public String getWandering() {
return wandering;
}
public void setWandering(String wandering) {
this.wandering = wandering;
}
public String getChoking() {
return choking;
}
public void setChoking(String choking) {
this.choking = choking;
}
public String getSuicide_attempt() {
return suicide_attempt;
}
public void setSuicide_attempt(String suicide_attempt) {
this.suicide_attempt = suicide_attempt;
}
public String getOther_incidents() {
return other_incidents;
}
public void setOther_incidents(String other_incidents) {
this.other_incidents = other_incidents;
}
}
package com.xxx.service;
import com.xxx.mapper.InfoMapper;
import com.xxx.pojo.Info;
import com.xxx.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
public class InfoService {
private SqlSessionFactory factory= SqlSessionFactoryUtils.getSqlSessionFactory();
public void add(Info info){
SqlSession session=factory.openSession();
InfoMapper mapper=session.getMapper(InfoMapper.class);
mapper.insertInfo(info);
session.close();
}
public Info getInfo(String id){
SqlSession session=factory.openSession();
InfoMapper mapper=session.getMapper(InfoMapper.class);
Info info = mapper.getInfoById(id);
session.close();
return info;
}
}
package com.xxx.mapper;
import com.xxx.pojo.Info;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface InfoMapper {
@Insert("INSERT INTO info (id, social_security_card, ethnicity, education_level, religion, marital_status, " +
"living_condition, medical_payment_methods, economic_source, dementia, psychiatric_disorder, chronic_diseases, " +
"fall, wandering, choking, suicide_attempt, other_incidents) " +
"VALUES (#{id}, #{socialSecurityCard}, #{ethnicity}, #{educationLevel}, #{religion}, #{maritalStatus}, " +
"#{livingCondition}, #{medicalPaymentMethods}, #{economicSource}, #{dementia}, #{psychiatricDisorder}, " +
"#{chronicDiseases}, #{fall}, #{wandering}, #{choking}, #{suicideAttempt}, #{otherIncidents})")
void insertInfo(Info info);
// 查（所有信息）
@Select("SELECT * FROM info")
List<Info> getAllInfo();
// 查（通过ID查单个信息）
@Select("SELECT * FROM info WHERE id = #{id}")
Info getInfoById(String id);
// 改
@Update("UPDATE info SET social_security_card = #{socialSecurityCard}, ethnicity = #{ethnicity}, " +
"education_level = #{educationLevel}, religion = #{religion}, marital_status = #{maritalStatus}, " +
"living_condition = #{livingCondition}, medical_payment_methods = #{medicalPaymentMethods}, " +
"economic_source = #{economicSource}, dementia = #{dementia}, psychiatric_disorder = #{psychiatricDisorder}, " +
"chronic_diseases = #{chronicDiseases}, fall = #{fall}, wandering = #{wandering}, choking = #{choking}, " +
"suicide_attempt = #{suicideAttempt}, other_incidents = #{otherIncidents} " +
"WHERE id = #{id}")
void updateInfo(Info info);
// 删
@Delete("DELETE FROM info WHERE id = #{id}")
void deleteInfoById(String id);
}
package com.xxx.pojo;
public class Info_provider {
private String id;
private String provider_name;
private String relationship;
private String name;
private String phone;
@Override
public String toString() {
return "Info_provider{" +
"id='" + id + '\'' +
", provider_name='" + provider_name + '\'' +
", relationship='" + relationship + '\'' +
", name='" + name + '\'' +
", phone='" + phone + '\'' +
'}';
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getProvider_name() {
return provider_name;
}
public void setProvider_name(String provider_name) {
this.provider_name = provider_name;
}
public String getRelationship() {
return relationship;
}
public void setRelationship(String relationship) {
this.relationship = relationship;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
}
package com.xxx.service;
import com.xxx.mapper.InfoMapper;
import com.xxx.pojo.Info;
import com.xxx.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
public class InfoService {
private SqlSessionFactory factory= SqlSessionFactoryUtils.getSqlSessionFactory();
public void add(Info info){
SqlSession session=factory.openSession();
InfoMapper mapper=session.getMapper(InfoMapper.class);
mapper.insertInfo(info);
session.close();
}
public Info getInfo(String id){
SqlSession session=factory.openSession();
InfoMapper mapper=session.getMapper(InfoMapper.class);
Info info = mapper.getInfoById(id);
session.close();
return info;
}
}
package com.xxx.mapper;
import com.xxx.pojo.Mental;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface MentalMapper {
@Insert("INSERT INTO mental (id,clock_test, recall_words, aggression_behavior, depression_symptoms, total_score, mental_state_level) " +
"VALUES (#{id},#{clock_test}, #{recall_words}, #{aggression_behavior}, #{depression_symptoms}, #{total_score}, #{mental_state_level})")
void insertMental(Mental mental);
@Delete("DELETE FROM mental WHERE id = #{id}")
void deleteMentalById(String id);
@Update("UPDATE mental SET clock_test = #{clock_test}, recall_words = #{recall_words}, aggression_behavior = #{aggression_behavior}, " +
"depression_symptoms = #{depression_symptoms}, total_score = #{total_score}, mental_state_level = #{mental_state_level} " +
"WHERE id = #{id}")
void updateMental(Mental mental);
@Select("SELECT * FROM mental WHERE id = #{id}")
Mental selectMentalById(String id);
@Select("SELECT * FROM mental")
List<Mental> selectAllMentals();
}
浙公网安备 33010602011771号