************根据ID删除用户***********

1> HelloMyBaties.java

class HelloMyBaties{
  
  @Test
  public void Test5() throws IOException{
    //配置文件
    String resource = "sqlMapConfig.xml";
    //读取配置文件
    InputStream in = Resources.getResourceAsStream(resource);

    //需要sqlSessionFactoryBuilder
    SqlSessionFactoryBuilder ssfb = new SqlSessionFactoryBuilder();

    //创建sqlSessionFactory
    SqlSessionFactory ssf = ssfb.build(in);

    //产生一个sqlSession
    SqlSession session = ssf.openSession();

    //操作数据库(根据ID删除)
    session.delete("UserMapper.deleteUserById",13);
    //由于配置了JDBC事务，需要使用commit()来实际操作数据
    session.commit();
  }
}

2> UserMapper.xml

<!--  根据ID删除用户  -->
<delete id = "deleteUserById" parameterType="Integer">
  delete from user where u_id = #{u_id}
</delete>