mybatis的增删改

插入信息

 <!--    插入信息-->
    <insert id="insertAll" parameterType="com.zks.vo.Dept">
        insert into dept values(#{deptno},#{dname},#{loc})
    </insert>

删除信息

<!--    删除信息-->
    <delete id="deleteByPk" parameterType="int">
        delete from dept where deptno=#{deptno}
    </delete>

/**
 * 删除数据
 */
public void deleteByPk(){
    //获取数据库链接
    SqlSession sqlSession= MyBatiesUtils.getSqlSession();
    //删除数据
    int count= sqlSession.delete("com.zks.dao.DeptMapper.deleteByPk",80);
    System.out.println(count);
    sqlSession.commit();
    sqlSession.close();
}

修改信息

<!--    修改信息-->
    <update id="updateByPk" parameterType="hashmap">
        update dept set loc=#{loc} where deptno=#{deptno}
    </update>

/**
 * 修改信息
 */
public void updateByPk(){
    //获取数据库链接
    SqlSession sqlSession= MyBatiesUtils.getSqlSession();
    //修改数据
    Map<String,Object> map=new HashMap<>();
    map.put("deptno",80);
    map.put("loc","大同");
    int count= sqlSession.delete("com.zks.dao.DeptMapper.updateByPk",map);
    System.out.println(count);
    sqlSession.commit();
    sqlSession.close();
}