<sql id="key">
        <trim suffixOverrides=",">
            <if test="id!=null">
                id,
            </if>
            <if test="name!=null">
                name,
            </if>
            <if test="password!=null">
                password,
            </if>
            <if test="type!=null">
                type,
            </if>
            <if test="nikename != null">
                nikename,
            </if>
            <if test="age != null">
                age,
            </if>
            <if test="sex != null">
                sex,
            </if>
            <if test="email != null">
                email,
            </if>
            <if test="phone != null">
                phone,
            </if>
            <if test="avatar != null">
                avatar,
            </if>
            <if test="location != null">
                location
            </if>
        </trim>
    </sql>

    <sql id="value">
        <trim suffixOverrides=",">
            <if test="id!=null">
                #{id},
            </if>
            <if test="name!=null">
                #{name},
            </if>
            <if test="password!=null">
                #{password},
            </if>
            <if test="type!=null">
                #{type},
            </if>
            <if test="nikename != null">
                #{nikename},
            </if>
            <if test="age != null">
                #{age},
            </if>
            <if test="sex != null">
                #{sex},
            </if>
            <if test="email != null">
                #{email},
            </if>
            <if test="phone != null">
                #{phone},
            </if>
            <if test="avatar != null">
                #{avatar},
            </if>
            <if test="location != null">
                #{location}
            </if>
        </trim>
    </sql>
 <insert id="saveUser" keyProperty="id" parameterType="User">
        insert into users(<include refid="key"/>) values(<include refid="value"/>)
    </insert>

@Repository
public interface UserDao {

    boolean addUser(@Param("user") User user);

    int saveUser(@Param("user") User user);

    User findByName(@Param("name")String name);

    User findBy(@Param("name")String name,@Param("password")String password);

    List<User> findAllUser();
}

請(qǐng)問(wèn)大家，我這樣寫有問(wèn)題嗎，如果有，如何改呢

改成下面這樣還是報(bào)錯(cuò)

<insert id="saveUser" parameterType="User">
        insert into users(id,name,password) values(#{id},#{name},#{password})
    </insert>