插入信息
<!-- 插入信息-->
<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();
}