MyBatis之增删改查

MyBatis增删改查的简单实现

核心代码如下:

Mapper文件
<mapper namespace="com.lzj.mapper.FlowerMapper3">

     <!--public   int   insert(Flower fl); -->
    
    <insert id="insert" >
         insert  into   flower   values(DEFAULT ,#{name},#{price},#{production})
    </insert>

    <!--public  int  update(Flower fl)-->
    <update id="update">
        update  flower   set  name =#{name},price=#{price} WHERE   id =#{id}
    </update>
    
   <!--public   int  delete(int  id);-->
    <delete id="delete">
        DELETE   from  flower   where  id =#{0}
    </delete>
</mapper>


测试类

public static void main(String[] args) throws Exception {
        //【1】解析mybatis.xml
        InputStream inputStream = Resources.getResourceAsStream("MyBatis.xml");
        //[2]获得session工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
        //[3]获得session对象
        SqlSession session = factory.openSession(true);
        //[4]调用方法
        Flower  flower=new Flower();
        flower.setName("夕颜123");
        flower.setPrice(15);
        //flower.setProduction("中国");
        flower.setId(6);        
        int insert = session.insert("com.lzj.mapper.FlowerMapper3.insert", flower);
        session.update("com.lzj.mapper.FlowerMapper3.update",flower);
        int delete = session.delete("com.lzj.mapper.FlowerMapper3.delete", 6);
        //[5]关闭
        session.close();
        
    }

[注]：mybatis中我们的增加、删除、修改操作都是需要自己手动提交       
          A、session.commit();
          B、SqlSession session = factory.openSession(true);