目录
1. 在mapper.xml中增加< insert >标签 无返回值类型:
Mybatis增删改
mybatis底层是对JDBC的封装,默认关闭了JDBC的自动提交功能,手动提交则调用 **session.commit()** 要设置自动提交则可在获取session对象时openSession(true) mybatis中< insert >< delete >< update >标签没有resultType属性,返回值都是int。在操作出现异常时,应事务回滚调用session.rollback()
新增:
1. 在mapper.xml中增加< insert >标签 无返回值类型:
<insert id="insert" parameterType="User">
insert into t_user2 values (default ,#{uname},#{pwd},#{sex},#{age},#{birth} )
</insert>
2.调用session.insert执行新增操作:
int num = session.insert("User.insert",new User(0,"qwe","qwe","男",50,new Date(2018,1,1))) ;
if (num>0){
System.out.println("成功");
}
session.commit();
修改:
1.在mapper.xml中增加< update >标签
<update id="updBanalceByAccno" parameterType="pojo.Account">
update account set balance = balance+#{balance} where accno = #{accno}
</update>
2.调用session.update()执行修改操作
int index = session.update(" mapper.AccountMapper.updBanalceByAccno",new Log(1,"3","2",456))
if (index>0){
System.out.println("成功");
}
session.commit();
删除:
1.在mapper.xml中增加< delete >标签
<delete id="del" parameterType="int">
delete from people where id = #{0}
</delete>
2.调用session.delete()执行删除操作
int del = session.delete("test.del",3);
if(del>0){
System.out.println("成功");
}else{
System.out.println("失败");
}
session.commit();