mybatis修改

修改全部字段

定义Mapper接口

public interface StudentMapper{

        void updata(Student data);


}

Student的结构

package top.wogong.pojo;



public class Student {
    private Integer ID;
    private String name;
    private String classID;
    private String gender;
    private String cardID;
    private String address;
    private String phone;

    public Student() {
    }

    public Student(Integer ID, String name, String classID, String gender, String cardID, String address, String phone) {
        this.ID = ID;
        this.name = name;
        this.classID = classID;
        this.gender = gender;
        this.cardID = cardID;
        this.address = address;
        this.phone = phone;
    }

    public Integer getID() {
        return ID;
    }

    public void setID(Integer ID) {
        this.ID = ID;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getClassID() {
        return classID;
    }

    public void setClassID(String classID) {
        this.classID = classID;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public String getCardID() {
        return cardID;
    }

    public void setCardID(String cardID) {
        this.cardID = cardID;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    @Override
    public String toString() {
        return "User{" +
                "ID=" + ID +
                ", name='" + name + '\'' +
                ", classID='" + classID + '\'' +
                ", gender='" + gender + '\'' +
                ", cardID='" + cardID + '\'' +
                ", address='" + address + '\'' +
                ", phone='" + phone + '\'' +
                '}';
    }
}

配置xml

<update id="updata">

       update studentinformation
       set
           student_name=#{name},
           student_classID=#{classID},
           student_gender=#{gender},
           student_cardID=#{cardID},
           student_address=#{address},
           student_phone=#{phone}
       where ID=#{ID}

</update>

修改动态字段

<set>可以解决',' 和set后为空的问题 

   <update id="updata">
        update studentinformation
        <set>
          <if test="name !=null and name=''">
                <!--要加,-->
              student_name=#{name},
          </if>
           <if test="classId !=null">
               student_classID=#{classID},
           </if>
            <if test="gender !=null ">
                student_gender=#{gender},
            </if>
            <if test="cardId !=null">
                student_cardID=#{cardID},
            </if>
            <if test="address !=null">
                student_address=#{address},
            </if>
            <if test="phone !=null  ">
                student_phone=#{phone},
            </if>
        </set>
        where ID=#{ID}

    </update>