mybatis使用笔记

1、通过xml配置 insert into users (username, password, description, role, cellphone, full_name, identity, email,

        gender, status, invitor, source,lcs_id, create_time)

        values (#{username}, #{password}, #{description}, #{role}, #{cellphone}, #{fullName}, #{identity}, #{email},

        #{gender}, #{status}, #{invitor}, #{source}, #{lcsId},#{createTime})

    2、使用注解@Insert("insert into user ( username, nickname,password,status,role, cellphone,source,full_name ,identity,gender,open_id,invitor) values ( #{user.username},#{user.nickname},#{user.password},#{user.status},#{user.role}, #{user.cellphone} , #{user.source},#{user.fullName},#{user.identity},#{user.gender},#{user.openId},#{user.invitor})")@Options(useGeneratedKeys = true, keyProperty = "user.userId")void insert(@Param("user") User user);