<insertid="insertOneUser"> insert into `user`(`username`,`password`) values (#{username},#{password});</insert><!--这里如果插入成功会返回插入的条数-->
同时你还可以选择插入多条数据(这里属于动态sql,之后会讲到)
<insertid="insertUser"> insert into `user`(`username`,`password`) values <foreachitem="item"collection="list"separator=","> (#{username},#{password}) </foreach></insert><!-- 这里执行效果大概是这样的,如标签所言,就是foreach的增加sql insert into `user`(`username`,`password`) values (#{username},#{password}),(#{username},#{password})~~~-->
update
和正常些insert差不多,看个例子
<updateid="updateUser"> UPDATE user SET uasername=#{username},password=#{password} WHERE id=#{id}</update><!--这里如果更新成功会返回更新的条数-->
delete
接着看例子
<deleteid="deleteUser"> DELETE FROM user WHERE id=#{id}</delete><!--这里如果删除成功会返回删除的条数-->
注解开发
注解开发适合在写一些比较简单的sql的场景,就没有必要写xml啥的了,很简单,看个例子就知道了
publicinterfaceUserMapper {//查询全部 @Select("SELECT * FROM user")publicabstractList<User> selectAll();//新增数据 @Insert("INSERT INTO user VALUES (#{id},#{username},#{password})")publicabstractIntegerinsert(User user);//修改操作 @Update("UPDATE user SET uasername=#{username},password=#{password} WHERE id=#{id}")publicabstractIntegerupdate(User user);//删除操作 @Delete("DELETE FROM user WHERE id=#{id}")publicabstractIntegerdelete(@Param("id")Integer id);}