1.<insert>标签实现新增数据
添加数据: <insert id="addUser"> <![CDATA[ insert into t_user (name,pwd,age) values ('王宝强','666',36) ]]> </insert> int res = sqlSession.insert("addUser"); System.out.println(res); sqlSession.commit(); |
2.openSession(boolean), boolean类型参数为true:事务自动提交
3. session.commit()实现openSession默认情况下是false,手动提交事务
4. session.rollback()实现手动回滚事务
6. MyBatis 实现修改
使用<update>标签
更新数据 <update id="updateUser"> <![CDATA[ update t_user set name = #{name}, pwd = #{age} where id = #{id} ]]> </update> User u = new User(); u.setName("张三丰"); u.setPwd("123"); u.setId(1); int count = sqlSession.update("updateUser",u); System.out.println(count); sqlSession.commit(); sqlSession.close(); |
7. MyBatis 实现删除
<delete>标签讲解
删除数据 <![CDATA[ delete from t_user where id = #{id} ]]> </delete> int count = sqlSession.delete("deleteUser",1); System.out.println(count); sqlSession.commit(); sqlSession.close(); |