Mybatis+JDBC 实现单表增删改查

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>标签讲解

删除数据      <delete id="deleteUser">          <![CDATA[               delete from t_user               where id = #{id}          ]]>      </delete> int count = sqlSession.delete("deleteUser",1);          System.out.println(count);          sqlSession.commit();          sqlSession.close();