老年人评估系统-补充

Usermapper的蓝色小鸟即接口：

点击查看代码

package work.mapper;

import org.apache.ibatis.annotations.Param;
import work.pojo.*;

import java.util.List;

public interface UserMapper {
    int addlogin(@Param("number") String number, @Param("password") String password);
    login selectlogin(@Param("number") String number, @Param("password") String password);
    int informationadd(@Param("id") String id,@Param("date") String date,@Param("reason") String reason,@Param("name") String name,@Param("gender") String gender,@Param("birthday") String birthday,@Param("number") String number,@Param("cordnumber") String cordnumber,@Param("nation") String nation,@Param("culture") String culture,@Param("religion") String religion,@Param("marrystate") String marrystate,@Param("livestate") String livestate,@Param("medicalpay") String medicalpay,@Param("financial") String financial,@Param("disease_1") String disease_1,@Param("disease_2") String disease_2,@Param("disease_3") String disease_3,@Param("accident_1") String accident_1,@Param("accident_2") String accident_2,@Param("accident_3") String accident_3,@Param("accident_4") String accident_4,@Param("accident_5") String accident_5,@Param("providername") String providername,@Param("relationship") String relationship,@Param("phonename") String phonename,@Param("phonenumber") String phonenumber);
    int assessment1add(@Param("number") String number,@Param("jinshi") int jinshi,@Param("xizao") int xizao,@Param("xiushi") int xiushi,@Param("chuanyi") int chuanyi,@Param("dabian") int dabian,@Param("xiaobian") int xiaobian,@Param("ruce") int ruce,@Param("chuangyi") int chuangyi,@Param("zoulu") int zoulu,@Param("shanglouti") int shanglouti);
    int assessment2add(@Param("number") String number,@Param("renzhi") int renzhi,@Param("gongji") int gongji,@Param("yiyv") int yiyv);
    int assessment3add(@Param("number") String number,@Param("yishi") int yishi,@Param("shili") int shili,@Param("tinli") int tinli,@Param("goutong") int goutong);
    int assessment4add(@Param("number") String number,@Param("shenghuo") int shenghuo,@Param("gongzuo") int gongzuo,@Param("shikong") int shikong,@Param("renwu") int renwu,@Param("shejiao") int shejiao);
    List<dailystate> selectdailystate(@Param("number") String number);
    List<mentalstate> selectmentalstate(@Param("number") String number);
    List<feelstate> selectfeelstate(@Param("number") String number);
    List<publicstate> selectpublicstate(@Param("number") String number);
    information selectinformationbynumber(@Param("number") String number);
    information selectinformationbyphone(@Param("phonename") String phonename,@Param("phonenumber") String phonenumber);
    information selectinformation(@Param("number") String number,@Param("phonenumber") String phonenumber);
        int checkDuplicate(String id, String date, String name, String gender, String number, String cordnumber);
    int abilityadd(@Param("number") String number,@Param("daily") String daily,@Param("mental") String mental,@Param("feel") String feel,@Param("publics") String publics,@Param("ability1") String ability1,@Param("changing") String changing,@Param("ability2") String ability2,@Param("auditor1") String auditor1,@Param("auditor2") String auditor2,@Param("provider") String provider,@Param("date") String date);
    ability selectability(@Param("number") String number);
}

UserMapper的红色小鸟：

点击查看代码

<?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="work.mapper.UserMapper">

    <insert id="addlogin">
        insert into login(number,password)values (#{number},#{password});
    </insert>
    <insert id="informationadd">
        insert into information(id,date,reason,name,gender,birthday,number,cordnumber,nation,culture,religion,marrystate,livestate,medicalpay,financial,disease_1,disease_2,disease_3,accident_1,accident_2,accident_3,accident_4,accident_5,providername,relationship,phonename,phonenumber)
        values (#{id},#{date},#{reason},#{name},#{gender},#{birthday},#{number},#{cordnumber},#{nation},#{culture},#{religion},#{marrystate},#{livestate},#{medicalpay},#{financial},#{disease_1},#{disease_2},#{disease_3},#{accident_1},#{accident_2},#{accident_3},#{accident_4},#{accident_5},#{providername},#{relationship},#{phonename},#{phonenumber});
    </insert>
    <insert id="assessment1add">
        insert into dailystate(number,jinshi,xizao,xiushi,chuanyi,dabian,xiaobian,ruce,chuangyi,zoulu,shanglouti)
        values (#{number},#{jinshi},#{xizao},#{xiushi},#{chuanyi},#{dabian},#{xiaobian},#{ruce},#{chuangyi},#{zoulu},#{shanglouti});
    </insert>
    <insert id="assessment2add">
        insert into mentalstate(number,renzhi,gongji,yiyv)
        values (#{number},#{renzhi},#{gongji},#{yiyv});
    </insert>
    <insert id="assessment3add">
        insert into feelstate(number,yishi,shili,tinli,goutong)
        values (#{number},#{yishi},#{shili},#{tinli},#{goutong});
    </insert>
    <insert id="assessment4add">
        insert into publicstate(number,shenghuo,gongzuo,shikong,renwu,shejiao)
        values (#{number},#{shenghuo},#{gongzuo},#{shikong},#{renwu},#{shejiao});
    </insert>
    <insert id="abilityadd">
        insert into ability(number,daily,mental,feel,publics,ability1,changing,ability2,auditor1,auditor2,provider,date)
        values (#{number},#{daily},#{mental},#{feel},#{publics},#{ability1},#{changing},#{ability2},#{auditor1},#{auditor2},#{provider},#{date});
    </insert>
    <select id="selectlogin" resultType="work.pojo.login">
        select * from login where number=#{number}and password=#{password};
    </select>
    <select id="selectdailystate" resultType="work.pojo.dailystate">
        select * from dailystate where number=#{number};
    </select>
    <select id="selectmentalstate" resultType="work.pojo.mentalstate">
        select * from mentalstate where number=#{number};
    </select>
    <select id="selectfeelstate" resultType="work.pojo.feelstate">
        select * from feelstate where number=#{number};
    </select>
    <select id="selectpublicstate" resultType="work.pojo.publicstate">
        select * from publicstate where number=#{number};
    </select>
    <select id="selectinformationbynumber" resultType="work.pojo.information">
        select * from information where number=#{number};
    </select>
    <select id="selectinformationbyphone" resultType="work.pojo.information">
        select * from information where phonenumber=#{phonenumber};
    </select>
    <select id="selectinformation" resultType="work.pojo.information">
        select * from information where number=#{number} and phonenumber=#{phonenumber};
    </select>
    <select id="checkDuplicate" resultType="int">
        SELECT COUNT(*) FROM your_table
        WHERE id = #{id}
           OR date = #{date}
           OR name = #{name}
           OR gender = #{gender}
           OR number = #{number}
           OR cordnumber = #{cordnumber}
    </select>
    <select id="selectability" resultType="work.pojo.ability">
        select * from ability where number=#{number};
    </select>
</mapper>

然后就完成了老年人评估系统